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

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

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

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

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

I was just about to post a link to this. I am still using it. Handy tool, it does a great job with the HTML doc. -- Bill Drago Senior Engineer L3 Communications / Narda Microwave East 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / william.dr...@l-3com.com > -Original Message- >

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

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

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

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

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

[sqlite] Repost: Having problems with Entity Framework code first db creation

I'm trying to use a code first model using the System.Data.SQlite NuGet (v1.0.94.1) package and Entity Framework. I'm using VS 2013. I have defined my objects, but when I try to create a new database file using them, I get an error "Unable to complete operation. The supplied SqlConnection does

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

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

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. ___

Re: [sqlite] Performance increase between 3.7 and 3.8

On Tue, 3 Feb 2015 06:39:02 -0700 (MST) Jan Slodicka wrote: > Eduardo Morras-2 wrote > > A ~8000MB db with app example data. More than 1000 query-corp > > created as part of test driven development of the app. We have > > precalculated the correct results in tables and its number

Re: [sqlite] Performance increase between 3.7 and 3.8

Eduardo Morras-2 wrote > A ~8000MB db with app example data. More than 1000 query-corp created as > part of test driven development of the app. We have precalculated the > correct results in tables and its number of rows. No write, only read > queries and don't use other improvements like partial

Re: [sqlite] "database disk image is malformed" error occurs more (AGAIN, damage)

Had another damaged database report. This time it is a configuration database which holds application settings. The file is stored on a local disk, not shared, and only ever accessed by my application and only by one thread. The database is run in FULL sync mode for maximum security. I’m

Re: [sqlite] Performance increase between 3.7 and 3.8

On Tue, 3 Feb 2015 02:43:00 -0700 (MST) Jan Slodicka wrote: > Eduardo Morras-2 wrote > > I use a big test db to assure new versions of sqlite works > > properly. With 3.7.15.2 it takes 43 minutes, with 3.8.8.2 on same > > hardware 27 minutes, it's 16/0.43 = 37% less or 27/0.43 =

Re: [sqlite] Performance increase between 3.7 and 3.8

Eduardo Morras-2 wrote > I use a big test db to assure new versions of sqlite works properly. With > 3.7.15.2 it takes 43 minutes, with 3.8.8.2 on same hardware 27 minutes, > it's 16/0.43 = 37% less or 27/0.43 = 63% improve. Thanks, Eduardo. Could I ask you for a rough characterization of the

Re: [sqlite] Performance increase between 3.7 and 3.8

Richard Hipp-3 wrote > From the description, your tests sound like you are pushing a bunch of > separate SQL statements into SQLite. In other words, the compute time > is likely dominated by the time need to parse the SQL and prepare > plans. Yes > Have you rerun the tests using prepared