Hi All, its my first time here in the Group,
I have question about replicating data into two different tables
Consider this example
I am getting some BookingData from one of the api as json => I am saving the data in the Table1 as
Id - Pk Bigint
UniqueID- unique string value
data - jsonb
these data I need to sent to other parties I can simply dump json and sent to others
Also once step completed I need these data need to be filtered from my UI application, which meanas i need to use normalized tables
Table2, Table3, Table4 with Pk-FK tables
question is it okay to write the data into diffrent places in tow different formats, so that my read or UI/API can be much easy to have complete filters
do I need to live with single table normalize all data, when you send again group together and sent to othres..
tell me whihc is option is good?
for me writing two places, so that UI/others can rely on the data..
select tbl1.*, array_agg(tbl2) from tbl1 left join tbl2 on tbl1.id = tbl2.tbl1_id group by tbl1.idcan be used to list all tbl1 items including all tbl2 items belonging to a tbl1 item