Showing entries 1 to 2
Displaying posts with tag: data_types (reset)
Storage and Indexed access of denormalized columns (arrays) on MySQL 8.0, via multi-valued indexes

Another “missing and missed” functionality in MySQL is a data type for arrays.

While MySQL is not there yet, it’s now possible to cover a significant use case: storing denormalized columns (or arrays in general), and accessing them via index.

In this article I’ll give some context about denormalized data and indexes, including the workaround for such functionality on MySQL 5.7, and describe how this is (rather) cleanly accomplished on MySQL 8.0.

[Read more]
Summary of trailing spaces handling in MySQL, with version 8.0 upgrade considerations

Fairly recently, we’ve upgraded to MySQL 8; it’s been a relatively smooth transition, however, some minor differences needed to be handled. One of them is the behavior of trailing spaces.

Trailing spaces are a (not in a good way) surprising, but also widely covered argument. This article gives a short overview, and relates it to how this affects people upgrading to MySQL 8.0.

Contents:

[Read more]
Showing entries 1 to 2