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.

Book Review: DSLs in Boo: Domain-Specific Languages in .NET

In short : Buy it. This book (DSLs in Boo: Domain Specific Languages in .NET) is the best book on DSL programming that you will ever read ... and really you should read a book on DSL programming. Even if you never do it. You never know when you might need it.

This book is written by one of the smartest programmers alive. The book uses Boo as the programming language of choice for DSL. The reasons for this are mentioned in chapter two of the book under "Boo’s built-in language-oriented features" Highly convincing. And he even mentions why its a better idea than IronPython and IronRuby. Boo is a respected language and you have admit that "wrist friendly language for the CLI" is pretty catchy. Also I recommend you get sharpdevelop (now at version 4!) to play a little with Boo.

The book is as complete a DSL book as you can get. I am still going through the book and am 4 chapters in (along with reading 4 other books... one of them being for my upcomming ADO.NET 4 certification exam ... all great books ... I really should review books more often). Also it is the only book on Boo that I know of.

PS: Boo just released a .NET framework 4 version of the binaries which means that you can use it freely in your latest and greatest cutting edge applications.