The in-memory or on-disk character of the database is implemented in a way that is not visible to the rest of the library, (except by name of the [VFS](https://sqlite.org/vfs.html) that stores pages.) As you might expect, the 'D' part of the ACID feature essentially vanishes for the in-memory DB. Also, many multiple-client access scenarios vanish.