2008-03-12, 11:54 AM
Just thought I'd mention it as it seems quite a useful little device.
http://sqlitemanager.mozdev.org/
http://sqlitemanager.mozdev.org/
Quote:Features:
* dialogs for creation, deletion of tables, indexes, views and triggers
* ability to rename, copy, reindex tables
* ability to add and drop columns
* create new db, open any existing db, copy an existing db
* a tab for database settings (no need to write the pragma statements) where you can view and change the sqlite library settings
* export tables/views as csv or xml files
* import tables from csv or xml files
* a dropdown menu showing all profile db (*.sqlite)
* an intuitive heirarchical tree showing all tables, indexes, views and triggers
* ability to browse data from any table
* dialogs to allow searching in a table
* allows editing and deleting selected record while browsing a table's data
* an extensive menu that helps with writing sql by hand and then executing it
* remembers the last used db, table and the tab (structure, browse & search, etc.) across sessions