[sqlite] SQLITE_OPEN_NOMUTEX

Hi, As per documentation opening a database with SQLITE_OPEN_NOMUTEX flag opens it in multi-threaded mode. http://www.sqlite.org/threadsafe.html says In this mode, SQLite can be safely used by multiple threads provided that no single database connection is used simultaneously in two or more

[sqlite] Header pointers in table callback

Hi, We were looking at the ways we can optimize our application. Our app does a simple sqlite3_exec and sends the callback as below. The data is just a mapstring, vectorstring int sqlite3TableCallback(void* data, int ncols, char** values, char** headers) { mapstring, vectorstring

[sqlite] SQLite Encryption Extension (SEE) and Public Domain Sqlite

Hi, I wanted to get an understanding of SQLite Encryption Extension. I am currently using sqlite-3.7.2, and if I want to use SEE, would it be equally compatible. Well, the http://www.hwaci.com/sw/sqlite/see.html page does not give much information, i.e. do still build sqlite from public and

[sqlite] Queries getting slow with concurrency

Hi, I have observed that when multiple processes from different hosts are concurrently doing the queries, the performance of sqlite degrades considerably. Queries are read only hence I believe that there should not be any locking issues (no busy handler called). I will dig a little more in my

[sqlite] Read database from multiple processes

Hi, I have a database placed on a shared drive. Two processes (from different hosts) do a bunch of select commands. I have a busy handler that sleeps of 1 second in each attempt and bails out after 10 attempts. The observation is that, if only one process is running (on any host) the results

[sqlite] File Locking And Concurrency In SQLite Version 3

Hello, I want to use sqlite as a db on a shared network drive (windows) (user would map the network drive to say T:). I read the documentation section File Locking And Concurrency In SQLite Version 3 (http://www.sqlite.org/lockingv3.html) Where following is clearly mentioned: SQLite uses

Re: [sqlite] File Locking And Concurrency In SQLite Version 3

Database Subject: Re: [sqlite] File Locking And Concurrency In SQLite Version 3 On 12 Nov 2010, at 5:58pm, Prakash Reddy Bande wrote: My question: Is it possible to verify if the network drive on which the DB is place can be used? Great question. Unfortunately LockFile() generally does /not/ work

[sqlite] Busy handler not called

Hi, I have set a busy handler. int ret = sqlite3_open(dbname.c_str(), m_ppDb); sqlite3_busy_handler(m_ppDb, hwLMsqlite3BusyHandler, 0); However it is not getting called. Here is what I am doing: 1. Using the sqlite3.exe run the following commands begin transaction; update users set name=hello

Re: [sqlite] Busy handler not called

? Pavel On Fri, Nov 12, 2010 at 4:51 PM, Prakash Reddy Bande praka...@altair.com wrote: Hi, I have set a busy handler. int ret = sqlite3_open(dbname.c_str(), m_ppDb); sqlite3_busy_handler(m_ppDb, hwLMsqlite3BusyHandler, 0); However it is not getting called. Here is what I am doing: 1

Re: [sqlite] Busy handler not called

-0500, Prakash Reddy Bande scratched on the wall: Hi, I have set a busy handler. int ret = sqlite3_open(dbname.c_str(), m_ppDb); sqlite3_busy_handler(m_ppDb, hwLMsqlite3BusyHandler, 0); However it is not getting called. As the docs for sqlite3_busy_handler() point out, this is exactly how

Re: [sqlite] Locking issue on NFS filesystem

of SQLite Database Subject: Re: [sqlite] Locking issue on NFS filesystem On 14 Jun 2010, at 3:16am, Prakash Reddy Bande wrote: I have stumbled upon the issue as described in http://sqlite.org/faq.html#q5 (But use caution: this locking mechanism might not work correctly if the database file

Re: [sqlite] Locking issue on NFS filesystem

: SHA1 On 06/14/2010 02:56 AM, Prakash Reddy Bande wrote: Our application is a simple desktop application with a simple install and run setup. It is not possible to tell users to apply workaround of sharing the drive via SMB etc. BTW SMB won't be much better than NFS. (A lot of things have

[sqlite] Locking issue on NFS filesystem

Hi, I have stumbled upon the issue as described in http://sqlite.org/faq.html#q5 (But use caution: this locking mechanism might not work correctly if the database file is kept on an NFS filesystem.) The question is, do we have a workaround. Our application has to store data in user home

Re: [sqlite] (no subject)

Me too, all attempts to unsubscribe have failed. I have put a filter, but still my .pst is becoming big. From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] On Behalf Of Pece Cvetkoski [pcvetko...@yahoo.com] Sent: Saturday, May 22,

[sqlite] Multiple connections and triggers

updatelog Doing this, I can have every connection have its own updatelog table Prakash Reddy Bande Altair Engg. Inc, Troy, MI

[sqlite] Multiple process using the same database

any in memory cached data in my processes. How do I go about achieving this? Regards, Prakash Reddy Bande Altair Engg. Inc, Troy, MI

[sqlite] Sqlite 3.5.1 stability

that 3.5.1 will be as stable as 3.4.0. The reason I am moving over is that the sources for fts are based 3.5.1. How can I get the sources of fts based on 3.4.0 if I have to use 3.4.0? Regards, Prakash Reddy Bande Altair Engg. Inc, Troy, MI

[sqlite] Group by without aggregates

are not aggregate. But the query did give some results. How does SQLite choose which row to return from a group? Regards, Prakash Reddy Bande Altair Engg. Inc, Troy, MI

[sqlite] Problem inserting blob

Hi, I am trying to insert blob in a sqlite database using sqlite.exe . create table t (x blob); insert into t values (x'ccaaffee'); insert into t values (x'ccaa-ffee'); // This line give the error SQL error: unrecognized token: x'ccaa Where am I going wrong? Regards, Prakash Reddy

RE: [sqlite] Problem inserting blob

OK, I figured it out X should be followed by only hex characters 0-9, a-f. Regards, Prakash Reddy Bande Altair Engg. Inc, Troy, MI -Original Message- From: Prakash Reddy Bande [mailto:[EMAIL PROTECTED] Sent: Friday, August 31, 2007 4:00 PM To: sqlite-users@sqlite.org Subject: [sqlite

[sqlite] GUID/UUID in sqlite.

.) Regards, Prakash Reddy Bande Altair Engg. Inc, Troy, MI - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] GUID/UUID in sqlite.

Thanks, I will try both (ASCII and BLOB) approaches and see speed vs. storage trade-offs. Any more ideas are welcome. Regards, Prakash Reddy Bande Altair Engg. Inc, Troy, MI -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 29, 2007 11:26 AM

RE: [sqlite] GUID/UUID in sqlite.

sure it's a large number and I hope my database will not consume all of it). Moreover, when the database no longer uses a uuid, it can be removed from this table too, which might mean a considerable work for application developer :-). Regards, Prakash Reddy Bande Altair Engg. Inc, Troy, MI