SQLite: how to open existing database in memory

[Dr. Hawkins]

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

> 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