Hacker News Reader

would this work with a postgres hosted on supabase? for our company brain mcp thing we mirror postgres data (along with server logs, banking data, slack, etc) in clickhouse but took a very inefficient polling approach since it works with any read-only db connection string. always looking to improve that and get rid of latency though.

View on HN

WalShadow requires direct access to the physical WAL, and most managed Postgres providers don't allow that. It works with ClickHouse Managed Postgres or self-hosted Postgres. I talk about this in the blog:

Physical WAL is key to WalShadow’s architecture, but most managed Postgres services don’t expose it to customers, making it impossible to use WalShadow. ClickHouse Managed Postgres manages both sides of the stack, allowing us to integrate WalShadow directly into the Postgres replication layer and provide a native path from Postgres WAL to ClickHouse.

Not this quick but better then polling: https://supabase.com/features/supabase-pipelines

Reply on news.ycombinator.com