Comment by riku_iki
2 years ago
> There's very little reason to choose a DB other than postgres
Postgres is single server OLTP DB with complicated failover story, it is strong enough reason to consider some other contenders e.g. CocroachDB, SpannerDB for distributed OLTP or OLAP specialized ClickHouse, BigQuery, DuckDB.
Aren't most of those wire-compatible with Postgres?
query language likely not fully supported
Yes, all engines are unique. Still wire compatible and still SQL though.
1 reply →