Supabase Realtime and ETL both read database changes via logical replication but serve different purposes and delivery guarantees.
- •Realtime pushes database changes to client apps over WebSocket for live UI updates with best-effort delivery
- •ETL is a CDC pipeline delivering changes to analytical systems like BigQuery with at-least-once delivery guarantee
- •Realtime uses temporary replication slots with sequential processing and per-subscriber RLS authorization checks
- •ETL uses permanent replication slots and batches changes, prioritizing reliability over latency
- •Use Realtime for live features (chat, collaborative editing, dashboards) and ETL for analytics and data warehouse replication
This summary was automatically generated by AI based on the original article and may not be fully accurate.
Supabase
Databricks
Airbnb