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