SQLite Applications Comparison
2009-06-29 BareFeet -> SQLite -> Compare
Description Comparison of features of SQLite GUI application programs, mainly for Mac OS X. A work in progress and very rough at the moment.
Contact Email us if you have any corrections or comments on this page.
Developer Froq SQLiteManager MesaSQLite Base Orac SQLGrinder DB Solo RazorSQL SQLite Manager for FireFox DBVisualizer Spatialite SQLiteQuery SQLEditor
Icon
URL http://www.alwintroost.nl/?id=82 http://www.sqlabs.net/sqlitemanager.php http://www.mesamysql.com/?realmesa_home http://menial.co.uk/software/base/ http://www.oractotherescue.com/ http://www.sqlgrinder.com/ http://www.dbsolo.com/ http://www.razorsql.com/ http://sqlite-manager.googlecode.com http://www.dbvis.com/products/dbvis/ http://www.gaia-gis.it/spatialite/ http://www.software-by-mabe.com/software/freeware.html#sqlitequery http://www.malcolmhardie.com/sqleditor/
Developer Alwin Troost SQLabs Rick Praetzel Menial Arten Science Advenio DB Solo LLC Richardson Software Mrinal Kant Minq Software Alessandro Furieri Manfred Bergmann MalcolmHardie Company
Price €49.99. Approx US$60 US$49 US$20 £10 Beta US$59 US$99 US$59.95 Free US$149 Free Free US$79
Version 2.1.2 B1602 3.0.1 2.0.8 1.3.1 1.0.0 beta 060509_2330 2.0.8 3.0 4.5.8 0.2.39 6.0.8 2.2 0.7.3 1.4b19
Technologies Froq SQLiteManager MesaSQLite Base Orac SQLGrinder DB Solo RazorSQL SQLite Manager for FireFox DBVisualizer Spatialite SQLiteQuery SQLEditor
Operating System Mac Mac Mac Mac Mac Mac Mac, others Mac, others? Mac, others? Mac, others? Mac, Linux, Windows Mac Mac
Platform Cocoa Cocoa, RealBasic Cocoa, RealBasic Cocoa RealBasic Cocoa Java? Java Firefox or oter Mozilla app Java (Mac theme) Java? Cocoa? Cocoa?
Database SQLite, Oracle, MySQL, others SQLite SQLite SQLite SQLite, Oracle, others? JDBC gives SQLite and others. Fussy about driver. JDBC gives SQLite and others SQLite (Razor built in), others, or JDBC SQLite JDBC gives SQLite and others SQLite SQLite JDBC gives SQLite and others
Driver Zentus? JDBC built in Built in Built in Built in Built in Zentus JDBC v044 added Zentus JDBC added Mac OS X, or select SQLite program Built in Zentus JDBC added Built in Zentus JDBC added
SQLite version 3.6.1 3.6.15 3.4.2 3.6.14.2 3.4.2 3.5.8 3.5.6 3.6.13 or latest 3.3.5 3.5.6 3.6.2 3.5.6 3.5.6
Can open database file on AppleShare volume No Yes Yes No Yes Yes using other JDBC. No using Zentus JDBC Yes using other JDBC. No using Zentus JDBC Yes Yes Yes using other JDBC. No using Zentus JDBC No No Yes using other JDBC. No using Zentus JDBC
Demo/shareware limit 25 day trial Query results limited to 20 rows. Disabled export, import, report generator, dump database. Limited print. Beta 15 minute sessions. 5 rows from custom SQL queries Beta until June 20 launches, with the ability to extend the trial period. 30 day limit 30? day eval period, thereafter can't launch. Free Free version doesn't allow editing of data, but doesn't explain that. Free 21 eval version on automated request, allows data entry. Free Beta
Data browse Froq SQLiteManager MesaSQLite Base Orac SQLGrinder DB Solo RazorSQL SQLite Manager for FireFox DBVisualizer Spatialite SQLiteQuery SQLEditor
Resize columns Yes, manually Yes, manually Yes manually or via "Set to natural widths" button. Yes, manually Yes, manually Yes, manually Yes, manually Yes, manually Yes, drag Yes. Manual and autosize Yes, manually. Autosizes. No No
Reorder Columns Yes, drag No Yes in tables via drag. No in views. No No Yes Yes, drag Yes, drag. Yes, drag Yes No No No
Horizontal scroll through columns Yes Yes, if preferences set to "Always add Horizontal Scroll" and "Columns can't be smaller than 80 pixel" Yes Yes Yes (option) Yes Yes? Yes No, so too cramped when many columns. Yes Yes Yes No
Show/hide columns No No. Can manually shrink to zero width. Yes, click on "Limit columns" button, or right click on column to choose "Hide column" from context menu. No No No No No Yes, via pop up menu on right of column headers Yes No No No
Quick sort columns Yes, click single column header. Click "Sort" button to sort multiple. No Yes, click on single column header. Or click on "Set multiple sort" button to show dialog. Fails for column names that should be quoted. Yes. Click header to sort ascending/descending Yes. Click header to sort ascending/descending Yes, click single column header Yes, click single column header Yes. Double click column header. Or click "Sort Query Results" button to sort via popup menus. No Yes. Click on first sort column, control click on second. No No No
Quick filter rows Yes, extensive. Can also drag cell from result set to filter, hold option to filter out, or drag to table browser to search another table. No Yes for tables. No for views. No No Yes, match one or all columns Yes No. Can refine/add "where" clause Yes, one condition per column Yes, match one or all columns No No No
Show column info in data editing No, but can see column names and types in Info for table/view No No No No No No No, not in column view, but entity browser can be expanded to show columns of a table, which includes type and PK. No Yes, key icon in header, tooltip shows column info. No, but can select column in entity browser, pop up menu select "Geometries" No No
Modes for viewing data Froq SQLiteManager MesaSQLite Base Orac SQLGrinder DB Solo RazorSQL SQLite Manager for FireFox DBVisualizer Spatialite SQLiteQuery SQLEditor
Column mode Yes Yes Yes. Edits direct in cell if numeric, opens text in cell mode when double clicked. Yes Yes Yes Yes Yes Yes Yes "Grid view" Yes Yes No
Line/form mode Yes, with next/previous. Click "Info" button to show in pane over columns. Yes, click pencil button to show "Record Editor". No No Yes, after double click row No No No Yes, for tables not views, as panel over column view without next/previous. Yes "Form view", initiated from hilighted row in column mode, but can't move to another record in form mode. No No No
Cell mode (large wrapped field) Yes, via right click on cell, choose "Edit Value" Yes. Selected cell shown in large field in line mode ("Record Editor") Yes. Opens in panel if cell is text. Yes. Set the long text threshold in Preferences. Yes, hover box No Select cell in column mode appears in own text entry field Yes Yes, via expand button next to cell in line mode. Yes, via context menu or button No No No
Other modes No Generate saved "Report" in HTML or other text based format. No No No No text column No No No No No No
Data entry Froq SQLiteManager MesaSQLite Base Orac SQLGrinder DB Solo RazorSQL SQLite Manager for FireFox DBVisualizer Spatialite SQLiteQuery SQLEditor
Entry in tables Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes, via popup menu "Edit table rows" No No
Entry in views (with "instead of" triggers) No Yes No No No No No Yes. Asks for key field to use. No Yes No No No
Mark & submit No, immediate. Incorrectly updates whole row instead of just changes. Does have commit/rollback mechanism. No, immediate Changes not marked. Can autocommit or begin/end transaction via buttons. No, immediate No No, immediate No? Bug with data entry. Yes No, immediate Yes Yes? No No
Null distinct from text No No, but does have "Set to null" command in cell entry. Yes uses "NUL" graphic No, but can set text to show (default 'NULL') No No, but can set string to show No in column mode, NULL appears same as 'NULL' literal text. In Cell mode shows number of characters. Yes, pink (adjustable) cell color for nulls. No, appears as "NULL" Yes, can choose string and cell color. No. NULL appears same as "NULL" No No
GUI Create Froq SQLiteManager MesaSQLite Base Orac SQLGrinder DB Solo RazorSQL SQLite Manager for FireFox DBVisualizer Spatialite SQLiteQuery SQLEditor
Add Column No Yes for tables. No for views. Yes in tables Yes, "Add Column" button in Schema tab view No Yes. Right click table, choose "Alter", "Add Column" Yes No. "Add New Column" popup menu just shows template SQL
Drop Column No Yes for tables. No for views. Yes in tables Yes. Click "Action" button under entity list, choose "Alter", then select and delete column. No No since tries "alter table... drop column" syntax which SQLite doesn't support. Yes Yes
Reorder column definitions No Yes in tables, no in views Yes, via Action -> Alter popup button under entity list. No No
GUI create table No, "Create Table" menu item disabled for SQLite. Yes Yes, via grid Yes No Yes No Yes Yes Yes, right click on "Tables" in browser -> "Create Table" No. "Create New Table" popup menu just shows template SQL No Yes
GUI create view No No, just shows dialog with field for name and select statement Yes basic. Can save a GUI query on a table as a view. "Add View" button asks for SQL. No No No ("Create Table" panel offers "view" option but does same as table. No No. Dialog allows view name and SQL of select, but limited usefulness. No, just shows dialog with field for name and select statement No No. "Create New View" popup menu just shows template SQL No No
Link tables No No No No No No (though "Foreign Keys" tab might be promising when it works) No No No No No No No, not in SQLite, requires support for "foreign key" in tables, wheras SQLite only links in views.
Entity browsing Froq SQLiteManager MesaSQLite Base Orac SQLGrinder DB Solo RazorSQL SQLite Manager for FireFox DBVisualizer Spatialite SQLiteQuery SQLEditor
Shows entities Tables, views, indexes, triggers Tables, views, triggers, indexes Tables and views is separate panes Tables, views, triggers. Indexes appear with selected table. Tables, indexes, but not views or triggers Tables, views, indexes, triggers Tables and views but not indexes or triggers? Tables, views, triggers, indexes Tables, views, indexes, triggers Tables, views, no triggers or indexes Tables, views. Expanding a table/view reveals associated columns, triggers and indexes No Tables only
Filter list Yes No No No No Yes, after customizing toolbar to have search field. No Yes. Right click, "Filter Navigator". No Yes, with wildcards No No No
Sorted list Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes No No
Refresh manually Yes, "Reload Connection info" from "Connection" menu. Also auto every 30s. Yes, collapse/expand grouping Yes via "Refresh Tables" button Yes, via "Reload" toolbar button. Also refreshes automatically after each SQL execution. No Yes, "Reload" button Yes, right click on "Tables" -> "Refresh" Yes. Right click -> "Reload Navigator" Yes, click "Refresh" toolbar icon Yes, right click -> "Refresh Objects Tree" Yes. Popup menu "Refresh". No No
Rename No Yes for tables. No for views, but can double click, change name field (fails if name contains space). Yes, double click on name to edit. Yes. But deletes triggers associated with renamed table/view. No No No Yes Yes No No. "Rename table" popup menu just shows template SQL No No (not existing entities)
View/edit data of selected table/view (without need for explicit query) Yes Yes, for tables, right click -> "Query". No for views. Yes for view. No for table, but can select table from menu with two clicks and then click "Show All" button in "Content" pane. Yes for tables No Yes, click "Data" tab and start button Yes, click "Execute" button in "Data" tab. Yes, right click -> "Edit" Yes Yes, in "Data" tab Yes via popup menu "Edit table rows" or "Query view" No No
Shows indexes belonging to selected table Yes, via "Info" -> "Indexes" No Yes Yes Yes No No Yes No, though does show number of associated indexes Yes, in "Indexes" tab Yes, by expanding table in entity browser No No
Shows triggers belonging to selected table/view Yes, via "Info" -> "Triggers" No Yes, but you have to reselect the table or view first. No No No No Yes for Tables, no for views. No No, missing for SQLite Yes, by expanding table/view in entity browser No No
Can show SQL of triggers/indexes with SQL of parent table/view No No No No No No No Yes No No No No No
Edit/view SQL of selected table, view Yes, click "info" then "DDL" button. Yes Yes. Shows for views. For tables need to click on "Show create table" button. Yes for views, no for tables No No. Recreates its own SQL, ignoring original, adding unnecessary (200000000) parameters, reformatting No? Not yet implemented? Yes. Right click -> "View DDL" Yes, in "Structure" tab, though scrolling field is too small at only 4 lines. No, missing for SQLite Yes, via popup menu "Show CREATE statement" No No
SQL Editing Froq SQLiteManager MesaSQLite Base Orac SQLGrinder DB Solo RazorSQL SQLite Manager for FireFox DBVisualizer Spatialite SQLiteQuery SQLEditor
SQL text editor Yes Yes Yes "Custom Query" Yes Yes Yes Yes Yes Yes Yes Yes Yes No
Syntax color Yes Yes Yes Yes Yes, only keywords Yes (slight bug when encountering a "/") Yes Yes No Yes No No No
Colors are context aware Mostly. Some inconsistent coloring of entity names. No No No No Yes? No No? No Yes? No No No
Distinct color for quoted identifiers vs literals No No No No No Yes No No No No No No No
Distinct color for tables/views Yes, but inconsistent No No No No Yes No No No No No
Distinct color for join aliases No No No No No No No No No No No
SQL indenting Yes, "Format indenting" command No No No No No No Yes but ignores level No Yes, extensive including alignment No No No
Keeps original case for keywords Yes Yes Yes Yes Yes (option for Caps) Yes. Can manually select text and choose upper/lower Yes Yes. Optional upper Yes Yes. Optional upper or lower Yes Yes creates upper
Copy from manually activated list of tables/columns No No, but can paste from list of shortcuts No No No No No Yes No No No No No
Drag and drop objects into text Yes, from entity list and "Statement Recall" No No. Entity list not visible in "Custom Query" tab. No No Yes, but dragging table from browser drops other table's column names No No No Yes, from entity list No No No
Auto completion No No No No No Yes. Hit escape key to show list of options. Problem with being case sensitive and doesn't quote entity names that need it. Pop up of tables/views (not columns) No No No "Show Autocompletion" from menu doesn't work No No No
Execution Froq SQLiteManager MesaSQLite Base Orac SQLGrinder DB Solo RazorSQL SQLite Manager for FireFox DBVisualizer Spatialite SQLiteQuery SQLEditor
SQL Execute Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No
Copes with spaces and reserved words in identifiers Yes No. Works in basic queries on tables. Fails in alter GUI and queries on views etc. Query on table uses [] but should use "". Yes Yes, though fails in "Alter" GUI, maybe others. Yes Yes for column names if enable preference "Browser" -> "Quote table column names when querying". No for table/view names. Yes? Yes Yes Yes, if set option for delimiters to "" No No Yes, except incorrectly uses single quotes instead of double


Time taken to build page: 1.306s