Support sqlite3 :memory: database

[AlexB52]

The connections between the DB schema and the main app are different. While the :memory: database gets loaded correctly the first time, the app uses another :memory: database that doesn't have the schema loaded.

We should have a way to either allow the use of the same :memory: database or change when the DB gets loaded during the app initialization when SQLite :memory: is used