BAREFEET Base is a neat reliable SQLite GUI app. It's good to see tat the latest version has fixed a few problems, such as opening database files on AppleShare volumes and altering (add column or rename) of tables containing a space in the name. The syntax coloring is good (including known functions) but could be improved. The biggest drawback for me is that Base, like many other similar apps, doesn't facilitate editing of data in views. 1. The ability to drag entities into the SQL editor, since the entity browser is conveniently always visible. 2. A quick filter and/or search refinement for the entity list and the data viewer. 3. NULL showing as a blank cell but somehow distinct from text (eg a color or something to show it's different to an empty string). 4. Show triggers and indexes with the table/view that owns them. I've published a detailed comparison of Base and other SQLite GUI apps here: http://www.tandb.com.au/sqlite/compare/?mu (Version 1.3.2) |