Re: [sqlite] Looking for SQLite schema doc generator (in

2015-02-04 Thread Erik Ejlskov Jensen
Thanks, I simply adapted this: https://sqldbdoc.codeplex.com/ And you can modify the xlst file if you have the guts Sendt fra Windows Mail Fra: gerald.ba...@gmail.com Sendt: ‎tirsdag‎, ‎3‎. ‎februar‎ ‎2015 ‎18‎:‎29 Til: Erik Ejlskov Jensen Cc: rsm...@rsweb.co.za,

Re: [sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

2015-02-04 Thread Gerald Bauer
Hello, Thanks. Good point. Will rename fields to columns in schema.json. Was trying initially to (re)use the Tabular Data Package format (in json) [1] from the Open Knowledge Foundation (OKFN) but it's not really a good fit. Sorry for the broken link. The schemadoc repo (that generates the

Re: [sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

2015-02-04 Thread Dominique Devienne
On Wed, Feb 4, 2015 at 9:18 AM, Gerald Bauer wrote: > [1a] New schemadoc Ruby Gem -> https://github.com/rubylibs/schemadoc > [DD] 404 for me > [1b ] Templates -> >

Re: [sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

2015-02-04 Thread Gerald Bauer
Hello, > I had something that I would use to draw a few pictures of the table schema... You're invited to share your code - my first version [1] is text-only so far. Always good to have some diagrams - a picture is worth a thousand words etc. ;-) Keep it up. Cheers. [1a] New schemadoc Ruby

Re: [sqlite] Looking for SQLite schema doc generator (in

2015-02-04 Thread Gerald Bauer
Hello, Thanks for the pointer to the template. I'm using a plain HTML template w/ Liquid tags [1]. You can see a rendered (live) version online. [2] Thanks for the inspiration. Cheers. [1] https://github.com/book-templates/schema/blob/gh-pages/index.html [2]

Re: [sqlite] Looking for SQLite schema doc generator (in

2015-02-03 Thread Erik Ejlskov Jensen
Thanks, I simply adapted this: https://sqldbdoc.codeplex.com/ And you can modify the xlst file if you have the guts Sendt fra Windows Mail Fra: gerald.ba...@gmail.com Sendt: ‎tirsdag‎, ‎3‎. ‎februar‎ ‎2015 ‎18‎:‎29 Til: Erik Ejlskov Jensen Cc: rsm...@rsweb.co.za,

Re: [sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

2015-02-03 Thread Mohit Sindhwani
On 4/2/2015 12:20 AM, Gerald Bauer wrote: Hello, I have started two hours ago ;-) to put together a little script. The idea is to "dump" the schema as json and then use a static site generator w/ html templates to generate the docu. So far the script that generates the json dump (is

Re: [sqlite] Looking for SQLite schema doc generator (in

2015-02-03 Thread Erik Ejlskov Jensen
You can use my Visual Studio addin: SQLite Toolbox to do this: http://erikej.blogspot.dk/2014/08/sqlite-toolbox-40-visual-guide-of.html Sendt fra Windows Mail ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Looking for SQLite schema doc generator (in

2015-02-03 Thread Gerald Bauer
Hello, > SQLite Toolbox Thanks for highlighting. The HTML pages for the schema looks great. Cheers. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Looking for SQLite schema doc generator (in

2015-02-03 Thread Drago, William @ CSG - NARDAEAST
age- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Erik Ejlskov Jensen > Sent: Tuesday, February 03, 2015 12:11 PM > To: rsm...@rsweb.co.za; gerald.ba...@gmail.com > Cc: sqlite-users@sqlite.org > Subject: Re: [sqlite] Looking for SQLite

Re: [sqlite] Looking for SQLite schema doc generator (in

2015-02-03 Thread Erik Ejlskov Jensen
You can use my Visual Studio addin: SQLite Toolbox to do this: http://erikej.blogspot.dk/2014/08/sqlite-toolbox-40-visual-guide-of.html Sendt fra Windows Mail ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

2015-02-03 Thread Gerald Bauer
Hello, I have started two hours ago ;-) to put together a little script. The idea is to "dump" the schema as json and then use a static site generator w/ html templates to generate the docu. So far the script that generates the json dump (is twenty lines of Ruby). You can see an example,

Re: [sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

2015-02-03 Thread Gerald Bauer
Hello, Thanks. Good point. Wrapping into a html pre tag and it's a great cheat sheet as a single html page. Ideally looking for something with an index page, table cross-references as links, etc. Cheers. ___ sqlite-users mailing list

Re: [sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

2015-02-03 Thread RSmith
On 2015/02/03 17:34, Gerald Bauer wrote: Hello, I'm looking for a little tool that reads in an SQLite schema (e.g. beer.db, football.db, etc.) and outputs (generates) documentation for tables, fields etc. as a single HTML page or as HTML pages.Any insight appreciated? Actually I

Re: [sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

2015-02-03 Thread Rich Shepard
On Tue, 3 Feb 2015, Gerald Bauer wrote: I'm looking for a little tool that reads in an SQLite schema (e.g. beer.db, football.db, etc.) and outputs (generates) documentation for tables, fields etc. as a single HTML page or as HTML pages. Any insight appreciated? Gerald, While not in html

[sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

2015-02-03 Thread Gerald Bauer
Hello, I'm looking for a little tool that reads in an SQLite schema (e.g. beer.db, football.db, etc.) and outputs (generates) documentation for tables, fields etc. as a single HTML page or as HTML pages.Any insight appreciated? Cheers. ___