Tuesday 18th June, 2013
10:00am to 10:45am
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.
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