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 <strong><em>MongoDB</em></strong>, 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
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.
94. MySQL Errors Messages And Common Problems
Errors or mistakes are common in any aspects, especially in development. Using MySQL or any database can't guarantee you an error-free environment.
95. SQL Data Modification Commands With Examples: A Fast and Easy Guide
In this article, we’ll explore these commands with practical examples.
96. My Personal Guide to SQL Window Functions (Part 2)
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.
97. Your App Is Slow Because You Don’t Know What a Primary Key Is
Primary key design is not just a technical detail — it's a make-or-break factor for database performance, especially at scale.
98. MySQL Single Leader Replication with Node.js and Docker
How to set up MySQL single-leader replication on your local machine using Docker.
99. Why Your SeaTunnel CDC Job Hangs at Snapshot Phase (And How to Fix It)
We encountered an abnormal issue when syncing a particular MySQL table.
100. The Secret to Faster JSON Queries in MySQL: Generated Columns
Migration script to make use of stored generated columns in MYSQL.
101. Step-by-Step Guide: Free Real-Time MySQL to Oracle Sync with SeaTunnel
When it comes to tools for syncing MySQL to Oracle, besides the traditional OGG, SeaTunnel should definitely be on the list—it’s simply too convenient to use.
102. The Noonification: Using Git Hooks with MySQL (9/30/2023)
9/30/2023: Top 5 stories on the Hackernoon homepage!
103. SQL Recursive Queries - How to Understand Common Table Expressions (CTEs)
This article introduces the WITH clause and demonstrates how recursive CTEs can simplify these operations.
104. How to Simplify Data Flow By Multi-Table Synchronization With Apache SeaTunnel
Apache SeaTunnel multi-table synchronization technology is efficient, real-time, reliable, and flexible, and plays an important role in enterprise data sync.
105. Packages for Store Routines in MariaDB 11.4: What You Need to Know
MariaDB 11.4 introduced support for packages for stored routines. Packages allow you to group related stored procedures, functions, variables, and other element
106. How to Migrate Your Existing MySQL Database to Vitess
A step-by-step guide to migrating a production MySQL database to Vitess using MoveTables, VReplication, and traffic switching with minimal downtime.
107. 3 Ways to Seamlessly Integrate Databend with SeaTunnel for Streaming ETL
Learn three practical methods to integrate Databend with SeaTunnel for scalable, real-time ETL.
108. Are MySQL replications as smooth as you think they are?
What are you actually missing out on in MySQL replication? It appears easy, but to debug the problem caused by it takes a lot of time. So, here's your answer.
109. Sync MySQL Data to S3 in Just 3 Steps Using Apache SeaTunnel
All steps detailed here have been fully tested and are suitable for building a data‑platform scenario based on object storage.
Thank you for checking out the 109 most read blog posts about Mysql on HackerNoon.
Visit the /Learn Repo to find the most read blog posts about any technology.