On 21/05/20, Michael Stephenson (domehead100@xxxxxxxxx) wrote: > On Thu, May 21, 2020 at 10:36 AM Rory Campbell-Lange wrote > > Presently I've been thinking of using triggers or materialized views in > > each database to materialise data into a "matview" schema which is then > > shipped via logical replication to an organisation database when > > required. New columns in the matview schema tables would ensure replica > > identity uniqueness and allow the data to be safely stored in common > > tables in the organisation database. > You might find Materialize interesting: > > https://materialize.io/ Hi Michael. Thanks for the pointer. Materialize.io seems cool but we don't deal with streaming data, or am I missing something? Cheers Rory
