Session

Back

A scalable, versioned document store in PostgreSQL

Date: 2018-09-06
Time: 20:30 - 21:20
Room: Market Street
Level: Intermediate
Feedback: Leave feedback

At Udacity, we recently migrated all of our classroom learning content from Google App Engine's Cloud Datastore to a sophisticated content-addressed versioned document store built on PostgreSQL. In this talk, we'll discuss the hybrid relational/NoSQL design we developed to meet Udacity's demanding international content authoring and publishing needs, and how we implemented it in PostgreSQL. We'll also discuss 'Dark Write' trigger techniques for performing large-scale content and schema migrations with zero downtime. Finally, we'll cover best practices for large-scale, performant jsonb-based applications in PostgreSQL.

Speaker

Art Gillespie