[sqlite] Database deleted from file system while other open connections exist.

2010-11-11 Thread Dennis Suehr
Hello, Apologies if an answer to my query exists elsewhere. I have been searching for a fair while without success. I am building an SQLite interface as a C shared library and consequently will have no knowledge or control of concurrent connections to any databases which are created by it. I ne

Re: [sqlite] Database deleted from file system while other open connections exist.

2010-11-12 Thread Dennis Suehr
Simon, Many thanks for your prompt and thorough response. Just a couple of follow-up questions if I may: Firstly, a bit more background information. The system will be running on Linux (kernel > 2.6.0) and all accesses to the database will be via local disk (ext3 or similar). 1) I appreciate y

[sqlite] Fwd: Database deleted from file system while other open connections exist.

2010-11-15 Thread Dennis Suehr
Simon (and others), Many thanks for your responses. This clears matters up a good bit. It just means that I will have to rethink how I implement this database 'delete' operation. Cheers, Dennis -- Forwarded message ------ From: Dennis Suehr Date: 12 November 2010 16:

[sqlite] Multi-file Atomic Commit issue.

2011-01-27 Thread Dennis Suehr
Hello, I have been trying to verify SQLite's Multi-file Atomic commit functionality, but unfortunately have been unable to do so. My test scenario is as follows: SQLite 3.7.4 (amalgamation) built into a C library. Fedora 12. Two databases residing on an ext4 filesystem. One database attached to

[sqlite] Multi-file Atomic Commit issue.

2011-01-27 Thread Dennis Suehr
> > So really it is if there are transactions: The first transaction by SQLite > completes exactly as it said it would. Then the second transaction (the > "rm" command) deletes the ATTACHed database. > > If you want to interrupt a transaction, use the "kill -9" command on the > SQLite process at

[sqlite] Case Sensitive FTS searches.

2011-08-11 Thread Dennis Suehr
Hello, I need to implement case-SENSITIVE searching for an FTS(4) table. As near as I can determine, that would seem to require a new user-defined tokenizer. I am hopeful that one or more of you might respond with hints, insights, experience, etc. which might aid me toward that end. Specificall

[sqlite] Fwd: Case Sensitive FTS searches.

2011-08-11 Thread Dennis Suehr
message -- From: Dennis Suehr Date: 11 August 2011 15:31 Subject: Case Sensitive FTS searches. To: sqlite-users@sqlite.org Hello, I need to implement case-SENSITIVE searching for an FTS(4) table. As near as I can determine, that would seem to require a new user-defined tokenizer. I am

Re: [sqlite] Case Sensitive FTS searches.

2011-08-12 Thread Dennis Suehr
On Thu, Aug 11, 2011 at 8:57 AM, Dennis Suehr wrote: > After some digging through the sqlite3 source code, I came across the code > for the ICU tokenizer. After enabling that and then commenting out the one > line where u_foldCase() is called, i.e. icuOpen(), I retested and > ca