5 releases

0.2.0 May 23, 2024
0.1.0 Nov 17, 2023
0.1.0-rc.4 Nov 2, 2023
0.1.0-rc.3 Mar 24, 2023
0.1.0-rc.2 May 9, 2022

#2343 in Database interfaces

Download history 3038/week @ 2024-09-09 2590/week @ 2024-09-16 3181/week @ 2024-09-23 2513/week @ 2024-09-30 1757/week @ 2024-10-07 1909/week @ 2024-10-14 2723/week @ 2024-10-21 2629/week @ 2024-10-28 2796/week @ 2024-11-04 2765/week @ 2024-11-11 2400/week @ 2024-11-18 2879/week @ 2024-11-25 3460/week @ 2024-12-02 3599/week @ 2024-12-09 2878/week @ 2024-12-16 994/week @ 2024-12-23

11,121 downloads per month
Used in 16 crates (14 directly)

MIT/Apache

1MB
14K SLoC

db_pools ci.svg crates.io docs.svg

Asynchronous database driver integration for Rocket. See the crate docs for full usage details.

Usage

  1. Add rocket_db_pools as a dependency with one or more database driver features enabled:

    [dependencies.rocket_db_pools]
    version = "0.2.0"
    features = ["sqlx_sqlite"]
    
  2. Choose a name for your database, here sqlite_logs. Configure at least a URL for the database:

    [default.databases.sqlite_logs]
    url = "/path/to/database.sqlite"
    
  3. Derive Database for a unit type (Logs here) which wraps the selected driver's Pool type and is decorated with #[database("name")]. Attach Type::init() to your application's Rocket to initialize the database pool:

    use rocket_db_pools::{Database, Connection};
    
    #[derive(Database)]
    #[database("sqlite_logs")]
    struct Logs(sqlx::SqlitePool);
    
    #[launch]
    fn rocket() -> _ {
        rocket::build().attach(Logs::init())
    }
    
  4. Use Connection<Type> as a request guard to retrieve an active database connection:

    #[get("/<id>")]
    async fn read(mut db: Connection<Logs>, id: i64) -> Result<Log> {
        sqlx::query!("SELECT content FROM logs WHERE id = ?", id)
            .fetch_one(&mut *db)
            .map_ok(|r| Log(r.content))
            .await
    }
    

Dependencies

~14–54MB
~1M SLoC