Grep and communicate to team before removing DB columns

This is part of the Semicolon&Sons Code Diary - consisting of lessons learned on the job. You're in the dumb-mistakes-and-gotchas category.

Last Updated: 2024-11-21

Upon seeing that many of the columns of the advisors table in Project S were not used in the web app I was tasked with building, I wrote a migration to delete and rename these columns.

I later found out that an administrator freelancer had a backdoor for adding data, that made use of some of the columns I removed.

Lessons