SQLiteManagers

=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. TomH || 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.
 * ~ Win ||~ Mac ||~ Product ||~ Review ||~ Rating
 * Y || N || [|SQLite Expert Personal]l || 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 ||