Keeping in-memory sqlite database connection pool alive

[kwtalley]

I'm writing a rust application library that needs a temporary in-memory database for the life of the application.

When creating an in-memory sqlite database with a connection pool, each connection is dropped after use and the pool size decreases. Eventually the pool size reaches 0 and any subsequent connections acquired from the pool are to a newly created in-memory database.

My understanding was that the connections would be returned to the pool so I'm not sure why the pool size decreases to 0. Do I need to spawn a keep-alive thread for the duration of the application?

I'm creating the pool like:

use once_cell::sync::Lazy;

static DB_POOL: Lazy<Pool<Sqlite>> = Lazy::new(|| {
    futures::executor::block_on(async {
        SqlitePoolOptions::new()
            .min_connections(10)
            .max_connections(100)
            .test_before_acquire(false)
            .connect_with(SqliteConnectOptions::new().filename("file::memory:?cache=shared"))
            .await
            .unwrap()
    })
});

[mfilteau]

I have the same problem. Did you find a solution?