Switching Teams: Moving an Application from MySQL to PostgreSQL

A session at Open Source Bridge 2013

Tuesday 18th June, 2013

10:00am to 10:45am (PST)

SQL is an ISO standard, so you should just be able to switch backend databases, right? Sadly, while standards help, real life applications almost always use version specific syntax and functions. Five years into the development of our application, we started thinking that a different database backend would better meet our future needs. This is the story of why we choose Postgres and Open Source, how and why we switched, what worked, what didn't, what was easy and what was hard. The conversion of our user generated data from a mixture of unknown and unrecorded character sets to consistent UTF-8 added some interesting twists to our journey.

While each application is different, Julie will give you the information you need to decide whether switching backends is right for your project and some tools to get you started. Although we switched from MySQL to PostgreSQL, most of the information applies to any SQL database. This talk will also be useful to people who have been thinking about switching backends for future projects or working on a project with an unfamiliar SQL dialect.

For those who are interested, the application in question provide the CATME SMARTER Teamwork tools (http://www.catme.org) A demo is available at https://www.catme.org/login/surv...

About the speaker

This person is speaking at this event.
Julie Baumler

Sys admin, programmer, drupalista , dog lover, needleworker, jack of all trades master of some bio from Twitter

Sign in to add slides, notes or videos to this session

Tell your friends!


Time 10:00am10:45am PST

Date Tue 18th June 2013

Short URL


Official session page


View the schedule



See something wrong?

Report an issue with this session