Friday, March 11, 2011

Free+OpenSource software for SQLite database management

Here's another software that I checked out from
Its called SqliteMan
You can download the latest windows version from here :

Its made in Qt4 (C++). Anyways on to the review as a user.
I downloaded the zip file for version 1.2.1 win32 : 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.