-- adding your comments on usability [in italics] to the end of the desriptions -- filling in licence details --
-- highlighting entries according to the key -- adding any new programs you discover -- fixing bad links --
Other possibilities to look into and add to the list:
* Kexi (part of KOffice)
* OpenOffice.org v2
Key:
- Programs highlighted in bright green below, are *recommended* and are under active development
- Programs highlighted in pale green below, are under active development
- Programs highlighted in pale red below, appear NOT to be under active development
- Licenses: commercial / freeware(closed source) / public domain / GPL / etc..
Multi-OS
| Name | Description | Licence |
| SQLiteDatabaseBrowser | SQLite Database Browser is a freeware, public domain, open source visual tool used to create, design and edit database files compatible with SQLite. Version 1.2 was updated to support SQLite 3.x databases. [fairly simplistic, works but slightly buggy, awkward data entry, single file executable] |
public domain |
| dgSQLite | A tcl/tk based GUI SQLite-Database Client which allows to import, export and query sqlite-databases. Available as kit/exe for Linux/Windows/OSF1. Other platforms can be added easily on request. [download location unknown] |
? |
| SQLiteManager | a commercial SQLite database manager that runs on Windows, Mac OS X, and Mac OS Classic. | commercial |
| SQLiteCC | SQLite Control Center is a visual tool for working on SQLite database files similar to MySQL CC. | ? |
| SQLiteCC for SQLite3 | Same as SQLiteCC but for SQLite3 database files | ? |
| TkSQLite | A graphical database manager for SQLite implemented by Tcl/Tk. | BSD |
PHP
| Name | Description | Licence |
| DB_SQLite_Tools | PHP PEAR official OO extension to manage and backup Sqlite Databases under PHP 5. | BSD |
| SQLiteManager | SQLiteManager is a multilingual web based tool to manage SQLite databases. The programming language used is PHP4 but it works fine with PHP5. Works just as well on a Linux as on Windows platform. This project is in course of developpement, but is already very functional. | GNU/GPL |
| SQLiteDB | A PHP class for working with SQLite databases. Supports ALTER TABLE statements. | Public Domain |
| SQLiteWebAdmin | SQLiteWebAdmin is a webbased administration tool for SQLite Databases. It is written in PHP and requires PHP 4.x with SQLite extension or PHP 5. It provides management of multiple sqlite Databases. | Artistic License |
| wtcSQLite | Web Tricks Central SQLite Administration Tool is an administration tool written in PHP. Create, edit, delete tables, data, indexes, triggers, views and more without knowing any SQL at all! On top of that, you may run 'ALTER TABLE' statements anywhere in wtcSQLite | LGPL |
| DCSQLite | A Flash MX2004 front-end based on Database Connector System to manage SQLite database files with PHP5 interaction. | GPL |
| SQLiteFront | a tool to manage SQLite databases like phpMyAdmin is to MySQL. Written in pure PHP5 using PHP5 DOM XML, XSL and SQLite extensions | GPL |
| phpSQLiteAdmin (1) | PHP based administration tool for SQLite in the same style as phpMyAdmin. Requires PHP 4.3+. GPL. | GPL |
| phpSQLiteAdmin (2) | Web interface for the administration of SQLite databases. | GPL |
Windows
| Name | Description | Licence |
| SQLitePlus Database Manager | GUI tool used to create, view and edit SQLite databases, similar to MS Query Analyzer
|
Commercial - |
| SqlPro SQL Editor | SqlPro SQL Editor is a visual database management and development tool for multiple databases with Explorer interface. Supports Oracle, MySql, Microsoft SQL Server, Microsoft Access and Sqlite 3. | Commercial (Free trial) |
| SQLite Query Analyzer | Sqlite Query Analyzer is a query analyzer tool for ADO.NET Data Provider for SQLite. The current version supports sqlite version 2 & 3. It can be described as a visual query builder, and it is written in C#. | GNU/GPL |
| Sqlite Developer | Sqlite3 Database Manager supports table, view & trigger edit. visual query builder, export/import data as csv,sql,etc, unicode support, etc. | Commercial |
| Visual SQLite | GUI application for SQLite 3 Databases. Visually control tables, indexes and triggers. Data editing, modify pragmas, SQL queries executions and more... | Commercial. 30 day trial available. |
| SQLite Spy | A freeware, graphical database manager for SQLite 3 databases. Features full Unicode input and display; REGEXP keyword with Perl 5.8 regular expression syntax; a schema tree showing tables, views, columns, indexes, and triggers; multiple tabbed SQL edits and query results; type-colored data grids; time measurement; outstanding performance and low memory consumption. SQLite Spy is realized as a fully self-contained, single-file executable, requires no installation and runs on plain Win9X, WinME, WinNT, Win2K, and WinXP with no dependencies. Data changes must be enacted through SQL statements (no cell based editing). | Freeware for personal and educational use |
| eSQL | A FREE sqlite database and database manager from Vieka. Provide consistent interface on Windows and Windows Mobile devices such as Pocket PC and Microsoft Smartphone. | Freeware (Windows) / Commercial with exceptions (Windows CE) |
| Another SQLite Explorer | A Free open source SQLite Explorer provided by Arke Systems. Binary and Source zips availabla. Enjoy! | Open Source |
| DBTools Manager | Freeware Win32 application to manage MySQL, PostgreSQL, XBase Tables and SQLite databases. Supports managing all objects in the database, create queries in visual mode, import/export data from MSAccess, ODBC, text files, Paradox, DBF Tables and generate PHP scripts. The list of features is just too big. Enterprise Edition with powerful features is available:
|
Commercial (Trial and Freeware available) |
| LiteQuery | Another GUI tool to create view and edit SQLite databases. Discontinued by author. | GPL |
| SQLite Analyzer | A comprehensive SQLite database processor. Edit or modify SQLite data visually without any risk of losing your data. | Commercial. 30 day trial available. |
| MyGeneration | a freeware template based code generation tool that supports SQLite and many other databases. With this tool, you can generate a middle tier for your database in practically any language (Needs .NET 1.1 or higher) | Freeware |
| Caligari's SQLite Admin Tool | SQLite admin tool. Have source too. | GPL |
| SQLite 3 Explorer | A great GUI tool written by Mike Cariotoglou. Freeware SQLite admin tool. | ? |
| SQLite Sharp Admin | A tool written by Evandro Junior (needs .NET Framework 2). | ? |
| SQLite Administrator | SQLite Administrator is a powerful tool if you easily want to create, design or administrate SQLite database files. The SQL code editor helps you to quickly write sql queries with features such as code completion and highlighting. Both major versions of SQLite database files are supported by SQLite Administrator. | Freeware |
Linux
| Name | Description | Licence |
| knoda | a database frontend for KDE. Its driver concept allows a uniform connection to different database servers (Mysql , Postgresql , SQLite or ODBC). | GPL |
| sqliteweb | Very small and simple web-based (CGI) sqlite administrator. Developed totally using shell script, with help from GNU coreutils and sed. | BSD |
| Commando | Auto-completion for table and column names. | Commercial. 10 day trial available. |