Tuning PostgreSQL Auto-vacuum
Why autovacuum is important in PostgreSQL and how to configure it properly. Continue reading Tuning PostgreSQL Auto-vacuum
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
MariaDB/MySQL: Working with MD5 or other hashes
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
How to test database backups
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: 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. Continue reading 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. Continue reading A checklist for Database backup automation
MariaDB: WITH TIES syntax
Semantics and use cases of the WITH TIES syntax. Continue reading 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. Continue reading 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. Continue reading The importance of maintenance windows
The costs of using multiple database technologies
Before introducing a new database technology in your organisation, consider the drawbacks. Continue reading The costs of using multiple database technologies