Hacker News new | ask | show | jobs
by chairleader 2927 days ago
Nice reference!

Does anyone have similar references for doing 0-downtime migrations? For example, building your indexes with CONCURRENTLY to prevent table locking.

2 comments

Not exhaustive but this has come in handy: https://www.braintreepayments.com/blog/safe-operations-for-h...
If you are using Rails, this is a nice guardrail: https://github.com/ankane/strong_migrations

Even if you aren't on Rails or don't want to use the gem, it is still nice a checklist.