Some opinionated thoughts on SQL databases

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

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.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  • citus

    Distributed PostgreSQL as an extension

  • This depends what you mean by "scaling". Postgres can easily handle 10s of Terabytes on a single server (though this is dependent upon your use case), but when it comes to multiple host sharded databases at the moment MySQL has some more mature options like Vitess [1], where your options in Postgres are things like Citus [2] which just recently open sourced their shard mover, but still have the HA and replication feature behind expensive enterprise pricing.

    For most people not dealing with the multiple terabyte database size, Postgres is what I would definitely recommend. But once you get above that, then there are no easy answers and you would need to look at what YouTube did with Vitess [3]

    [1] https://vitess.io/

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

    [3] https://vitess.io/docs/overview/history/

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

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

  • This depends what you mean by "scaling". Postgres can easily handle 10s of Terabytes on a single server (though this is dependent upon your use case), but when it comes to multiple host sharded databases at the moment MySQL has some more mature options like Vitess [1], where your options in Postgres are things like Citus [2] which just recently open sourced their shard mover, but still have the HA and replication feature behind expensive enterprise pricing.

    For most people not dealing with the multiple terabyte database size, Postgres is what I would definitely recommend. But once you get above that, then there are no easy answers and you would need to look at what YouTube did with Vitess [3]

    [1] https://vitess.io/

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

    [3] https://vitess.io/docs/overview/history/

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

  • Vitess 18

    2 projects | news.ycombinator.com | 7 Nov 2023
  • Using Postgres as a Data Warehouse

    3 projects | /r/dataengineering | 11 May 2021
  • The challenges of supporting foreign key constraints

    1 project | news.ycombinator.com | 5 Dec 2023
  • What is the best database technology to use to create a new chat app today?

    1 project | /r/Database | 20 Jun 2023
  • Vitess – Scalable. Reliable. MySQL-Compatible. Cloud-Native. Database

    1 project | news.ycombinator.com | 7 Jun 2023