|
|
Version 0.2.39 Released
A very lightweight firefox extension (originally) to manage all your sqlite databases. This extension will be useful to developers who want to create and play with sqlite databases. For changes since the last version, see this.
Supported Applications
Actually, SQLite Manager targets more applications than just firefox. See the complete list
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
- 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
More and more developers will start using SQLite. To help them manage their databases through a Mozilla extension is the motivation behind this add-on extension.
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.