Build a Random Quote Machine with Nextjs, PlanetScale MySQL, and Drizzle ORM

Learn to build a random quote machine using Next.js, PlanetScale MySQL, and Drizzle ORM in this comprehensive tutorial. Set up a MySQL database on PlanetScale, connect to and query it using Drizzle ORM, and develop a Next.js frontend with API routes. Follow along as the instructor guides you through creating and populating database tables, generating schemas automatically, implementing library functions for data retrieval, and constructing API routes. By the end of this 51-minute video, you'll have created a fully functional random quote machine, gaining valuable experience in integrating these powerful technologies.

Intro
Welcome
PlanetScale
Create a MySQL database
Create & populate the tables
Promote the branch to production
Get connection credentials
Creating the Next.js project
Getting started with Drizzle
Introspect for automatic schema generation
Create library functions to retrieve the data
Next.js API Routes
Next.js Random Quote Machine