MyGeneration software has added SQLite support to thier freeware template based code generator.
http://www.mygenerationsoftware.com/ MyGeneration has a generic meta-data API that supports 9 databases with more on the way. The meta-data (which includes columns, indeces, foreign keys, etc) is made available in the templates which are written in JScript, C#, VBScript, or VB.Net. among other things, you can generate a middle tier, SQL scripts, documentation, export data, etc. I personally added the support for SQLite to MyGeneration, so if anyone out there finds it useful, please send me some feedback. I havn't had much of a test group. In fact, I'm the only guy that's tested it so far. ;) I also wrote a short article about collecting meta data from SQLite which can be found on my blog: http://justingreenwood.blogspot.com/2004/10/sqlite-100-free-database.html I love SQLite! I'm going to be using it in my next project. Thanks to all the people that are maintaining it!
