SQLite Applications Comparison
|
|
SQLite Applications Comparison
|
|||||||||
| 2008-05-07 | 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 | SQLGrinder | MesaSQLite | DB Solo | RazorSQL | SQLite Manager for FireFox | DBVisualizer | SQLiteQuery | SQLEditor |
| Icon |
|
|
|
|
|
|
|
|
|
|
| URL | http://www.alwintroost.nl/?id=82 | http://www.sqlabs.net/sqlitemanager.php | http://www.sqlgrinder.com/ | http://www.mesamysql.com/?realmesa_home | http://www.dbsolo.com/ | http://www.razorsql.com/ | http://sqlite-manager.googlecode.com | http://www.dbvis.com/products/dbvis/ | http://www.software-by-mabe.com/software/freeware.html#sqlitequery | http://www.malcolmhardie.com/sqleditor/ |
| Developer | Alwin Troost | SQLabs | Advenio | Rick Praetzel | DB Solo LLC | Richardson Software | Mrinal Kant | Minq Software | Manfred Bergmann | MalcolmHardie Company |
| Price | €49.99. Approx US$60 | US$49 | US$59 | US$20 | US$99 | US$49.95 | Free | US$149 | Free | US$79 |
| Version | 2.0.1 B1397 | 2.6.2 | 2.0.8 | 1.6.8 | 3.0 | 4.2.5 | 0.2.39 | 6.0.8 | 0.7.3 | 1.4b19 |
| Technologies | Froq | SQLiteManager | SQLGrinder | MesaSQLite | DB Solo | RazorSQL | SQLite Manager for FireFox | DBVisualizer | SQLiteQuery | SQLEditor |
| Operating System | Mac | Mac | Mac | Mac | Mac, others | Mac, others? | Mac, others? | Mac, others? | Mac | Mac |
| Platform | Cocoa | Cocoa, RealBasic | Cocoa | Cocoa, RealBasic | Java? | Java | Firefox or oter Mozilla app | Java (Mac theme) | Cocoa? | Cocoa? |
| Database | SQLite, Oracle, MySQL, others | SQLite | JDBC gives SQLite and others. Fussy about driver. | SQLite | JDBC gives SQLite and others | SQLite (Razor built in), others, or JDBC | SQLite | JDBC gives SQLite and others | SQLite | JDBC gives SQLite and others |
| Driver | Zentus? JDBC built in | Built in | Zentus JDBC v044 added | Built in | Zentus JDBC added | Built in | Built in | Zentus JDBC added | Built in | Zentus JDBC added |
| SQLite version | 3.5.8 | 3.3.12 | 3.5.8 | 3.4.2 | 3.5.6 | 3.4.0 | 3.3.5 | 3.5.6 | 3.5.6 | 3.5.6 |
| Can open database file on AppleShare volume | No | Yes | Yes using other JDBC. No using Zentus JDBC | Yes | Yes using other JDBC. No using Zentus JDBC | Yes | Yes | Yes using other JDBC. No using Zentus JDBC | No | Yes using other JDBC. No using Zentus JDBC |
| Demo/shareware limit | 25 day trial | 20 launches, with the ability to extend the trial period. | Beta | 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 | SQLGrinder | MesaSQLite | DB Solo | RazorSQL | SQLite Manager for FireFox | DBVisualizer | SQLiteQuery | SQLEditor |
| Resize columns | Yes, manually | Yes, manually | Yes, manually | Yes manually. "Set to natural widths" button doesn't seem to work. | Yes, manually | Yes, manually | Yes, drag | Yes. Manual and autosize | No | No |
| Reorder Columns | Yes, drag | No | Yes | Yes, drag. | Yes, drag | Yes, drag. | Yes, drag | Yes | 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? | Yes | No, so too cramped when many columns. | Yes | Yes | No |
| Show/hide columns | No | No | No | Yes, click on "Limit columns" button, or right click on column to choose "Hide column" from context menu. | No | No | Yes, via pop up menu on right of column headers | Yes | No | No |
| Quick sort columns | Yes, click single column header. Click "Sort" button to sort multiple. | No | Yes, click single column header | Yes, click on single column header. Or click on "Set multiple sort" button to show dialog. | Yes, click single column header | No | No | Yes. Click on first sort column, control click on second. | No | No |
| Quick filter rows | Yes, extensive. Can also drag cell from result set to filter. Buggy in views. | No | Yes, match one or all columns | No but since can only browse data via query, query is easily altered. | Yes | No. Can refine/add "where" clause | Yes, one condition per column | Yes, match one or all columns | No | No |
| Show column info | No | No | No | No | No | No. "Keys" tab shows editable list of key fields to use for updates. | No | Yes, key icon in header, tooltip shows column info. | No | No |
| Modes for viewing data | Froq | SQLiteManager | SQLGrinder | MesaSQLite | DB Solo | RazorSQL | SQLite Manager for FireFox | DBVisualizer | SQLiteQuery | SQLEditor |
| Column mode | Yes | Yes | Yes | Yes. Edits direct in cell if numeric, opens text in cell mode when double clicked. | Yes | Yes | Yes | Yes "Grid view" | Yes | No |
| Line/form mode | Yes, with next/previous. Click "Info" button to show in pane over columns. | Yes, by double click row in column mode. No row navigation in line mode. | No | 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 |
| Cell mode (large wrapped field) | Yes, via right click on cell, choose "Edit Value" | Yes, only way to enter data. | No | Yes. Opens in panel if cell is text. | 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 |
| Other modes | No | Generate saved "Report" in HTML or other text based format. | No | No | text column | No | No | No | No | No |
| Data entry | Froq | SQLiteManager | SQLGrinder | MesaSQLite | DB Solo | RazorSQL | SQLite Manager for FireFox | DBVisualizer | SQLiteQuery | SQLEditor |
| Entry in tables | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
| Entry in views (with "instead of" triggers) | No | Yes | No | No | No | Trouble | No | Yes | No | No |
| Mark & submit | No, immediate. Incorrectly updates whole row instead of just changes. Does have commit/rollback mechanism. | No, immediate | No, immediate | Changes not marked. Can autocommit or begin/end transaction via buttons. | No? Bug with data entry. | Yes | No, immediate | Yes | No | No |
| Null distinct from text | No | No, but does have "Set to null" command in cell entry. | No, but can set string to show | No. Nulls appear same as empty string. | No in column mode, NULL appears same as 'NULL' literal text. In Cell mode shows number of characters. | No | No, appears as "NULL" | Yes, can choose string and cell color. | No | No |
| GUI Create | Froq | SQLiteManager | SQLGrinder | MesaSQLite | DB Solo | RazorSQL | SQLite Manager for FireFox | DBVisualizer | SQLiteQuery | SQLEditor |
| Add Column | Yes | |||||||||
| Drop Column | Yes | |||||||||
| GUI create table | No, "Create Table" menu item disabled. | Yes | Yes | Yes, via grid | No | Yes | Yes | Yes, right click on "Tables" in browser -> "Create Table" | No | Yes |
| GUI create view | No | No, just shows dialog with field for name and select statement | No ("Create Table" panel offers "view" option but does same as table. | No | 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 | No |
| Link tables | No | No | No (though "Foreign Keys" tab might be promising when it works) | No (since no views) | 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 | SQLGrinder | MesaSQLite | DB Solo | RazorSQL | SQLite Manager for FireFox | DBVisualizer | SQLiteQuery | SQLEditor |
| Shows entities | Tables, views, indexes, triggers | Tables, indexes, triggers, indexes | Tables, views, indexes, triggers | Tables, no views | Tables and views but not indexes or triggers? | Tables, views, triggers, indexes | Tables, views, indexes, triggers | Tables, views, no triggers or indexes | No | Tables only |
| Filter list | Yes | No | Yes, after customizing toolbar to have search field. | No | No | No | No | Yes, with wildcards | No | No |
| Sorted list | Yes | No | Yes | No, creation order | Yes | Yes | Yes | Yes | No | No |
| Refresh manually | Yes, "Reload Connection info" from "Connection" menu. Also auto every 30s. | Yes, collapse/expand grouping | Yes, "Reload" button | Yes via "Refresh Tables" button | Yes, right click on "Tables" -> "Refresh" | Yes. Right click -> "Reload Navigator" | Yes, click "Refresh" toolbar icon | Yes, right click -> "Refresh Objects Tree" | No | No |
| Rename | No | No | No | Yes, double click on name to edit. Bug: uses SQLite's alter table command which quotes name in single quotes, which MesaSQLite doesn't list in browser properly or allow access. | No | Yes | Yes | No | 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, click "Data" tab and start button | No but can select table from menu with two clicks and then click "Show All" button in "Content" pane. | Yes, click "Execute" button in "Data" tab. | Yes, right click -> "Edit" | Yes | Yes, in "Data" tab | No | No |
| Shows indexes belonging to selected table | Yes, via "Info" -> "Indexes" | No | No | Yes | No | Yes | No, though does show number of associated indexes | Yes, in "Indexes" tab | No | No |
| Shows triggers belonging to selected table/view | Yes, via "Info" -> "Triggers" | No | No | Yes | No | Yes for Tables, no for views. | No | No, missing for SQLite | No | No |
| Shows SQL of triggers/indexes with SQL of parent table/view | No | No | No | No | No | Yes | No | No | No | No |
| Edit/view SQL of selected table, view | Yes, click "info" then "DDL" button. | Yes | No. Recreates its own SQL, ignoring original, adding unnecessary (200000000) parameters, reformatting | Yes. Click on "Show create table" button | 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 | No | No |
| SQL Editing | Froq | SQLiteManager | SQLGrinder | MesaSQLite | DB Solo | RazorSQL | SQLite Manager for FireFox | DBVisualizer | SQLiteQuery | SQLEditor |
| SQL text editor | Yes | Yes | Yes | Yes "Custom Query" | Yes | Yes | Yes | Yes | Yes | No |
| Syntax color | Yes | Yes | Yes (slight bug when encountering a "/") | No | Yes | Yes | No | Yes | No | No |
| Colors are context aware | Yes? | Yes? | Yes? | No | No | Yes? | No | Yes? | No | No |
| Distinct color for quoted identifiers vs literals | Yes | No | Yes | No | No | No | No | No | No | No |
| Distinct color for tables/views | Yes | Yes | No | No | No | |||||
| Distinct color for join aliases | No | No | No | No | No | |||||
| SQL indenting | Yes, "Format indenting" command | No | No | No | No | Yes but ignores level | No | Yes, extensive including alignment | No | No |
| Keeps original case for keywords | Yes | Yes | Yes. Can manually select text and choose upper/lower | Yes | Yes | Yes. Optional upper | Yes | Yes. Optional upper or lower | Yes | creates upper |
| Copy from manually activated list of tables/columns | No | No, but can paste from list of shortcuts | No | No | No | Yes | No | No | No | No |
| Drag and drop objects into text | Yes, from entity list and "Statement Recall" | No | Yes, but dragging table from browser drops other table's column names | Entity list not visible in "Custom Query" tab. | No | No | No | Yes, from entity list | No | No |
| Auto completion | 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. | No | Pop up of tables/views (not columns) | No | No | No "Show Autocompletion" from menu doesn't work | No | No |
| Execution | Froq | SQLiteManager | SQLGrinder | MesaSQLite | DB Solo | RazorSQL | SQLite Manager for FireFox | DBVisualizer | SQLiteQuery | SQLEditor |
| SQL Execute | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
| Copes with spaces and reserved words in identifiers | Yes | Yes in tables, no in views | Yes for column names if enable preference "Browser" -> "Quote table column names when querying". No for table/view names. | Mostly | Yes? | Yes | Yes | Yes, if set option for delimiters to "" | No | Yes, except incorrectly uses single quotes instead of double |