News for hackers. Stuff that matters.
Re:For Want of a JOIN by kgeist on Thursday December 22, 2022 @01:45PM (#34096842)
>How does one JOIN across not just tables but opaque services

One solution we use is to have an event queue from service A to which service B is subscribed. In the event handler, service B fills its own view table with data from service A. And then it can do joins on data from multiple services because everything is in the same DB. We require services to always emit "created" and "updated" events for its objects.

There are no comments on this comment yet.