Hacker News new | ask | show | jobs
by nomel 1043 days ago
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.

1 comments

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.