Yes they share, I wanted to try writing relationsh...
# spicedbm
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
vroldanbet
02/07/2023, 11:50 AMso 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
vroldanbet
02/07/2023, 11:50 AMyou could create a program that subscribes to database changes on the main app tables, and then use the SpiceDB API to write them
vroldanbet
02/07/2023, 11:51 AMI'm not sure 100% but that may be also what
zed experimental importvroldanbet
02/07/2023, 11:57 AMwe also have this repository: https://github.com/authzed/connector-postgresql
vroldanbet
02/07/2023, 12:13 PMyep indeed that's what the tool does: https://github.com/authzed/connector-postgresql/blob/5a22597732aeb79437fca3a55a1bb1412b5434f3/pkg/follow/follower.go#L62
vroldanbet
02/07/2023, 12:15 PMso yeah zed import is for bulk importing (initial backfill), while the connector is for continuously propagate changes
3 Views