Posts by Aaron Francis
Learn the differences between datetimes and timestamps in MySQL, the DATE, YEAR, and TIME columns, timezones, and when to use each. →
Creating generated hash columns in MySQL for faster strict equality lookups. →
Using redundant conditions as a method to unlock obfuscated indexes and improve performance in MySQL. →
Understanding the differences between character sets and collations in MySQL. →
There are several reasons why MySQL might not consider your index, and in this article we’ll explore some of the most common ones. →
Everything you need to know about MySQL as an application developer, with a focus on improving query performance. After covering the high-level overview, we’ll put the learnings to the test with some hands-on examples. →
An overview of the different ways to paginate in MySQL including limit/offset pagination and cursor pagination plus the pros and cons of each. →
A comprehensive overview of Laravel’s many safety features that can help you prevent painful mistakes. →
Learn how to index JSON in MySQL with generated columns and functional indexes. →