JSON
JSON Columns and Schema Drift and How to Find It Early
Measure schema drift in a jsonb column with key counts and type counts, see how it changes a sum, and stop it with a NOT VALID check constraint.
6 min read
Tag
schema-change
14 posts
YAML
Generating Table Schemas From YAML Definitions Safely
Generate CREATE TABLE statements from a YAML definition, quote identifiers so order and group work, and run the same DDL on PostgreSQL, SQLite and DuckDB.
6 min read