-------- 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... the italian players 
are the better players. But our coach has done a greatly work.
We can be content with this result.

> My point that since Sqlite is embedded its only locking method is the 
> fcntl type file lock.  Any other level of locking has to be supplied by 
> your application.  It cannot perform row and table locks like a DB 
> server.

Thats not my intention. I dont want to blow up a Single-File-DB like
SQLite to a Server-Based DBMS like MS SQL-Server. 

But I work with various DB, and I like to do handle all at the 
same way. It is be much easier, to access and repeat my own 
knowledge, if I support a frontend and all frontend looks similarly
at the Database-Connect-Level.

And... why should I don't handle a SQLite-DB as a Backend like a Server-Based 
DBMS? Its imho primary the same.

If I allow more than one User to "connect" to a DB, I have to
manage the access of all this users, particularly the concurrent Edit 
of one and the same Record. The Problem exist not during the Dialog-
Edit. The Problem occurs after read Data and stay on Screen, at the
End-Editing, then, if changes written to Disk. 

Other Users is allowed to fetch this Record too and present it in his 
own View - but only as Read-Only. I do it at the same Way like SAP. 
All User can fetch "this" record and present it in Dialog-View, but 
only the first reader can edit and store his Changes to DB.

Greetings, Anne
-- 


"Feel free" – 10 GB Mailbox, 100 FreeSMS/Monat ...
Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail

Reply via email to