PostgreSQL Is Enough

1. walex

   1 19 307 7.4 Elixir

   Postgres change events (CDC) in Elixir

   

   Yep, I should add that. One of the libraries in my list is WalEx: https://github.com/cpursley/walex/issues

   It subscribes to the Postgres WAL and let you do the same sort of thing you can do with listen/notify, but without the drawbacks like need for triggers or character limits.

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

   2 3 2,639 0.0 C

   High-performance time-series aggregation for PostgreSQL

   

4. Logflare

   3 12 868 9.5 Elixir

   Never get surprised by a logging bill again. Centralized structured logging for Cloudflare, Vercel, Elixir and Javascript.

   

   btw recently cleaned up my wal cache busting code quite a bit if you're interested.

   https://github.com/Logflare/logflare/blob/main/lib/logflare/...

   Need to make a lib out of this!!

5. citus

   4 71 11,268 9.3 C

   Distributed PostgreSQL as an extension

   

   It is possible, if you pay for it. You can do Multi-AZ Clustered Instances in RDS, where you get the benefits of Multi-AZ failover with traffic sharing.

   If you can run your own infra – at least on an EC2 level – you can do things like Citus [0] for Postgres, which is about as close to "just add database nodes" as you'll get.

   [0]: https://www.citusdata.com/

6. bytebase

   5 43 12,275 10.0 Go

   World's most advanced database DevSecOps solution for Developer, Security, DBA and Platform Engineering teams. The GitHub/GitLab for database DevSecOps.

   

   Migrations. All my database logic lives in version control.

   Popular tooling like Phoenix, Hasura, etc have good built in migration stories.

   https://www.bytebase.com looks really promising.

   Hover, I do struggle with one big issue: changing database logic (views, functions, etc) that has other logic dependent on it. This seems like a solvable problem.

7. supavisor

   6 16 1,888 9.3 Elixir

   A cloud-native, multi-tenant Postgres connection pooler.

   

   WalEx instead of pub/sub (listen/subscribe): https://github.com/cpursley/walex

   Supavisor connection pooler: https://github.com/supabase/supavisor

8. pgsql-http

   7 19 1,411 8.1 C

   HTTP client for PostgreSQL, retrieve a web page from inside the database.

   

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

   

10. pg_net

    8 5 286 7.8 C

    A PostgreSQL extension that enables asynchronous (non-blocking) HTTP/HTTPS requests with SQL

    

11. Flyway

    9 85 8,675 7.8 Java

    Flyway by Redgate • Database Migrations Made Easy.

    

    There is a bit of tooling needed but is already around. For Java for example I had very good experience with a combination of flyway [1] for migrations, testcontainers [2] for making integration tests as easy as unit tests and querydsl [3] for a query and mapping layer.

    [1] https://github.com/flyway/flyway

    [2] https://java.testcontainers.org/modules/databases/postgres/

    [3] https://github.com/querydsl/querydsl

12. Querydsl

    10 7 4,850 0.0 Java

    Unified Queries for Java

    

    There is a bit of tooling needed but is already around. For Java for example I had very good experience with a combination of flyway [1] for migrations, testcontainers [2] for making integration tests as easy as unit tests and querydsl [3] for a query and mapping layer.

    [1] https://github.com/flyway/flyway

    [2] https://java.testcontainers.org/modules/databases/postgres/

    [3] https://github.com/querydsl/querydsl

Suggest a related project