If you have found yourself in the MySQL world (at least for a little while), chances are that you have probably heard about the usage of EXPLAIN. In the MySQL world, this keyword is everywhere.
With Arctype, you can generate dashboards that easily create visualizations for data in your databases. In this tutorial, you will learn how to use Arctype dashboards to visualize business sales data.
SQL injection attacks traditionally represent one of the largest threats to database security. This article explains what they are and how you can prevent them.
Some MySQL engineers might call them the cornerstone of improving performance in MySQL: indexes are data structures that are frequently used to quickly find rows matching a given query.
During my work tenure, I got a chance to work with MySQL databases with as many as 700 million rows. This post will emphasize how to index and optimize your MySQL queries for indexes.
By
Akhil Mathew
Have you ever wanted to track your tweet activity on Twitter? Then this article is for you. I love how Django’s ORM makes it easy to model a database and modify it with views (i.e., the app’s functional back-end).
MySQL introduced Window functions in their release of MySQL version 8.0. to target groups of rows without collapsing them. In this article, we will explore example implementations of the most versatile window functions MySQL has to offer.
Once developers find themselves in the MySQL world, they will almost certainly hear some advice on how they should go about designing database schemas in MySQL. This blog post will provide insight into what you should consider when dealing with database schemas in MySQL.
Sometimes MySQL (or MariaDB) can be great for big data too! In this article, we will explore the things you should consider when answering the question: “Is MySQL a good option for my big data project?”
