Replacing Kafka and its whole ecosystem with one Postgres, an object storage bucket, and DuckDB.

Hello friends! Today’s post is going to be about window functions (specifically with Postgres).

Here’s the docs and tutorial. Give them a read. Like most Postgres docs, they’re quite good.

TimescaleDB. Is. Dope.

Back in the bad ol’ days when I worked on transient astronomy, all my timeseries data fit in memory. I’d store it in a CSV and not give it a second thought. But if you want to build a web application that leverages timeseries data, that won’t fly. You might think “I can’t store my timeseries data in a relational database, I need to stand up a whole new database for my timeseries stuff and I need to learn a whole new tsdb system and blah blah blah…”