Re: [sqlite] What happens if an in memory database runs out of memory

No clue sorry. Not familiar with c++ builder or clang. -Rowan On 29 December 2017 at 15:05, x wrote: > Well spotted Rowan. I still get the same error message though. I’m using > c++ builder (clang compiler) and in Project | Options | C++ (Shared > Options) | Conditional

Re: [sqlite] What happens if an in memory database runs out of memory

Well spotted Rowan. I still get the same error message though. I’m using c++ builder (clang compiler) and in Project | Options | C++ (Shared Options) | Conditional defines I've entered the following SQLITE_EXTRA_INIT=core_init;-DSQLITE_ENABLE_MEMSYS5 I’m unsure how c++ builder presents that on

Re: [sqlite] Btree page corruption

On 29 Dec 2017, at 4:10am, Rowan Worth wrote: > do any of your processes open the database file, for any > reason, without going through sqlite's API? Just to note that a major offender in this respect is anti-virus software. So don’t think just of things that might want to

Re: [sqlite] Btree page corruption

On 28 December 2017 at 02:55, Simon Slavin wrote: > On 27 Dec 2017, at 6:10pm, Nikhil Deshpande wrote: > > >> Can you include a "pragma integrity_check" at startup ? > >> Can you include a "pragma integrity_check" executed at regular > intervals ? >

Re: [sqlite] What happens if an in memory database runs out of memory

On 23 December 2017 at 00:17, curmudgeon wrote: > >You can run tests yourself by compiling with -DSQLITE_ENABLE_MEMSYS5 > > Is that a minus sign before the DSQLITE_ENABLE_MEMSYSS? If I try compiling > with a minus sign before that directive I get a compile error "macro

Re: [sqlite] Minor bug reports during build.

On 22 December 2017 at 23:57, Michael Tiernan wrote: > > > It just doesn’t install to a directory it can’t write to, because you > > told it to install system-level things. > > Not going to hash it out here but I didn't tell it to install system-level > things, I told

Re: [sqlite] sqlite3AtoF()

On 12/25/17, Cezary H. Noweta wrote: > > Could you consider an exponentiation by squaring (in the main release) > instead of current n-multiplication of exponents? Please test the latest trunk version (or any version after check-in

[sqlite] Committing and memory usage

Does committing reduce memory usage on a memory database with pragma journal_mode=off? I see advice to do periodic commits in order to reduce memory usage, but I'm wondering if that also applies to memory databases with journaling off.

Re: [sqlite] Is WAL mode more robust against corruption?

On 28 Dec 2017, at 8:10pm, Chris Brody wrote: > I am considering whether or not to recommend the WAL mode for users in the > PhoneGap sqlite plugin that I maintain. The negative I see is the delays > that may result at certain points from the need for database checkpoints.

[sqlite] Is WAL mode more robust against corruption?

Hello, I am considering whether or not to recommend the WAL mode for users in the PhoneGap sqlite plugin that I maintain. The negative I see is the delays that may result at certain points from the need for database checkpoints. But I wondered if WAL may be more robust against possible sqlite

Re: [sqlite] advice about schema versioning and WAL

On 12/29/2017 01:28 AM, Gwendal Roué wrote: Hello, Season's greetings to all SQLite fellows! I'm developping a library that would like to keep a "cache" of some information about the database schema. Such information are the columns of a table, its primary key, or its indexes. The purpose

[sqlite] advice about schema versioning and WAL

Hello, Season's greetings to all SQLite fellows! I'm developping a library that would like to keep a "cache" of some information about the database schema. Such information are the columns of a table, its primary key, or its indexes. The purpose of this cache is not really speed, even if it