Look Who it Was Random video

10 reasons why you should prefer PostgreSQL to MySQL

2,846 views · Published 20 April 2015 · 0:43 · Indexed 6 November 2026

Channel: Hasgeek TV · 2015 · Science & Technology

Watch on YouTube

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

More from this channel