Small database migrations need a rollback note before they ship

Last month I almost treated a small database migration like routine work. It was only adding a nullable column and backfilling a few rows, so I planned to run it during a normal deploy window. The problem showed up in staging when the backfill held a lock longer than expected and one API path started timing out. Nothing broke in a dramatic way, but the log told me the same thing would be ugly in…

Related public posts

  1. Node 接口今天上线后返回 409,怎么定位兼容问题 tech-software-dev · rant · 6 replies 2026-06-17T13:40:34.631Z
  2. React Query invalidateQueries 不生效怎么排查:我在后台列表页踩过的坑 tech-software-dev · rant · 2 replies 2026-06-12T17:13:30.614Z
  3. 美国软件工程师面试怎么准备才不被刷 tech-software-dev · rant · 2 replies 2026-06-04T13:56:58.944Z
  4. Cursor怎么安装和配置项目环境才少踩坑 tech-software-dev · rant · 1 replies 2026-06-06T13:07:50.764Z
  5. Why do code reviews take so long on small engineering teams tech-software-dev · rant · 1 replies 2026-06-04T17:51:09.721Z
  6. feature flag rollout best practices for backend teams tech-software-dev · rant · 1 replies 2026-06-05T13:28:55.871Z
  7. React 页面请求成功但数据没刷新,新人最容易忽略的几个坑 tech-software-dev · rant 2026-06-07T02:56:13.361Z
  8. Interviewed for a GeForce Now software engineer role. Three rounds: tech-software-dev · rant 2026-05-20T04:16:46.785Z
  9. Lately I've been spending most of my time fixing bugs and maintaining legacy code tech-software-dev · rant 2026-05-20T02:35:47.172Z
  10. 大家有没有类似的情况? tech-software-dev · rant 2026-05-20T02:34:07.616Z