Manage all your SQLite databases using this lightweight extension for Firefox, Thunderbird, SeaMonkey, Songbird, Komodo etc. (See the complete list of supported applications) This extension will be useful to developers who want to create and play with SQLite databases.
SQLite Manager is available as a XULRunner application too.
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
supports writing your own queries (single or multiple)
supports saving the queries with a name
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, sql or xml files
import tables from csv, sql or xml files
a dropdown menu showing all profile db (.sqlite)
an intuitive heirarchical tree showing all tables, indexes, views and triggers
ability to see the master tables
ability to see the temporary tables, indexes, views and triggers
ability to browse data from any table/view
dialogs to allow searching in a table/view
allows editing and deleting selected record while browsing a table's data
allows adding, saving and changing blob 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
Comments and Reviews
To export a view to Excel, export it as a CSV file with tab separated values, and use an editor to convert encoding. Rename the extension to xls and open in Excel.