Rust SQL

Open-source Rust projects categorized as SQL
Edit details
Topics: Rust Database Postgresql Sqlite MySQL
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.
www.influxdata.com
Sponsored

Top 23 Rust SQL Projects

  • surrealdb

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

    • Project mention: Show HN: I made a tool to easily compare pricing of developer tools and services | news.ycombinator.com | 2024-04-23

    you should add https://surrealdb.com -- basically an open source firebase. and they will launch a paid cloud offering soon.

  • cube.js

    📊 Cube — The Semantic Layer for Building Data Applications

    • Project mention: MQL – Client and Server to query your DB in natural language | news.ycombinator.com | 2024-04-07

    I should have clarified. There's a large number of apps that are:

    1. taking info strictly from SQL (e.g. information_schema, query history)

    2. taking a user input / question

    3. writing SQL to answer that question

    An app like this is what I call "text-to-sql". Totally agree a better system would pull in additional documentation (which is what we're doing), but I'd no longer consider it "text-to-sql". In our case, we're not even directly writing SQL, but rather generating semantic layer queries (i.e. https://cube.dev/).

  • 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.

    WorkOS logo

  • 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: Prolog language for PostgreSQL proof of concept | news.ycombinator.com | 2024-03-30

  • 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

    Cloud-native SQL 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.

    InfluxDB logo

  • 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: Ask HN: How Can I Make My Front End React to Database Changes in Real-Time? | news.ycombinator.com | 2024-04-17

    [2] https://materialize.com/

  • datafusion

    Apache DataFusion SQL Query Engine

    • Project mention: Velox: Meta's Unified Execution Engine [pdf] | news.ycombinator.com | 2024-03-25

    Python's Substrait seems like the biggest/most-used competitor-ish out there. I'd love some compare & contrast; my sense is that Substrait has a smaller ambition, and more wants to be a language for talking about execution rather than a full on execution engine. https://github.com/substrait-io/substrait

    We can also see from the DataFusion discussion that they too see themselves as a bit of a Velox competitor. https://github.com/apache/arrow-datafusion/discussions/6441

  • 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: Ask HN: How Can I Make My Front End React to Database Changes in Real-Time? | news.ycombinator.com | 2024-04-17

    - Some platforms like Supabase Realtime [3] and Firebase offer subscription models to database changes, but these solutions fall short when dealing with complex queries involving joins or group-bys.

    My vision is that the modern frontend to behave like a series of materialized views that dynamically update as the underlying data changes. Current state management libraries handle state trees well but don't seamlessly integrate with relational or graph-like database structures.

    The only thing I can think of is to implement it by myself, which sounds like a big PITA.

    Anything goes, Brainstorm with me. Is it causing you headaches as well? Are you familiar with an efficient solution? how are you all tackling it?

    [1] https://readyset.io/

  • fselect

    Find files with SQL-like queries

  • greptimedb

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

    • Project mention: GreptimeDB: A fast and cost-effective alternative to InfluxDB | news.ycombinator.com | 2024-04-06

  • 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

    SaaSHub logo
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).

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 25,191
2 cube.js 17,135
3 diesel 11,930
4 sqlx 11,742
5 prql 9,427
6 databend 7,184
7 risingwave 6,283
8 sea-orm 6,246
9 toydb 5,886
10 materialize 5,567
11 datafusion 5,020
12 readyset 3,882
13 fselect 3,803
14 greptimedb 3,743
15 rust-postgres 3,281
16 arroyo 3,275
17 roapi 3,080
18 GQL 3,043
19 pg_graphql 2,765
20 rusqlite 2,737
21 gobang 2,672
22 gluesql 2,599
23 incubator-horaedb 2,490

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com