If you are looking for an SQLite Editor in the public domain under Creative Commons license or GPL (General Public License) i.e. for free commercial or non-commercial use. Then here is a shortlist of the SQLite Editor that is available on the web for free download.
These software work on macOS, Windows, Linux and most of the Unix Operating systems.
![Sqlite Sqlite](/uploads/1/2/7/7/127782192/402056137.png)
- SQLite database browser and navigator contains features such as browsing database objects and structures, generating SQL, and more, and is available for macOS / Mac OS X, Windows, and Linux.
- SQLite Database Browser is a freeware, public domain, open source visual tool used to create, design and edit database files compatible with SQLite.
- SQLite-Browser is full functional Sqlite client application for iOS devices which allow to browser, manage and execute Sqlite database Main Features: - Allow to import unlimited sqlite database files - Allow to browse tables and views - View table/query result in grid kind view - View details row.
1. SQLiteStudio
I use Liya from the Mac App Store, it's free, does the job, and the project is maintained (a month or so between updates as of Jan 2013). I also test a lot on the device. You can access the SQLITE database on the device by: Add Application supports iTunes file sharing to the info.plist and setting it to YES; Running the app on a device; Open iTunes; Select the device. Download sqlitebrowser 3.8 for Mac from our website for free. Our built-in antivirus checked this Mac download and rated it as 100% safe. The most popular versions of the tool are 3.5, 3.4 and 3.3. The program belongs to Design & Photo Tools. The actual developer of this free Mac application is sqlitebrowser.
Link : http://sqlitestudio.pl/
SQLiteStudio Database manager has the following features :
- A small single executable Binary file, so there is need to install or uninstall.
- Open source and free - Released under GPLv2 licence.
- Good UI with SQLite3 and SQLite2 features.
- Supports Windows 9x/2k/XP/2003/Vista/7, Linux, MacOS X, Solaris, FreeBSD and other Unix Systems.
- Language support : English, Polish, Spanish, German, Russian, Japanese, Italian, Dutch, Chinese,
- Exporting Options : SQL statements, CSV, HTML, XML, PDF, JSON, dBase
- Importing Options : CSV, dBase, custom text files, regular expressions
- UTF-8 support
2. Sqlite Expert
Link : http://www.sqliteexpert.com/download.html
SQLite Expert though not under public domain, but its free for commercial use and is available in two flavours.
a. Personal Edition
Mac Sqlite Viewer
- It is free for personal and commercial use but, covers only basic SQLite features.
- But its a freeware and does not have an expiration date.
b. Professional Edition
- It is for $59 (onetime fee, with free lifetime updates )
- It covers In-depth SQLite features.
- But its a freeware and does not have an expiration date.
Features :
- Visual SQL Query Builder : with auto formatting, sql parsing, analysis and syntax highlighting features.
- Powerful restructure capabilities : Restructure any complex table without losing data.
- Import and Export data : CSV files, SQL script or SQLite. Export data to Excel via clipboard.
- Data editing : using powerful in-place editors
- Image editor : JPEG, PNG, BMP, GIF and ICO image formats.
- Full Unicode Support.
- Support for encrypted databases.
- Lua and Pascal scripting support.
3. Database Browser for SQLite
Sqlite Database Browser Download
Link : http://sqlitebrowser.org/
- Database Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.
- Database Browser for SQLite is bi-licensed under the Mozilla Public License Version 2, as well as the GNU General Public License Version 3 or later.
- You can modify or redistribute it under the conditions of these licenses.
Sqlite Browser Download For Mac
Features :
- You can Create, define, modify and delete tables
- You can Create, define and delete indexes
- You can Browse, edit, add and delete records
- You can Search records
- You can Import and export records as
- You can Import and export tables from/to text, CSV, SQL dump files
- You can Issue SQL queries and inspect the results
- You can See Log of all SQL commands issued by the application
4. SQLite Manager for Firefox Browser
Link : https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/This is an addon plugin for Firefox Browser,
Features :
Sqlite Browser For Mac Free Download
- Manage any SQLite database on your computer.
- An intuitive hierarchical tree showing database objects.
- Helpful dialogs to manage tables, indexes, views and triggers.
- You can browse and search the tables, as well as add, edit, delete and duplicate the records.
- Facility to execute any sql query.
- The views can be searched too.
- A dropdown menu helps with the SQL syntax thus making writing SQL easier.
- Easy access to common operations through menu, toolbars, buttons and context-menu.
- Export tables/views/database in csv/xml/sql format. Import from csv/xml/sql (both UTF-8 and UTF-16).
- Possible to execute multiple sql statements in Execute tab.
- You can save the queries.
- Support for ADS on Windows
More Posts related to Mac-OS-X,
More Posts: - Disable jQuery button after being click - jQuery
- Android xml error Attribute is missing the Android namespace prefix [Solution] - Android
- Google Webmaster : An error has occurred. Please try again later - Google
- How to Change Bootstrap Carousel Slide Speed - Bootstrap
- Increase Android Emulator Timeout time - Android
- Create a large dummy file using Mac OS X terminal command - Mac-OS-X
- How to write hello world different languages syntax - HowTos
- Enable Spellcheck in eclipse workspace - Eclipse
- Remove URL Forward Slash Before Single or Double quotes in php.ini - PHP
- Android Studio Error:(19, 0) Gradle DSL method not found: android() - Android-Studio
- How to upload file programmatically to SharePoint Document Library using Server Object Model C# .Net - SharePoint
- Fixed Length Android Edittext - Android
- Obsolete marquee element alternatives html5 - Html
- Update Created By (Author) column of SharePoint document using PowerShell - SharePoint
- The Android Virtual Device is currently running in an emulator and cannot be deleted - Android