Session: PostgreSQL versus MySQL — What Are The Real Differences
Two open source databases both started by guys named Michael that have been around more than twenty five years and have thriving communities. They are both popular, have thriving communities, and at a certain vantage point can be seen as being pretty much the same thing – a relational database. However the differences can drastically impact how your project operates. While there are a few features that each have that the other does not, there are real differences that materially effect how your project works. Both support transactions but the differences in technique determine just how many transactions you will want to support. There are many different approaches to indexing columns that you can architecturally take advantage of easily. Replication between servers have different technologies and high availability options. This session will show you which areas are similar, where they differ vastly, and help you decided between PostgreSQL and MySQL.
