Skip to content
Hallway
0:00 / 0:00

#postgresql#mysql

Tekpub: Why Not MySQL?

MrTekpub

1K subscribers • 1 video on Hallway

YouTube
  • Recommended by 2 people: 2 in engineering communities.
  • May be out of date. The tools, versions or practices it shows have likely moved on.
  • An opinion. It argues one side of a question engineers disagree on.

Intermediate. Assumes working knowledge.

30K views14 years ago2 recommendations

Databases and dataPostgresMySQLDatabase internals

A comparison highlighting historical data validation and transaction issues in MySQL and how PostgreSQL handles them.

This video highlights many of the strange issues underlying MySQL - and how those problems are handled by Postgres. Our goal is to answer the question: "Why Postgres and not MySQL?". This is episode 2 of Tekpub's Hello Postgres production - given to the community for free.

Why it's here

2 people recommend this

What people say. Linked as a historical reference for why developers preferred PostgreSQL over MySQL due to data integrity concerns.

u/chunkyksin r/PostgreSQL • Recommends

On “What are your experiences with PostgreSQL?”

Specific examples? Out of the box, MyISAM was the default table engine for most of its life, which means no enforced FK constraints and no transactions. I believe the default may have changed, but it belies a fearsome attitude; at some point, someone thought "let's have the faster but less safe one the default". This video gives a bunch of examples where MySQL will silently smoke your data rather than Do The Right Thing(TM). Again, it's the attitude that doing the factually incorrect thing is OK, which is wrong. Again... you can, I think, change this behaviour, but this behaviour is f**king *wrong* and shouldn't be allowed, ever. Until very recently, you couldn't have fulltext indices on…
3View on Reddit

u/alcaldein r/Database • Recommends

On “Why you shouldn't use MySQL”

Some more useful examples: Tekpub: Why Not MySQL? From the MySQL documentation: "it is not the job of the SQL server to validate dates" 5 Reasons It's Time To Ditch MySQL
0View on Reddit

u/mobiliakas1in r/programming • Mentions

On “PostgreSQL 17 Released!”

Historically it was very lax on data validation, see link to this video Now it has better behavior.
1View on Reddit