Hello, I've put together a command line tool, that is, schemadoc [1] that lets you auto-generate your SQLite database schema docu for tables, columns, etc.
The schemadoc tool connects to your SQLite database and writes out the schema info in database.json and also builds an a-z symbol index in symbols.json. Drop the json files in the _data/ folder for your static site theme (template pack) and let Jekyll (or GitHub Pages) do the rest. See the football.db [2] or beer.db [3] examples. All code and templates public domain. Cheers. [1] https://github.com/rubylibs/schemadoc [2] http://openfootball.github.io/schema [3] http://openbeer.github.io/schema PS: Thanks for your suggestions and helping w/ the design of the tool and templates. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users