[EMAIL PROTECTED] wrote:
Original-Nachricht
Datum: Wed, 05 Jul 2006 17:24:54 -0500
Von: John Stanton <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
Hello John
Ann don't cry into your beer, there is always next time! My tea
Original-Nachricht
Datum: Wed, 05 Jul 2006 17:24:54 -0500
Von: John Stanton <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
Hello John
> Ann don't cry into your beer, there is always next time! My team also
> got kno
it into German).
[EMAIL PROTECTED] wrote:
Original-Nachricht
Datum: Wed, 05 Jul 2006 13:01:12 -0500
Von: John Stanton <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
First, sad about the football, but someone has to win.
Its only football
Original-Nachricht
Datum: Wed, 05 Jul 2006 19:30:04 +0100
Von: Nikki Locke <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
> We seem to have a misunderstanding over the definition of "optomistic
> locking".
Yes,
Original-Nachricht
Datum: Wed, 05 Jul 2006 13:01:12 -0500
Von: John Stanton <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
> First, sad about the football, but someone has to win.
Its only football... and so hard it is... th
We seem to have a misunderstanding over the definition of "optomistic
locking".
To me, "optimistic" locking means the application doesn't do any locking
when a record is read. All it does it to retain the timestamp of the record
when it was read.
When the application wants to write edited reco
-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
Hi John
I think, I understand what you will to say
Sqlite is a single file shared between users just like a word processing
file shared between multiple users. It is not a DBMS server and just
uses the regular fcntl type file locks.
bu
Original-Nachricht
Datum: Wed, 05 Jul 2006 07:32:47 -0600
Von: Dennis Cote <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
> Anne,
>
> Yes, ...
A simple "Yes" :-)))
>...your description is correct
Hi D
-Nachricht
Datum: Wed, 05 Jul 2006 12:05:07 +0100
Von: Nikki Locke <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
> ...the way SQLite works during a database update is that the
> entire database file is locked, and remains locked until t
[EMAIL PROTECTED] wrote:
but... I want try to ask again... ;-)
SQLite handles the File-Lockings as a physical Locking during the
writings to File and Disk. (Is it so?) I do my own logical Locking
during the Edit of a Record and then reflect to the Busy-State if the
changes will be saved to
Original-Nachricht
Datum: Wed, 5 Jul 2006 13:19:30 +0200
Von: "Olaf Beckman Lapré" <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
Hi Olaf
> Why not use optimistic locking (timestamp based pseudo locking)? It's
>
On 7/5/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
but... I want try to ask again... ;-)
SQLite handles the File-Lockings as a physical Locking during the
writings to File and Disk. (Is it so?) I do my own logical Locking
during the Edit of a Record and then reflect to the Busy-State if th
Why not use optimistic locking (timestamp based pseudo locking)? It's
ussually sufficient.
Olaf
- Original Message -
From: "Nikki Locke" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, July 05, 2006 1:05 PM
Subject: Re: [sqlite] Multiple Users
> > In order to this,
> In order to this, the next question ;-) Is a physcial Locking to the
> DB allways necessary, if more the one User (writer) connect to a DB
> and a Table? That means, is it insufficient, if I handle only a
> logical Locking in the Application instead of physcial Locking?
As I understand it (m
Original-Nachricht
Datum: Tue, 04 Jul 2006 19:13:56 -0500
Von: John Stanton <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
Hi John
I think, I understand what you will to say
> Sqlite is a single file shared between users ju
Stanton <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
Hello Gerrry, Aristotle and John
Many thanks for your answers. I'm very glad about your help.
Yes, I found this Page (File Locking And Concurrency In SQLite
Version 3) at last weekend and r
Original-Nachricht
Datum: Tue, 04 Jul 2006 12:01:25 -0500
Von: John Stanton <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
Hello Gerrry, Aristotle and John
Many thanks for your answers. I'm very glad about your help.
Yes, I
If your application observes the locking rules or provides its own
synchronization you can have very many concurrent users. If your
application doesn't observe locking you can only have one user.
Your question is the same as "how many users can share a file", because
Sqlite is basically a fil
* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [2006-07-03 21:35]:
> How many Users can be reader/writer to a DB at the same time,
> if all User controlled by the logical Locking-System?
>
> I have searched in Mail-Archiv and in Docu, but I dont found
> any Infos about concurrent Users.
That’s because
[EMAIL PROTECTED] wrote:
Hi to all
... any questions... ;-)
How many Users can operate with one SQLite-DB at the same time?
Anne,
Look at the following documentation, and if you have further questions,
do not hesitate to ask:
http://sqlite.org/lockingv3.html
Gerry
20 matches
Mail list logo