Title
m
Mesh
02/07/2023, 11:31 AMYes they share, I wanted to try writing relationships using triggers
v
vroldanbet
02/07/2023, 11:44 AMIt would work, but the challenge here is that you are bypassing the API layer and all that comes with it (fundamentally data validation and the ORM logic). Particularly for postgres it would be very tricky to get the MVCC stuff right
so I don't think it would be advisable to go that route. But another thing you could explore is subscriptions: https://www.postgresql.org/docs/current/sql-createsubscription.html
you could create a program that subscribes to database changes on the main app tables, and then use the SpiceDB API to write them
I'm not sure 100% but that may be also what
zed experimental importwe also have this repository: https://github.com/authzed/connector-postgresql
yep indeed that's what the tool does: https://github.com/authzed/connector-postgresql/blob/5a22597732aeb79437fca3a55a1bb1412b5434f3/pkg/follow/follower.go#L62
so yeah zed import is for bulk importing (initial backfill), while the connector is for continuously propagate changes