3 ms·
> The "memdb" VFS now allows the same in-memory database to be shared among multiple database connections in the same process as long as the database name begi
by hardwaresofton 5y ago
> The "memdb" VFS now allows the same in-memory database to be shared among multiple database connections in the same process as long as the database name begins with "/".
Ohh this is interesting -- now SQLite can function as an in-memory shared DB, as long as you have lots of readers and only one writer? IIRC WAL mode doesn't apply to in-memory DBs but the locking concurrency docs[0] seem to suggest that most of the time the one writer would hold the RESERVED+ locks and readers would hold the SHARED locks.
[0]: https://sqlite.org/lockingv3.html https://sqlite.org/lockingv3.html