Rust SQL

Open-source Rust projects categorized as SQL

Top 23 Rust SQL Projects

  • surrealdb

    A scalable, distributed, collaborative, document-graph database, for the realtime web

    Project mention: Task tracker application using NextJS and SurrealDB | dev.to | 2024-01-21

    In this article, I have shared how I have built a simple task-tracking full-stack application using NextJS and SurrealDB.

  • cube.js

    📊 Cube — The Semantic Layer for Building Data Applications

    Project mention: Apache Superset | news.ycombinator.com | 2024-02-26

    We use https://cube.dev/ as intermediate layer between data warehouse database and Superset (and other "terminal" apps for BI like report generators). You define your schema (metrics, dimensions, joins, calculated metrics etc) in cube and then access them by any tool that can connect to SQL db

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  • diesel

    A safe, extensible ORM and Query Builder for Rust

    Project mention: Top 10 Rusty Repositories for you to start your Open Source Journey | dev.to | 2023-12-19

    7. Diesel

  • sqlx

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

    Project mention: Rust as a general application language | /r/rust | 2023-12-09

    What exactly are you missing? I haven't really written "boring corporate backend stuff" in a few years but something like sqlx provides everything I've ever needed there.

  • prql

    PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement

    Project mention: Transpile Any SQL to PostgreSQL Dialect | news.ycombinator.com | 2024-03-18
  • databend

    𝗗𝗮𝘁𝗮, 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 & 𝗔𝗜. Modern alternative to Snowflake. Cost-effective and simple for massive-scale analytics. https://databend.com

    Project mention: Solutions to manage runaway Snowflake costs? | news.ycombinator.com | 2024-01-16

    Databend vs. Snowflake: https://github.com/datafuselabs/databend/issues/13059

  • risingwave

    Scalable Postgres for stream processing, analytics, and management. KsqlDB and Apache Flink alternative. 🚀 10x more productive. 🚀 10x more cost-efficient.

    Project mention: Proton, a fast and lightweight alternative to Apache Flink | news.ycombinator.com | 2024-01-30

    How does this compare to RisingWave and Materialize?

    https://github.com/risingwavelabs/risingwave

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  • sea-orm

    🐚 An async & dynamic ORM for Rust

    Project mention: Rust GraphQL APIs for NodeJS Developers: Introduction | dev.to | 2024-02-08

    SQL with SeaORM:

  • toydb

    Distributed SQL database in Rust, written as a learning project

    Project mention: ToyDB: A Rust learning adventure, fun open-source project, and database learning resource for the community | /r/rust | 2023-05-06

    This is great, but you might want to consider a different name. There's already a Rust project called ToyDB, and it's a distributed database with a Raft log, SQL, disk persistence, ACID transactions, etc. It's under active development (though the developer now works at Cockroach Labs), and has 5K stars on GitHub, so I think they have the right to the name.

  • materialize

    The data warehouse for operational workloads. (by MaterializeInc)

    Project mention: Choosing Between a Streaming Database and a Stream Processing Framework in Python | dev.to | 2024-02-10

    To fully leverage the data is the new oil concept, companies require a special database designed to manage vast amounts of data instantly. This need has led to different database forms, including NoSQL databases, vector databases, time-series databases, graph databases, in-memory databases, and in-memory data grids. Recent years have seen the rise of cloud-based streaming databases such as RisingWave, Materialize, DeltaStream, and TimePlus. While they each have distinct commercial and technical approaches, their overarching goal remains consistent: to offer users cloud-based streaming database services.

  • arrow-datafusion

    Apache Arrow DataFusion SQL Query Engine

    Project mention: What I Talk About When I Talk About Query Optimizer (Part 1): IR Design | news.ycombinator.com | 2024-01-29

    Agree, substrait is a really cool project! Related: if you like substrait you might want to check out datafusion too. The project is a query execution engine built on top of Apache Arrow (with SQL parser, query planner & optimizer, execution engine, extensible user defined functions, among others) and it implements a substrait provider and consumer: https://github.com/apache/arrow-datafusion/tree/main/datafus...

  • readyset

    Readyset is a MySQL and Postgres wire-compatible caching layer that sits in front of existing databases to speed up queries and horizontally scale read throughput. Under the hood, ReadySet caches the results of cached select statements and incrementally updates these results over time as the underlying data changes.

    Project mention: FLaNK Stack 26 February 2024 | dev.to | 2024-02-26

    Postgresql + MySQL Cache https://github.com/readysettech/readyset

  • fselect

    Find files with SQL-like queries

  • greptimedb

    An open-source, cloud-native, distributed time-series database with PromQL/SQL/Python supported.

    Project mention: Another distributed time-series database written in Rust | news.ycombinator.com | 2024-02-12
  • rust-postgres

    Native PostgreSQL driver for the Rust programming language

  • arroyo

    Distributed stream processing engine in Rust

    Project mention: FLaNK AI Weekly 18 March 2024 | dev.to | 2024-03-18
  • roapi

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

    Project mention: Full-fledged APIs for slowly moving datasets without writing code | news.ycombinator.com | 2023-10-25
  • GQL

    Git Query language is a SQL like language to perform queries on .git files with supports of most of SQL features such as grouping, ordering and aggregations functions

    Project mention: Git Query Language | news.ycombinator.com | 2024-02-02
  • pg_graphql

    GraphQL support for PostgreSQL

    Project mention: Is it just me or is the Supabase GraphQL API really bad? | /r/webdev | 2023-12-07

    Hi, I'm the author of Supabase GraphQL (pg_graphql)

  • rusqlite

    Ergonomic bindings to SQLite for Rust

    Project mention: SQLite + Rust: Building a CLI Password Vault 🦀 | dev.to | 2024-03-15

    "Rusqlite is an ergonomic wrapper for using SQLite from Rust." - Crates.io

  • gobang

    A cross-platform TUI database management tool written in Rust

    Project mention: Ratatui | news.ycombinator.com | 2023-12-10

    I think a lot of Ratatui apps will tend to land on similar concepts for your app. There's a few good examples of apps using a component approach rather than just widgets that I'm aware of:

    - https://github.com/sxyazi/yazi

    - https://github.com/TaKO8Ki/gobang

    - https://github.com/nomadiz/edma

    Perhaps the intuitive crate would make a good abstraction on top of Ratatui?

  • gluesql

    GlueSQL is quite sticky. It attaches to anywhere.

    Project mention: GlueSQL v0.14 Release - Schemaless data support and the official doc website | /r/rust | 2023-05-30
  • incubator-horaedb

    HoraeDB is a high-performance, distributed, cloud native time-series database.

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

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 2024-03-18.

Rust SQL related posts

Index

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

Project Stars
1 surrealdb 24,779
2 cube.js 16,987
3 diesel 11,718
4 sqlx 11,424
5 prql 9,272
6 databend 7,046
7 risingwave 6,087
8 sea-orm 6,045
9 toydb 5,837
10 materialize 5,527
11 arrow-datafusion 4,760
12 readyset 3,776
13 fselect 3,752
14 greptimedb 3,512
15 rust-postgres 3,234
16 arroyo 3,091
17 roapi 3,028
18 GQL 2,946
19 pg_graphql 2,708
20 rusqlite 2,676
21 gobang 2,612
22 gluesql 2,566
23 incubator-horaedb 2,451
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com