[sqlite] Working with blob

On Thu, 28 Apr 2016 20:27:17 +0200 "deltagamma1 at gmx.net" wrote: > If I store the blob directly in the sqlite, is there a way to open the > blob directly with the respective programm (e.g. irfanview or a pdf > with acroread) ? I have heard of a FUSE filesystem implemented with SQLite. I

[sqlite] Lemon reduce action merge bug

I believe the lemon reduce action optimizer needs to compare the codePrefix and codeSuffix. Consider this example: 8< %type malloc {void *} %destructor malloc {free($$)} %type contrived_example {int} bug_report ::= contrived_example. contrived_example(LHS) ::= INT INT INT. { LHS = 0;

[sqlite] Working with blob

What is a convenient way to store the path from a external blob (jpg, pdf) ? How can I retrieve this blob ? Is there a Frontend which opens the jpg directly from the listed table-content ? If I store the blob directly in the sqlite, is there a way to open the blob directly with the respective

[sqlite] ANALYZE, sqlite_stat1, and query planning

On Thu, Apr 28, 2016 at 5:53 PM, Richard Hipp wrote: > > It looks like the ENABLE_STAT2/STAT4 options generate histogram data > which > > would probably help for non-uniform data? > > Yes, STAT4 provides histogram data to help with query planning on > tables with non-uniform data distributions.

[sqlite] ANALYZE, sqlite_stat1, and query planning

On Thu, Apr 28, 2016 at 5:28 PM, Rowan Worth wrote: > In an attempt to understand a slow query I've had a quick look at the > contents of the sqlite_stat1 table. It looks like the stat column contains > a series of integers like: > > > > > ... > > Is this observation correct? And if so, does

[sqlite] Working with blob

I strongly recommend that you store a SHA-256 hash (or pick a better hash algorithm if there is one) of the file content as a blob in the database as the canonical way to identify the file. This is much more reliable than doing it with the file's name, and any filename info can then be

[sqlite] Recent downloads gone? Bad http returns

On 4/28/16, Roger Binns wrote: > I can download 3.12.2 as > http://sqlite.org/2016/sqlite-autoconf-3120200.tar.gz but 3.12.1 and > 3.12.0 are now gone, giving a 404 error. URLs were > http://sqlite.org/2016/sqlite-autoconf-3120100.tar.gz and >

[sqlite] Working with blob

Semantics and methodology of use aside, SQLite is the same as MySQL, MSSQL, Access, etc, in that it is a tool to store and retrieve bytes in a retrievable way via some kind of structured language. None of mentioned tools actually do any sort of presentation of said data. "From the factory",

[sqlite] Recent downloads gone? Bad http returns

y broken. Roger -- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 181 bytes Desc: OpenPGP digital signature URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20160428/24c7ca5d/attachment.pgp>

[sqlite] ODP: ODP: Controlling of check-pointing of WAL Dbs

Thank you for all your help! Cheers, Albert Od: sqlite-users-bounces at mailinglists.sqlite.org w imieniu u?ytkownika Richard Hipp Wys?ane: 28 kwietnia 2016 15:16 Do: SQLite mailing list Temat: Re: [sqlite] ODP: Controlling of check-pointing of WAL Dbs

[sqlite] Recent downloads gone? Bad http returns

. Roger -- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 181 bytes Desc: OpenPGP digital signature URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20160428/54906

[sqlite] ANALYZE, sqlite_stat1, and query planning

On 4/28/16, Richard Hipp wrote: > On 4/28/16, Dominique Devienne wrote: >> >> Richard, is STAT3 or STAT4 required for >> https://www.sqlite.org/optoverview.html#skipscan ? >> Or essential for skip-scan to bring the most benefit? --DD > > No. But sqlite_stat1 data is. Skip-scan is only

[sqlite] ANALYZE, sqlite_stat1, and query planning

On 4/28/16, Dominique Devienne wrote: > > Richard, is STAT3 or STAT4 required for > https://www.sqlite.org/optoverview.html#skipscan ? > Or essential for skip-scan to bring the most benefit? --DD No. But sqlite_stat1 data is. Skip-scan is only attempted if there are an average of 18 or more

[sqlite] [System.Data.SQLite] int overflow in date handling when unixepoch is used

Jann Roder wrote: > > I just tested the new version that should have the fix for this and now > I get an ArgumentOutOfRangeException exception when I actually have a > value of Int64.MaxValue in a date column. Stack trace: > I am able to recreate the exception here. The value of Int64.MaxValue

[sqlite] ANALYZE, sqlite_stat1, and query planning

On 4/28/16, Rowan Worth wrote: > Hi guys, > > In an attempt to understand a slow query I've had a quick look at the > contents of the sqlite_stat1 table. It looks like the stat column contains > a series of integers like: > > > > > ... > > Is this observation correct? And if so, does sqlite

[sqlite] [System.Data.SQLite] int overflow in date handling when unixepoch is used

Hi Joe, I just tested the new version that should have the fix for this and now I get an ArgumentOutOfRangeException exception when I actually have a value of Int64.MaxValue in a date column. Stack trace: at System.DateTime.Add(Double value, Int32 scale) at

[sqlite] ODP: Controlling of check-pointing of WAL Dbs

On 4/28/16, Albert Banaszkiewicz wrote: > I assume (I will test it later), that by killing the process you mean simply > shutting it down (regularly) without ever calling sqlite3_close, am I right > ? Yes -- D. Richard Hipp drh at sqlite.org

[sqlite] FTS5 ranking across multiple databases

Hi All, I'm trying to work out if there is a way to use/abuse/extend SQLite and FTS5 to allow me to do a query across two (or more) separate databases and then sort the results in a meaningful manner. In order to do this I really need the 'global' elements of the ranking algorithm (e.g.

[sqlite] Use System.Data.Sqlite in Mono on a ARM based Panel

Found the Problem! When I run my exceutable with MONO_LOG_LEVEL=debug I see that mono searches for libSQLite.Interop.dll after enaming it works! Von: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at mailinglists.sqlite.org] im

[sqlite] ODP: Controlling of check-pointing of WAL Dbs

Good morning Richard, Thank you for the tip. I assume (I will test it later), that by killing the process you mean simply shutting it down (regularly) without ever calling sqlite3_close, am I right ? If so, that is quite feasible in our case I think. Regards, Albert

[sqlite] Use System.Data.Sqlite in Mono on a ARM based Panel

I've now compiled the Library with this script without problems. (I changed it that the output filename ist: SQLite.Interop.dll But when I copy it to my ARM based Panel I always get this Exception: System.DllNotFoundException: SQLite.Interop.dll at (wrapper managed-to-native)

[sqlite] Use System.Data.Sqlite in Mono on a ARM based Panel

Jochen Kuehner wrote: > > I've now compiled the Library with this script without problems. > (I changed it that the output filename ist: SQLite.Interop.dll > Please try without changing the output file name. Mono has its own special transformations on the P/Invoke library names. The file