Transforming tables data into Jsons - what DB u choose for such task?

I have specific requirement for Json structures, meaning i get the structure (complex) one , I build from existing tables the data i need for that json and now "only" thing left is transform that to a spepcifc Json structure.

The Volume is meaningful (can be million of Json based on much more of relational data).

I'm aware for how to build the Json by the tables relation for build a Json with sub elements as list/dict . till now , I had Oracle DB and use create dynamically the query for generating the Json i needed. it work perfectly i could create ANY json in any format .

Now there's decision for open source DB only .

I start review the options , like Cassandra - where it seems not really good choice as it quite challenging to handle those UDT which used for building a json , PostgresQL - it seems the obvious choice but I guess maybe there's some other DB will provide better porting table to json more easily (i need it be flexible enough so i could structure any Json). any recommendation for DB /approach /suggestions are highly welcome.

https://stackoverflow.com/questions/67351210/transforming-tables-data-into-jsons-what-db-u-choose-for-such-task May 02, 2021 at 05:59AM