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

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, a real-time queue management platform, I came across a backend problem that looked simple at first: > A customer reaches the front of the queue, and the system needs to send notifications to other customers. The first ins...

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