In terms of performance and good practice, is it better to create a new row for every new json object or just append objects to an json object array all within one row? I'm building a NodeJS application that will let the user create, read, update and delete data from the json objects.
Also, how would you go about appending a new object to a specific json object array in NodeJS and PostgresQL? I couldn't find any examples online. What is the insert command to do it for this example where the table name is "myData", "data" is the column name and I want to insert 5 into "b":
data
{"a": 1, "b": [1, 2, 3]}