Chaotic Commits | Software, AI, and Uncomfortable Truths
query: there's something in your database and it's been there since 2017
· 19 min · Temporada 1 Episódio 28
Notas do episódio
I found a table in a production database called user_archive_old_v2. Two million rows. Last written to this morning. Nobody knew what it was, and the senior engineer's only advice was: don't touch it.
This episode is one investigation, start to finish, into the basement of a legacy database. We read the schema like an archaeological record, grep the codebase and find nothing, and finally track down what's been writing to that table every day since 2017: a database trigger nobody remembered. Then it gets worse. A user asks for their data to be deleted under GDPR, the soft delete fires the…
