08/ 11·6 lessons·2 h 20 min

JSONB, arrays, and search

Semi-structured data and in-database search: jsonb access and containment (-> ->> @> ?), when not to use jsonb, SQL/JSON path and building, arrays vs a junction table, full-text search (tsvector + GIN), and fuzzy search via pg_trgm — with an FTS/trgm/engine decision matrix.

Start module→Continue · jsonb access and containment→Reread module→Next module →
/ lessons

Lessons

6 lessons · 2 h 20 min
  1. 01jsonb access and containment↳ continue from here#jsonb#containment#operators25m
  2. 02When not to use jsonb↳ continue from here#jsonb#write-amplification#constraints20m
  3. 03SQL/JSON path and building↳ continue from here#jsonb#jsonpath#jsonb-set25m
  4. 04Arrays vs a junction table↳ continue from here#arrays#junction-table#gin25m
  5. 05Full-text search↳ continue from here#full-text-search#tsvector#ts-rank25m
  6. 06Fuzzy search with pg_trgm↳ continue from here#pg-trgm#similarity#fuzzy20m