Re: [sqlite] SQLite DB backups on Windows

I forgot to mention that we're using SQLite 3.5.9. Arun Arun Bhalla wrote: > Hi there, > > We are performing backups of the SQLite DB file by opening an IMMEDIATE > transaction and then copying the file. (cf. > <http://www.mail-archive.com/sqlite-users@sqlite.org/msg192

[sqlite] SQLite DB backups on Windows

Hi there, We are performing backups of the SQLite DB file by opening an IMMEDIATE transaction and then copying the file. (cf. , ) On Windows we use CopyFileA

[sqlite] temp_store_directory issue with SQLite 3.5.9

that sqlite3_temp_directory is a global, and hence the temp_store_directory pragma is also global, affecting all databases opened within the same process. cheers, Arun Bhalla ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080

Re: [sqlite] DB corruption, unit tests

Arun Bhalla wrote: 2) In order to help diagnose the problem, we ran some unit tests, and we had some unusual results: c) On a Linux/x86 VM (running under Windows), some tests fail. I don't have the specifics at the moment, but that would be cause for alarm, particularly the failures

[sqlite] DB corruption, unit tests

Hello there, I have a couple related questions: 1) Is anyone aware of any recent cases of SQLite DB corruption? We upgraded from SQLite 3.3.6 to SQLite 3.4.1 a few months ago. In the last couple days, we've encountered a couple cases of SQLite reporting that a DB file had become corrupted

[sqlite] NaN

Last night I upgraded from SQLite 3.3.6 to SQLite 3.4.0. This morning a transaction in my application failed because SQLite detected that the application was trying to insert a row with a NULL in a REAL NOT NULL column. Actually, it turns out that it was a NaN, which SQLite 3.4.0 apparently

[sqlite] disk I/O error

Hello, This message may be off-topic in that I don't think the following issue corresponds to a bug with SQLite, but it's something I've discovered while using SQLite. Perhaps someone on the list has had a similar experience or could make a suggestion. A Linux 2.6/x86_64 system reports a

Re: [sqlite] Re: SQLite :memory: performance difference between v2 and v3?

Dennis Cote wrote: Erik Jensen wrote: very interesting. Do you have the chance to run the same test with version 3.2.1? Like i wrote in an earlier message, i noticed a similar performance drop when i upgraded my application from sqlite 3.2.1 to 3.3.5. Eric, I reran these test using 3.2.1

Re: [sqlite] a string indexing experiment

I forgot to mention -- I was using SQLite 3.3.4. Arun Bhalla wrote: Hi, I performed a quick benchmark of three different string indexing schemes for SQLite3. * Scheme 0 = indexing on the string field * Scheme 1 = indexing on the MD5 sum (as text in hexadecimal representation

[sqlite] a string indexing experiment

Hi, I performed a quick benchmark of three different string indexing schemes for SQLite3. * Scheme 0 = indexing on the string field * Scheme 1 = indexing on the MD5 sum (as text in hexadecimal representation) of the string * Scheme 2 = indexing on the high 64 bits of the MD5 sum (as int)