[ptx]

If you're using SQLite, why the indirection of an in-memory filesystem rather than SQLite's in-memory database feature?

[yencabulator]

Not the person you're asking this, but N connections to sqlite :memory: backend results in N separate database instances.

This can be worked around in some scenarios, but not always & reliably. Most importantly, you can't reach the same in-memory database from multiple processes.

https://www.sqlite.org/inmemorydb.html