Small. Fast. Reliable.
Choose any three.
About Sitemap Documentation Download License News Developers Support

Page History

Turn Off History

Programs to help you manage SQLite databases:


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 pale green below, are recommended and 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.
?
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
?

PHP

Name
Description
Licence
DB_SQLite_Tools
PHP PEAR official OO extension to manage and backup Sqlite Databases under PHP 5.
?
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.
?
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.
?
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
?
DCSQLite
A Flash MX2004 front-end based on Database Connector System to manage SQLite database files with PHP5 interaction.
?
SQLiteFront
a tool to manage SQLite databases like phpMyAdmin is to MySQL. Written in pure PHP5 using PHP5 DOM XML, XSL and SQLite extensions
?
phpSQLiteAdmin (1)
PHP based administration tool for SQLite in the same style as phpMyAdmin. Requires PHP 4.3+. GPL.
?
phpSQLiteAdmin (2)
Web interface for the administration of SQLite databases.
GPL
ezSqliteAdmin
is written in PHP and can be used to manage SQLite databases of large websites through user friendly interface. It requires XUL supported browser to administer and manage SQLite. Check out the Demo
?

Windows

Name
Description
Licence
Visual SQLite
GUI application for SQLite 3 Databases. Visually control tables, indexes and triggers. Data editing, modify pragmas, SQL queries executions and more...
?
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; fast 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.
?
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. (For PC : .NET required)
?
SQLitePlusDatabase Manager
GUI tool used to create, view and edit SQLite databases, similar to MS Query Analyzer. (try before you buy)
commercial
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 additional features not yet available)
?
LiteQuery
Another GUI tool to create view and edit SQLite databases. GPL.
?
SQLite Analyzer
A comprehensive SQLite database processor. Edit or modify SQLite data visually without any risk of losing your data.
?
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.
?
Caligari's SQLite Admin Tool
a Freeware SQLite admin tool. Have source too.
?
SQLite 3 Explorer
A great GUI tool written by Mike Cariotoglou. Freeware .NET2 SQLite admin tool. Have source also.
?
SQLite Sharp Admin
A tool written by Evandro Junior (needs .Net Framework 2).
?

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).
?

Parser

Name
Description
Licence
SQLite access driver
for Parser web scripting engine is done for Win32 and Linux. Binaries and sources will be officially released soon, just after confirmation from parser developers.
?