PostgreSQL: Advanced Data Types

Data Types

Use arrays

Query JSONB

Create GIN indexes

Arrays vs tables?

JSONB vs JSON?

How to index?

PostgreSQL Arrays

JSONB Guide