Struct quaint::pooled::Quaint

pub struct Quaint {
    pub inner: Pool<QuaintManager>,
    // some fields omitted
}

The main entry point and an abstraction over database connections and

Fields

inner: Pool<QuaintManager>

Methods

impl Quaint

pub async fn new<'_>(url_str: &'_ str) -> Result<Self>

Create a new pool of connections to the database. The connection string follows the specified format:

connector_type://user:password@host/database?parameters

Connector type can be one of the following:

• sqlite/file opens an SQLite connection
• mysql opens a MySQL connection
• postgres/postgresql opens a PostgreSQL connection

All parameters should be given in the query string format: ?key1=val1&key2=val2. All parameters are optional.

Common parameters:

• connection_limit defines the number of connections opened to the database. If not set, defaults to the HikariCP Recommendation: physical_cpus * 2 + 1.

SQLite:

• user/password do not do anything and can be emitted.
• host should point to the database file.
• db_name parameter should give a name to the database attached for query namespacing.

PostgreSQL:

• sslmode either disable, prefer or require.
• sslcert should point to a PEM certificate file.
• sslidentity should point to a PKCS12 certificate database.
• sslpassword the password to open the PKCS12 database.
• sslaccept either strict or accept_invalid_certs. If strict, the certificate needs to be valid and in the CA certificates. accept_invalid_certs accepts any certificate from the server and can lead to weakened security. Defaults to accept_invalid_certs.
• schema the default search path.
• host additionally the host can be given as a parameter, typically in cases when connectiong to the database through a unix socket to separate the database name from the database path, such as postgresql:///dbname?host=/var/run/postgresql.

MySQL:

• sslcert should point to a PEM certificate file.
• sslidentity should point to a PKCS12 certificate database.
• sslpassword the password to open the PKCS12 database.
• sslaccept either strict or accept_invalid_certs. If strict, the certificate needs to be valid and in the CA certificates. accept_invalid_certs accepts any certificate from the server and can lead to weakened security. Defaults to strict.
• socket needed when connecting to MySQL database through a unix socket. When set, the host parameter is dismissed.

pub async fn capacity<'_>(&'_ self) -> u32

The number of connections in the pool.

pub async fn check_out<'_>(&'_ self) -> Result<PooledConnection>

Reserve a connection from the pool.

pub fn connection_info(&self) -> &ConnectionInfo

Info about the connection and underlying database.