2010-02-27

Slitaz -- sqlite


tux@alanyih:~$ tazpkg info sqlite

Tazpkg information
================================================================================
Package : sqlite
Version : 3.6.16
Category : office
Short desc : Small SQL database engine.
Maintainer : pankso@slitaz.org
Web site : http://www.sqlite.org/
================================================================================

tux@alanyih:~$ ls ~/.mozilla/firefox/7kdi32oc.default/*.sqlite
/home/tux/.mozilla/firefox/7kdi32oc.default/content-prefs.sqlite
/home/tux/.mozilla/firefox/7kdi32oc.default/cookies.sqlite
/home/tux/.mozilla/firefox/7kdi32oc.default/downloads.sqlite
/home/tux/.mozilla/firefox/7kdi32oc.default/formhistory.sqlite
/home/tux/.mozilla/firefox/7kdi32oc.default/permissions.sqlite
/home/tux/.mozilla/firefox/7kdi32oc.default/places.sqlite
/home/tux/.mozilla/firefox/7kdi32oc.default/search.sqlite
/home/tux/.mozilla/firefox/7kdi32oc.default/signons.sqlite
/home/tux/.mozilla/firefox/7kdi32oc.default/urlclassifier3.sqlite
tux@alanyih:~$

Add-ons for Firefox
SQLite Manager 0.5.11
by Tarakant Tripathy, Mrinal Kant
https://addons.mozilla.org/en-US/firefox/addon/5817?from=%2Fzh-TW%2Ffirefox%2Faddon%2F5817

More about this add-on

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, delete and duplicate the records. Facility to execute any sql query. The views can be searched too. 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. Export tables/views/database in csv/xml/sql format. Import from csv/xml/sql (both UTF-8 and UTF-16). Possible to execute multiple sql statements in Execute tab. You can save the queries. Support for ADS on Windows.

New issues, bugs, request for enhancements can be entered at:
http://code.google.com/p/sqlite-manager/issues/list.
.