4 ms·
A better title is "Once you start keeping financial state, there are no rollbacks". The current title might as well be click bait.
by LinuxAmbulance 2y ago
A better title is "Once you start keeping financial state, there are no rollbacks". The current title might as well be click bait.
- PeterCorless 2y agoI was going to say... Someone didn't seem to have experience with restoring from backup.
- prng2021 2y ago“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.
- mattmanser 2y agoYou 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)
- prng2021 2y agoLol. 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.