Tech

Notes on databases, APIs and the parts that break. Most of these start as something I worked out twice and wanted written down.

2024

Querying JSONB data in PostgreSQL

10 min

The operators and query patterns I keep reaching for when data lives in a JSONB column, from simple objects to arrays of objects.