Working with JSON Data in SQL

PostgreSQL JSON Functions

-- Extract a value

SELECT data->>'name' AS customer_name FROM events;

-- Query JSON arrays

SELECT * FROM events WHERE data->'tags' ? 'premium';

Storing flexible, schema-less data (e.g., event payloads).

Logging and audit trails.

Don't use JSON for everything. Relational columns are faster for querying and joining.

*Day 91: Full-Text Search.*