Show HN: Real-time app starter with FastAPI, PostgreSQL pub/sub, and UV

1 month ago 6

Starter template for real-time web apps using modern Python/JS tooling and PostgreSQL's LISTEN/NOTIFY instead of external message queues.

Stack: - UV (Python package manager - incredibly fast) - FastAPI with full async/await - PostgreSQL triggers + LISTEN/NOTIFY for pub/sub - Bun for frontend builds - Proper connection pooling and lifecycle management

GitHub: https://github.com/garage44/plank

This came from rebuilding the same pattern across projects. Most examples I found were toy demos that didn't handle reconnection, dead clients, or proper shutdown.

Includes working frontend example that updates in real-time when database changes. Docker Compose setup for testing.

Good for: admin dashboards, monitoring tools, collaborative apps where you just need current state pushed immediately. Not for: guaranteed message delivery or job queues.

Read Entire Article