PostgreSQL 18 adds a new parameter to json{b}_strip_nulls functions to also remove null elements from arrays, enhancing JSON data cleaning.
A collection of lesser-known but powerful PostgreSQL features and tips shared by the developer community, from data types to performance tricks.
An updated overview of PostgreSQL's key features and improvements from the last 5 years, including JSONB, extensions, and logical replication.
A guide to using the JSONB data type in PostgreSQL, covering indexing, querying, and practical examples for storing and searching JSON data.
A guide to lesser-known but useful PostgreSQL features, including psql tips, query watching, and JSONB formatting.
A hands-on tutorial demonstrating how to use PostgreSQL's JSONB feature as a NoSQL document store with the MassiveJS library in a Node.js application.
Overview of new PostgreSQL 9.4 features, focusing on the performance benefits of JSONB for document storage and the introduction of logical decoding.
