Hacker News new | ask | show | jobs
by c17r 2108 days ago
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?
1 comments

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.