← 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.