Hacker News new | ask | show | jobs
by thewix 1043 days ago
You get JSON types with postgres. If you aren't sharing data between tables then json is fine
1 comments

You get JSONB with postgres, which, to me, is a significant difference. This means you can indexing by key/value, access keys directly, without parsing the whole json string, etc.

For my use case, JSONB support completely killed most NoSQL solutions.

Sorry, I should have said JSONB. Do you still consider a table with a single JSONB column SQL or NoSQL? Sure, it may be contained within a RDBMS but you are treating it more like a document store than a relationship database.