Creating a keep-alive connection to prevent a new connection for every statement

[EvilWatermelon]

Hi,

I have several functions to communicate with my database i.e.:

pub async fn get_images(
    con: &DatabaseConnection
) -> Result<Vec<entities::image::Model>, sea_orm::DbErr>{

    let images: Vec<entities::image::Model> = Image::find().all(con).await?;

    Ok(images)
}

pub async fn get_queries(
    con: &DatabaseConnection
) -> Result<Vec<serde_json::Value>, sea_orm::DbErr> {

    let queries = Query::find().into_json().all(con).await?;

    Ok(queries)
}

// Init actix
    HttpServer::new(move || {
        let auth = HttpAuthentication::with_fn(validator);
        App::new()
            .wrap(Logger::default())
            .app_data(web::Data::new(db.clone())) //etc.

However, the logic of sea_orm requires to pass the DatabaseConnection for each statement. Is it possible to create a keep-alive connection that starts an initial connection after the program starts and keeps it up as long as the program runs? Or is the passing the more secure way and I should accept it like it is?

[tyt2y3]

this is the rusty-way of doing things. the dependency is explicitly provided, so the logic is easy to test. it also makes it possible to use multiple databases in the same app.

you can, for example, use lazy_static to setup a connect pool globally and get it from there everytime you need it. then you don't have to pass the context around.

[EvilWatermelon]

I'm not very familiar creating a connection pool. Do you have an example?

[EvilWatermelon]

Found a solution: #1645 (comment)