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