sqlite-manager - Project Hosting on Google Code

sqlite-manager Extension for Firefox and other apps to manage any sqlite database

Project Home		Downloads		Wiki		Issues		Source

Summary | Updates | People

Star this project

Activity: High

Code license: Mozilla Public License 1.1

Labels: sqlite, database, gui, firefox, mozilla, addon, thunderbird, xulrunner, seamonkey, komodo

Featured downloads: sqlitemanager-0.6.0.xpi sqlitemanager-0.6.1b1.xpi sqlitemanager-xr-0.6.0.zip sqlitemanager-xr-0.6.1b1.zip Show all »

Featured wiki pages: FAQ OtherLanguages ScreenShots SupportedApplications Show all »

External links: Statistics http://www.sqlite.org/

Feeds: Project feeds

Owners: mrinal.kant, tarakant...@gmail.com

Contributors: mozrob, a1rex2003

People details »

Announcements¶

• It would be nice to have someone contribute in providing a simple documentation about what one can do with SQLite Manager (and what one cannot).

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. The file with XR in its name is the zip of the XULRunner application. Read More...

Other Languages (German, Russian, Spanish)

You can also download from Mozilla Addons site

Changes in version 0.6.1 Changes in version 0.6.0

SQLite Manager for other applications¶

• Songbird: http://addons.songbirdnest.com/addon/1711
• Komodo: http://community.activestate.com/xpi/sqlite-manager
• Firefox 3.0: http://sqlite-manager.googlecode.com/files/SQLiteManager_0.4.8.xpi

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

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.

Go there...
http://code.google.com/p/sqlite-manager/

Don