Hacker News Reader

Comment by prng2021 | Hacker News Reader

prng2021

“You'll find finance moving it to spreadsheets and other weird programs, data integrations putting it in warehouses and BI tools, and it's going out in emails and 3rd party payment processors and their bank and your bank”

How did you miss something so close to the beginning of the article? I’d love to hear how you “restore from backup” all the external systems that data propagates to.

View on HN

You just deal with it. Manually if need be, sending someone a spreadsheet. Not that hard, just a right pita.

Tbh the article's actual example is stupid, if I desperately need to rollback that change I'd just take a backup of that table and change the new types back to the main payment method, 'Stripe'. When we've got it fixed and redeploy the changes, change them back.

Problem solved in two SQL queries.

Not sure if the author's never had to deal with a problem like this before, but his 'impossible' problem's got a bloody obvious solution.

   SELECT * INTO _paymentsbackup FROM payments WHERE PaymentType in (3, 4)

   UPDATE payments SET PayemntType = 1 WHERE PaymentType in (3, 4)

Lol. Your solution is to change a bunch of recorded money transactions? Oh shoot I messed up. Let me just change all these cash transactions temporarily to stripe. Oh shoot I also messed up my sales tax for these geographic regions. Let me just change all the dollar amounts temporarily. That’s hilarious.

Reply on news.ycombinator.com