Rust SQL

Open-source Rust projects categorized as SQL

Top 23 Rust SQL Projects

  • GitHub repo diesel

    A safe, extensible ORM and Query Builder for Rust

    Project mention: diesel.exe - Application Error | reddit.com/r/rust | 2021-04-20

    I managed to install the diesel cli like they showed on the getting started page, but when I try to run the diesel commands from command promt I get an error box that pops up saying: "The application was unable to start correctly (0xc000007b). Click OK to close the application." Apparently there was a similar issue previously (https://github.com/diesel-rs/diesel/issues/2034) but they just said its probably some missing DLLs but how do I know what DLLs are missing? Any ideas on how to fix this issue?

  • GitHub repo sqlx

    🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, SQLite, and MSSQL. (by launchbadge)

    Project mention: Tiberius help | reddit.com/r/rust | 2021-04-14

    Sqlx does something that sounds like what you want, but its' MSSQL support isn't the greatest. https://github.com/launchbadge/sqlx#compile-time-verification

  • GitHub repo zombodb

    Making Postgres and Elasticsearch work together like it's 2021

    Project mention: What is the future of databases? | reddit.com/r/programming | 2021-01-25
  • GitHub repo fselect

    Find files with SQL-like queries

    Project mention: AWESOME WINDOWS TOOLS | dev.to | 2021-04-26

    fselect - Command-line tool to search files with SQL-like queries.

  • GitHub repo materialize

    Materialize simplifies application development with streaming data. Incrementally-updated materialized views - in PostgreSQL and in real time. Materialize is powered by Timely Dataflow. (by MaterializeInc)

    Project mention: Logica: Modern Logic Programming | news.ycombinator.com | 2021-04-14

    Fantastic to see a logic programming/datalog/prolog-like from a big actor like Google. Perhaps this can make more such tools become mainstream.

    Only I wish we had such a language for a more generic streaming framework such as materialize [1].

    I was very optimistic about that for some time, as the guy behind the technology, Frank McSherry, wrote some datalog tools as well [2].

    [1] https://materialize.com/

    [2] https://github.com/vmware/differential-datalog

  • GitHub repo rust-postgres

    Native PostgreSQL driver for the Rust programming language

    Project mention: Hey Rustaceans! Got an easy question? Ask here (12/2021)! | reddit.com/r/rust | 2021-03-22

    (see: https://github.com/sfackler/rust-postgres/blob/e15c9b1415f69821799f1370246581c1600a6196/postgres-protocol/src/types/mod.rs#L137)

  • GitHub repo rusqlite

    Ergonomic bindings to SQLite for Rust

    Project mention: SQLite 3.35: math functions, materialized CTEs, RETURNING, and DROP COLUMN | reddit.com/r/programming | 2021-03-13

    I see a tracking issue for rusqlite (diesel dependency) to support sqlite 3.35 but I don't think there's a tracking issue for it in diesel itself yet.

  • GitHub repo sqlparser-rs

    Extensible SQL Lexer and Parser for Rust

    Project mention: My third Rust project: Querying your Kubernetes API Server using SQL | reddit.com/r/rust | 2021-04-15

    sqlparser

  • GitHub repo gluesql

    GlueSQL is quite sticky, it attaches to anywhere.

    Project mention: GlueSQL: SQL Database with Support for WebAssembly | news.ycombinator.com | 2021-04-24
  • GitHub repo barrel

    🛢 A database schema migration builder for Rust

    Project mention: Is there any alternative to Diesel that supports switching between DBMS? | reddit.com/r/rust | 2021-02-05

    I don't know about alternatives, but I think the SQL in the Diesel Getting Started is just migrations. If you want to write those in Rust, Diesel has support for Barrel (setup guide). Not production-ready though.

  • GitHub repo rust-mysql-simple

    Mysql client library implemented in rust.

  • GitHub repo quaint

    SQL Query AST and Visitor for Rust

    Project mention: Is there any alternative to Diesel that supports switching between DBMS? | reddit.com/r/rust | 2021-02-05
  • GitHub repo roapi

    Create full-fledged APIs for static datasets without writing a single line of code.

    Project mention: Generate GraphQL API for any tabular dataset | news.ycombinator.com | 2021-03-18
  • GitHub repo mysql_async

    Asyncronous Rust Mysql driver based on Tokio.

    Project mention: Hey Rustaceans! Got an easy question? Ask here (1/2021)! | reddit.com/r/rust | 2021-01-06

    I'm way ahead of you. I found out about it because I noticed the impl Clone for Pool at the bottom and clicked the [src] button to verify that the pool was shared among clones.

  • GitHub repo rustorm

    an orm for rust

  • GitHub repo deuterium-orm

    Fully typed SQL query builder for Rust [deprecated]

  • GitHub repo mysql-proxy-rs

    A highly scalable MySQL Proxy framework written in Rust

  • GitHub repo isomorphicdb

    The core repository of implementing PostgreSQL compatible distributed database in Rust

    Project mention: Why you should code in Rust in 2021 | dev.to | 2021-05-06

    IsomorphicDB : PostgreSQL clone - it is a good experimental project written in Rust.

  • GitHub repo kubesql

    Experimental tool to query K8s API using plain SQL

    Project mention: My third Rust project: Querying your Kubernetes API Server using SQL | reddit.com/r/rust | 2021-04-15

    I'm glad you like it! Someone asked my friend, "Do you know SQL?" And he said: "No, maybe if it was k8sql". And It suddenly brought me an idea to calling Kubernetes API using SQL. I wrote some design templates before starting the implementation. I hadn't thought of writing its blog post, btw. :)

  • GitHub repo kamu-cli

    Next generation tool for decentralized exchange and transformation of semi-structured data

    Project mention: RiB Newsletter #22 - A few tweaks | reddit.com/r/rust | 2021-03-31

    Kamu Data. Tool for decentralized exchange and transformation of semi-structured data.

  • GitHub repo SQLite

    Interface to SQLite (by stainless-steel)

  • GitHub repo rust-sqlite3

    Rustic bindings for sqlite3

  • GitHub repo treasure

    ORM for rust (journey begins) (by phonkee)

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2021-05-06.

Index

What are some of the best open-source SQL projects in Rust? This list will help you:

Project Stars
1 diesel 6,765
2 sqlx 3,916
3 zombodb 3,334
4 fselect 2,840
5 materialize 2,662
6 rust-postgres 2,137
7 rusqlite 1,055
8 sqlparser-rs 635
9 gluesql 490
10 barrel 424
11 rust-mysql-simple 423
12 quaint 287
13 roapi 280
14 mysql_async 211
15 rustorm 206
16 deuterium-orm 167
17 mysql-proxy-rs 146
18 isomorphicdb 118
19 kubesql 116
20 kamu-cli 86
21 SQLite 75
22 rust-sqlite3 53
23 treasure 39