I've tried many free tools as well as shareware tools. Here are my two favorites and why:
SQLite Manager for Firefox, Thunderbird, etc: http://code.google.com/p/sqlite-manager/ This one is simply amazing! It does everything I want, supports multiple platforms and is completely free. It doesn't include any nice new user features like a query builder and what not but it includes everything an end user would need to view/manage their database. After using this I stopped looking. SQLite Maestro: http://www.sqlmaestro.com/products/sqlite/maestro/ This is a shareware tool that is free for 30 days. This tool is very good and does everything you would expect a SQL database tool to do. One of my subtle gripes with it however is how it displays certain data. I have many many several text-type foreign keys and instead of displaying the text value, it displays it as "MEMO". Other than that though the tool is much better than any others I've tried prior to Firefox's plugin. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Allen Fowler Sent: Tuesday, August 04, 2009 10:50 AM To: [email protected] Subject: [sqlite] GUI design & managment tool? Hello, Can anyone recommend a Free, or reasonably priced Non-Free, GUI tool for creating and maintaining an SQlite databases that can run on both Windows and Linux? (Support for visual relation design would be great, too.) I found a list at: http://www.sqlite.org/cvstrac/wiki?p=ManagementTools But, I was wondering if anyone has personal experience to share... Thanks, :) _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

