SQLite: how to open existing database in memory

Dr. Hawkins dochawk at gmail.com
Wed Oct 21 11:38:58 EDT 2015

On Wed, Oct 21, 2015 at 8:25 AM, Bob Sneidar <bobsneidar at iotecdigital.com>

> But I think your idea of using a file copy method is the best way. I used
> to do that with the Spiceworks database because the Spiceworks system would
> periodically open the database and since it is really a single user system
> opening it directly could cause problems with Spiceworks. I just did a
> simple file copy and worked with the copy.

my own, multiuser, is to use postgres,and periodically run a query on the
:memory: sqlite version, and by code turn that into INSERT commands for
sqlite, with the postgres db keeping the co,ands, rather than data.  It
also works with a disk-basessqlite.

Dr. Richard E. Hawkins, Esq.
(702) 508-8462

More information about the use-livecode mailing list