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 the JSONB datatype. My colleague @will likes to state that the B stands for better. In Postgres 14, the JSONB support is indeed getting way better. I’ll get into this small but pretty incredible change in Postgres 14 in just a minute, first though it is worth some summary disclaimer on the difference between JSON and JSONB. JSON still exists…
External feed Read More at the Source: https://postgr.es/p/55g




CHICAGO—Excited about his final opportunity to make friends as an adult before surrendering to a life of solitude, local man Josh Kelly reported Friday that the adult kickball he joined would be a great way to meet other people who are entirely out of options. “It feels good to do something different and meet some…
From: Instagram <no-reply@mail.instagram.com>