Sqlite remotely

viktoras didziulis 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, 
but multiuser.

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 
the database.
(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..

best wishes!
Viktoras

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
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>     
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>   




More information about the use-livecode mailing list