--- 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
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
>>
>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
--- [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
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
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
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."
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
8 matches
Mail list logo