Hacker News new | ask | show | jobs
by yellowapple 1925 days ago
I fondly remember accidentally deleting around half of a warehouse's bulk inventory once during a previous job; I was trying to wipe out test data from a test database, and stupid Azure Data Studio was showing the IP address of the test DB server in the status bar even though the active tab was using a prod connection.

Luckily we were pulling full snapshots of the relevant tables into CSV exports (for ingestion into Redshift for reporting), so it was just a matter of grabbing the most recent of those, reinserting the data, and having some of the warehouse workers do some cycle counts to spot check. Still was a nerve-wracking and awkward conversation with my boss, though, lol