Get the latest tech news

Two sizes fit most: PostgreSQL and ClickHouse


Relational databases are not in decline. Here's why.

The clickhouse developers wanted to have realtime analytics, but do so not with customized data structures, as is customary in this application domain, but instead with a generalized database engine queryable with SQL. Two years later, he published The end of an Architectural Era (It’s Time for a Complete Rewrite), where he argues that even for OLTP, the existing engines can be surpassed by more than a factor of ten. Nowadays, we can get single servers with tens of terabytes of memory configured for us at the click of a mouse (with a subsequent bill...), so the workloads we can keep in RAM are quite substantial.

Get the Android app

Or read this on Hacker News

Read more on:

Photo of PostgreSQL

PostgreSQL

Photo of sizes

sizes

Photo of ClickHouse

ClickHouse

Related news:

News photo

ClickHouse matches PG for single-row UPDATEs and 4000 x faster for bulk UPDATEs

News photo

System View for Inspecting DSM Registry Allocations in PostgreSQL

News photo

Postgres to ClickHouse: Data Modeling Tips