109 Blog Posts To Learn About Mysql
Learn everything you need to know about Mysql via these 109 free HackerNoon blog posts.
Discover 109 free online articles to learn about MySQL. The posts are ranked by HackerNoon's reader engagement metrics. MySQL is an open-source relational database management system known for its high performance, dependability, and simplicity in web applications.
1. An introduction to MySQL concepts like one-to-one, one-to-many, many-to-many relationships and nesting.
2. A guide on installing MySQL 8 on macOS using Homebrew.
3. Instructions on how to compress a MySQL dump backup using Gzip.
4. A tutorial on installing and setting up PHP for Apache and MySQL.
5. A strategy for tackling database concurrency issues with TypeORM to address race-condition and deadlock bugs.
6. Recommendations for deep SQL resources to enhance your skills.
7. A breakdown of MySQL data types, focusing on string types.
8. A Docker-based MySQL replication setup guide.
9. A guide on handling JSON in MySQL.
10. An overview of Byzantine Fault Tolerant PostgreSQL and its potential for data-intensive trustless digital infrastructure.
11. Tips and tricks for efficiently generating test data using SQL.
12. A method for detecting and removing emojis in a MySQL table encoded in utf8.
13. The distinction between ENUM, VARCHAR, and INT data types in MySQL.
14. Unexpected findings in TypeORM version 0.3.11, an ORM tool for TypeScript.
15. Steps to deploy Strapi v4 on DigitalOcean App Platform utilizing a MySQL database.
16. A Ruby on Rails project setup guide with MySQL database and GitHub Actions CI configuration.
17. A list of top 10 websites for learning SQL and database management online.
18. An upgrade guide from MySQL 5.5 to MySQL 8.
19. A comparative performance evaluation of GROUP BY queries in MySQL, PostgreSQL, and MS SQL Server.
Written by urgent.news from HackerNoon's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.