# How Supabase Rebuilt Postgres for Real-Time Apps

Page: https://stenobird.com/podcast/the-cto-podcast-with-fexingo-technical-leadership-architecture-and-engineering-org-7871807/how-supabase-rebuilt-postgres-for-real-time-apps
Text version: https://stenobird.com/podcast/the-cto-podcast-with-fexingo-technical-leadership-architecture-and-engineering-org-7871807/how-supabase-rebuilt-postgres-for-real-time-apps.md
Podcast: [The CTO Podcast with Fexingo: Technical Leadership, Architecture, and Engineering Org](https://stenobird.com/podcast/the-cto-podcast-with-fexingo-technical-leadership-architecture-and-engineering-org-7871807)
Published: 2026-06-15T07:11:18+00:00
Episode link: https://audio.fexingo.com/business/the-cto-podcast/episode-0052.mp3
Audio file: https://audio.fexingo.com/business/the-cto-podcast/episode-0052.mp3
Processing state: not_requested
JSON: https://stenobird.com/v1/public/podcasts/the-cto-podcast-with-fexingo-technical-leadership-architecture-and-engineering-org-7871807/episodes/how-supabase-rebuilt-postgres-for-real-time-apps
Duration seconds: 634

## Resource

In this episode, Lucas and Luna explore how Supabase, an open-source Firebase alternative, built a real-time layer on top of PostgreSQL that handles millions of concurrent WebSocket connections. They break down the architecture behind Supabase's Realtime server, which uses PostgreSQL's logical replication and Elixir's BEAM VM to stream database changes to client applications with sub-second latency. Lucas explains why the team chose to fork PostgreSQL's replication slot mechanism and how they handle backpressure when clients fall behind. Luna questions the trade-offs of using WebSockets versus server-sent events for real-time data synchronization. The conversation also touches on Supabase's decision to build on AWS's Graviton processors to reduce costs and how the company scaled from zero to over 200,000 users without a dedicated infrastructure team. If you're building a real-time application or just curious about modern database architecture, this episode offers concrete insights into one of the most exciting open-source projects in the cloud space. #Supabase #PostgreSQL #RealTime #WebSockets #Elixir #BEAM #Database #Backend #Architecture #OpenSource #FirebaseAlternative #LogicalReplication #AWS #Graviton #Scalability #BusinessAndTechnology #FexingoBusiness #BusinessPodcast Keep every episode free: buymeacoffee.com/fexingo

## Actions

- request_transcript: `POST https://stenobird.com/v1/public/podcasts/the-cto-podcast-with-fexingo-technical-leadership-architecture-and-engineering-org-7871807/episodes/how-supabase-rebuilt-postgres-for-real-time-apps/transcription-requests` — Idempotently request low-priority transcript generation for this episode.
- read_markdown: `GET https://stenobird.com/podcast/the-cto-podcast-with-fexingo-technical-leadership-architecture-and-engineering-org-7871807/how-supabase-rebuilt-postgres-for-real-time-apps.md` — Read the agent-friendly Markdown representation of this episode resource.

A page view does not enqueue transcription. Agents should invoke `request_transcript` explicitly when they need this episode processed.

## Transcript

Full transcripts are not published on public pages unless there is a clear rights basis.