Sqlite-manager is a tool that originated as a Mozilla (Thunderbird, Lightening, FireFox) plug-in for managing SQLite databases. However, over at the Kiveo website blog, I found instructions for making this plug-in a stand-alone application.
I followed the directions exactly as posted (note though, that the current version of the sqlitemanager-xr packageis now 0.5.16) and it works perfectly.
Here's a running list of the current features:
I followed the directions exactly as posted (note though, that the current version of the sqlitemanager-xr packageis now 0.5.16) and it works perfectly.
Here's a running list of the current 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
And here's a screenshot of it running happily on my Mac (OS 10.5.8)
The correct link is:
ReplyDeletehttp://www.kiveo.net/blog/mac-sqlite-manager-standalone-app/
Thanks Matt!
ReplyDeleteSomehow I just saw this and have corrected the link.
YOU can use on MAC OS X - free tool Valentina Studio, does everything you need, and does it very well http://www.valentina-db.com/en/valentina-studio-overview
ReplyDeleteYou can install Valentina Studio (FREE) directly from Mac App Store: https://itunes.apple.com/us/app/valentina-studio/id604825918?ls=1&mt=12