Small. Fast. Reliable.
Choose any three.

This information is obsolete. You are looking at the CVSTrac source management system display for SQLite that was replaced by Fossil on 2009-08-11. The information shown here has not been updated since that cut-over. These pages are retained for historical reference only.

Please help to keep this list up to date by:
-- 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
SQLite2009 Pro Enterprise Manager SQLite2009 Pro Enterprise Manager is a freeware tool that enables you to manage your SQLite3 databases. Not only that, you can using this tool for learning and working with LUA programming language.

Features:
  • Unicode Support
  • Blob/Image viewer
  • Built-in FTS3 Extention
  • Built-in LUA Programming Language
  • Encrypted database support
  • Export recordset into excel, csv, xml and html format
  • Import data from Ms Access, MS SQL server and MySQL server
  • Includes Additional sqlite3 function (compress, decompress, crc32, md5, lua_exec, etc)
  • Includes the user-contributed extension-functions from http://www.sqlite.org/contrib.
    The new functions are: acos, asin, atan, atn2, atan2, acosh, asinh, atanh, difference, degrees, radians, cos, sin, tan, cot, cosh, sinh, tanh, coth, exp, log, log10, power, sign, sqrt, square, ceil, floor, pi, replicate, charindex, leftstr, rightstr, reverse, proper, padl, padr, padc, strfilter, and aggregates stdev, variance, mode, median, lower_quartile, upper_quartile.
  • Visual Query Builder
Included SQLite2009 Pro ODBC Driver,the first free ODBC driver which have supported for accessing encrypted database that was build with SQLite2009 Pro Enterprise Manager (includes with vb6 sample project).
Freeware
SQLitePlus Database Manager GUI tool used to create, view and edit SQLite databases, similar to MS Query Analyzer
  • Open multiple databases at the same time
  • Open unlimited Query windows
  • View schema info (eg. field types)
  • Create Stored Scripts
  • Execute highlighted query text or all text (like MS Query Analyzer) - invaluable for working-out complex queries
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. A Software Development firm in Atlanta. 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:
  • Database Comparer
  • Task Builder
  • Blob and Image Viewer
  • Data Migration Wizard
  • Database Documenter
  • Diagram Designer
  • Report and Forms Builders
  • And Much More
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.