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

[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, sqlite-users@sqlite.org





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 HTML) for tables, fields, etc

[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 twenty lines of
Ruby). You can see an example, for the football.db online [1]. Cheers.

[1] https://github.com/book-templates/schema/blob/master/_data/schema.json

PS: The static site generator (e.g. Jekyll) is actually built into
GitHub - so the idea is you upload the schema in json and the docu
auto-builds itself (incl. free hosting thanks to GitHub Pages).


I had something that I would use to draw a few pictures of the table 
schema... since you're using Ruby, I'm tempted to revisit that...


Best Regards,
Mohit.


___
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

[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
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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

[Drago, William @ CSG - NARDAEAST]

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-
> 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 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
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.
___
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

[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
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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, for the football.db online [1]. Cheers.

[1] https://github.com/book-templates/schema/blob/master/_data/schema.json

PS: The static site generator (e.g. Jekyll) is actually built into
GitHub - so the idea is you upload the schema in json and the docu
auto-builds itself (incl. free hosting thanks to GitHub Pages).
___
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 HTML) for tables, fields, etc

[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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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 was just in the process of making such a tool - maybe we could help each other. Could you send me an example schema and 
resulting document that you would like it to produce?

No need to be complex, but it needs to contain every plausible kind of result 
needed. Triggers and Indices too. Thanks!



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Walter Williams]

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 not specify an initial catalog or AttachDBFileName."

I created a simple project which demonstrates the error.  It can be
downloaded from
http://www.sawtoothsoftware.com/download/temp/SQLiteTest.zip.  I was able to
use the same code with SQL Server Compact 4.0 but for preference I'd like to
use SQLite.

Is this a bug in the package or am I missing something?


Walter Williams
Senior Software Engineer
Sawtooth Software, Inc.


"Do, or do not.  There is no try."


___
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 HTML) for tables, fields, etc

[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 format, try the .schema command from the command line.

  Invoke sqlite3, then type .help to see all options. The .sc option dumps
the entire schema to the display; if you specify a table name then the
schema for only that table is displayed.

Rich
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Performance increase between 3.7 and 3.8

[Eduardo Morras]

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 of rows.
> > No write, only read queries and don't use other improvements like
> > partial indexes. Queries run in sequential order at a time.
> 
> That means that (complex) queries are substantially faster in v3.8.
> That's important for me, too.

Yes, the 'next generation query planner' helps a lot in queries with more than 
4 tables, temp or normal tables.

> 
> Thanks.


---   ---
Eduardo Morras 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Performance increase between 3.7 and 3.8

[Jan Slodicka]

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 indexes. Queries run
> in sequential order at a time.

That means that (complex) queries are substantially faster in v3.8. That's
important for me, too.

Thanks.




--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/Performance-increase-between-3-7-and-3-8-tp80355p80371.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Mario M. Westphal]

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 puzzled. These files are very small, a few MB only.


The error message is

 

*** in database main ***Page 15: Rowid 3050 out of order (max larger than 
parent max of 3016)Page 128: Rowid 3017 out of order (min less than parent min 
of 3050) 

 

 

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Performance increase between 3.7 and 3.8

[Eduardo Morras]

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 = 63%
> > improve.
> 
> Thanks, Eduardo. Could I ask you for a rough characterization of the
> test performed?

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 indexes. Queries run in sequential order at 
a time.

Some queries test own sql functions and a virtual table, no improvements 
expected on them.

The test was done with same application version in debug mode and recompiled 
with 3.7.15.2 on same computer. All tests passed.

---   ---
Eduardo Morras 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Performance increase between 3.7 and 3.8

[Jan Slodicka]

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 test
performed?



--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/Performance-increase-between-3-7-and-3-8-tp80355p80368.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Performance increase between 3.7 and 3.8

[Jan Slodicka]

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 statements, where you
> do a limited number of sqlite3_prepare_v2() calls and then reuse each
> prepared statement multiple times with different bound parameters?
> That's the kind of work-load we have been striving to optimize, since
> we figure anybody who is interested in performance is already making
> heavy use of prepared statements.

We call SQLite from C# and use a .net wrapper inspired by system.data.sqlite
package. In other words there is a lot of overhead in high level layer.
(Moreover, we rely on Mono implementation, which is even slower.) In the old
days I run a lot of tests trying to find out the fastest way until we
decided for the current algorithm. Since then we heavily optimized the C#
layer and you now optimized the C code.

Maybe the original decision is not true anymore. If I find spare time I'll
run the tests again. But right now I am primarily interested whether it
makes sense to upgrade SQLite code.





--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/Performance-increase-between-3-7-and-3-8-tp80355p80367.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users