We built a real-time server to solve this using Postgres Write Ahead Log: https://github.com/supabase/realtime https://github.com/supabase/realtime. We also hav

We built a real-time server to solve this using Postgres Write Ahead Log: https://github.com/supabase/realtime https://github.com/supabase/realtime. We also have some neat stuff coming with integrated Row Level Security. Disclosure (Supabase cofounder)