r2d2-mysql

KO | EN

gitlite — search

#javascript #hacktoberfest #react #ai #typescript #go #rust #linux #macos #vue #security #mcp #ios #openai

(★ 51)

MySQL support for the r2d2 connection pool (Rust)

File Explorer

Download Latest Version (.zip)

- - ci.yml
- dependabot.yml
- test.sh
- lib.rs
- pool.rs
.gitignore
Cargo.lock
Cargo.toml
CHANGELOG.md
LICENSE
README.md

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# r2d2_mysql

> [`mysql`](https://github.com/blackbeam/rust-mysql-simple) support library for the [`r2d2`](https://github.com/sfackler/r2d2) connection pool.

[![crates.io](https://img.shields.io/crates/v/r2d2_mysql?label=latest)](https://crates.io/crates/r2d2_mysql)
[![Documentation](https://docs.rs/r2d2_mysql/badge.svg?version=26)](https://docs.rs/r2d2_mysql)
![Version](https://img.shields.io/badge/rustc-1.88+-ab6000.svg)
![License](https://img.shields.io/crates/l/r2d2_mysql.svg)
[![Download](https://img.shields.io/crates/d/r2d2_mysql.svg)](https://crates.io/crates/r2d2_mysql)

## Install

Include `r2d2_mysql` in the `[dependencies]` section of your `Cargo.toml`:

```toml
[dependencies]
r2d2_mysql = "28"
```

## Usage

```rust
use std::{env, sync::Arc, thread};

use r2d2_mysql::{
    mysql::{prelude::*, Opts, OptsBuilder},
    r2d2, MySqlConnectionManager,
};

fn main() {
    let url = env::var("DATABASE_URL").unwrap();
    let opts = Opts::from_url(&url).unwrap();
    let builder = OptsBuilder::from_opts(opts);
    let manager = MySqlConnectionManager::new(builder);
    let pool = Arc::new(r2d2::Pool::builder().max_size(4).build(manager).unwrap());

let mut tasks = vec![];

for _ in 0..3 {
        let pool = pool.clone();
        let th = thread::spawn(move || {
            let mut conn = pool.get().expect("error getting connection from pool");

let _ = conn
                .query("SELECT version()")
                .map(|rows: Vec<String>| rows.is_empty())
                .expect("error executing query");
        });

tasks.push(th);
    }

for th in tasks {
        let _ = th.join();
    }
}
```

r2d2-mysql

File Explorer

Today's picks

Was this content helpful?

Recent Feedback

r2d2-mysql

File Explorer

Today's picks

Was this content helpful?

Recent Feedback

Download README