Very nice! Data wants to be free. Please check out this rosettable thing we open-sourced last year, it could come in handy: it allows real time ETL-like sync between mysql and postgres. https://github.com/francoisp/rosettable I've implemented the struts of a framework built around rosettable, with mautic <-> davical as a proof of concept, it keeps a user defined map (one to one, many to one, one to many and many to many) in sync, live, both ways, surviving restarts even if there's been divergent edits on both sides while offline.

I havent released this as OS yet, but I'll put a demo online shortly.

For datalakes, I've also implemented something that could be useful: check out duplexRsync: https://github.com/francoisp/duplexRsync. I'll try to reach out via email to make sure you guys see this.

cheers! best, F