How to fix git mistakes
Code or configuration versioning comes with a potential problem: fixing mistakes can be tricky. Here are some solutions for the most common problems. Continua a leggere How to fix git mistakes
Archivio autore: Federico Razzoli
MariaDB/MySQL: Working with MD5 or other hashes
The optimal way to store a MD5 hashes in MariaDB, and how to work with them. Continua a leggere MariaDB/MySQL: Working with MD5 or other hashes
How to test database backups
Testing backups is often considered too expensive. But it is not, if the tests are adequately designed. Continua a leggere How to test database backups
MariaDB: The regexp + LIKE optimisation
MariaDB supports regular expressions, but regexps won’t use indexes. Here’s a workaround that can be used in some cases. Continua a leggere MariaDB: The regexp + LIKE optimisation
A checklist for Database backup automation
Databases and technical debts: here’s a list of requirements your database infrastructure should have. Continua a leggere A checklist for Database backup automation
MariaDB: WITH TIES syntax
Semantics and use cases of the WITH TIES syntax. Continua a leggere MariaDB: WITH TIES syntax
How to delete duplicate rows in MariaDB
How to remote duplicate values from a table to add a UNIQUE index, in MariaDB. Continua a leggere How to delete duplicate rows in MariaDB
The importance of maintenance windows
Periodical maintenance windows can be healthy both for your team and your infrastructure. Business won’t be damaged. Continua a leggere The importance of maintenance windows
The costs of using multiple database technologies
Before introducing a new database technology in your organisation, consider the drawbacks. Continua a leggere The costs of using multiple database technologies
How slow is SELECT * ?
The most widely known query optimisation rule is that developers should always avoid SELECT *. Even when all columns are needed, they should list their names, because more columns could be created in the future. But developers find this really Continua a leggere How slow is SELECT * ?