SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Rust MySQL Projects
-
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.
-
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)
-
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.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
SQLpage
SQL-only webapp builder, empowering data analysts to build websites and applications quickly
-
actix_sqlx_mysql_user_crud
A user crud written in Rust, designed to connect to a MySQL database with full integration test coverage.
-
geni
Standalone database migration tool which works for Postgres, MariaDB, MySQL, Sqlite and LibSQL(Turso). (by emilpriver)
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Project mention: MQL – Client and Server to query your DB in natural language | news.ycombinator.com | 2024-04-07I 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/).
Project mention: Top 10 Rusty Repositories for you to start your Open Source Journey | dev.to | 2023-12-197. Diesel
For PostgreSQL, the most relevent part of the code is here. With this in mind I changed some things around to rely on schemas instead of databases and even simplified some parts of the implementation as this was always meant to be for internal use only..
SQL with SeaORM:
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/
It's rather for access control with like, 50+ clients. Possibly with access control. I'm currently testing with warpgate
Project mention: What would I need to use in order to interface with a database? | /r/rust | 2023-06-09
This is a full blown framework, but if anyone else stumbles across this question, https://crates.io/crates/apalis has been really useful for me.
Project mention: compile-time SQL validations and type generation in TypeScript & Node | /r/typescript | 2023-08-27
A while ago, I developed Geni, a CLI database migration tool. The goal of the app was to make migrations to Tursos databases easier. When I developed Geni, I also decided to add support for Postgres, MariaDB, MySQL, and SQLite. The goal of this post is to describe what database/schema migrations are and how to perform them via Geni.
Rust MySQL related posts
-
A tale of TimescaleDB, SQLx and testing in Rust
-
Readyset: A MySQL and Postgres wire-compatible caching layer
-
We built our customer data warehouse all on Postgres
-
Periodic tasks
-
Fine-grained caching strategies of dynamic queries
-
Crate that can help me with background jobs in a server?
-
SQLX MSSQL Connection String Problem
-
A note from our sponsor - SaaSHub
www.saashub.com | 10 May 2024
Index
What are some of the best open-source MySQL projects in Rust? This list will help you:
Project | Stars | |
---|---|---|
1 | cube.js | 17,199 |
2 | diesel | 11,995 |
3 | sqlx | 11,892 |
4 | sea-orm | 6,316 |
5 | Replibyte | 3,998 |
6 | readyset | 3,890 |
7 | warpgate | 3,402 |
8 | rbatis | 2,140 |
9 | sea-query | 1,012 |
10 | SQLpage | 797 |
11 | rust-mysql-simple | 646 |
12 | apalis | 376 |
13 | mysql_async | 365 |
14 | seaography | 342 |
15 | ormx | 278 |
16 | mysql-proxy-rs | 192 |
17 | sea-schema | 169 |
18 | sqlx-ts | 140 |
19 | actix_sqlx_mysql_user_crud | 119 |
20 | lxp-bridge | 101 |
21 | doteur | 99 |
22 | geni | 81 |
23 | sqlx-adapter | 45 |
Sponsored