Collect, organize, and act on massive volumes of high-resolution data to power real-time intelligent systems. Learn more →
Top 23 Rust SQL Projects
-
Project mention: SurrealDB 2.2: Benchmarking, graph path algorithms and foreign key constraints | dev.to | 2025-03-17
To make this better, we've created a language testing suite similar to the ECMAscript conformance testing suite test262.
-
CodeRabbit
CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
-
cube.js
📊 Cube’s universal semantic layer platform is the next evolution of OLAP technology for AI, BI, spreadsheets, and embedded analytics
Cube is a headless business intelligence tool for building analytical web apps quickly and efficiently. Data modeling, access control, APIs, and caching are the four main features of Cube. It offers analytical API servers with query orchestration and multi-level caching capabilities.
-
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)
Because type correctness does not imply branch correctness. SQL has side effects of interpretation, and any string/query builder that is not aware of grammatical implications should be avoided in my opinion.
Check the query builder of sqlx [1]
[1] https://github.com/launchbadge/sqlx/blob/main/sqlx-core/src/...
-
Tauri's backend is in Rust, so I always thought the only way to use sqlite ORM in a Tauri app is with projects like diesel or prisma-client-rust, which could be hard because they are in rust. What is even harder is sqlite db encryption. Both of the 2 ORMs don't support cipher encryption, thus I had to write raw sql queries in kunkun Example Maintaining raw sql queries is a nightmare to me, especially when it comes to schema migration. I have to rely on thorough testing to make sure everything is correct. There is no type checking.
-
prql
PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
-
> they seem to intend to Embrace Extend Extinguish
What makes you think that? Limbo is MIT licensed and I don't see any CLA on [1].
[1]: https://github.com/tursodatabase/limbo/blob/main/CONTRIBUTIN...
-
-
InfluxDB
InfluxDB high-performance time series database. Collect, organize, and act on massive volumes of high-resolution data to power real-time intelligent systems.
-
Project mention: Simplifying SQL function implementation with Rust procedural macro | dev.to | 2025-03-13
Then, utilize declarative macros to generate various types of kernel functions, including functions with 1, 2, and 3 parameters, as well as the input/output combinations of T and Option. Common kernels like unary, binary, ternary, unary_nullable and unary_bytes are generated, partially addressing the last two issues. (For the implementation details, see RisingWave's earlier code.) Theoretically, type exercise could also be used here. For example, introducing a trait to unify (A,), (A, B) and (A, B, C), or utilizing traits of Into and AsRef to unify T, Option, and Result, etc. However, you will probably encounter some type challenges posed by rustc.
-
Project mention: Apache Datafusion – An extensible query engine in Rust that uses Apache Arrow | news.ycombinator.com | 2025-04-15
-
paradedb
ParadeDB is a modern Elasticsearch alternative built on Postgres. Built for real-time, update-heavy workloads.
Project mention: Meilisearch – search engine API bringing AI-powered hybrid search | news.ycombinator.com | 2025-04-14- https://github.com/paradedb/paradedb
I'm still looking for a systematic approach to make a hybrid search (combined full-text with vectors).
Any thoughts on up-to-date hybrid search experience are greatly appreciated
-
-
Project mention: Postgres Learns to RAG: Wikipedia Q&A using Llama 3.1 inside the database | news.ycombinator.com | 2024-09-24
GitHub: https://github.com/postgresml/postgresml
Looking forward to your feedback and any questions about the technical details.
-
materialize
Real-time Data Integration and Transformation: use SQL to transform, deliver, and act on fast-changing data. (by MaterializeInc)
https://materialize.com/ provides another approach, based on "timely dataflow" (https://timelydataflow.github.io/timely-dataflow/) - originated at MS.
-
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: How to Make Your Postgres Database 100x Faster and 50% Cheaper with Readyset Cloud🚀⚡💵 | dev.to | 2025-02-27I also faced similar issues and was looking for easy ways to improve performance in our application when I came across an awesome tool called Readyset. It sits between your application and database, intelligently caching complex queries while automatically handling invalidation. This setup can significantly boost performance without requiring major changes to your existing infrastructure.
-
greptimedb
An open-source, cloud-native, unified observability database for metrics, logs and traces, supporting SQL/PromQL/Streaming. Available on GreptimeCloud.
Time Series: Greptime, Influx, Loki, Mimir, Prometheus, Tempo, Victoria Metrics
-
-
-
-
-
Using a proper datetime system has the added bonus of letting us represent dates much farther in the past than 1900, although I'd be careful with anything before 1582. Building a spreadsheet from scratch is challenging and takes a long time to get right, so if you have a use case we don't support yet, let us know on our community forums or submit a code contribution on GitHub!
-
GQL
GitQL is a extensible SQL-like query language and SDK to perform queries on various data sources such .git files with supports of most of SQL features such as grouping, ordering and aggregation and window functions and allow customization like user-defined types and functions
-
Project mention: Show HN: Turn CSS files into high performance APIs | news.ycombinator.com | 2025-01-11
-
Project mention: Modern Web Development Sucks? How PostgreSQL Can Replace Your Tech Stack | dev.to | 2025-03-05
Want a GraphQL API without the hassle of setting up Apollo Server or Hasura? With the pg_graphql extension, PostgreSQL itself becomes your GraphQL backend—no extra servers, no complex configurations, just pure SQL.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Rust SQL discussion
Rust SQL related posts
-
Postgres Language Server: Initial Release
-
Just Write a Test for It
-
ConnectorX: Accelerating Data Loading From Databases to Dataframes
-
SQL queries don't start with SELECT (2019)
-
Why Not SQL: The Origin of ScopeQL
-
Show HN: RisingLight – OLAP Database in Rust with SQL Support
-
Show HN: RisingWave – Open-Source Real-Time Database for Stream&Batch with SQL
-
A note from our sponsor - InfluxDB
influxdata.com | 17 Apr 2025
Index
What are some of the best open-source SQL projects in Rust? This list will help you:
# | Project | Stars |
---|---|---|
1 | surrealdb | 29,104 |
2 | cube.js | 18,433 |
3 | sqlx | 14,519 |
4 | diesel | 13,264 |
5 | prql | 10,208 |
6 | limbo | 10,147 |
7 | sea-orm | 8,062 |
8 | risingwave | 7,636 |
9 | datafusion | 7,008 |
10 | paradedb | 6,968 |
11 | toydb | 6,392 |
12 | postgresml | 6,235 |
13 | materialize | 5,951 |
14 | readyset | 4,928 |
15 | greptimedb | 4,865 |
16 | fselect | 4,163 |
17 | arroyo | 4,253 |
18 | rust-postgres | 3,659 |
19 | rusqlite | 3,529 |
20 | quadratic | 3,489 |
21 | GQL | 3,396 |
22 | roapi | 3,282 |
23 | pg_graphql | 3,085 |