Friday, March 11, 2011

Free+OpenSource software for SQLite database management

Here's another software that I checked out from http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
Its called SqliteMan
You can download the latest windows version from here : http://sourceforge.net/projects/sqliteman/files/sqliteman/

Its made in Qt4 (C++). Anyways on to the review as a user.
I downloaded the zip file for version 1.2.1 win32 : sqliteman-1.2.1-win32.zip extracted and run. Easy peasy.
Now for the key features review.

Altertable is pretty basic. I missed that you cannot reorder rows. (although in the software defense it is a drop and recreate table script that would be required)

The create index setting is decent. No surprises there. 

I like the template provided for Create Trigger:


The Sql Editor is pretty basic. No intellisense. Just syntax highlighting.


I specifically liked the CreateView from current statement option.


The describe table option is vital to my way of working. Especially when you end up with legacy code:

However the resultant output is not formatted nicely. Its just a single line.

All in all its a pretty decent piece of software. And for the price you really can't complain.