Best of MySQL — March 2024

1. 1
   Video

   Community Picks·2y

   Stop using COUNT(id) to count rows

   Counting rows using COUNT(*) in MySQL is not slow as often believed. It is actually optimized to be the fastest way to count rows.

   790

   27
2. 2
   Article

   PlanetScale·2y

   The problem with using a UUID primary key in MySQL

   Learn about the downsides of using UUIDs as a primary key in your MySQL database, including insert performance and higher storage utilization. Discover best practices for minimizing the negative impacts and explore alternative ID types.

   27
3. 3
   Article

   Community Picks·2y

   Migrate Next.js app away from "Vercel + PlanetScale" to "Fly.io"

   Learn how to migrate a Next.js app from Vercel + PlanetScale to Fly.io. The article provides a step-by-step guide on deploying the app and MySQL database to Fly.io. It also explains how to set up Cloudflare for non-www to www redirection.

   19

   2
4. 4
   Article

   AWS in Plain English·2y

   Lamp Stack Implementation on AWS (Linux, Apache, MySQL, and PHP.)

   This post provides a step-by-step guide on implementing the LAMP stack on AWS using Linux, Apache, MySQL, and PHP. It includes instructions on installing Apache web server, setting up a virtual host, and configuring PHP. The post also explains what a web stack is and the components of the LAMP stack. The instructions are beginner-friendly and assume the use of an Ubuntu server.

   12