3 ms·
You get JSON types with postgres. If you aren't sharing data between tables then json is fine
by thewix 3y ago
You get JSON types with postgres. If you aren't sharing data between tables then json is fine
- nomel 3y agoYou 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 3y agoSorry, 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.