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

Walter Williams wrote: > > I received the same result. > Is that the same error message you posted before (i.e. "Unable to complete operation. The supplied SqlConnection does not specify an initial catalog or AttachDBFileName.")? That particular error message leads me to believe that the Entity

Re: [sqlite] Possible to get table size (in bytes)?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/04/2015 10:26 AM, Rael Bauer wrote: > Is it possible to get the information of how many bytes a table is > taking up in the database? What is the underlying problem you are trying to solve with this information? There may be alternate

Re: [sqlite] Possible to get table size (in bytes)?

On 2015/02/04 20:26, Rael Bauer wrote: Hi, Is it possible to get the information of how many bytes a table is taking up in the database? Not with API calls, but it is possible by running the SQLiteAnalyzer utility afvailable from the same download pages as SQLite3 CLI etc.

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

I received the same result. Walter Williams Senior Software Engineer Sawtooth Software, Inc. "Do, or do not. There is no try." -Original Message- From:

Re: [sqlite] Query Planner for Virtual Tables: link table evaluation & transitive property of constraints not used

Hello, I went forward and implemented the suggestion I made. It works quite nice, so I decided to share a patch (https://www.dropbox.com/sh/buim6b4hevg7db3/AAD75j1NkXSakx-1_iGu1QW4a?dl=0). Statement: I (the author of this code patch) dedicate any and all copyright interest in this code patch

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

Green Fields wrote: > > I realise that Windows Mobile 6 is not well supported any more, but can > anyone help with some insight of what may be causing this to occur on the > Mobile and not the desktop? > It is supported. However, I've been unable to reproduce the issue that you describe here

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

Walter Williams wrote: > > Is this a bug in the package or am I missing something? > It may be a "bug" in the System.Data.SQLite 1.0.94.0 packaging. Several people have reported issues; however, it seems to depend on the number of updates installed for Visual Studio 2012 / 2013. Could you

Re: [sqlite] Possible to get table size (in bytes)?

On 4 Feb 2015, at 6:49pm, Stephen Chrzanowski wrote: > I can't be certain if a > single page contains multiple types of data such as table AND index > information. In a SQLite file, each page is assigned to header information or to a specific table or index. No mixed

Re: [sqlite] Possible to get table size (in bytes)?

Wrong answer. He's asking how many bytes a table takes up within the database. That would depend on a whole lot of factors including what is stored, the number of fields, etc. Is there SQL code to get requested result? Short answer, No. Not easily. Long answer, a table isn't a certain number

Re: [sqlite] Possible to get table size (in bytes)?

On 4 February 2015 at 18:26, Rael Bauer wrote: > Hi, > > Is it possible to get the information of how many bytes a table is taking up > in the database? For Windows, see http://www.sqlite.org/download.html#a10 There are other links for other operating systems > Thanks >

[sqlite] Possible to get table size (in bytes)?

Hi, Is it possible to get the information of how many bytes a table is taking up in the database? Thanks Rael ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] HashBackup sqlite 3.6.18 -> 3.8.8 performance

To add to the real-world performance info, I recently upgraded the backup program I'm developing, HashBackup, from SQLite 3.6.18 to 3.8.8, mostly to see if it fixed some occasional "Database is locked" errors (multithreaded). For these tests, nothing was changed except the SQLite library.

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

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

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

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

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]