> Werbung / Disclosure: Prisma gave me a coupon for two months of a paid plan for free and said it will add free credits, so I could try Prisma Postgreshttps://www.prisma.io/postgres and Compute for this project. All results below come from my own ru...

While testing a reconnect system for a deliverer-facing WebSocket gateway: when someone reconnects after losing their connection, they should get a snapshot of their current job plus any events they missed while offline. Two pieces, both of which I w...

I was fixing a real bug in a delivery backend I'm building: a customer's order could get created in Postgres even when something downstream failed, leaving an order with no event history behind it. The fix looked simple. Wrap the whole thing in pris...

I was fixing a real bug in a delivery backend I'm building: a customer's order could get created in Postgres even when something downstream failed, leaving an order with no event history behind it. The fix looked simple. Wrap the whole thing in pris...

I was fixing a real bug in a delivery backend I'm building: a customer's order could get created in Postgres even when something downstream failed, leaving an order with no event history behind it. The fix looked simple. Wrap the whole thing in pris...

While working on Waitless, I needed customers to be able to track their position in a queue and leave the queue without creating an account. That led to a small but interesting security design question: > How can I authorize an anonymous user witho...

While working on Waitless, I needed customers to be able to track their position in a queue and leave the queue without creating an account. That led to a small but interesting security design question: > How can I authorize an anonymous user witho...

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