SQLite Forum

In-memory database from sqlite file
Login
Thanks Ryan. 

> To get the DB file INTO Serialized form, you need to open it with an SQLite connection and tell the connection to Serialize it to bytes - which means you can do it both from a physical disk-file or from an in-memory DB to start with.

I don't think this is possible when the database has an exclusive lock? I can't even run simple commands like `.schema` when the lock is on. Which is why I fell back to the "let's make a copy and pray" approach.

> You have to compile SQLite with SQLITE_ENABLE_DESERIALIZE - The Serialize/Deserialize switch. It's not on by default.

Uhm, this is really useful to know. Thanks!