If you have ever dived deeper into the settings letting you unleash the full power of MySQL, you might already come across a couple of settings letting you perform a variety of different tasks — one of such settings is the secure_file_priv variable. What is the secure_file_priv Variable and How Does it Work? The secure_file_priv variable is heavily associated with…

If you’ve found yourself in the MySQL space even for a little while, you already know that MySQL and other flavors of it offer a couple of data types for developers to choose from. A wide majority of the most popular data types offered by MySQL are related to text…

Indexes are there to simplify our work when searching for data: they speed up SELECT queries at the expense of slowing down other kinds of queries like DELETEs, UPDATEs, and INSERTs instead. However, as awesome as indexes might be, they also need a lot of work to get right –…

As a developer, you may be wondering if you need a blog. To be honest, I have been blogging for a while, and all I can tell you is that having a blog on your website has immense benefits. Let’s just say that you have a website where you have…

In this blog, you will learn when you should consider adding JSON data types to your tables and when you should avoid it. Most relational database technologies can now store JSON data and perform queries on it. The introduction of the JSON data type to relational databases represented a turning…

Today we look at three best-practice database designs to store data in multiple languages and easily scale to new markets. Reaching millions of users with an application is every developer's dream. Achieving this goal becomes easier if users from all over the world can use your application. Since not all…

If you frequently find yourself immersed into the MySQL world, there’s probably no need to explain to you what SQL queries are and what they do. Chances are, you know them like your five fingers. SELECT queries allow us to read data, INSERT queries allow us to insert data into…

If you’ve found yourself in the MySQL space at least for a little while, chances are that you have heard about one of its well-known files: my.cnf. my.cnf is a configuration file exclusive to MySQL and all of its flavors and it’s widely regarded as the “go-to” file whenever MySQL…