SQLite Manager 是一个开源的SQLite管理工具,可以作为firefox, thunderbird, sunbird, seamonkey, songbird, komodo, flock等的插件,也可以作为独立程序(XULRunner application)。
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
本文转自RubyPdf 的中文博客博客园博客,原文链接:http://www.cnblogs.com/hardrock/archive/2009/02/15/1391084.html,如需转载请自行联系原作者博客园博客