PostgreSQL: json, jsonb support

I follow, and use the pydal, and web2py projects quite closely. I like the way these projects are engineered, and the community around them.

One of the discussion points that came up was around the wonderful support for JSON, and JSONB in PostgreSQL. As part of that discussion, I started jotting down some points on the differences between the vanilla JSON, and PostgreSQL supported JSONB. These differences are described in the PostgreSQL documentation. I included the “implications” column, below. Continue reading “PostgreSQL: json, jsonb support”