Showing entries 11 to 20 of 36
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: engineering (reset)
Generated hash columns in MySQL

Creating generated hash columns in MySQL for faster strict equality lookups.

Using redundant conditions to unlock indexes in MySQL

Using redundant conditions as a method to unlock obfuscated indexes and improve performance in MySQL.

Character sets and collations in MySQL

Understanding the differences between character sets and collations in MySQL.

Why isn’t MySQL using my index?

There are several reasons why MySQL might not consider your index, and in this article we’ll explore some of the most common ones.

Pagination in MySQL

An overview of the different ways to paginate in MySQL including limit/offset pagination and cursor pagination plus the pros and cons of each.

Faster MySQL with HTTP/3

In this article we explore how our HTTP/3 API compares to the latency of a traditional MySQL client.

MySQL Integers: INT BIGINT and more

Gain a deeper understanding of the MySQL integer types by exploring the different options (INT BIGINT MEDIUMINT etc) and how they are stored.

Indexing JSON in MySQL

Learn how to index JSON in MySQL with generated columns and functional indexes.

MySQL data types: VARCHAR and CHAR

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.

The MySQL JSON data type

Learn what the MySQL JSON data type is when to use MySQL JSON and some caveats to using JSON documents in relational databases.

Showing entries 11 to 20 of 36
« 10 Newer Entries | 10 Older Entries »