Video Conferencing with Postgres
Summary
PlanetScale demonstrates running a live video chat workflow on Postgres by streaming JPEG frames and PCM audio through a WebSocket relay into a logical replication stream. The setup uses a 640x360 15fps pipeline with frames stored in video_frames and audio_frames, backed by WAL, and discusses trade-offs with alternatives like LISTEN/NOTIFY and unlogged tables. The piece concludes with 'Should you do this? No—use WebRTC,' but offers a compelling look at Postgres as a real-time backend and performance considerations.