Rust Postgresql

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

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, branching, and bottomless storage.

    • Project mention: Serverless Postgres with Neon - My first impression | dev.to | 2024-04-24

    Such is the case with Neon, a serverless Postgres service, that went generally available on April 15. Congrats Nikita Shamgunov and team on the launch. When I saw the announcement, I knew I had to try it out for myself and report back with my findings.

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

  • 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

    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

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

  • 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

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

    • Project mention: PostgresML | /r/programming | 2023-08-30

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

  • paradedb

    Postgres for Search and Analytics

    • Project mention: Using ClickHouse to scale an events engine | news.ycombinator.com | 2024-04-11

  • rust-postgres

    Native PostgreSQL driver for the Rust programming language

  • pgrx

    Build Postgres Extensions with Rust!

    • Project mention: Building a Managed Postgres Service in Rust | news.ycombinator.com | 2024-04-08

    Consider also the companies and work behind pgrx [0] and pgzx [1]:

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

    [1] https://github.com/xataio/pgzx

  • 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: Qsv: Efficient CSV CLI Toolkit | news.ycombinator.com | 2023-12-22

    Thanks for the detailed feedback @snidane!

    As maintainer of qsv, here's my reply:

    - Given qsv's rapid release cycle (173 releases over three years), the auto-update check is essential at the moment. Once we reach 1.0, I'll turn it off. For now, given your feedback, I've only made it check 10% of the time.

    - Pivot is in the backlog and I'll be sure to add unpivot when I implement it. (https://github.com/jqnatividad/qsv/issues/799)

    - I'll add a dedicated summing command with the group by (-by) and window by (-over) capability (https://github.com/jqnatividad/qsv/issues/1514). Do note that `stats` has basic sum as @ezequiel-garzon pointed out.

    - With the `enum` command, qsv can achieve what you proposed with `laminate`. E.g. qsv enum --new-column newcol --constant newconstant mydata.csv --output laminated-data.csv

    - With the cat rowskey command, qsv can already concatenate files with mismatched headers.

    - other file formats. qsv supports parquet, csv, tsv, excel, ods, datapackage, sqlite and more (see https://github.com/jqnatividad/qsv/tree/master#file-formats). Fixed-format though is not supported yet and quite interesting, and have added it to the backlog (https://github.com/jqnatividad/qsv/issues/1515)

    - as to "enable embedding outputs of commands", qsv is composable by design, so you can use standard stdin/stdout redirection/piping techniques to have it work with other CLI tools like jq, awk, etc.

    Finally, just released v0.120.0 that already incorporates the less aggressive self-update check. https://github.com/jqnatividad/qsv/releases/tag/0.120.0

  • 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: SQLite Schema Diagram Generator | news.ycombinator.com | 2024-03-23

  • 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

  • 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

Index

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

Project Stars
1 cube.js 17,135
2 neon 12,186
3 diesel 11,904
4 sqlx 11,742
5 hyperswitch 10,300
6 risingwave 6,283
7 materialize 5,567
8 postgresml 5,430
9 Replibyte 3,990
10 readyset 3,867
11 paradedb 3,803
12 rust-postgres 3,281
13 pgrx 3,221
14 pg_graphql 2,765
15 pgcat 2,528
16 qsv 2,214
17 martin 1,873
18 reshape 1,621
19 sea-query 1,008
20 SQLpage 777
21 cornucopia 686
22 trieve 624
23 pg_gpt 456

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