[Koha-devel] MySQL/MariaDB index prefix length

2022-12-08 Thread David Cook
Hi all, We often create indexes with a prefix length of 191 because we use 4 byte encoded fields. 191 * 4 = 764, which comes in under the prefix index length threshold of 767. But that looks like a limit that was imposed due to the COMPACT row format. Most newer MySQL/MariaDB databases

[Koha-devel] What's the definitive way to use Perl tidy in koha-testing-docker?

2022-12-08 Thread David Cook
Hi all, I've heard a few people saying lately that they wish people would use Perl tidy more. So I used the ":Tidy" command in koha-testing-docker on my visual selection and I got the following: +$this_item->{shelves} = +