Just Use Postgres for Everything

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
  • postgrest

    REST API for any Postgres database

    I love postgres for most things but these days (Especially while my product is in development, embedded, or just not internet-facing) sqlite is amazingly workable.

    Killer postgres features however: Row-level security (Amazing when you're using something like postgrest for rapid application development [1]), and its built in fulltext search engine is 'good enough' for use cases like when you have an enormous users table and need to index something simple enough, like email addresses for quick login.

    [1] https://postgrest.org/

  • pg_auto_failover

    Postgres extension and service for automated failover and high-availability

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

  • ApacheKafka

    A curated re-sources list for awesome Apache Kafka

    Messaging is the first use-case given by the Kafka docs [1] and is the first core capability they mention on the Kafka landing page [2].

    1. https://kafka.apache.org/documentation/#uses_messaging

    2. https://kafka.apache.org/

    I think use (and think of) Kafka as a message bus, with distributed commit logging being the mechanism for how it accomplishes that task.

  • postgres-operator

    Postgres operator creates and manages PostgreSQL clusters running in Kubernetes

    My favorite route right now is running a postgres operator on Kubernetes & letting it do all the work for me.

    Zalando's operator use Patroni under the hood, to create a cluster over streaming replication. It also has Spilo, which orchestrates pg_basebackup or WAL-E for point-in-time backup. https://github.com/zalando/postgres-operator#postgresql-feat...

    CrunchyData operator seems to have built their own streaming replication system coordinated by Raft. https://access.crunchydata.com/documentation/postgres-operat...

  • citus

    Distributed PostgreSQL as an extension

    As always: it depends. For some workloads something like Citus [1] might allow you stay within the PostgreSQL ecosystem even when you are trying to do OLAP.

    [1] https://github.com/citusdata/citus

  • galera

    Synchronous multi-master replication library

  • talk

    Talks on PostgreSQL, Go and YACC (by jmscott)

    postgresql handles queues well. the trick is skip lock.


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

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts