Migrating Databases with Rails at Scale

At Procore, PostgreSQL is our workhorse. The nature of our product - a very large suite of enterprise business management tools for the construction industry - requires a fully normalized relational database with over 600 tables, and we keep adding more. Our traffic peaks predictably every weekday morning as an average of 80,000 construction industry professionals log in and use Procore throughout their day. It's not unusual for our database to perform 35,000 transactions / second and scan 20,000,000 rows a second sustainedly for several hours every morning. At the same time, our engineering team is hard... Read More

Join Us for a Post-RailsConf 2017 Wrap-Up Event

Procore had the privilege of sponsoring the RailsConf 2017 event that took place last month in Phoenix, AZ. At the event, we had the opportunity to speak and collaborate with a handful of thought leaders and influencers in this space. Some of whose names you may recognize: Yehuda Katz, Sarah Mei and Justin Searls. We spoke to these influencers about how they contribute to the tech community, what inspires them to do so, and other challenges they’ve observed within the tech world. Procore’s Engineering Team hopes to facilitate more discussion around this at a RailsConf Wrap-Up taking place... Read More