109 Blog Posts To Learn About Mysql

Let's learn about Mysql via these 109 free blog posts. They are ordered by HackerNoon reader engagement data. Visit the Learn Repo or LearnRepo.com to find the most read blog posts about any technology.

A widely used open-source relational database management system, valued for its speed, reliability, and ease of use in web applications.

1. [MySQL] Note: Relation: 1–1, 1-n, n-n, nest

Over the pass few years, I have built couple of E-commerce or content shared platform by MongoDB, and realized that it is not a ideal database for the architecture of complex relational tables(like user, permission, product or shop relations) and fast-moving features requirement(it causes inconsistent records/data type) . It happens every few months when new requirement come to us, dirty data correcting is like pull teeth from my ass.

2. How to Install MySQL 8 on macOS Using Homebrew

A step-by-step guide 📙 on how to install, configure and run MySQL 8 server on macOS using Homebrew 🍺

3. How to Сompress a mysqldump Backup Using Gzip

What is mysqldump?

4. How to Install and Configure PHP for Apache and MySQL

In this article, we explain how to install PHP, Apache, and MySQL and then find out how to configure PHP.

5. Solve Database Concurrency Issues with TypeOrm

Solve concurrency issues with typeorm query to fix race-condition and deadlock bug.

6. My Favorite Resources to Learn SQL in Depth

Practicing SQL online on sites like SQLZoo or SQLFiddle will help you keep up-to-date and improve your SQL skills.

7. Navigating MySQL Data Types: Strings

This article covers string types in MySQL, how they function, what may go wrong, and how to make safe choices.

8. MySQL Master-Slave Replication using Docker

In this article I want to share my experience of how to setup MySQL replication locally with using Docker.

9. Go: Handling JSON in MySQL

10. Fortifying Postgres With Byzantine Fault Tolerance

Byzantine Fault Tolerant PostgreSQL combines BFT consensus algorithms with relational databases, enabling data-intensive trustless digital infrastructure.

11. Unlocking the Power of JSON in MySQL: Tips and Tricks

In this article, I will explain how and why you should use the JSON data type instead of TEXT.

12. How to Efficiently Generate Test Data With SQL

There are a large number of utilities for generating test data. Here are some examples of using SQL queries to generate test data.

13. How to Detect and Delete Emojis in Golang

I encountered an issue when 10 million messages with emoji were written in the MySQL table with utf8 encoding.

14. What Is the Difference Between Enum, Varchar and Int Data Types in MySQL

The 'varchar' and 'enum' fields are different types of data types. They are different in terms of performance, easiness to use, and support for feature changes.

15. Unexpected Discoveries in TypeORM 0.3.11

TypeORM is an ORM tool for TypeScript, supports popular databases and make it easy to interact with them. Upgrade to v0.3.11 for new features and improvements.

16. How to Deploy Strapi v4 on the DigitalOcean App Platform with MySQL Database

This is a step-by-step guide for deploying a Strapi v4 project to DigitalOcean's App Platform with managed mySql Database.

17. GitHub Actions CI config for MySQL, Redis, Elasticsearch in Ruby on Rails project with RSpec tests

How to run parallel tests with Github Actions jobs for Rails project with MySQL, Redis, Elasticsearch.

18. 5 Best Courses to Learn MySQL Database for Beginners

If you are interested in learning SQL with MySQL database then you have come to the right place.

19. Top 10 Websites to Learn SQL and Database Online

These are the best places to learn SQL and Database online

20. Upgrading MySQL 5.5 to MySQL 8: A Step by Step Guide

It is one of the dogmas that upgrading freeware libraries is a drag - but not anymore especially for MySQL. Check out this article for more information.

21. DBngin: Instant Local Server for MySQL, PostgreSQL, and Redis

Docker might be an easy solution as an all-in-one tool for setting up a Local Development Environment. But on the other hand, it eats up a huge portion of your system resources to get up and running, and we hate it when our computer becomes lagging and clumsy.

22. Connecting GraphQL with Java Spring Boot and Postgres or MySQL

GraphQL is revolutionising the way developers build APIs. It lets you query precisely what you want. Nothing more, nothing less! It also gives you the flexibility to query related objects in a single round trip, unlike the REST APIs.

23. Using Git Hooks with MySQL

In this article, we'll explore how to integrate Git with MySQL for version control using Git hooks, with specific examples in a guide format.

24. MySQL Loose Scan Optimization: A Comparative Performance Evaluation Against PostgreSQL and MSSQL

An extensive performance comparison research for GROUP BY queries in MySQL, PostgreSQL and MS SQL Server.

25. Navigating MySQL Data Types: Sets and Enums

Learn how to use MySQL’s SET and ENUM data types effectively. This guide explains their internal behavior, common pitfalls, and best practices

26. How to Create and Connect a MySQL Database to PHP Files Using cPanel

Learn how to fetch data from a MySQL database and print it on a webpage using PHP.

27. Integrate Java Database Versioning with Liquibase using MySQL [A Step by Step Guide]

Versioning database changes is as important as versioning source code. By using a database migration tool we can safely manage how the database evolves, instead of running a bunch of non versioned loose SQL files. In some frameworks like Ruby On Rails, database versioning occurs along the development. But when it comes to Java world, I don't see it happening so often.

28. Express-js Boilerplate with User Authentication

I couldn’t find a complete user authentication system for Expressjs, so I wrote this one.

29. How to Stream Data from MySQL to Postgres

Stream MySQL data to PostgreSQL in real-time. Any changes made to your source immediately applies them to the target database.

30. A Prisma ORM Review

Prisma ORM is a good choice for your project. It lacks some features of other ORMs. But it's not a big deal because you can jump the lover levels of raw SQL

31. Is MariaDB simply a fork of MySQL?

MariaDB is more than a fork of MySQL and offers transactional, analytical, and write-scale capabilities on-prem and in the cloud

32. Build a Movie Streaming App Like Netflix Using Node.js, MySQL, and Deploy on Aptible

Imagine watching your favorite movies and TV shows anytime, anywhere, without worrying about buffering or slow loading times. That's the power of a movie stream

33. 2019 Database Trends – SQL vs. NoSQL, Top Databases, Single vs. Multiple Database Use

Wondering which databases are trending in 2019? We asked hundreds of developers, engineers, software architects, dev teams, and IT leaders at DeveloperWeek to discover the current NoSQL vs. SQL usage, most popular databases, important metrics to track, and their most time-consuming database management tasks. Get the latest insights on MySQL, MongoDB, PostgreSQL, Redis, and many others to see which database management systems are most favored this year.

34. Navigating MySQL data types: date and time

Explore the nuances of MySQL’s DATETIME and TIMESTAMP types, from handling time zones and zero dates to optimizing performance and preventing pitfalls.

35. PostgreSQL or MySQL: What Should I Choose for My Full-Stack Project?

A comprehensive guide comparing PostgreSQL and MySQL for full-stack developers, covering installation, transactional support, performance, security, and more.

36. Creating a Simple Business Directory using CodeIgniter and MySQL

A walkthrough of how to build a simple web directory using CodeIgniter and MySQL. The code is available in this github repo.

37. Principles of a Clean Relational Database

The article describes how a relational database should be designed to properly work in OLTP mode.

38. How to model an efficient database for your application

What is Database Modeling?

39. An In-depth Look Into MySQL Vs. PostgreSQL

PostgreSQL and MySQL are both reliable, secure and scalable databases that have been around for years.

40. Navigating MySQL data types: numeric

Learn how to choose the right numeric data types in MySQL, from integers and decimals to floating-point and bit fields. This guide covers common pitfalls, best

41. Mastering Java JDBC CRUD Operations in Eclipse Using MySQL

In this article, we will see how can we perform crud operations with MySQL database using JDBC.

42. How To Create Secure Registration Flow with PHP and Password Hashing

Building a secure user registration form with PHP seems like a scary task. How do I protect myself from MySQL injection and other methods of hacking. Surprisingly, with only a few steps and precautions, you can greatly reduce the chance of success for attacks.

43. The Power of Functional Indexes in MySQL: A Comprehensive Guide

This article explores the concept and benefits of functional indexes in MySQL.

44. Dockerize Your Laravel Project in a Jiffy

The easiest way to dockerize your Laravel project. you can set up Laravel in just 10 minutes...

45. Hosting Provider Cloud Clusters Inc. Potentially Exposed 63M Records

An exposed and unsecured database from Cloud Application Hosting company Cloud Clusters, Inc. was discovered on October 5, 2020, containing more than 63 million records.This discovery was made by Jeremiah Fowler from Securethoughts. Among the records were username and password credentials for Magento, WordPress, and MySql.

46. Installing phpMyAdmin for Easy MySQL Administration [A How-To Guide]

For any database administrator, being able to employ tools that make the job a bit easier can be the difference between getting everything done by the end of the day and struggling to meet deadlines.

47. Decoding MySQL EXPLAIN Query Results for Better Performance

Understanding MySQL explains query output is essential to optimize the query. EXPLAIN is good tool to analyze your query.

48. Does MariaDB Depend on MySQL?

Thoughts on how MariaDB is incorrectly perceived merely as a fork of MySQL and how MariaDB is independent from MySQL yet highly compatible

49. Jython: The Love Child of Python and Java

Jython is an implementation of Python that runs on Java. For the most part, it is compatible with Python 2.7.

50. How to Quickly and Efficiently Create Tests for MySQL

How to quickly and efficiently create tests for MySQL without installing any additional utilities.

51. Reduce MySQL CPU Usage Through Dynamic Binary Optimisation

If you are using MySQL or MariaDB as a Database Management System for your web-application so sometimes these DBMS consume too much of CPU resources which lead to the slow down of the application performance.

52. How to Navigate Auto-Increment Columns in Relational Databases

Auto-increment is a database feature that generates unique IDs for new rows. It's supported by most RDBMS and can be implemented using different syntax.

53. How to Use .populate() With mongoDB

How to use populate() method with mongoDB to itch data across referenced collections

54. Your ORM Is Lying to You (And You're Paying for It)

ORMs hide what they really do to your database. Learn the patterns that kill performance and the architecture that uses both ORM and raw SQL correctly.

55. SQL Window Functions: A Quick Review With Examples

In this article, we’ll explore some commonly used SQL window functions (ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LEAD(), and LAG()) with examples.

56. Check Out These 8 Free SQL Courses to Learn About Oracle, MySQL, and SQL Server

SQL is very important and many programmers realize this, however, I have found that many more programmers just don't spend much time improving their SQL skills.

57. Decoding MySQL EXPLAIN Query Results for Better Performance (Part 2)

Understanding MySQL explains query output is essential to optimize the query. EXPLAIN is good tool to analyze your query.

58. Take your Materialized Views to the Next Level by Joining MySQL and Postgres

59. Top 3 Databases Every New Developer Should Know

Most new developers wonder which database is suitable for their project since they don't want to get off on the wrong foot. So, first and foremost, let's define a database. A database is a type of storage facility that electronically stores and organizes data so that it may be utilized and accessed later.

60. [Tutorial] Top 5 Ways to Query your Relational Database in JavaScript [Part 1]

If you’re developing web applications, you’re almost certainly going to be constantly interacting with a database. And when it comes time to select the way you’ll interact, the choices can be overwhelming.

61. Make Your Application Scalable Optimizing the ORM Performance

In this article I would share a set of ORMs optimization strategies that I'm using in almost every backend service I'm working on.

62. RocksDB Is Steadily Eating the Database World

Technical design. Because one of the most common use cases of the new databases is storing data that is generated by high-throughput sources, it is important that the store engine is able to handle write-intensive workloads, all while offering acceptable read performance. RocksDB implements what is known in the database literature as a log-structured merge tree aka LSM tree.

63. Efficient Dockerized Database Monitoring with Dockerized PMM

Learn how to monitor your databases with ease using Docker and Percona Monitoring and Management (PMM). PMM is a free and open-source platform for monitoring an

64. Getting your Swift API Interacting With a MySQL Database 💾

Continuing our Swift backend takeover 😬 by configuring our API with a popular, powerful database MySQL 🖥

65. [Tutorial] Top 5 Ways to Query Your Relational Database in JavaScript [Part 2]

Welcome back! In the first part of this series, we looked at a very "low-level" way to interact with a relational database by sending it raw SQL strings and retrieving the results. We created a very simple Express application that we can use as an example and deployed it on Heroku with a Postgres database.

66. Is JOIN Faster Than Correlated Subqueries? Taking a Look and Subsequently Debunking the Myth

I decided to put it to the test across four popular database systems: MySQL 8.0, Oracle 23c, PostgreSQL 16, and SQLite 3.45. The results were eye-opening.

67. How I Connected MySQL Shell Over SSH

Until recently, I had only used MySQL Shell to connect to a local instance of MySQL running on my development machine.

68. My Personal Guide to SQL Window Functions (Part 1)

First introduced as part of the SQ:2003 Standard and available in MySQL 8.0, window functions in MySQL are compelling, but the syntax can be difficult to grok.

69. How to Connect to Oracle, MySql and PostgreSQL Databases Using Python

To connect to a database and query data, you need to begin by installing Pandas and Sqlalchemy.

70. ChartDB: Pioneering the Future of Database Visualization ✨

ChartDB is an open-source tool transforming database design. Discover intuitive visualization, AI features, and seamless developer workflows.

71. Generating Unique Values for Test Data in MySQL

Generating unique values for test data in MySQL

72. SQL Data Modification Commands With Examples: A Quick and Simple Guide

In this article, we’ll explore these commands with practical examples.

73. Postgres and MySQL: Performance Comparisson

What workload analysis and running queries can teach us about the performance differences in JSON, indexing, and concurrency.

74. Maximize Cybersecurity with Multiple Databases

If securing your company’s intellectual property is such a complex process, how can business leaders efficiently defend their assets? Use multiple databases.

75. How to Master SQL Joins - Inner, Outer, Cross, and Self-Joins With Examples

In this article, we’ll explore various SQL join types with clear explanations and practical examples.

76. Spring Boot on Choreo: Connecting a Database

Learn to configure a robust database in a Spring Boot app on Choreo, from development to deployment, ensuring a seamless and secure transition.

77. Integrating Manticore Search with Apache Superset

In this article, we’ll provide a step-by-step tutorial that will guide you through connecting Manticore to Apache Superset and adding a chart.

78. SaaS Database Migration To Heroku Postgres

The next step in my fitness application journey is to migrate to Heroku Postgres. Check out how easy this turned out to be too.

79. Synchronizing Data from MySQL to PostgreSQL Using Apache SeaTunnel

A step-by-step walkthrough of building a real-time data pipeline to merge and synchronize MySQL data sources using Apache SeaTunnel.

80. A Basic Guide to MySQL Tests Automation

We created a script that can be automatically run on certain kinds of events, as well as interpret its results, basing the automation execution logic on them.

81. Auto-Synchronization of an Entire MySQL Database for Data Analysis

Flink-Doris-Connector 1.4.0 allows users to ingest a whole database containing thousands of tables into Apache Doris, a real-time analytic database, in one step

82. Jwenky: An Express API Server with User Authentication

Jwenky is an API server coded in Express framework.

83. A Guide to Understanding Indexes in MySQL

In this blog, we will understand the different types of Index in MySQL, their use cases, and various strategies to decide the index for a table.

84. How to Connect With External MySQL Servers (Part 1: Select Operations)

This tutorial shows how to perform basic select queries to interact with MySQL Server using mysql2 gem.

85. PHP CRUD Generator – Instantly Build Admin Panels from Your Database

Instantly generate secure, responsive PHP admin panels from your MySQL database. Save development time with automated CRUD operations

86. Apache APISIX Without etcd?

etcd is an excellent key-value distributed database used internally by Kubernetes and managed by the CNCF.

87. Investigating the "Bus Factor" Risk in MongoDB, MariaDB, and More

Ever wonder what would happen to an open source database project in case its main developers “got hit by a bus”?

88. Unveiling a MySQL Bug: Inconsistent Foreign Key Constraints

In this article, I want to share an interesting bug that I stumbled upon in MySQL.

89. The HackerNoon Newsletter: AI Is Not Being Adopted. It Is Being Installed. (3/9/2026)

3/9/2026: Top 5 stories on the HackerNoon homepage!

90. IKODIX Helps to Create Admin Panel Fullstack Apps for Your Databases

IKODIX is an online code generator for admin panel full-stack applications for any relational database.

91. I Tried Every Open Source Database and Found Only One That is Actually Useful

Let's walk through this journey. My journey. Maybe it helps someone else avoid the same database-induced headache.

92. Manticore Search Now Integrates With Grafana

We are excited to announce that Manticore Search starting from 6.2.0 integrates effortlessly with Grafana.

93. MySQL FAQs

MySQL is an open-source relational database management system. As the
name suggests, it is used to create, update, and store databases. It is based on SQL (Structured Query Language). So, today we will be checking out the 13 most asked questions on MySQL.