Posts by JD Lien

JD Lien |March 24, 2023

Learn what you should look out for when upgrading an existing database from MySQL 5.7 to 8 and how to change your database to be compatible with the new version. →

JD Lien |February 17, 2023

Learn about some of the possible downsides of using database indexes and how to remove unused database indexes in MySQL. →

JD Lien |January 18, 2023

Learn what the N+1 queries problem is by working through an example N+1 query updating it to a JOIN statement and going over how to identify them in the future. →

JD Lien |October 7, 2022

Learn how and when to use inner joins, outer joins, left joins, and right joins in MySQL. →