A Beginner's Tale of Migrating Column Types in PostgreSQL
Time: 17:30 - 18:20
Feedback: Leave feedback
In June of 2017, I entered "psql" into the command line for the first time, and by the end of the year, I had migrated a varchar(36) column on our largest production postgres table to a uuid column type. Our client devices still rely on the capitalization of this field, so I used an additional boolean column and SQLAlchemy's hybrid property to perform server-side serialization to upper/lowercase strings. In this talk, I'll walk you through the migration, challenges I ran into along the way, as well as some hard lessons I learned as someone totally new to PostgreSQL.