Show HN: Real-time app starter with FastAPI, PostgreSQL pub/sub, and UV https://ift.tt/xzEfXFy

Show HN: Real-time app starter with FastAPI, PostgreSQL pub/sub, and UV 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://ift.tt/BHhD2t9 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. October 3, 2025 at 08:12AM