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.

Free+OpenSource software for SQLite database management

I have been looking through SQLite management tools free + opensource (what can I say ... sqlite has me spoilt! ) from here : http://www.sqlite.org/cvstrac/wiki?p=ManagementTools

And I really like SQLite Studio http://sqlitestudio.one.pl/

Check out there screenshots here : http://sqlitestudio.one.pl/index.rvt?act=screenshots
They pretty much cover everything. I don't need to say much more.

Here are a few I took on windows:

Edit Table

Edit / Add / Commit data in the table

My favorite feature: The DDL for the table

The SQL Editor. And yes Ctrl+Space filled up the tale name for me. Intellisense :)

I needed something lightweight and this is awesome. Just a simple exe :)

Also check out the Query explain: 

Enjoy!