Cdc feature request

[gedw99]

Been using bum and love the good old sql first approach .

I was wondering if CDC would be possible . Change Data Capture.

i found postresql and SQLite cdc golang implementations and have been using them and they are independent of bun but it would be cool if bun make it a first clsss citizen so to speak.

Uses cases galore:

• clustering your db and keeping them in sync
• Real time services and gui updates, so that stake data is never sent to the db.
• Workflows Diven by data itself.

there are 2 questions that come up:

• need a proxy in front of the db to send mutations o the master db and reads to the read slave
• Need a transport for the cdc change events.

I and others are using NATS so do this .

marmot is a decent example to get a feeling of nats for cdc off a SQLite db .

https://github.com/maxpert/marmot

[gedw99]

Hooks are not quite the same but similar.

https://bun.uptrace.dev/guide/hooks.html

I prefer cdc as it’s much more powerful and can work synergistic with hooks. Hooks fired off the cdc architecture and so you get scale out for free. Only one hook will fire on a cluster with nats , which is what you want .

[github-actions[bot]]

This issue has been automatically marked as stale because it has not had activity in the last 30 days. If there is no update within the next 7 days, this issue will be closed.