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.
An overview of the different ways to paginate in MySQL including limit/offset pagination and cursor pagination plus the pros and cons of each.
In this article we explore how our HTTP/3 API compares to the latency of a traditional MySQL client.
Gain a deeper understanding of the MySQL integer types by exploring the different options (INT BIGINT MEDIUMINT etc) and how they are stored.
Learn how to index JSON in MySQL with generated columns and functional indexes.
In this entry of the series we explore using VARCHAR and CHAR data types in your database and give some pointers on which type is best to use and when.
Learn what the MySQL JSON data type is when to use MySQL JSON and some caveats to using JSON documents in relational databases.