Unused Indexes in MySQL: A Basic Guide
Indexes are frequent friends for SELECT queries; however, if we want to use indexes, we must ensure that our database instances use them first. Indexes that are not utilized by our database instances are useless – they waste space and make INSERT, UPDATE, and DELETE queries slower.
Choose the Best SQL Adapter for Your Python Project
Finding the ideal database adapter for your python application can be hard. In this article, we'll help you choose the right SQL connector based on your database system and application requirements.
Partitioning MySQL: Why, When, How?
If you are familiar with MySQL, you have probably heard of partitions. Partitions are one of your best friends in regards to query optimization. This article will provide you with a basic overview of partitions to help you understand why they are so important.
Use Advanced MySQL Operations to Analyze Python Web Scraper Data
In this tutorial, we will be building a web scraper in Python to aggregate data from the top five soccer leagues in the world. Then, we'll use advanced MySQL operations such as dynamic SQL, user variables, and CTEs to analyze the data and create visualizations.