[sqlite] SQLite linked to plugin binary

2019-01-23 Thread Carsten Müncheberg
I am running into a problem with the following use-case: A host application (which is a black box for me I cannot change) is loading my plugin binaries which each have SQLite linked statically. When two plugins now access the same database file from the process of the host application none of the

[sqlite] Uncompressed SQLite Archive Files

2019-01-23 Thread Andre deBruin
I am a Big fan of the recent support for 'SQLite Archive' files. Basically I was planning to use this as a generic version of an "Application File Format" (sqlite.org/appfileformat.html). As far as I can see the Archive Files functionality does always compress the blobs if it is found that

Re: [sqlite] Query Planning Knowledge

2019-01-23 Thread Clemens Ladisch
Andy Bennett wrote: >> foreign key constraints > > my experience with other engines taught me that it makes experimenting at the > monitor harder. Then don't use them. :) But do you actually want 'wrong' data? > Are there any efficiency benefits or is it just there to enforce data >

Re: [sqlite] SQLite linked to plugin binary

2019-01-23 Thread Jens Alfke
> On Jan 23, 2019, at 8:27 AM, Carsten Müncheberg > wrote: > > A host application (which is a black box for me I cannot change) is loading > my plugin binaries which each have SQLite linked statically. When two > plugins now access the same database file from the process of the host >

Re: [sqlite] SQLite linked to plugin binary

2019-01-23 Thread Clemens Ladisch
Carsten Müncheberg wrote: > A host application (which is a black box for me I cannot change) is loading > my plugin binaries which each have SQLite linked statically. When two > plugins now access the same database file from the process of the host > application none of the serialization

Re: [sqlite] CoreData - when database gets closed

2019-01-23 Thread Scott Perry
On Jan 22, 2019, at 9:02 AM, Simon Slavin wrote: > > On 22 Jan 2019, at 3:45pm, Maldonado-Salazar, Carlos > wrote: > >> Is there a way to know when CoreData closes sqlite files?. I’m using >> CoreData in an iOS app and I set file attributes for sqlite file to be >>

[sqlite] 'no such table' error code XXX should be propagated up to the client instead of generic error code 1

2019-01-23 Thread Anton Sukhin
sqlite3LocateTable returns generic error code 1 (SQLITE_ERROR) and error message 'no such table'. This makes it difficult to distinguish this error from others as in order to find that the table is missing, string parsing of error message for 'no such table' is required. the same applies to 'no

Re: [sqlite] Query Planning Knowledge

2019-01-23 Thread Andy Bennett
Hi, I could use the inner join for the "entrys" join and the "items" join but not the "entry-items" join because each entry can have more than one item. WITH a(id, name) AS (VALUES (1, 'A')), b(id, name) AS (VALUES (1, 'B1'), (1, 'B2')) SELECT * FROM a INNER JOIN b USING (id);

[sqlite] System.Data.Sqlite Encryption Cipher

2019-01-23 Thread Mattock Paul extern
Hi, Would anyone be able to confirm what encryption cipher is used when SetPassword="" is set on database creation? Regards, Paul ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] sqlite-src-3260000 tests throw Error: couldn't fork child process: not enough memory

2019-01-23 Thread Dennis Clarke
On 1/23/19 7:10 PM, Richard Hipp wrote: On 1/23/19, Dennis Clarke wrote: Perhaps I was mistaken to enable --enable-tempstore=yes during configure ? Maybe. Does it work if you omit that option? I just tried without and also went back to sqlite-src-324 and they all fail in the same

Re: [sqlite] sqlite-src-3260000 tests throw Error: couldn't fork child process: not enough memory

2019-01-23 Thread Richard Hipp
On 1/23/19, Dennis Clarke wrote: > > Perhaps I was mistaken to enable --enable-tempstore=yes during configure ? > Maybe. Does it work if you omit that option? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

[sqlite] WAL mode readonly errors to SELECT statements

2019-01-23 Thread Robert Searle
Hi, I have an sqlite3 database (version 3.25.3) in tmpfs which has many readers and writers. The database is running in WAL mode and seems to work efficiently in that mode. Since the database files are in a memory based file-system, we don't care about the usual corruption on power-cycle issues

[sqlite] sqlite-src-3260000 tests throw Error: couldn't fork child process: not enough memory

2019-01-23 Thread Dennis Clarke
On Oracle solaris 10 sparc with 16GB of memory I was surprised to see : . . . Time: keyword1.test 229 ms Time: lastinsert.test 64 ms Time: laststmtchanges.test 60 ms (82 ms - want less than 1000) (80 ms - want less than 1000) Time: like.test 188 ms Time: like2.test 215 ms Time: like3.test

Re: [sqlite] WAL mode readonly errors to SELECT statements

2019-01-23 Thread Simon Slavin
On 24 Jan 2019, at 2:37am, Robert Searle wrote: > occasionally get either > SQLITE_READONLY_RECOVERY or SQLITE_READONLY_CANTINIT responses to select > statements No programmer should be seeing these. They indicate low-level errors that cannot be handled in a systematic manner. Rather than

Re: [sqlite] sqlite-src-3260000 tests throw Error: couldn't fork child process: not enough memory

2019-01-23 Thread Dennis Clarke
On 1/23/19 7:10 PM, Richard Hipp wrote: On 1/23/19, Dennis Clarke wrote: Perhaps I was mistaken to enable --enable-tempstore=yes during configure ? Maybe. Does it work if you omit that option? The solution seems to be to throw hardware at the problem and then it goes away. I

Re: [sqlite] WAL mode readonly errors to SELECT statements

2019-01-23 Thread Clemens Ladisch
Robert Searle wrote: > We have recently started trying to provide read-only access to the database > (service run as user with group/other read access permissions under Linux, > service not database owner) and occasionally get either > SQLITE_READONLY_RECOVERY or SQLITE_READONLY_CANTINIT responses