JSON and Postgresql

Post tags: | json | jsonb | postgresql |

JSONB and PostgreSQL: Work Faster By Ditching Migrations rob.conery.io article

What’s different in JSONB?

Is PostgreSQL Your Next JSON Database? compose.io/article

Well, with JSONB it turns the JSON document into a hierarchy of key/value data pairs. All the white space is discarded, only the last value in a set of duplicate keys is used and the order of keys is lost to the structure dictated by the hashes in which they are stored. If we make a JSONB version of the table we just created, insert some data and look at it:

Peter Geoghegan - What I think of jsonb

pgeoghegan.blogspot article

Jsonb is a new datatype for Postgres. It is distinct from the older json datatype in that its internal representation is binary, and in that it is internally typed. It also makes sophisticated nested predicates within queries on jsonb indexable.