Forget SQL vs. NoSQL – Get the Best of Both Worlds with JSON in PostgreSQL

PinkPigeon · on June 3, 2021

While this is definitely a high-effort post, with a lot of useful information, it's sort of missing a huge change that's about to happen with JSON in Postgres 14:

  SELECT *
  FROM shirts 
  WHERE details['attributes']['color'] = '"neon yellow"'
    AND details['attributes']['size'] = '"medium"'

Which is in fact making me wonder whether I should change my entire system from file-based JSON to DB-based JSON, which would no-doubt speed everything up by orders of magnitude.

More info: https://blog.crunchydata.com/blog/better-json-in-postgres-wi...