10 releases (5 breaking)

0.6.0	Mar 31, 2024
0.5.0	Sep 26, 2023
0.4.1	Dec 9, 2022
0.4.0	Sep 12, 2022
0.1.2	Jul 16, 2021

#1477 in Database interfaces

12,093 downloads per month

MIT/Apache

98KB
1.5K SLoC

Deadpool for Diesel

Deadpool is a dead simple async pool for connections and objects of any type.

This crate implements a deadpool manager for diesel connections.

Features

Feature	Description	Extra dependencies	Default
`sqlite`	Enable `sqlite` feature in `diesel` crate	`diesel/sqlite`	no
`postgres`	Enable `postgres` feature in `diesel` crate	`diesel/postgres`	no
`mysql`	Enable `mysql` feature in `diesel` crate	`diesel/mysql`	no
`rt_tokio_1`	Enable support for tokio crate	`deadpool/rt_tokio_1`	yes
`rt_async-std_1`	Enable support for async-std crate	`deadpool/rt_async-std_1`	no
`serde`	Enable support for serde crate	`deadpool/serde`	no
`tracing`	Enable support for tracing by propagating Spans in the `interact()` calls. Enable this if you use the `tracing` crate and you want to get useful traces from within `interact()` calls.	`deadpool-sync/tracing`, `tracing`	no

Example

use deadpool_diesel::sqlite::{Runtime, Manager, Pool};
use diesel::{prelude::*, select, sql_types::Text};

#[tokio::main]
async fn main() -> Result<(), Box<dyn std::error::Error>> {
    let manager = Manager::new(":memory:", Runtime::Tokio1);
    let pool = Pool::builder(manager)
        .max_size(8)
        .build()
        .unwrap();
    let conn = pool.get().await?;
    let result = conn.interact(|conn| {
        let query = select("Hello world!".into_sql::<Text>());
        query.get_result::<String>(conn)
    }).await??;
    assert!(result == "Hello world!");
    Ok(())
}

License

Licensed under either of

Apache License, Version 2.0 (LICENSE-APACHE or http://www.apache.org/licenses/LICENSE-2.0)
MIT license (LICENSE-MIT or http://opensource.org/licenses/MIT)

at your option.

Dependencies

~4–20MB
~265K SLoC