On Mon, Jan 14, 2019 at 2:23 PM Wout Mertens <wout.mert...@gmail.com> wrote:

> AFAIK, your best bet is to put a file db on a ramdisk (tmpfs).


That's not a very portable solution, and a work-around at best.

I don't see anything technical that would prevent WAL to work for
":memory:".
"Shared-memory" "in-process" is just memory about all...
And mutexes already exists in SQLite to protected access when necessary.

In-memory DBs are just so useful, and WAL is just so useful,
I just don't see why we can't have both at the same time.
Richard?


> The ":memory:" DB is per connection only.
>

Not really. You can open the same :memory: DB
from different connections in the same process, via URIs. --DD
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to