#async-orm #postgresql #sqlite #mssql #mysql #orm #sql-database

welds-connections

An async ORM for (postgres, mssql, mysql, sqlite)

7 releases

0.3.5 May 1, 2024
0.3.4 Apr 4, 2024
0.3.1 Mar 11, 2024

#1375 in Database interfaces

Download history 472/week @ 2024-03-06 56/week @ 2024-03-13 44/week @ 2024-03-20 54/week @ 2024-03-27 347/week @ 2024-04-03 46/week @ 2024-04-10 20/week @ 2024-04-17 98/week @ 2024-04-24 162/week @ 2024-05-01 2/week @ 2024-05-08 10/week @ 2024-05-15 32/week @ 2024-05-22 33/week @ 2024-05-29

78 downloads per month
Used in 2 crates (via welds)

BSD-3-Clause

88KB
2.5K SLoC

An async ORM written in rust using sqlx and tiberius.

Welds Connections

This is the common interface used by welds for all Databases.

It allows you to talk to sqlx and tiberius over traits in a simple common way.

Features

  • async for all.
  • Connections are pooled.
  • Transactions for all. (looking at you tiberius)
  • Support for multiple SQL databases (Mssql, MySql, Postgres, Sqlite)
  • Written for ease of development. Simple interface

The Simple interface

/// The common trait for database connections and transactions.
pub trait Client {
    /// Execute a sql command. returns the number of rows that were affected
    async fn execute(&self, sql: &str, params: &[&(dyn Param + Sync)]) -> Result<ExecuteResult>;

    /// Runs SQL and returns a collection of rows from the database.
    async fn fetch_rows(&self, sql: &str, params: &[&(dyn Param + Sync)]) -> Result<Vec<Row>>;

    /// Run several `fetch_rows` command on the same connection in the connection pool
    async fn fetch_many(&self, args: &[Fetch]) -> Result<Vec<Vec<Row>>>;

    // Returns what syntax (dialect) of SQL the backend is expecting
    fn syntax(&self) -> Syntax;
}

Thats it.

Thats All this crate is.

You get this for:

  • MySql and its transactions
  • Postgres and its transactions
  • Sqlite and its transactions
  • Mssql and its transactions

Transactions

You can get a transaction with the TransactStart Trait.


use welds_connections::{Client, TransactStart};
#[tokio::main]
async fn main() -> std::result::Result<(), Box<dyn std::error::Error>> {
    let url = "sqlite://./test.sqlite";
    let client = welds_connections::sqlite::get_conn(url).await?;
    let transaction = client.begin().await?;
    transaction.rollback.await?;
}

Example


use welds_connections::{Client, TransactStart};

#[tokio::main]
async fn main() -> std::result::Result<(), Box<dyn std::error::Error>> {

    let url = "sqlite://./test.sqlite";
    let client = welds_connections::sqlite::get_conn(url).await?;

    let sql = "SELECT name from people where name like ?";
    let filter = "James%".to_string();
    let rows = client.fetch_rows(sql, &[&filter]).await?;

    for row in rows {
        let name: String = row.get("name").unwrap();
        println!("ROW: {:?}", &name);
    }
}

Dependencies

~0.3–18MB
~241K SLoC