Rust SQL

Open-source Rust projects categorized as SQL | Edit details

Top 23 Rust SQL Projects

  • GitHub repo diesel

    A safe, extensible ORM and Query Builder for Rust

    Project mention: What's everyone working on this week (38/2021)? | reddit.com/r/rust | 2021-09-20

    I initially meant to use Rails as a way to learn it, but missed Rust too much and switched to Yew for the frontend and Diesel and Tide for the backend. I'm trying to force myself to care more about finishing the project (and quickly getting it into production!) than making everything perfect, which is difficult for me.

  • 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: Ask HN: How do you handle CI/CD for databases | news.ycombinator.com | 2021-09-21

    We use sqx: https://github.com/launchbadge/sqlx. The devs create and commit the up/down migration files and the cicd runner runs the migrations against the db.

  • Nanos

    Run Linux Software Faster and Safer than Linux with Unikernels.

  • 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: How not to blow up the production database | news.ycombinator.com | 2021-10-15

    I've been looking at Materielize for a while (https://materialize.com/). It can handle automatically refreshed materialized views. Last time I checked, it didn't support some Postgres SQL constructs that I use often, but I'm really looking forward to it.

  • GitHub repo toydb

    Distributed SQL database in Rust, written as a learning project

    Project mention: ToyDB: Distributed SQL Database in Rust | news.ycombinator.com | 2021-07-18

    No, you can't really opt out of A. CAP is a great theoretical result, but it's too narrow to be convenient for analyzing real life situations. (At least this is my not too deep understanding of this topic.)

    In practice even this ToyDB is likely able to serve requests in a degraded state (probably as long as the Raft leader's timer does not expire, and if there's a quorum of nodes they can reelect a leader). And it seems that if a node falls out of sync it will automatically rejoin and try to replay the logs. (As long as they are available of course.)

    https://github.com/erikgrinaker/toydb/blob/master/docs/archi...

    https://www.youtube.com/watch?v=hUd_9FENShA

    https://blog.acolyer.org/2014/11/07/highly-available-transac...

  • GitHub repo fselect

    Find files with SQL-like queries

    Project mention: Awesome Rewrite It In Rust - A curated list of replacements for existing software written in Rust | reddit.com/r/rust | 2021-05-27

    I really like fselect, which I use more than fd

  • GitHub repo rust-postgres

    Native PostgreSQL driver for the Rust programming language

    Project mention: Announcing Usual -- a small nORM wrapper to make dealing with SQL easier (like tokio-postgres) | reddit.com/r/rust | 2021-08-25

    Some nifty things about usual: - It's a generic wrapper over any SQL "row" object. The first implementation that's provided is for tokio-postgres, but traits are available to implement over whatever you'd like. - It provides static typing for partial queries. That is, it supports fetching a subset of fields from a row and makes a unique type for the return value. This gives you some neat-o type safety like this:

  • GitHub repo databend

    An elastic and reliable Cloud Data Warehouse, offers Blazing Fast Query and combines Elasticity, Simplicity, Low cost of the Cloud, built to make the Data Cloud easy

    Project mention: Databend will release proposal: Nightly v0.5 | reddit.com/r/Database | 2021-10-15
  • Scout APM

    Scout APM: A developer's best friend. Try free for 14-days. Scout APM uses tracing logic that ties bottlenecks to source code so you know the exact line of code causing performance issues and can get back to building a great product faster.

  • GitHub repo gobang

    A cross-platform TUI database management tool written in Rust

    Project mention: Hacker News top posts: Sep 11, 2021 | reddit.com/r/hackerdigest | 2021-09-11

    Gobang – Cross-platform TUI database management tool written in Rust\ (34 comments)

  • GitHub repo rusqlite

    Ergonomic bindings to SQLite for Rust

    Project mention: Any way to make all variables of a struct optional? | reddit.com/r/rust | 2021-08-18

    Sqlite is an in-memory database, and it looks like it has rust bindings: https://github.com/rusqlite/rusqlite

  • GitHub repo gluesql

    GlueSQL is quite sticky, it attaches to anywhere.

    Project mention: GlueSQL v0.8 - MVCC Transaction is now supported! | reddit.com/r/rust | 2021-08-23

    I'm really glad to share the release of GlueSQL v0.8

  • GitHub repo sqlparser-rs

    Extensible SQL Lexer and Parser for Rust

    Project mention: We Went All in on Sqlc/Pgx for Postgres and Go | news.ycombinator.com | 2021-09-08
  • GitHub repo roapi

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

    Project mention: Roapi: An API Server for Static Datasets | news.ycombinator.com | 2021-10-08

    In its current form, the main use-case is to load data into memory first then serve them through query apis. Thomas has made some effort to support querying data directly from remote source without loading them into memory: https://github.com/roapi/roapi/pull/71. The underlying query engine, Apache Arrow Datafusion, supports running query on data stream on the granularity of partitions. This is not heavily used in roapi at the moment because I want to nail the in memory serving use-case first.

  • GitHub repo skytable

    Skytable is an extremely fast, secure and reliable real-time NoSQL database with automated snapshots and TLS

    Project mention: What are you using Rust for? | reddit.com/r/rust | 2021-10-01

    Well, we're building the Skytable database with it.

  • GitHub repo rust-mysql-simple

    Mysql client library implemented in rust.

  • GitHub repo sea-orm

    🐚 An async & dynamic ORM for Rust

    Project mention: Whats your favourite open source Rust project that needs more recognition? | reddit.com/r/rust | 2021-10-11

    SeaORM - 🐚 An async & dynamic ORM for 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 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 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

    New generation decentralized data warehouse and streaming data pipeline

    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 squawk

    🐘 linter for PostgreSQL, focused on migrations

    Project mention: PostgreSQL 14 Released | news.ycombinator.com | 2021-09-30

    We've had good success with https://github.com/sbdchd/squawk to lint migrations. It tells you if a query is going to lock your table (as long as it's written in SQL, not some ORM DSL)

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-10-15.

Index

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

Project Stars
1 diesel 7,422
2 sqlx 4,719
3 materialize 3,136
4 toydb 3,039
5 fselect 3,038
6 rust-postgres 2,302
7 databend 2,216
8 gobang 1,497
9 rusqlite 1,221
10 gluesql 1,093
11 sqlparser-rs 830
12 roapi 574
13 skytable 462
14 rust-mysql-simple 454
15 sea-orm 393
16 quaint 374
17 mysql_async 236
18 rustorm 216
19 deuterium-orm 169
20 mysql-proxy-rs 148
21 kubesql 137
22 kamu-cli 99
23 squawk 87
Find remote SQL jobs at our new job board 99remotejobs.com. There is 1 new remote job listed recently.
Are you hiring? Post a new remote job listing for free.
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com