In-Memory Databases are not really pooled/shared

[gwenn]

Hi,
https://www.sqlite.org/inmemorydb.html:

The database ceases to exist as soon as the database connection is closed. Every :memory: database is distinct from every other. So, opening two database connections each with the filename ":memory:" will create two independent in-memory databases.

Regards.

[ivanceras]

Yes, we can't do anything about it for now.

[gwenn]

Are you sure ?
https://github.com/jgallagher/rusqlite/blob/master/src/lib.rs#L180
http://sqlite.org/c3ref/open.html
http://sqlite.org/uri.html

SqliteConnectionManager::new(PathBuf::from("file:dummy.db?mode=memory&cache=shared"),
             SQLITE_OPEN_URI | SQLITE_OPEN_CREATE | SQLITE_OPEN_READ_WRITE)

...

[SergioBenitez]

Just ran into this. It makes absolutely no sense to me to create a pool of connections if each connection refers to a different in-memory database.

[ivanceras]

I just make it a pool to have a uniform code for accessing the connection. If you have a better improvement, I'll take a PR.

[gwenn]

A PR removing the following entries:

• https://github.com/ivanceras/r2d2-sqlite/blob/master/src/lib.rs#L102
• https://github.com/ivanceras/r2d2-sqlite/blob/master/src/lib.rs#L109

will be accepted ?

[gwenn]

It seems to me that the issue has been fixed by f0a7bdd .