Is it possible to have a single, shared connection?

[sergi0g]

I'd like to integrate Diesel into a web app powered by xitca_web. Different API endpoints will need to use the DB, so I've put that in a shared state that can be accessed by the handle functions. tldr: I've got an Arc<Mutex<SqliteConnection>>.

The problem I'm facing is that load wants a &mut SqliteConnection and the MutexGuard I have in front of it makes the compiler unhappy.

I think having a shared DB connection is a good idea, since recreating a connection object with every request would be very inefficient. Am I doing something wrong? Is there a way to solve this problem?

[mjanda]

You shold be using some connection pool that will keep those connections open for you.

https://docs.diesel.rs/2.2.x/diesel/r2d2/index.html

[weiznich]

I would like to add that depending on the context you might want to use a different connection pool implementation. For example if you write an async web application you might want to use something like deadpool-diesel instead which better integrates into async web frameworks

[sergi0g]

Thanks!