#Community articles: Page 3

I’m developing an application that takes data from different sources, processes it, and prepares reports. In this series of articles, I will explain how to inst...

As any developer, I don’t like to write documentation. But if I am writing it, I would like to test that what I wrote works. I often found myself copy-pasting s...

Creating the database for an application is simple and easy. However, database script management gets complicated in a hurry when you need to support multiple v...

There are a number of options for generating ID values for your tables. In this post, Alexey Mikotkin of Devart explores your choices for generating identifiers...

In the context of providing managed WordPress hosting services, at Presslabs we operate with lots of small to medium-sized databases, in a DB-per-service model,...

...

MySQL has locking capabilities, for example table and row level locking, and such locks are needed to control data integrity in multi-user concurrency. Deadlock...

The goal of this tutorial is to show you how to use multi-master to aggregate databases with the same name, but different data from different masters, on the sa...

In this post, I provide an illustration of how to use Pentaho Data Integration (PDI) tool to set up external dictionaries in MySQL to support ClickHouse. Althou...