Examples of CDC into SpiceDB?
# spicedb
r
Hello! I'm very interested in replacing our jank, slow auth/permission system with SpiceDB. How do folks get data into SpiceDB and keep it in sync? I can kind of picture some possibilities where we use CDC to monitor our entities changes, and push relevant changes into SpiceDB. Has anyone used Debezium or some kind of CDC system for this purpose? I've dug through the awesome list. Keycloak-spicedb-eventlistener seems to tackle this general problems of syncing data in; it leverages event emitters baked into Keycloak which our boutique systems don't have. Using CDC tools like Debezium has a high appeal here for letting us layer in these sync concerns without having to re-instrumemt our own code. I'd love if anyone had wisdom or experience or thoughts or links to share around this topic, to help illuminate the path some. 🔦 Thanks, best wishes!
y
we're currently using kafka consumers to write relationships to SpiceDB and it seems to be working pretty well
there aren't any existing connectors that i know of, official or otherwise
so you'd have to write your own logic
and depending on which relationships you're writing and how, you may end up with the New Enemy problem due to not being able to associate zed tokens with writes, but depending on your domain that may be fine
j
@rektide what is your source DB?
r
We have a mix of MySQL and postgresql systems. We could probably get by with just MySQL support for a while, it has most entities. (Albeit longer term there is some interest in moving most of our data to postgres.) @Joey
j
the recommendation today is what @yetitwo suggested
we did prototype something for Postgres: https://github.com/authzed/connector-postgresql
but there didn't seem to be a lot of community interest
19 Views