Event Triggers / Zero Sync support
Is there any plan to add support for Event Triggers? I'm researching the viability of using Zero (https://zero.rocicorp.dev/) and it has a pretty significant caveat with Neon since Event Triggers are not supported. I was able to get it to work, but it requires a full rebuild when schema changes happen. Zero is looking extremely promising!
It looks like supabase will be looking to make it work well, but I would prefer to use Neon. https://x.com/kiwicopple/status/1874752935198179802
More info:
https://zero.rocicorp.dev/docs/connecting-to-postgres
Zero Docs
The official documentation for Zero by Rocicorp.
Paul Copplestone — e/postgres (@kiwicopple) on X
@axlrck @supabase @stolinski i don't think we'll have it "built in" but we'll definitely work with @aboodman to make it seamless 👍
X
Zero Docs
The official documentation for Zero by Rocicorp.
2 Replies
sensitive-blue•8mo ago
We're in touch with the zero team. Triggers is something we plan on supporting https://github.com/neondatabase/neon/issues/7570
GitHub
Epic: Support Postgres event triggers · Issue #7570 · neondatabase/...
Add support for event triggers to capture DDL events: https://www.postgresql.org/docs/current/event-triggers.html We currently do not support event triggers due to the superuser requirement. Relate...
rival-blackOP•8mo ago
Awesome! That is great to hear!