SQLite Managers


SQLite Management Tools : a comprehensive table for multiple operating systems but not updated since 2011.
The following table describes a few tried by one member of this wiki. The page SQLite Managers for Mac OS looks into some for the Mac.
Win
Mac
Product
Review
Rating
TomH
Y
N
SQLite Expert Personall
Free subset of the $59 Professional version. Excellent results display, sort, filter, thumbnails of images. BLOB viewer/editor. Copy/paste for results export. Save/load SQL files. Supports loadable extensions including most compatible fake RMNOCASE. Supports runtime parameters. Best at handling very large databases, large result sets and multiple open databases. Very frequently updated.
8.8
Y
N
SQLiteSpy
Free, basic, clean manager capable of bypassing the RMNOCASE obstruction by using a fake collation. Fastest display of table data; sort by column with both numerical and ASCII fields. Export results by copy to clipboard and paste to Excel or text editor. Export/Import SQL. Frequently updated. 1.9.0 supports loadable extensions with potential for RM date processing and other lengthy expressions to be made custom functions. Can bog down on very large intermediate or final results sets.
8.5
Y
N
SQLite Developer
Were it not for its $29 license, this one would tie or be first. Only one to have choice of user named UniCode collations, hence a substitute for RMNOCASE and no more COLLATE NOCASE overrides. Has good sorting (no numerical sort), filtering, bookmarking and exporting of results. Export/import SQL files. SQL structured formatting. NB: the free Lite version lacks the Collation and some other tools. Good support for bug fixes.
8
Y
N
SQLiteman
Simple, reliable but no visual query builder. Good error handling. Can export and import SQL files and save SQL Views. Development appears to have stalled in 2010.
6
Y
N
DBTools DBManager Standard
More professional, commercial. Seems complex and powerful but freeware version out-dated (2007) and restricted.
6
Y
N
SQLite2009 Pro
Attractive GUI. Fast visual query builder. Unreliable - crashed on some queries or views with poor error handling (Jan 2010). Version 3.7.6.3 as of 2011-05-20 still does not save or load a SQL file - must copy to/from clipboard; takes almost twice as long as SQLiteSpy to execute LifeLines-OO.sql on a large database (117MB). Current 3.8.3.1 (2014-02) has not been tested.
5
Y
Y
SQLiteStudio
Version 3 (2014-12) under review; promising.
?
Y
N
SQLite Administrator
Beta. Quirky column widths in results display. No sorting, filtering. No import/export of queries or data. Queries saved to db table. Not updated since 0.8.3.2 (2006).
3
Y
Y
DB Browser for SQLite
Very limited. A basic browser. (that is an old review...)
3
I tend to use a combination of SQLite Expert Personal and SQLiteSpy when developing new queries. For using established queries, I rather prefer the look of the results tables from Spy but Expert handles user inputted parameters at run-time. For a new user, Spy is probably the easier of the two to start with. SQLite Expert Personal is better for its performance on very large databases, display of JPG blobs and the availability of a highly compatible substitute RMNOCASE collation.