SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Rust Postgre Projects
-
neon
Neon: Serverless Postgres. We separated storage and compute to offer autoscaling, branching, and bottomless storage.
-
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)
-
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.
-
risingwave
SQL stream processing, analytics, and management. We decouple storage and compute to offer instant failover, dynamic scaling, speedy bootstrapping, and efficient joins.
-
-
postgresml
The GPU-powered AI application database. Get your app to market faster using the simplicity of SQL and the latest NLP, ML + LLM models.
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
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.
-
-
-
-
-
dozer
Dozer is a real-time data movement tool that leverages CDC from various sources and moves data into various sinks. (by getdozer)
-
-
-
-
-
-
-
pg_branch
Experimental Postgres extension for quickly branching databases through file system snapshots
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Postgres (With Neon DB)
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..
Project mention: Proton, a fast and lightweight alternative to Apache Flink | news.ycombinator.com | 2024-01-30How does this compare to RisingWave and Materialize?
https://github.com/risingwavelabs/risingwave
SQL with SeaORM:
Project mention: Pg_lakehouse: Query Any Data Lake from Postgres | news.ycombinator.com | 2024-05-13
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/
Project mention: Pg_lakehouse: Query Any Data Lake from Postgres | news.ycombinator.com | 2024-05-13Yet another amazing postgres plugin made possible by pgrx (https://github.com/pgcentralfoundation/pgrx)
It's really crazy how some projects just instantly enable a whole generation of new possibilities.
If you are impressed like this and want to build something like it -- check out pgrx, it's a pretty great experience.
Project mention: We built our customer data warehouse all on Postgres | news.ycombinator.com | 2024-02-02Thank you for turning me on top Cornucopia, it looks awesome. I've used the very similar aiosql in Python, but I hadn't realized there was a Rust analog.
To tell the truth I've been waiting for postgres_lsp to mature before trying it out, but based on this example [1] I think it does support multiple queries.
Since it uses a parser extracted from Postgres, the nonstandard syntax would probably trip it up, but there's probably a way to fix that.
[1] https://github.com/supabase/postgres_lsp/blob/main/example/f...
Hi, I'm the author of Supabase GraphQL (pg_graphql)
Project mention: Show HN: Find simple open source bounties to solve and get paid | news.ycombinator.com | 2023-08-19https://github.com/getdozer/dozer/issues/1631#issuecomment-1...
and then something has gone off the rails about the accounting process since
Trigger.dev
Project mention: We built our customer data warehouse all on Postgres | news.ycombinator.com | 2024-02-02There are multiple queries each separated by ; and on top of each query, there's a comment giving a name to the query (it's more like a header)
I think the only thing that would require specific support in postgres_lsp is using the :parameter_name syntax for prepared statements [1] (in vanilla Postgres would be something like $1 or $2, but in Cornucopia it is named to aid readability). But, if postgres_lsp is forgiging enough to not choke on that, then it seems completely fit for this use case.
[0] https://github.com/cornucopia-rs/cornucopia
[1] https://cornucopia-rs.netlify.app/book/writing_queries/writi...
I used one of their open source work in a project: https://github.com/supabase/wrappers
It’s appreciated since SaaS on AWS is a no-no in my field.
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: GitHub - NAlexPear/pg_branch: Experimental Postgres extension for quickly branching databases through file system snapshots | /r/PostgreSQL | 2023-11-19
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 Postgres related posts
-
Pg_lakehouse: Query Any Data Lake from Postgres
-
A tale of TimescaleDB, SQLx and testing in Rust
-
How to ditch Neon
-
Squawk – A Linter for Postgres Migrations
-
Serverless Postgres with Neon - My first impression
-
Introducing pgzx: create PostgreSQL extensions using Zig
-
Why PlanetScale broke our trust in database startups
-
A note from our sponsor - SaaSHub
www.saashub.com | 22 May 2024
Index
What are some of the best open-source Postgre projects in Rust? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | neon | 12,460 |
| 2 | sqlx | 12,025 |
| 3 | risingwave | 6,394 |
| 4 | sea-orm | 6,392 |
| 5 | postgresml | 5,483 |
| 6 | Replibyte | 4,006 |
| 7 | paradedb | 4,240 |
| 8 | readyset | 3,896 |
| 9 | pgrx | 3,266 |
| 10 | postgres_lsp | 3,136 |
| 11 | pg_graphql | 2,780 |
| 12 | rbatis | 2,150 |
| 13 | dozer | 1,456 |
| 14 | sea-query | 1,026 |
| 15 | cornucopia | 713 |
| 16 | squawk | 498 |
| 17 | wrappers | 446 |
| 18 | wasmer-postgres | 397 |
| 19 | apalis | 385 |
| 20 | seaography | 344 |
| 21 | KuiBaDB | 311 |
| 22 | pg_branch | 300 |
| 23 | ormx | 278 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com