redisql icon indicating copy to clipboard operation
redisql copied to clipboard

[FEATURE REQUEST] Autosync

Open DGKSK8LIFE opened this issue 3 years ago • 17 comments

Could be implemented in a redis-native way with Redis pub/sub; not sure about MySQL

DGKSK8LIFE avatar Aug 15 '21 07:08 DGKSK8LIFE

@DGKSK8LIFE may i kow what are we wanting to do an Async of ?

ShlokMohanty avatar Oct 01 '21 02:10 ShlokMohanty

I basically want to find a way to do auto sync (meaning that, when a change happens in a SQL database, it is reflected in Redis automatically, sort of like an "event-driven" architecture), integrating into what I've already written (the internal Convert function here: https://github.com/DGKSK8LIFE/redisql/blob/master/utils/db.go).

DGKSK8LIFE avatar Oct 01 '21 02:10 DGKSK8LIFE

@DGKSK8LIFE ok got it can i take on this issue if y9ou could plz assign this task to me ?

ShlokMohanty avatar Oct 01 '21 04:10 ShlokMohanty

Sure, will assign others if they'd like to though.

DGKSK8LIFE avatar Oct 01 '21 04:10 DGKSK8LIFE

thank you @DGKSK8LIFE for assigning this issue to me .

ShlokMohanty avatar Oct 01 '21 10:10 ShlokMohanty

Any updates @ShlokMohanty? This doesn't necessarily have to be implemented in code, more of an architectural question (same for #28)

DGKSK8LIFE avatar Oct 03 '21 16:10 DGKSK8LIFE

yeah @DGKSK8LIFE i was looking at the redis document would be implementing it from tomorrow or day after tomorrow will it be fine for you ?

ShlokMohanty avatar Oct 03 '21 16:10 ShlokMohanty

No pressure @ShlokMohanty! Take as long as you need, just wondering if you had any ideas for a potential implementation; cause my ideas would perform badly if implemented.

DGKSK8LIFE avatar Oct 03 '21 16:10 DGKSK8LIFE

@DGKSK8LIFE could we use Mysql for the autosync ?

ShlokMohanty avatar Oct 05 '21 06:10 ShlokMohanty

if i get some resources like how to do it then I will surely inform you

ShlokMohanty avatar Oct 05 '21 06:10 ShlokMohanty

@ShlokMohanty It should support MySQL and Postgres; test with whatever u prefer.

DGKSK8LIFE avatar Oct 05 '21 08:10 DGKSK8LIFE

The internal Convert() function already supports Postgres and MySQL out of the box so autosync should be built on top of it

DGKSK8LIFE avatar Oct 05 '21 08:10 DGKSK8LIFE

ok sure then it would be great

ShlokMohanty avatar Oct 05 '21 09:10 ShlokMohanty

@DGKSK8LIFE sorry was a little busy this week but from now i would try to give you regular updates to keep you updated about the work .

ShlokMohanty avatar Oct 09 '21 10:10 ShlokMohanty

@ShlokMohanty No problem. Take all the time you need. Perhaps join the discord server so that we can communicate more about the autosync idea and implementation. Sorry, I haven't done the best job of explaining the codebase as it is currently.

DGKSK8LIFE avatar Oct 09 '21 11:10 DGKSK8LIFE

@DGKSK8LIFE can you share the discord link ?

ShlokMohanty avatar Oct 09 '21 13:10 ShlokMohanty

Yes @ShlokMohanty. It is also in the README https://discord.gg/RfZU9dp9ts

DGKSK8LIFE avatar Oct 09 '21 14:10 DGKSK8LIFE