Crate diesel_connection

Static diesel r2d2 connection pooling with env configuration

Composible connection urls are provided by environment variables using env-url using the DATABASE prefix:

 | ENV                     |                            |
 | -----------------------:|:--------------------------:|
 | DATABASE_URL            | set connection url         |
 | DATABASE_HOST           | set url host               |
 | DATABASE_PORT           | set url port               |
 | DATABASE_PATH           | set selected database      |
 | DATABASE_USERINFO       | set connnection userinfo   |

MAX_DB_CONNECTIONS env sets max connections within connection pool

The dotenv feature flag enables automatic at-most-once dotenv loading via dotenvy. This is necessary because pool statics are initialized pre-main via static_init.

use diesel_connection::{pg::get_connection, PoolError};

#[actix_rt::main]
async fn main() -> Result<(), PoolError> {
  let conn = get_connection()?;
}

Re-exports

• pub use pg::PooledConnection;

Modules

• mysqlmysql
  Types for MySQL connections.
• pgpostgres
  Types for Postgres connections.
• sqlitesqlite
  Types for SQLite connections.

Structs

• ConnectionPool
  Static connection pool type

Traits

• ConnectionInfo
• PoolContext
  Trait for defining static connection pool

Functions

• get_connection
  Get postgress connection from pool. Use DATABASE_URL env variable to set connection url

Derive Macros

• PoolContext