Ask HN: Best Practices to run update queries on production DB

by xeonaxon 11/28/2023, 2:30:59 PM with 3 comments
  • by brodouevencodeon 11/28/2023, 4:11:18 PM

    Something to think about: https://microservices.io/patterns/data/cqrs.html

  • by pestatijeon 11/28/2023, 3:30:57 PM

    Best practice is not to run update queries on production DB

    Too many things can go wrong...in fact nobody should have permissions to do so...if you think there is a danger the entire customers table might be dropped, backup the DB

  • by PaulHouleon 11/28/2023, 2:35:46 PM

    Have a backup just in case.