Vol. I · A Postgres Handbook

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

EasyAdvanced PostgreSQL

Theory: PostgreSQL vs MySQL - Data Types & JSON

The query

SQL
-- Q: How do PostgreSQL and MySQL differ in handling JSON?
-- A: PostgreSQL has a highly optimized JSONB type which stores data in 
-- a decomposed binary format, allowing fast indexing (GIN) and complex querying. 
-- MySQL has a JSON type but PostgreSQL's JSONB implementation is widely 
-- considered superior in performance and query capabilities.
Tested against PostgreSQL 16

Note

“PostgreSQL is often used as a hybrid SQL/NoSQL database because of JSONB.