MariaDB vs MySQL – Comparing MySQL 8.0 with MariaDB 10.3

Introduction The goal of this article is to evaluate and highlight the main similarities and differences between the MySQL Server Database and the MariaDB Server Database. We’ll look into performance aspects, security, main features, and list all aspects which need to be considered before choosing the right database for your requirements. Who is using MySQL… Continue reading MariaDB vs MySQL – Comparing MySQL 8.0 with MariaDB 10.3

What’s the best way to learn to write better and faster SQL queries?

Imagine how spider-man's life would look like if he had never find out that he can shoot webs from his wrist... Not a good starting point, isn't it? Sometimes one can learn to write SQL queries but miss critical functionalities and important features, which can change their day-to-day life and save them significant amount of… Continue reading What’s the best way to learn to write better and faster SQL queries?

Most popular databases in 2018 according to StackOverflow survey

The survey results from StackOverflow's developers survey are already here, and we can now declare the most popular databases for 2018. Without further ado, let's look into the results: So what can we learn from these results? The most popular database is MySQL, and not by far comes SQL Server. This wasn't very surprising, as… Continue reading Most popular databases in 2018 according to StackOverflow survey

Choosing the best indexes for MySQL query optimization

Many of our users, developers and database administrators, keep asking our team about EverSQL's indexing recommendations algorithm. So, we decided to write about it. This tutorial won't detail all the internals of the algorithm, but rather try to lay down the basic and important aspects of indexing, in simple terms. Also, and most importantly, we'll… Continue reading Choosing the best indexes for MySQL query optimization

Faster Pagination in Mysql – Why Order By With Limit and Offset is Slow?

Queries with LIMITs and OFFSETs are common in application that require pagination and in some cases might work well for a while. In many cases though, they become slow and painful once the OFFSET has a high value. Why OFFSET is so slow? Well, in most cases, low offset queries are not slow. The problem… Continue reading Faster Pagination in Mysql – Why Order By With Limit and Offset is Slow?

MySQL utf8 vs utf8mb4 – What’s the difference between utf8 and utf8mb4?

The Story of UTF8 VS UTF8MB4 I once got a call from the support team, saying that one of our customers reported that the application fails to save data in one of our business-critical features. The customer is seeing a general error from the application. About 30 of his 500 users are experiencing this issue… Continue reading MySQL utf8 vs utf8mb4 – What’s the difference between utf8 and utf8mb4?