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. Continue reading How to fix git mistakes
Expert consulting and automation for your database infrastructure
Code or configuration versioning comes with a potential problem: fixing mistakes can be tricky. Here are some solutions for the most common problems. Continue reading How to fix git mistakes
The optimal way to store a MD5 hashes in MariaDB, and how to work with them. Continue reading MariaDB/MySQL: Working with MD5 or other hashes
Testing backups is often considered too expensive. But it is not, if the tests are adequately designed. Continue reading How to test database backups
MariaDB supports regular expressions, but regexps won’t use indexes. Here’s a workaround that can be used in some cases. Continue reading MariaDB: The regexp + LIKE optimisation
Databases and technical debts: here’s a list of requirements your database infrastructure should have. Continue reading A checklist for Database backup automation
Semantics and use cases of the WITH TIES syntax. Continue reading MariaDB: WITH TIES syntax
How to remote duplicate values from a table to add a UNIQUE index, in MariaDB. Continue reading How to delete duplicate rows in MariaDB
Periodical maintenance windows can be healthy both for your team and your infrastructure. Business won’t be damaged. Continue reading The importance of maintenance windows
Before introducing a new database technology in your organisation, consider the drawbacks. Continue reading The costs of using multiple database technologies
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 Continue reading How slow is SELECT * ?