← Tech Stack
PostgreSQL
An open-source relational database known for correctness, strong SQL support, and extensions.
Official site ↗PostgreSQL is the default database for most of what I build. It handles plain relational data, JSON documents, and time series well enough that a second database is rarely worth adding.
On my cluster it runs under CloudNativePG, which handles replicas, failover, and backups. The ferry-demo server stores every raw answer from WSF’s API in it, compressed as JSON, and derives everything else from those rows.