Technical notes on web development, DevOps, and AI integration.
1 article
Seven public slugs carried curly-quote bytes from a bad import. The fix: a HEX-guarded idempotent SQL migration with a byte-identical down path.
TL;DR: A HEX spot-check found seven venue slugs carrying curly quotes and en dashes from a bad import, not charset truncation. The fix skips regex, using manual ASCII maps guarded byte-exact by HEX checks, so migrations stay idempotent and rollbacks restore identical bytes. Same commit also blocks staging user-data overwrites and misdirected E2E runs.