You Can Make Postgres Scale

1. pg_query.rs

   1 1 173 5.8 Rust

   Parse, deparse and normalize SQL queries using the Postgres source code

   

   We use the Postgres parser directly, thanks to the great work of pg_query [1].

   [1] https://github.com/pganalyze/pg_query.rs

2. InfluxDB

   influxdata.com featured

   InfluxDB high-performance time series database. Collect, organize, and act on massive volumes of high-resolution data to power real-time intelligent systems.

   

3. Shrine

   2 9 3,204 5.2 Ruby

   File Attachment toolkit for Ruby applications

   

   https://github.com/shrinerb/shrine/discussions/665

   I've never personally encountered this, but I've seen other HN contributors mention it.

   From what I can tell, unlike mongo, some postgres queries will try to update the entire JSONB data object vs a single field. This can lead to race conditions.

4. vitess

   3 63 19,502 9.9 Go

   Vitess is a database clustering system for horizontal scaling of MySQL.

   

   Apart from being backed by Postgres instead of MySQL, is this different from Vitess (and its commercial vendor PlanetScale)?

   https://vitess.io/

5. FerretDB

   4 48 10,059 9.6 Go

   A truly Open Source MongoDB alternative

   

6. pgdog

   5 8 1,039 9.7 Rust

   Horizontal scaling for PostgreSQL with automatic sharding.

   

   I ended up adding support for GROUP BY: https://github.com/pgdogdev/pgdog/pull/43

   I had it in the back of my mind for a while, nice to have it in code. Works pretty well, as long as columns in GROUP BY are present in the result set. Otherwise, we would need to rewrite the query to include them, and remove them once we're done.

7. CodeRabbit

   coderabbit.ai featured

   CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

   

Suggest a related project