resonate icon indicating copy to clipboard operation
resonate copied to clipboard

Alternate storage backends: MySQL and etcd-io/BBolt

Open huesflash opened this issue 1 year ago • 4 comments

Can and should resonate support MySql and BBolt (kv) storage backends ?

Apologies if this isn’t the right place to pose such questions. I’d be interested in implementing them.

huesflash avatar Oct 19 '23 13:10 huesflash

Alternate storages are definitely on the roadmap, including supporting key-value stores. Just out of curiosity, what would be the benefits for you of mysql over postgres?

dfarr avatar Oct 19 '23 15:10 dfarr

Just for coverage and I know MySQL has many fans :/ As for the KV, I like what restatedev is doing with their distributed workers that also act as stores for latency and durability reasons. Is a similar design being considered for resonate ?

huesflash avatar Oct 19 '23 16:10 huesflash

That's a really good question, @huesflash do you mind joining our community slack and we can talk more in depth? We are currently in the process of deciding and prioritizing features.

dfarr avatar Oct 23 '23 22:10 dfarr

I agree with you @huesflash on MySQL. It would be a great addition given its popularity.

dropping this to show anyone interested in contributing and helping us out where in the codebase we store our db implementations:

  • https://github.com/resonatehq/resonate/tree/53d377535e2dbe7f8e05915c092c65513c33ccab/internal/app/subsystems/aio/store.

Thanks!

guergabo avatar Nov 06 '23 02:11 guergabo

Hey, Can I work on this? If this is still open that. I can go through the code and then give my commitment if thats okay with you guys.

Madraceee avatar Oct 08 '24 16:10 Madraceee

Closing as won't do for the time being

dfarr avatar Nov 07 '24 18:11 dfarr