The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. Learn more →
Top 23 Rust SQL Projects
-
In this article, I have shared how I have built a simple task-tracking full-stack application using NextJS and SurrealDB.
-
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.
-
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)
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
-
databend
𝗗𝗮𝘁𝗮, 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 & 𝗔𝗜. Modern alternative to Snowflake. Cost-effective and simple for massive-scale analytics. https://databend.com
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-30How does this compare to RisingWave and Materialize?
-
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.
-
SQL with SeaORM:
-
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.
-
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.
-
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.
Postgresql + MySQL Cache https://github.com/readysettech/readyset
-
-
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 -
-
-
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
-
Hi, I'm the author of Supabase GraphQL (pg_graphql)
-
"Rusqlite is an ergonomic wrapper for using SQLite from Rust." - Crates.io
-
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?
-
Project mention: GlueSQL v0.14 Release - Schemaless data support and the official doc website | /r/rust | 2023-05-30
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Rust SQL related posts
- SQLite + Rust: Building a CLI Password Vault 🦀
- Apache Superset
- We built our customer data warehouse all on Postgres
- Quadratic – Open-Source Spreadsheet Is Now Multiplayer
- GitQL 0.13.0 allow exporting result as JSON or CSV
- Solutions to manage runaway Snowflake costs?
- Polars
-
A note from our sponsor - WorkOS
workos.com | 18 Mar 2024
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 |