Rust Postgresql

Open-source Rust projects categorized as Postgresql
Edit details
Topics: Rust Postgres SQL Database 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
featured

Top 23 Rust Postgresql Projects

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

  • neon

    Neon: Serverless Postgres. We separated storage and compute to offer autoscaling, code-like database branching, and scale to zero.

    • Project mention: The evolution of Serverless Postgres | dev.to | 2024-05-30

    A lot has changed since then, including AWS's decision to deprecate scale-to-zero in Aurora. Today, developers have other options for running serverless Postgres, such as Neon. In this comparison, we'll examine the key differences between Aurora and Neon, focusing on their serverless capabilities and pricing models.

  • 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

  • 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: A tale of TimescaleDB, SQLx and testing in Rust | dev.to | 2024-05-02

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

  • hyperswitch

    An open source payments switch written in Rust to make payments fast, reliable and affordable

    • Project mention: A better storage format for postman collections | news.ycombinator.com | 2024-04-14

  • risingwave

    SQL stream processing, analytics, and management. We decouple storage and compute to offer instant failover, dynamic scaling, speedy bootstrapping, and efficient joins.

    • 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

  • materialize

    The data warehouse for operational workloads. (by MaterializeInc)

    • Project mention: The Notifier Pattern for Applications That Use Postgres | news.ycombinator.com | 2024-05-14

    Those updates are not retroactive. They apply on a go forward basis. Each day's changes become Apache 2.0 licensed on that day four years in the future.

    For example, v0.28 was released on October 18, 2022, and becomes Apache 2.0 licensed four years after that date (i.e., 2.5 years from today), on October 18, 2026.

    [0]: https://github.com/MaterializeInc/materialize/blob/76cb6647d...

  • SaaSHub

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

    SaaSHub logo

  • Replibyte

    Seed your development database with real data ⚡️

    • Project mention: Replibyte: Database Backup/Anonimization Tool | news.ycombinator.com | 2024-05-29

  • paradedb

    Postgres for Search and Analytics

    • Project mention: Tantivy – full-text search engine library inspired by Apache Lucene | news.ycombinator.com | 2024-05-27

    Postgres's FTS is actually quite solid! You can get very far with just the built-in tsvector. The ranking could be improved, though, which was one of the reasons for creating pg_search in the first place: https://github.com/paradedb/paradedb/tree/dev/pg_search (disclaimer: I work on pg_search @ ParadeDB)

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

  • rust-postgres

    Native PostgreSQL driver for the Rust programming language

  • pgrx

    Build Postgres Extensions with Rust!

    • Project mention: Pg_lakehouse: Query Any Data Lake from Postgres | news.ycombinator.com | 2024-05-13

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

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

  • pgcat

    PostgreSQL pooler with sharding, load balancing and failover support.

    • Project mention: MySQL 8.2 Introduces Transparent Read/Write Splitting | news.ycombinator.com | 2023-12-17

    Not natively, no. You’d need to front it with something like PgCat [0].

    [0]: https://github.com/postgresml/pgcat

  • qsv

    CSVs sliced, diced & analyzed.

    • Project mention: Ask HN: How would you chunk a large Excel file? | news.ycombinator.com | 2024-05-26

    xsv is great. I quite like the fork called qsv as well; it has some features that were helpful to avoid some piping I didn't want to do. There are a lot of other additions. https://github.com/jqnatividad/qsv

  • martin

    Blazing fast and lightweight PostGIS, MBtiles and PMtiles tile server, tile generation, and mbtiles tooling.

    • Project mention: Martin: Generate and serve vector tiles on the fly from multiple tile sources | news.ycombinator.com | 2023-10-03

  • reshape

    An easy-to-use, zero-downtime schema migration tool for Postgres

    • Project mention: Show HN: Reshape – Zero-downtime schema migrations for Postgres | news.ycombinator.com | 2023-11-16

  • sea-query

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

  • SQLpage

    SQL-only webapp builder, empowering data analysts to build websites and applications quickly

    • Project mention: OAuth and OIDC Implementation in SQL | news.ycombinator.com | 2024-04-25

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

  • trieve

    All-in-one infrastructure for building search, recommendations, and RAG. Trieve combines search language models with tools for tuning ranking and relevance.

    • Project mention: Open-source Rust-based RAG | news.ycombinator.com | 2024-03-10

  • squawk

    🐘 linter for PostgreSQL, focused on migrations

    • Project mention: Squawk – A Linter for Postgres Migrations | news.ycombinator.com | 2024-04-30

  • pg_gpt

    Experimental extension that brings OpenAI API to your PostgreSQL to run queries in human language.

  • 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 Postgresql related posts

  • The evolution of Serverless Postgres

    1 project | dev.to | 30 May 2024

  • Pg_lakehouse: Query Any Data Lake from Postgres

    7 projects | news.ycombinator.com | 13 May 2024

  • How to ditch Neon

    2 projects | dev.to | 1 May 2024

  • Squawk – A Linter for Postgres Migrations

    1 project | news.ycombinator.com | 30 Apr 2024

  • Serverless Postgres with Neon - My first impression

    1 project | dev.to | 24 Apr 2024

  • Code Search Is Hard

    13 projects | news.ycombinator.com | 10 Apr 2024

  • Prolog language for PostgreSQL proof of concept

    7 projects | news.ycombinator.com | 30 Mar 2024
  • A note from our sponsor - InfluxDB
    www.influxdata.com | 2 Jun 2024
    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. Learn more →

Index

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

Project Stars
1 cube.js 17,265
2 neon 12,862
3 diesel 12,088
4 sqlx 12,064
5 hyperswitch 10,605
6 risingwave 6,422
7 materialize 5,614
8 Replibyte 4,025
9 paradedb 4,314
10 readyset 3,945
11 rust-postgres 3,329
12 pgrx 3,306
13 pg_graphql 2,787
14 pgcat 2,590
15 qsv 2,258
16 martin 1,935
17 reshape 1,672
18 sea-query 1,037
19 SQLpage 815
20 cornucopia 724
21 trieve 1,095
22 squawk 510
23 pg_gpt 456

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