Video Conferencing with Postgres

This post demonstrates using PostgreSQL's logical replication to stream real-time data (video frames and audio) for a video conferencing application. It details the implementation using a SvelteKit frontend, a Node.js WebSocket relay, and PlanetScale PostgreSQL. Key technical contributions include: using `INSERT` statements to store media frames in `video_frames` and `audio_frames` tables, leveraging logical replication to stream these frames to recipients, implementing a cleanup job to prune old frames, and addressing audio synchronization issues with clamping. It also contrasts this approach with `LISTEN/NOTIFY` and unlogged tables, highlighting the trade-offs.