SQLite 3.36.0 Changelog

> 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

And just yesterday I realized that SQLite didn't come with the REGEXP extension by default. How cool.