Partitioning a billion-row table of soccer data using data context
Why you should study your application domain when defining efficient partitioning criteria for your database.
10 months ago
MySQL
What is mysqld?
What is the mySQL daemon? Why do developers care about it, and what does it do?
a year ago
Querying GitHub data with SQL: Insights for developers and engineering leaders
In this article, we'll learn about using a tool called MergeStat to query and gain insights from a GitHub repo.
By
Bonnie
Parsing Data with Just SQL
Simple SQL operations like LOAD, ALTER, INSERT, and UPDATE can turn parsing data from a chore into an efficient and mistake-free task.
a year ago
Improving performance with SQL aggregate functions
SQL aggregate functions helped me take the performance of my backend application to the next level and avoid the bottlenecks that were slowing it down.
a year ago
Building a REST API with Node.js, MySQL, and Express
Learning how to build a simple database for adding, updating, and removing todos with Node.js, MySQL, and Express.
a year ago
Importing Data Using MySQL and Arctype
In this blog, we will look through the options you have when it comes to importing data into your MySQL instances.
a year ago
Using cursors and for loops in MySQL
If you've ever wanted to learn how to write a MySQL cursor or a MySQL loop, you've come to the right place. Let's iterate!
a year ago
Collation Relation, what's your Translation?
Emojis and support for all languages are amazing. But the collations and character sets that enable them can cause baffling problems without a little knowledge.
a year ago