Better JSON in Postgres with PostgreSQL 14 ↦
Craig Kerstiens:
Postgres has had “JSON” support for nearly 10 years now. I put
JSON
in quotes because well, 10 years ago when we announced JSON support we kinda cheated. We validated JSON was valid and then put it into a standard text field. Two years later in 2014 with Postgres 9.4 we got more proper JSON support with theJSONB
datatype. My colleague @will likes to state that the B stands for better. In Postgres 14, the JSONB support is indeed getting way better.
A small but solid improvement to how you query JSONB
, making it more JSON
-y than ever.
Discussion
Sign in or Join to comment or subscribe