Rust Postgres

Open-source Rust projects categorized as Postgres

Top 23 Rust Postgre Projects

  • neon

    Neon: Serverless Postgres. We separated storage and compute to offer autoscaling, branching, and bottomless storage.

    Project mention: Why PlanetScale broke our trust in database startups | news.ycombinator.com | 2024-03-15

    Migrated away when they removed the free tier, ended up using https://neon.tech/

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

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

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

  • Replibyte

    Seed your development database with real data ⚡️

  • 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: FLaNK Stack 26 February 2024 | dev.to | 2024-02-26

    Postgresql + MySQL Cache https://github.com/readysettech/readyset

  • paradedb

    Postgres for Search and Analytics

    Project mention: Transforming Postgres into a Fast OLAP Database | news.ycombinator.com | 2024-02-07

    You're right. We're working on this currently. You can track the issue here: https://github.com/paradedb/paradedb/issues/717

  • pgrx

    Build Postgres Extensions with Rust!

    Project mention: UUIDv7 is coming in PostgreSQL 17 | news.ycombinator.com | 2024-02-05

    If you like this (I do very much), you might also like pg_idkit[0] which is a little extension with a bunch of other kinds of IDs that you can generate inside PG, thanks to the seriously awesome pgrx[1] and Rust.

    [0]: https://github.com/VADOSWARE/pg_idkit

    [1]: https://github.com/pgcentralfoundation/pgrx

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

  • postgres_lsp

    A Language Server for Postgres

    Project mention: We built our customer data warehouse all on Postgres | news.ycombinator.com | 2024-02-02

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

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

  • rbatis

    Rust Compile Time ORM robustness,async, pure Rust Dynamic SQL

  • dozer

    Dozer is a real-time data platform for building, deploying and maintaining data products. (by getdozer)

    Project mention: Show HN: Find simple open source bounties to solve and get paid | news.ycombinator.com | 2023-08-19

    https://github.com/getdozer/dozer/issues/1631#issuecomment-1...

    and then something has gone off the rails about the accounting process since

      Trigger.dev

  • sea-query

    🔱 A dynamic SQL query builder for MySQL, Postgres and SQLite

  • cornucopia

    Generate type-checked Rust from your PostgreSQL.

    Project mention: We built our customer data warehouse all on Postgres | news.ycombinator.com | 2024-02-02

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

  • squawk

    🐘 linter for PostgreSQL, focused on migrations

    Project mention: Postgres Language Server: Implementing the Parser | news.ycombinator.com | 2023-12-08

    that is definitely the goal, both a formatter and a linter. we want to add something like squawk directly to the language server, so you get eslint-like dx. with the ast and the database schema in the data model, you can basically add any rule you like.

    [0] https://github.com/sbdchd/squawk/tree/master

  • wrappers

    Postgres Foreign Data Wrapper development framework in Rust.

    Project mention: Should I Open Source my Company? | news.ycombinator.com | 2024-01-22

    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.

  • wasmer-postgres

    💽🕸 Postgres library to run WebAssembly binaries.

  • apalis

    Simple, extensible multithreaded background job and message processing library for Rust

    Project mention: Periodic tasks | /r/rust | 2023-12-04

    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.

  • seaography

    🧭 GraphQL framework for SeaORM

  • KuiBaDB

    Another OLAP database

  • pg_branch

    Experimental Postgres extension for quickly branching databases through file system snapshots

    Project mention: GitHub - NAlexPear/pg_branch: Experimental Postgres extension for quickly branching databases through file system snapshots | /r/PostgreSQL | 2023-11-19
  • oxide

    Teach your PostgreSQL database how to speak MongoDB Wire Protocol

    Project mention: SQLite Functions for Working with JSON | news.ycombinator.com | 2023-08-10

    Sorry about that, it's just a shortcut for https://github.com/fcoury/oxide.

  • ormx

    bringing orm-like features to sqlx

  • mobc

    A generic connection pool for Rust with async/await support

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

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). The latest post mention was on 2024-03-15.

Rust Postgres related posts

Index

What are some of the best open-source Postgre projects in Rust? This list will help you:

Project Stars
1 neon 11,831
2 sqlx 11,493
3 sea-orm 6,091
4 Replibyte 3,965
5 readyset 3,800
6 paradedb 3,528
7 pgrx 3,111
8 postgres_lsp 3,106
9 pg_graphql 2,734
10 rbatis 2,108
11 dozer 1,420
12 sea-query 979
13 cornucopia 628
14 squawk 432
15 wrappers 420
16 wasmer-postgres 397
17 apalis 338
18 seaography 326
19 KuiBaDB 311
20 pg_branch 291
21 oxide 275
22 ormx 273
23 mobc 264
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com