Evolving a schema: JSON columns, online DDL, data types and views
Why pre-created spare columns c1..c6 are obsolete, adding columns and indexes without downtime on MySQL 8.4 and PostgreSQL 16, indexing JSON fields, choosing types for strings, numbers, money and time, and MERGE, TEMPTABLE and materialized views with their performance and security traps, all with real measurements.