[tarkin2]

JSONB objects with SQL relations in Postgresql is my happy-medium between the joy of schema-less JSON and the reassurance of SQL relations.

[c17r]

Would you explain a little more? I'm intrigued. Are you saying SQL relations between fields inside JSONB columns between tables? A field in the JSONB column has foreign key to another table? And you can do a join?

[tarkin2]

You can do both. You can make relations between jsonb fields.

Or, as I do: have a jsonb blob in one column, and a normal sql field in another, and do the sql joins with that.

So I have some data fields as sql columns, and some as jsonb properties.