All you need is PostgreSQL

53 points by schonfinkel

peter-leonov

…and ClickHouse.

seabre

Yeah. ClickHouse has turned into the thing I reach for when I need OLAP.
veqq

Why so? I know nothing about it.
- Verfeuil
  I use Clickhouse at work. It's very nice for handling large amount of data (i have hundred of billions of lines and i can query them in minutes to find patterns on hardware from 2012), but what i really like are :
  
  TTLs (you can auto expire rows, columns, in a dynamic way)
  
  Materialized view, both refreshable and classic  (you can transform data automatically, and deserialize json / do join when some data is inserted in a given table, and the data is appended to another table)
  
  The fact you can query URLs (e.g. csv files) and populate a table on a schedule
  
  Compression you can change, and choose the best compression for the task at hand
b--man

only if you need ad hoc analytical queries. And even then, do try duckdb first.
dark_grimoire

Technically you also have TimescaleDB?

peter-leonov

stored_procedures_everywhere.gif

On the serious note, I expected to learn how Postgres' rich type set allows to store almost anything, or how its locking primitives remove the need in external lock system coordination, or how different isolation levels cover for a spectrum of concurrency heavy apps, or how to design and tune a table to allow cheap write heavy storage, or how Postgres CDC plugins enable transparent heterogeneous replication, or how embedded scripting allows to pull the client-server app inside out where latency is critical, or how… stop-token.

andersmurphy

There's only one correct isolation level.

tomjakubowski

That OLAP approach is pretty interesting. Basically you materialize the ledger sums the application needs ahead of time with triggers. One nice thing about an OLAP database (or something like DuckDB querying parquets) is you can run whatever stats you want on your data columns, relatively quickly, without needing to anticipate what intermediate data you'll need to compute it. This flexibility is valuable for business reporting and other analytical purposes.

b--man

ad hoc analytical queries is one of the few places where I advise people to reach for something else. And that would be DuckDB.