Dear Instagram, How do you deploy database updates? With Rails-style migrations?... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

joevandyk on Jan 17, 2013 | parent | context | favorite | on: Handling Growth with Postgres

Dear Instagram,

How do you deploy database updates? With Rails-style migrations?

One thing that bugs me about migrations is that if you use functions or views, the function/view definition has to be copied to a new file. It makes it difficult to see what's been changed. I'm looking forward to http://sqitch.org/ for this reason. (slides: http://www.slideshare.net/justatheory/sqitch-pgconsimple-sql...)

rbranson on Jan 17, 2013 [–]

The short answer is we don't do it very often, and it's often complex (data sizes, sharding, and availability concerns), so we do it on an adhoc basis and in a semi-automated fashion.

Join us for AI Startup School this June 16-17 in San Francisco!
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact