10 reasons why you should prefer PostgreSQL to MySQL

May 2015

11 Mon

12 Tue

13 Wed

14 Thu

15 Fri 08:15 AM – 05:30 PM IST

16 Sat 08:15 AM – 05:15 PM IST

17 Sun

MLR Convention Centre, J P Nagar

All submissions

Previous Next

This submission has been added to the schedule

10 reasons why you should prefer PostgreSQL to MySQL

Submitted Mar 31, 2015

Section: Full talk Technical level: Intermediate

To provide in-depth comparison of MySQL and PostgreSQL, highligihting the advanced features of PostgreSQL.

Outline

MySQL is the most popular database server, but popular doesn’t always mean the best.

PostgreSQL on the other hand is less popupar, but claims to be the most advanced database server.

In this talk I plan to do a in-depth comparision of MySQL and PostgreSQL on various fronts.

Outline:

Brief history of MySQL and PostgreSQL
MySQL ate my cake - cases where mysql strips data without telling you
MySQL vs. PostgreSQL in Database Maintanance
- creating indexes
- alter table
- auto increment issues
Exection Model - MySQL threads vs. PostgreSQL processes
Replication - How replication works is MySQL and PostgreSQL
Advanced Features of PostgreSQL
- Write Ahead Log and Point In Time Recovery
- Table partitioning
- partial indexes
- JSON type
- fuzzy string matching
- views

Speaker bio

I’m an independent software consultant and trainer.

I’ve been using PostgreSQL for long time. During my work at Internet Archive, I’ve migrated their database server from MySQL to PostgreSQL and learnt lot of things about both of them during that.