Advanced Data Types in PostgreSQL
summary
Notes the environment: roughly 1,000 Postgres databases, up to 30 TB and 250,000 tables, driving practical choices. Demonstrates concrete features and outcomes: using jsonb operators to query and mutate nested data, arrays and composite types to pack related fields, domains to enforce reusable checks, and range types plus a range exclusion constraint (with gist index) to prevent double bookings. Builds a boolean2 custom type to map PHP truthiness to 0/1, saving months of application rewrites.
AI-written summary · about
chapters (4)
related talks
43mAdvanced Data Types in PostgreSQL
57mUnderstanding Advanced Datatypes in PostgreSQL
29mPostgres Demystified
14mJSON data structure – the hidden gem inside your database engine
46mUse PostgreSQL to Step Up Your Game
48mData Horizons With Postgres
57mUnderstanding Advanced Datatypes in PostgreSQL
19mNO ARRAY OF SUNSHINE: an introduction to data types from a data quality perspective