@dynamicFlowfields — #postmortum
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 post-mortem: migration pipeline (apr 5 2026) what broke db:migrate hung indefinitely after merging migration hang better-sqlite3 v12.8.0 silently changed its default behavior: new connections now have foreign_keys=on. drizzle-orm's migrate runner wraps all migration sql in an explicit begin transaction before executing it. sqlite's documented behavior is that pragma foreign_keys is silently ignored inside a transaction. so the pragma foreign_keys=off in drizzle's generated table-recreation sql had no effect, and drop a table hung indefinitely wa...Read more
Kult: +35
Total: 35