Between episodes, here's something lighter. Still useful. Still PostgreSQL. You've used PostgreSQL for years. SELECT, INSERT, JOIN, INDEX. Maybe you've partitioned a table or two. But PostgreSQL has been quietly shipping features that most engineers never discover until they're deep in a Stack Overflow thread at 2 AM. Here are 10 you'll wish you'd known earlier. 1. LISTEN/NOTIFY — Real-time pub/sub built into your database. No Kafka, no Redis, no external message broker. PostgreSQL can push notifications to connected clients. -- Terminal 1 LISTEN order_updates ; -- Terminal 2 NOTIFY order_updates , '{"order_id": 12345, "status": "shipped"}' ; Enter fullscreen mode Exit fullscreen mode Terminal 1 receives the payload instantly. Use it for cache invalidation, real-time dashboards, or lightweight event-driven workflows. It doesn't persist messages or guarantee delivery after disconnect, so it won't replace Kafka. But for "hey, this row changed, go refresh your cache" — it's perfect. 2.…