[sqlite] SQLITE_OPEN_NOMUTEX

2014-01-02 Thread Prakash Reddy Bande
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] SQLite Encryption Extension (SEE) and Public Domain Sqlite

2011-07-07 Thread Prakash Reddy Bande
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] Header pointers in table callback

2011-07-11 Thread Prakash Reddy Bande
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 map int sqlite3TableCallback(void* data, int ncols, char** values, char** headers) { map& table

[sqlite] GUID/UUID in sqlite.

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

RE: [sqlite] GUID/UUID in sqlite.

2007-08-29 Thread Prakash Reddy Bande
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.

2007-08-29 Thread Prakash Reddy Bande
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

[sqlite] Problem inserting blob

2007-08-31 Thread Prakash Reddy Bande
Prakash Reddy Bande Altair Engg. Inc, Troy, MI

RE: [sqlite] Problem inserting blob

2007-08-31 Thread Prakash Reddy Bande
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] Group by without aggregates

2007-09-20 Thread Prakash Reddy Bande
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] Sqlite 3.5.1 stability

2007-10-10 Thread Prakash Reddy Bande
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] Multiple process using the same database

2007-11-21 Thread Prakash Reddy Bande
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] Multiple connections and triggers

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

Re: [sqlite] (no subject)

2010-05-22 Thread Prakash Reddy Bande
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] Locking issue on NFS filesystem

2010-06-13 Thread Prakash Reddy Bande
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] Locking issue on NFS filesystem

2010-06-14 Thread Prakash Reddy Bande
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 > data

Re: [sqlite] Locking issue on NFS filesystem

2010-06-14 Thread Prakash Reddy Bande
- Hash: 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

[sqlite] File Locking And Concurrency In SQLite Version 3

2010-11-12 Thread Prakash Reddy Bande
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

2010-11-12 Thread Prakash Reddy Bande
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() generall

[sqlite] Busy handler not called

2010-11-12 Thread Prakash Reddy Bande
Hi, I have set a busy handler. int ret = sqlite3_open(dbname.c_str(), _ppDb); sqlite3_busy_handler(m_ppDb, , 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" 2. Note I have not

Re: [sqlite] Busy handler not called

2010-11-12 Thread Prakash Reddy Bande
r 12, 2010 4:57 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Busy handler not called > int ret = sqlite3_exec(m_ppDb, query.c_str(), , , > ); > > I get SQLITE_BUSY and hwLMsqlite3BusyHandler is not getting called. What query do you use? Pavel On Fri, Nov 12, 2

Re: [sqlite] Busy handler not called

2010-11-12 Thread Prakash Reddy Bande
-0500, Prakash Reddy Bande scratched on the wall: > Hi, > > I have set a busy handler. > > int ret = sqlite3_open(dbname.c_str(), _ppDb); > sqlite3_busy_handler(m_ppDb, , 0); > > However it is not getting called. As the docs for sqlite3_busy_handler() point

[sqlite] Read database from multiple processes

2010-11-18 Thread Prakash Reddy Bande
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] Queries getting slow with concurrency

2010-11-25 Thread Prakash Reddy Bande
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