viktoras at ekoinf.net
Fri Dec 5 13:38:09 CST 2008
there is one trick to make it working like a multiuser database. The
same trick was frequently used in all flat-file based multiuser
environments (mostly websites). I did not try it with Revolution yet,
but did many times in Perl (CGI) and it works. It is not lightning fast,
A verbal simplified description of this "ancient" recipe is:
(1) Before updating database check if file "sem.txt" is present.
(2) If it is present - wait a few milliseconds and check (1) again.
(3) Otherwise if it is not present, create "sem.txt" and start updating
(4) When the job is finished, delete "sem.txt", so that another process
won't see it.
one implementation of sqlite that is able to access remote sqlite
database is Apache modsqlite module. Ask Google for more info..
hershel fisch wrote:
> On 12/4/08 4:31 PM, "Kee Nethery" <kee at kagi.com> wrote:
> Thanks, to all.
> Hershel Fisch
>> sqlite is is a sql database but it is not a multi-user database. Think
>> of it as a local file on your hard drive (in fact that is what it is).
>> If you want to use it remotely, you have to mount that hard drive
>> remotely, open the sqlite file, and then read and write to it. While
>> you are doing that, no one else can.
>> If you want multiple people to read and write from the same sqlite
>> database file, you will need to build an app that accepts requests
>> from remote users and it and only it opens and reads and writes to
>> that data file. That connecter server is not a standard part of
>> sqlite. You would have to build it yourself.
>> sqlite is great for applications that need local data storage. For
>> example, most (if not all) of the Apple apps running on a Mac store
>> all their data in sqlite data files. It's not a multi-user database.
>> Kee Nethery
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the use-livecode