--- title: Best MySQL posts of 2022 | daily.dev description: The most upvoted MySQL posts of 2022, curated by the daily.dev community. canonical: https://daily.dev/tags/mysql/best-of/2022 twitter:card: summary_large_image twitter:site: @dailydotdev og:url: https://daily.dev/tags/mysql/best-of/2022 og:type: website og:site_name: daily.dev og:title: Best MySQL posts of 2022 | daily.dev og:description: The most upvoted MySQL posts of 2022, curated by the daily.dev community. og:image: https://media.daily.dev/image/upload/s--VAY5ToZt--/f_auto/v1724209435/public/daily.dev%20-%20open%20graph --- # Best of MySQL — 2022 1. 1 [](/posts/dockerizing-full-stack-react-apps-2wsiovxvh "Dockerizing Full-Stack React apps") Article asayer · 4y Dockerizing Full-Stack React apps Using infrastructures such as Docker and Containers gives a developer an upper hand to quickly set up and deploy applications. Containers are lightweight operating systems that run as a form of virtualization. 110 5 2. 2 [](/posts/dolt---a-sql-database-that-works-like-git-6gp5mgsck "Dolt - A SQL Database that Works like Git") Article Honeypot · 4y Dolt - A SQL Database that Works like Git Dolt is an SQL-based database that allows you to maintain your database like Git repositories. It combines all the great features of Git and SQL in order to give you an amazing experience. Dolt comes with a powerful CLI similar to Git, and you can apply your knowledge in Git to easily commit, merge, and push database changes. Earn Money from DoltHub Data Bounties. 98 6 3. 3 [](/posts/building-a-scalable-notification-service-zghziuwzk "Building a Scalable Notification Service") Article Quastor Daily · 4y Building a Scalable Notification Service Razorpay is one of India’s most valuable fintech startups. The company powers payments for over 8 million businesses in India and has been growing extremely quickly. With the increase in transactions, the Razorpay team encountered a few scalability issues - Database Bottleneck - Read query performance was getting worse and it couldn’t scale to meet the required input/output operations per second. 96 2 4. 4 [](/posts/mikeroyal-self-hosting-guide-self-hosting-guide-learn-all-about-locally-hosting-on-premises-priv-ew-m8pbvf "mikeroyal/Self-Hosting-Guide: Self-Hosting Guide. Learn all about locally hosting(on premises & private web servers) and managing software applications by yourself or your organization.") Article Pointer · 4y mikeroyal/Self-Hosting-Guide: Self-Hosting Guide. Learn all about locally hosting(on premises & private web servers) and managing software applications by yourself or your organization. Most self-hosted software can be installed using Docker, a packaging system which allows software to bundle their configuration and dependencies. Shipwright is a WebUI to generate templates for Yacht, Portainer, Docker-Compose, and Unraid. Dozzle is a small lightweight application with a web based interface to monitor Docker logs. Diun is a tool that receive notifications when a Docker image is updated. 82 4 5. 5 [](/posts/the-architecture-of-facebook-s-distributed-message-queue-sedbpskzc "The Architecture of Facebook's Distributed Message Queue") Article Quastor Daily · 4y The Architecture of Facebook's Distributed Message Queue Facebook Ordered Queue Service (FOQS) is an internal Facebook tool that fills that role. FOQS provides an API that consists of the following operations - Enqueue - Add an item Dequeue The dequeue API accepts a collection of (topic, count) pairs where count represents the number of items to return from the topic. 81 2 6. 6 [](/posts/database-guis-in-javascript-ho-pky1po "Database GUIs in JavaScript") Article DEV · 4y Database GUIs in JavaScript Traditional tools are often written in Java, C++ or Delphi and they use good old JDBC, ODBC or ADO.NET drivers for accessing database. Almost all tools are open-source. If you know about other tool not listed in this article, you could write about it in comments below. For SQLlite I actually use Firefox. 80 2 7. 7 [](/posts/how-i-became-a-better-cto-using-these-8-resources-j2o4gff70 "How I became a better CTO using these 8 resources") Article EverSQL · 4y How I became a better CTO using these 8 resources Google offers 25 lessons, 30+ exercises, real case studies, and lectures from Google experts. The SaaS CTO Security Checklist provides actionable security best practices CTOs can use to harden their security. JavaScript is a bird's eye view of JavaScript, its benefits, patterns, and more. 62 8. 8 [](/posts/creating-dashboards-in-react-with-react-dashboard-y2aac32xp "Creating dashboards in React with React Dashboard") Article LogRocket · 5y Creating dashboards in React with React Dashboard The Flatologic dashboard template is built with React, Bootstrap, React Router, Redux, and GraphQL. It comes with a React frontend and a Node.js backend. This tutorial will cover how to create a dashboard in three easy steps. We will connect it to an SQL database with MAMP so you have some local data. 54 2 9. 9 [](/posts/dolthub-dolt-dolt-it-s-git-for-data-qnjsevmfa "dolthub/dolt: Dolt – It's Git for Data") Article Hacker News · 4y dolthub/dolt: Dolt – It's Git for Data Dolt is a single 68 megabyte program. It can be used to run queries or update the data using SQL commands. All the commands you know for Git work exactly the same for Dolt. We also built DoltHub, a place to share Dolt databases. If you want to host your own version of Dolt, we have DoltLab. 48 1 10. 10 [](/posts/forge-dark-mode-mjqk99qhn "Forge: Dark Mode") Article Laravel · 4y Forge: Dark Mode dark mode can be toggled between light, dark, or automatically switch between modes. We're releasing dark mode as a beta feature and will continue to improve it based on your feedback. If you don’t have a Forge account, now is a great time to sign up! 39 11. 11 [](/posts/the-right-database-for-you-project-s-success-uoilvmmq6 "The Right Database for You Project's Success") Article DZone · 4y The Right Database for You Project's Success The Right Database for You Project's Success Maximize Your Project's success with the Right Database Selection Learn the key considerations for choosing the right database for your project. The database management system is chosen depending on the tasks of the business. 30 3 12. 12 [](/posts/mariadb-vs-mysql-iufefpzra "MariaDB vs. MySQL") Article SingleStore · 4y MariaDB vs. MySQL MariaDB is an open-source Relational Database Management System (RDBMS) MariaDB is gaining popularity due to its flexibility and availability. MariaDB has made significant progress in the areas of scalability and reliability, and has emerged as a competitor to MySQL. 29 1 13. 13 [](/posts/how-we-simplified-mysql-tuning-to-improve-laravel-performance-ioc8ejy-q "How we simplified MySQL Tuning to improve Laravel Performance") Article Community Picks · 4y How we simplified MySQL Tuning to improve Laravel Performance The Releem - MySQL Performance Tuning is the first step before optimizing code to improve the performance of web applications. It is faster than optimizing and testing source code. Before you start tuning, you should read the documentation, "best practices", and check the efficiency of your current MySQL configuration. 28 1 14. 14 [](/posts/5-ways-to-rapidly-improve-mysql-database-performance-o4h-s8w8h "5 ways to rapidly improve MySQL database performance") Article LogRocket · 4y 5 ways to rapidly improve MySQL database performance The database management system can support all kinds of projects, from gaming forums to healthcare solutions. Improving database performance is also something that every DBA struggles with at some point in their career. 26 15. 15 [](/posts/mgramin-awesome-db-tools-everything-that-makes-working-with-databases-easier-jonx8nluh "mgramin/awesome-db-tools: Everything that makes working with databases easier") Article Changelog · 4y mgramin/awesome-db-tools: Everything that makes working with databases easier Awesome Database Tools is a community driven list of database tools that simplify working with databases for DBA, DevOps, Developers and mere mortals. Feel free to add information about your own db-tools or your favorite third-party db- tools. For updates on awesome-db-tools and thoughts/news about databases/tools/SQL follow me at @GraminMaksim. 26 1 16. 16 [](/posts/what-is-a-query-planner--zaypomoap "What is a query planner?") Article PlanetScale · 4y What is a query planner? queries with lots of tables and lots of indexes can quickly run into the thousands and even millions of alternatives. Choosing the right indexes to use, and the right order to fetch data in, proves to be the difference between a 10ms and 5s query. The planner's job is to find the best possible query plan among all possibilities. 21 17. 17 [](/posts/3-reasons-why-your-mysql-database-needs-redis-zffk1ub-y "3 Reasons Why Your MySQL Database Needs Redis") Article Redis · 4y 3 Reasons Why Your MySQL Database Needs Redis Redis Enterprise is a free, free, open source database solution until… it isn’t. It’s very common for products and services to eventually run into issues with performance, scaling, and innovating outside of the rigid SQL-based environment. 20 1 18. 18 [](/posts/creating-dashboards-in-react-using-react-dashboards-bfh3lx0gy "Creating Dashboards in React using React Dashboards") Article Section · 5y Creating Dashboards in React using React Dashboards React Dashboard is a free and premium dashboard template from Flatologic. It is built with React, Bootstrap, React Router, Redux, and GraphQL. It comes with a React frontend and a Node.js backend. This tutorial will cover how to create a dashboard in three easy steps. Then, we will connect it to an SQL database with MAMP. 20 1 19. 19 [](/posts/how-canva-stores-tens-of-billions-of-user-generated-media-kz5uxlatg "How Canva Stores Tens of Billions of User Generated Media") Article Quastor Daily · 4y How Canva Stores Tens of Billions of User Generated Media How Canva Stores Tens of Billions of User Generated Media Canva is an online design platform with tens of millions of users. The company has more than 100 million monthly active users, who collectively upload more than 50 million new pieces of media (pictures, videos, logos, etc.) every day. 19 20. 20 [](/posts/what-is-an-orm-the-meaning-of-object-relational-mapping-database-tools--d7g39lbr "What is an ORM – The Meaning of Object Relational Mapping Database Tools") Article freeCodeCamp · 4y What is an ORM – The Meaning of Object Relational Mapping Database Tools Object Relational Mapping (ORM) is a technique used in creating a "bridge" between object-oriented programs and relational databases. The ORM and ORM tools help simplify the interaction between relational databases and different OOP languages. The tools are built to eliminate the possibility of SQL injection attacks. 19 21. 21 [](/posts/turns-any-mysql-postgres-sqlite-into-a-spreadsheet-with-rest-apis--5nc07iuw8 "turns any MySQL, Postgres, SQLite into a spreadsheet with REST APIs.") Article Pointer · 5y turns any MySQL, Postgres, SQLite into a spreadsheet with REST APIs. NocoDB turns any database into a smart-spreadsheet. It uses Docker, Git, Npm, Slack, Reddit, and Twitter. NocoDB can search, sort, filter, hide columns with uber ease. It can also upload images to cells (Works with S3, Minio, GCP, Azure, DigitalOcean, Linode, OVH, BackBlaze) 18 22. 22 [](/posts/monitor-your-databases-with-this-open-source-tool-ucrgzitih "Monitor your databases with this open source tool") Article Open Source Way · 5y Monitor your databases with this open source tool Percona Monitoring and Measurement (PMM) is an open source solution for all three databases. The documentation is well written, detailed, and handy. The software itself is easy to obtain and install. PMM is only monitoring the underlying system and the database it uses for gathering statistics. 16 1 23. 23 [](/posts/mysql-packet-injection-a2pthvoli "MySQL Packet Injection") Article System Weakness · 4y MySQL Packet Injection I recommend to everyone this tool the best for network attacks. It gives many errors with issues of versions and Python libraries, the creators recommend using Python 3.7.7. 15 24. 24 [](/posts/speed-up-database-queries-mysql-fkp28m9ec "Speed Up Database Queries MySQL") Article SingleStore · 4y Speed Up Database Queries MySQL The airportdb database is 2GB in size and consists of 14 tables containing a total of 55,983,205 records. You must execute the EXPLAIN command on the query that you want to optimize. 14 25. 25 [](/posts/detailed-way-to-implement-mysql-in-nestjs-xqlwaoh5p "Detailed Way To Implement MySQL In NestJS") Article Community Picks · 4y Detailed Way To Implement MySQL In NestJS NestJS is a framework for building scalable Node.js server-side applications. It combines the support for Object-Oriented Programming (OOP), Functional Programming (FP) and Functional Reactive Programming (FRP) NestJS has full TypeScript support and uses it primarily, but users can also use JavaScript. For a read operation let’s create getUsers() method. 14 [See all MySQL archives](/tags/mysql/best-of) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@graph":[{"@type":"CollectionPage","@id":"https://daily.dev/tags/mysql/best-of/2022#page","url":"https://daily.dev/tags/mysql/best-of/2022","name":"Best MySQL Posts of 2022","description":"The most upvoted MySQL posts of 2022, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/tags/mysql/best-of/2022#items","numberOfItems":25,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/dockerizing-full-stack-react-apps-2wsiovxvh","name":"Dockerizing Full-Stack React apps"},{"@type":"ListItem","position":2,"url":"https://daily.dev/posts/dolt---a-sql-database-that-works-like-git-6gp5mgsck","name":"Dolt - A SQL Database that Works like Git"},{"@type":"ListItem","position":3,"url":"https://daily.dev/posts/building-a-scalable-notification-service-zghziuwzk","name":"Building a Scalable Notification Service"},{"@type":"ListItem","position":4,"url":"https://daily.dev/posts/mikeroyal-self-hosting-guide-self-hosting-guide-learn-all-about-locally-hosting-on-premises-priv-ew-m8pbvf","name":"mikeroyal/Self-Hosting-Guide: Self-Hosting Guide. Learn all about locally hosting(on premises & private web servers) and managing software applications by yourself or your organization."},{"@type":"ListItem","position":5,"url":"https://daily.dev/posts/the-architecture-of-facebook-s-distributed-message-queue-sedbpskzc","name":"The Architecture of Facebook's Distributed Message Queue"},{"@type":"ListItem","position":6,"url":"https://daily.dev/posts/database-guis-in-javascript-ho-pky1po","name":"Database GUIs in JavaScript"},{"@type":"ListItem","position":7,"url":"https://daily.dev/posts/how-i-became-a-better-cto-using-these-8-resources-j2o4gff70","name":"How I became a better CTO using these 8 resources"},{"@type":"ListItem","position":8,"url":"https://daily.dev/posts/creating-dashboards-in-react-with-react-dashboard-y2aac32xp","name":"Creating dashboards in React with React Dashboard"},{"@type":"ListItem","position":9,"url":"https://daily.dev/posts/dolthub-dolt-dolt-it-s-git-for-data-qnjsevmfa","name":"dolthub/dolt: Dolt – It's Git for Data"},{"@type":"ListItem","position":10,"url":"https://daily.dev/posts/forge-dark-mode-mjqk99qhn","name":"Forge: Dark Mode"},{"@type":"ListItem","position":11,"url":"https://daily.dev/posts/the-right-database-for-you-project-s-success-uoilvmmq6","name":"The Right Database for You Project's Success"},{"@type":"ListItem","position":12,"url":"https://daily.dev/posts/mariadb-vs-mysql-iufefpzra","name":"MariaDB vs. MySQL"},{"@type":"ListItem","position":13,"url":"https://daily.dev/posts/how-we-simplified-mysql-tuning-to-improve-laravel-performance-ioc8ejy-q","name":"How we simplified MySQL Tuning to improve Laravel Performance"},{"@type":"ListItem","position":14,"url":"https://daily.dev/posts/5-ways-to-rapidly-improve-mysql-database-performance-o4h-s8w8h","name":"5 ways to rapidly improve MySQL database performance"},{"@type":"ListItem","position":15,"url":"https://daily.dev/posts/mgramin-awesome-db-tools-everything-that-makes-working-with-databases-easier-jonx8nluh","name":"mgramin/awesome-db-tools: Everything that makes working with databases easier"},{"@type":"ListItem","position":16,"url":"https://daily.dev/posts/what-is-a-query-planner--zaypomoap","name":"What is a query planner?"},{"@type":"ListItem","position":17,"url":"https://daily.dev/posts/3-reasons-why-your-mysql-database-needs-redis-zffk1ub-y","name":"3 Reasons Why Your MySQL Database Needs Redis"},{"@type":"ListItem","position":18,"url":"https://daily.dev/posts/creating-dashboards-in-react-using-react-dashboards-bfh3lx0gy","name":"Creating Dashboards in React using React Dashboards"},{"@type":"ListItem","position":19,"url":"https://daily.dev/posts/how-canva-stores-tens-of-billions-of-user-generated-media-kz5uxlatg","name":"How Canva Stores Tens of Billions of User Generated Media"},{"@type":"ListItem","position":20,"url":"https://daily.dev/posts/what-is-an-orm-the-meaning-of-object-relational-mapping-database-tools--d7g39lbr","name":"What is an ORM – The Meaning of Object Relational Mapping Database Tools"},{"@type":"ListItem","position":21,"url":"https://daily.dev/posts/turns-any-mysql-postgres-sqlite-into-a-spreadsheet-with-rest-apis--5nc07iuw8","name":"turns any MySQL, Postgres, SQLite into a spreadsheet with REST APIs."},{"@type":"ListItem","position":22,"url":"https://daily.dev/posts/monitor-your-databases-with-this-open-source-tool-ucrgzitih","name":"Monitor your databases with this open source tool"},{"@type":"ListItem","position":23,"url":"https://daily.dev/posts/mysql-packet-injection-a2pthvoli","name":"MySQL Packet Injection"},{"@type":"ListItem","position":24,"url":"https://daily.dev/posts/speed-up-database-queries-mysql-fkp28m9ec","name":"Speed Up Database Queries MySQL"},{"@type":"ListItem","position":25,"url":"https://daily.dev/posts/detailed-way-to-implement-mysql-in-nestjs-xqlwaoh5p","name":"Detailed Way To Implement MySQL In NestJS"}]},{"@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Tags","item":"https://daily.dev/tags"},{"@type":"ListItem","position":3,"name":"MySQL","item":"https://daily.dev/tags/mysql"},{"@type":"ListItem","position":4,"name":"Best of","item":"https://daily.dev/tags/mysql/best-of"},{"@type":"ListItem","position":5,"name":"2022"}]}]} ```