deadpool-diesel 0.7.0

Dead simple async pool for diesel
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51

# Deadpool for Diesel [![Latest Version](https://img.shields.io/crates/v/deadpool-diesel.svg)](https://crates.io/crates/deadpool-diesel) [![Build Status](https://img.shields.io/github/actions/workflow/status/deadpool-rs/deadpool/deadpool-diesel.yml?branch=main)](https://github.com/deadpool-rs/deadpool/actions/workflows/deadpool-diesel.yml?query=branch%3Amain) ![Unsafe forbidden](https://img.shields.io/badge/unsafe-forbidden-success.svg "Unsafe forbidden") [![Rust 1.85+](https://img.shields.io/badge/rustc-1.85+-lightgray.svg "Rust 1.85+")](https://blog.rust-lang.org/2025/02/20/Rust-1.85.0/)

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

This crate implements a [`deadpool`](https://crates.io/crates/deadpool)
manager for [`diesel`](https://crates.io/crates/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](https://crates.io/crates/tokio) crate                                                                                                                                                               | `deadpool/rt_tokio_1`              | yes     |
| `rt_async-std_1` | Enable support for [async-std](https://crates.io/crates/async-std) crate                                                                                                                                                       | `deadpool/rt_async-std_1`          | no      |
| `serde`          | Enable support for [serde](https://crates.io/crates/serde) crate                                                                                                                                                               | `deadpool/serde`                   | no      |
| `tracing`        | Enable support for [tracing](https://github.com/tokio-rs/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

```rust
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](LICENSE-APACHE) or <http://www.apache.org/licenses/LICENSE-2.0>)
- MIT license ([LICENSE-MIT](LICENSE-MIT) or <http://opensource.org/licenses/MIT>)

at your option.