SQLite Manager 0.3.11

Manage any SQLite database on your computer. An intuitive heirarchical tree showing database objects. Helpful dialogs to manage tables, indexes, views and triggers. You can browse and search the tables, as well as add, edit and delete the records.
Facility to execute any sql query. A dropdown menu helps with the sql syntax thus making writing sql easier. Easy access to common operations through menu, toolbars, buttons and context-menu.
SQLite Manager allows you to export tables/views in csv or xml format.
SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine. An SQLite database is a single ordinary disk file that can be located anywhere in the directory hierarchy. It is likely that most of the storage in Mozilla applications, in near future, will use SQLite.
Note: The SQLite Manager add-on is cross-platform and it works on Mac OS X, Windows and Linux.

Main 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 as csv files
- a dropdown menu showing all profile db (*.sqlite)
- an intuitive hierarchical 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 tables data
- an extensive menu that helps with writing sql by hand and then executing it
- remembers the last used db across sessions

System requirements:
-

Enhancements:
- Issue #151 : "Copy Row" command should not include rowid if it is not a column in the table. Fixed.
- Issue #156 : Add Record, Edit Record, Search dialogs: Allow to paste constants instead of typing them. As of now, you can paste constants in input fields in dialogs for Add Record, Edit Record, Duplicate Record, Search by using the following shortcut keys: CTRL + 1: CURRENT_DATE, CTRL + 2: CURRENT_TIME, CTRL + 3: CURRENT_TIMESTAMP
- Issue #169 : Add New Record: Option to retain the previous values in the textboxes or to clear all textboxes and show default values where available. This can be done by setting the value of preference "extensions.sqlitemanager.whenInsertingShow" to either "previous" or "default". The default value is "previous". The preference can be set from the Options dialog. However, when the Add Record dialog is first opened, default values will be shown whatever the preference is set to.
- Issue #171 : support SeaMonkey 2.0a2. Done.
- Issue #174 : Export the Database Structure. This can be done through a menuitem "Export Database Structure" under the "Database" menu.
- Issue #175 : Default values for columns should not be converted to strings in all cases. The problem occurs in create table dialog and add column action under structure tab. Even if numbers like 12, 12.21, 12.1e-2, etc. are specified and while adding column even if the default value is left blank, the extension converts them to strings and adds the default clause in the column definition. This has now been fixed. If the default value field contains the string NULL (case-insensitive) or is blank, the default clause is omitted. If the value can be converted to a number it is considered as a number otherwise it is regarded as a string. The special strings CURRENT_DATE, CURRENT_TIME and CURRENT_TIMESTAMP are treated as constants.
- Issue #176 : Add Record, Edit Record, Search dialogs: accesskey related errors. Fixed.