MySQL

Our courses on writing T-SQL queries for SQL Server, SQL for PostgreSQL, and SQL for Snowflake have all been very popular. But we’ve had so many requests for a similar course targeting MySQL, and we’ve delivered that now.

We’re pleased to announce that this course is now available, and it’s low cost. Just $95 USD. It’s easy to set up to do the practical work so you get real experience with MySQL. You can find details of the course here:

2025-11-13

SQL: SQL Server index updates vs PostgreSQL index updates

The link below is to quite a fascinating article that on the surface is about why Uber moved to MySQL from PostgreSQL.

http://use-the-index-luke.com/blog/2016-07-29/on-ubers-choice-of-databases

What it really is about is a limitation in how PostgreSQL indexes are updated. They consider it a severe limitation.

With SQL Server (and MySQL), if you update a few columns in a row, only the indexes that have that column are updated. In PostgreSQL, all indexes still need to be updated. I understand why they’ve done that but I can see why users might not want that behavior.

2016-08-04