SQLite Forum

In-memory database from sqlite file
I believe you'd be looking to use the [deserialize](https://www.sqlite.org/c3ref/deserialize.html) interface.

Bear in mind though that the other process could be in the middle of writing to the file at any moment, and thus your memory copy of the file contents could be completely inconsistent and broken. There's pretty much nothing you can do to prevent that when you're skirting around the mechanisms put in place to ensure consistency.