Showing entries 1 to 2
Displaying posts with tag: data_types (reset)
Mar
16
2020
Storage and Indexed access of denormalized columns (arrays) on MySQL 8.0, via multi-valued indexes
Posted by Saverio Miroddi on Mon 16 Mar 2020 00:00 UTC
Tags:

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]
Jul
09
2019
Summary of trailing spaces handling in MySQL, with version 8.0 upgrade considerations
Posted by Saverio Miroddi on Tue 09 Jul 2019 00:00 UTC
Tags:

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