i guess problem with multiple instances can be solved by using Apache
sqlite module modsqlite which adds db server functionality to the Apache
web server. It resides in memory all the time, so no new instances are
initiated, no application startup overheads and cash is not stressed...
What rocks is the possibility to access sqlite databases directly over
HTTP like
http://localhost/test?db=/tmp/foo.db&q=select+*+from+test
However because of the security issues database access is possible only
from and on the localhost. This means that you will not be able to do
http://mysite.com/test?db=..., but you can easily do
http://localhost/test?db=... from any cgi application without running an
external database server.
More info on http://modsqlite.sourceforge.net/
Viktoras
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
