Tuesday, May 25, 2010

Free SQLite Manager for Mac OS


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)



                                        3 comments:

                                        1. The correct link is:

                                          http://www.kiveo.net/blog/mac-sqlite-manager-standalone-app/

                                          ReplyDelete
                                        2. Thanks Matt!
                                          Somehow I just saw this and have corrected the link.

                                          ReplyDelete
                                        3. 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
                                          You can install Valentina Studio (FREE) directly from Mac App Store: https://itunes.apple.com/us/app/valentina-studio/id604825918?ls=1&mt=12

                                          ReplyDelete