How to load db from memory?

[bitnick10]

Hey guys.Is there a way to load db from memory?

[SRombauts]

The best approach is probably to use the Backup to load a db from a file and copy it in a db ":memory:" (eg in Python https://stackoverflow.com/a/53253110)

I should add an example doing exactly that

[PMeira]

There's also sqlite3_deserialize since SQLite 3.23.