top | item 37067885

(no title)

thewix | 2 years ago

You get JSON types with postgres. If you aren't sharing data between tables then json is fine

discuss

order

nomel|2 years 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.

thewix|2 years ago

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.