#odbc #sql #pool #database #r2d2

r2d2_odbc

ODBC support for the r2d2 connection pool

5 releases (breaking)

Uses old Rust 2015

0.5.0 Dec 18, 2019
0.4.0 Nov 12, 2019
0.3.0 Oct 29, 2019
0.2.0 Jan 22, 2019
0.1.0 Feb 21, 2018

#583 in Database interfaces

Download history 8/week @ 2020-09-22 12/week @ 2020-09-29 7/week @ 2020-10-06 7/week @ 2020-10-13 10/week @ 2020-10-20 7/week @ 2020-10-27 7/week @ 2020-11-03 8/week @ 2020-11-10 8/week @ 2020-11-17 13/week @ 2020-11-24 12/week @ 2020-12-01 14/week @ 2020-12-08 3/week @ 2020-12-15 4/week @ 2020-12-22 2/week @ 2020-12-29 7/week @ 2021-01-05

54 downloads per month

MIT license

8KB
107 lines

r2d2-odbc

ODBC adapter for r2d2 connection pool

https://travis-ci.org/Koka/odbc-rs Appveyor Build status https://crates.io/crates/r2d2_odbc Coverage Status Docs

Example:


extern crate r2d2;
extern crate r2d2_odbc;
extern crate odbc;

use std::thread;
use r2d2_odbc::ODBCConnectionManager;
use odbc::*;

fn main() {
    let manager = ODBCConnectionManager::new("DSN=PostgreSQL");
    let pool = r2d2::Pool::new(manager).unwrap();

    let mut children = vec![];
    for i in 0..10i32 {
        let pool = pool.clone();
        children.push(thread::spawn(move || {
            let pool_conn = pool.get().unwrap();
            let conn = pool_conn.raw();
            let stmt = Statement::with_parent(&conn).unwrap();
            if let Data(mut stmt) = stmt.exec_direct("SELECT version()").unwrap() {
                while let Some(mut cursor) = stmt.fetch().unwrap() {
                    if let Some(val) = cursor.get_data::<&str>(1).unwrap() {
                        println!("THREAD {} {}", i, val);
                    }
                }
            }
        }));
    }

    for child in children {
        let _ = child.join();
    }
}

Dependencies

~4.5MB
~142K SLoC