Re: [sqlite] c-api

2011-07-27 Thread John Deal
Hello Baruch, You may want to look at sqlite3_exec() (http://www.sqlite.org/c3ref/exec.html). John --- On Wed, 7/27/11, Baruch Burstein wrote: > From: Baruch Burstein > Subject: [sqlite] c-api > To: "General Discussion of SQLite Database" > Date: Wednesday, July 27, 2011, 9:22 AM > Is there

Re: [sqlite] year, month & day problem

2011-07-17 Thread John Deal
Hello, I am new and have received much information from this list so I hope I am not wasting bandwidth. I don't know if it is my misunderstanding or typos but should your sqlite3_column_int() use indexes 0,1 and 2 instead of 1, 12 and 13? If this is the case, according to the docs on sqlite3_c

Re: [sqlite] Multi-threading Common Problem

2011-05-24 Thread John Deal
t; sqlite3 > command line tool for example while your application is > running, and > you will do some manipulations with the database, then > your > pthread_rwlock won't work and you will still get > SQLITE_BUSY. And now > you decide what mechanism is better for you. >

Re: [sqlite] Multi-threading Common Problem

2011-05-24 Thread John Deal
chinisms? > > When SQLITE_BUSY in a reader transaction is returned just > wait a > little bit and try again. Also you can benefit from > sqlite3_busy_timeout (http://www.sqlite.org/c3ref/busy_timeout.html). > > Another question is why do you want to get read of > pthread_rwl

Re: [sqlite] Multi-threading Common Problem

2011-05-24 Thread John Deal
n --- On Tue, 5/24/11, Roger Binns wrote: > From: Roger Binns > Subject: Re: [sqlite] Multi-threading Common Problem > To: "General Discussion of SQLite Database" > Date: Tuesday, May 24, 2011, 3:10 AM > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On

Re: [sqlite] Multi-threading Common Problem

2011-05-23 Thread John Deal
bvious. Thanks, John --- On Fri, 5/13/11, Roger Binns wrote: > From: Roger Binns > Subject: Re: [sqlite] Multi-threading Common Problem > To: sqlite-users@sqlite.org > Date: Friday, May 13, 2011, 2:00 AM > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 05/12/2

Re: [sqlite] Common Multi-treaded Problem

2011-05-13 Thread John Deal
nks, John --- On Fri, 5/13/11, Simon Slavin wrote: > From: Simon Slavin > Subject: Re: [sqlite] Common Multi-treaded Problem > To: "General Discussion of SQLite Database" > Date: Friday, May 13, 2011, 9:05 PM > > On 14 May 2011, at 12:29am, John Deal wrote: >

Re: [sqlite] Common Multi-treaded Problem

2011-05-13 Thread John Deal
ared statements) I would > not think > >> there would be any dependency on different > physical prepared > >> statements on different threads.  I would expect > this with > >> incomplete transactions. > >> > >> There's no dependency betwe

Re: [sqlite] Common Multi-treaded Problem

2011-05-13 Thread John Deal
should be doing. Thanks, John --- On Thu, 5/12/11, Simon Slavin wrote: > From: Simon Slavin > Subject: Re: [sqlite] Common Multi-treaded Problem > To: "General Discussion of SQLite Database" > Date: Thursday, May 12, 2011, 9:28 PM > > On 13 May 2011, at 1:33am,

Re: [sqlite] Multi-threading Common Problem

2011-05-12 Thread John Deal
011, 4:01 PM > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 05/12/2011 09:38 AM, John Deal wrote: > > I have been working for weeks on this and I feel there > must be something simple I am overlooking.  > > Why are you discarding SQLite's builtin and tested mutexes

Re: [sqlite] Common Multi-treaded Problem

2011-05-12 Thread John Deal
all > statements in this transaction are reset or finalized. > > > Pavel > > > On Thu, May 12, 2011 at 4:01 PM, John Deal > wrote: > > Hello Igor, > > > > That very well maybe it.  I am not at home so can't > test for sure but I reset the p

Re: [sqlite] Common Multi-treaded Problem

2011-05-12 Thread John Deal
nts in this transaction are reset or finalized. > > > Pavel > > > On Thu, May 12, 2011 at 4:01 PM, John Deal > wrote: > > Hello Igor, > > > > That very well maybe it.  I am not at home so can't > test for sure but I reset the prepared statemen

Re: [sqlite] Multi-threading Common Problem

2011-05-12 Thread John Deal
between different connections in the same process when > shared cache is > turned off. > > > Pavel > > > On Thu, May 12, 2011 at 4:26 PM, John Deal > wrote: > > Good question.  Very possible my understanding is not > complete. > > > > I have basi

Re: [sqlite] Multi-threading Common Problem

2011-05-12 Thread John Deal
er Binns > Subject: Re: [sqlite] Multi-threading Common Problem > To: sqlite-users@sqlite.org > Date: Thursday, May 12, 2011, 4:01 PM > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 05/12/2011 09:38 AM, John Deal wrote: > > I have been working for weeks on thi

Re: [sqlite] Common Multi-treaded Problem

2011-05-12 Thread John Deal
plete transactions. Anyway, thanks for the insight. John --- On Thu, 5/12/11, Igor Tandetnik wrote: > From: Igor Tandetnik > Subject: Re: [sqlite] Common Multi-treaded Problem > To: sqlite-users@sqlite.org > Date: Thursday, May 12, 2011, 12:35 PM > On 5/12/2011 12:31 PM, John Deal >

[sqlite] Multi-threading Common Problem

2011-05-12 Thread John Deal
Hello All, I have been using SQLite for a couple of years but have never posted to this list before. I am sure my problem is common and am looking for ideas to solve it. I have used SQLite extensively single-threaded with no problems (other than my own!). I am currently working on another pr

[sqlite] (no subject)

2011-05-12 Thread John Deal
Hello All, I have been using SQLite for a couple of years but have never posted to this list before. I am sure my problem is common and am looking for ideas to solve it. I have used SQLite extensively single-threaded with no problems (other than my own!). I am currently working on another pr

[sqlite] Common Multi-treaded Problem

2011-05-12 Thread John Deal
Hello All, I have been using SQLite for a couple of years but have never posted to this list before. I am sure my problem is common and am looking for ideas to solve it. I have basically the same situation as this thread: --- On Wed, Jan 26, 2011 at 10: