Hacker News new | ask | show | jobs
by boredatoms 17 days ago
The need ‘default sets’ so that as the very first command I can say ‘use 2026.1 defaults’
1 comments

Or even better just SET STRICT_TABLES, or whatever other opt-in feature you want. A couple of such statements in the beginning of your migration script (refactored in a way to be reused across all migration scripts) and you are done. I wouldn't want to learn WTF "2026.1 defaults" are.
I just do it in my code like

def create_table(name, cols): return f"CREATE TABLE {name} ({cols}) STRICT;"

That relies on you knowing about what good settings are though