Re: [sqlite] Locking and concurrency in SQLite version 3.0

2004-06-16 Thread Daniel K
--- Christian Smith <[EMAIL PROTECTED]> wrote: > On Wed, 16 Jun 2004, Daniel K wrote: > > >--- [EMAIL PROTECTED] wrote: > >> > >> > http://www.sqlite.org/lockingv3.html > >> > >> My thoughts are listed as they come to me. > >> > >> Thought 1: > >> > >> Section 5.0, entitled "Writing to a

Re: [sqlite] Locking and concurrency in SQLite version 3.0

2004-06-16 Thread Christian Smith
On Wed, 16 Jun 2004, Daniel K wrote: >--- [EMAIL PROTECTED] wrote: >> >> > http://www.sqlite.org/lockingv3.html >> >> My thoughts are listed as they come to me. >> >> Thought 1: >> >> Section 5.0, entitled "Writing to a database file": >> After the in-memory cache initially spills to disk >>

RE: [sqlite] Locking and concurrency

2004-06-16 Thread Wempa, Kristofer \(Kris\), ALABS
>Hi, >I am using sqlite 2.8.5 and I'd like to know if I can have a proces >that reads(select) while a proces is writing (insert or update) in the >same db. > >I have read FAQ number 7 but it doesn't help me. >Thank you very much. > >Bye Max >FAQ 7 >**Can multiple applications or multiple

Re: [sqlite] Locking and concurrency in SQLite version 3.0

2004-06-16 Thread Daniel K
--- [EMAIL PROTECTED] wrote: > G'day, > > > > > > "D. Richard Hipp" <[EMAIL PROTECTED]> > 12/06/2004 08:16 AM > > > To: [EMAIL PROTECTED] > cc: > Subject:[sqlite] Locking and > concurren

Re: [sqlite] Locking and concurrency in SQLite version 3.0

2004-06-16 Thread ben . carlyle
G'day, "D. Richard Hipp" <[EMAIL PROTECTED]> 12/06/2004 08:16 AM To: [EMAIL PROTECTED] cc: Subject: [sqlite] Locking and concurrency in SQLite version 3.0 > http://www.sqlite.org/lockingv3.html My thoughts are listed as they com

[sqlite] Locking and concurrency

2004-06-16 Thread Massimiliano Zilio
Hi, I am using sqlite 2.8.5 and I'd like to know if I can have a proces that reads(select) while a proces is writing (insert or update) in the same db. I have read FAQ number 7 but it doesn't help me. Thank you very much. Bye Max * FAQ 7 **Can multiple applications or multiple instances of

Re: [sqlite] Locking and concurrency in SQLite version 3.0

2004-06-12 Thread D. Richard Hipp
Christian Smith wrote: "Note that the BEGIN command does not acquire any locks on the database. After a BEGIN command, a SHARED lock will be acquired when the first SELECT statement is executed. A RESERVED lock will be acquired when the first INSERT, UPDATE, or DELETE statement is executed."

Re: [sqlite] Locking and concurrency in SQLite version 3.0

2004-06-12 Thread Darren Duncan
At 6:16 PM -0400 6/11/04, D. Richard Hipp wrote: The first alpha release of SQLite version 3.0 will occur in less than 7 days. In preparation for that release, a document describing the new file locking mechanism has be prepared and placed on the website. http://www.sqlite.org/lockingv3.html