> TL;DR. My uptime monitor keeps config and incidents in Postgres and check results in ClickHouse. The split is one rule: does a row ever change? Config gets edited, so it wants Postgres transactions and constraints. A check result is written once an...

At https://pterocos.eu.org/...

Let's be honest, the Apple Watch stopped being “just a watch” a long time ago. At this point, it has morphed into a medical device that measures the vital signs and also keeps track of time and helps users pay for their oat milk matcha latte. But App...

I built two systems that both needed event tracking. I used PostgreSQL in one and MongoDB in the other. Here's exactly why — and what I learned from doing both. Although the two systems were completely different in purpose, they shared one architectu...