Thursday, March 10, 2011

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!