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

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] WAL mode readonly errors to SELECT statements

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

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

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] sqlite-src-3260000 tests throw Error: couldn't fork child process: not enough memory

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

[sqlite] WAL mode readonly errors to SELECT statements

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

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

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] sqlite-src-3260000 tests throw Error: couldn't fork child process: not enough memory

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] CoreData - when database gets closed

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] Uncompressed SQLite Archive Files

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] SQLite linked to plugin binary

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] SQLite linked to plugin binary

> 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] Query Planning Knowledge

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 >

[sqlite] SQLite linked to plugin binary

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] System.Data.Sqlite Encryption Cipher

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] Query Planning Knowledge

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] 'no such table' error code XXX should be propagated up to the client instead of generic error code 1

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