Build a Harry Potter API with Node.js/Express, MySQL, and PlanetScale

Let's create an API in Node.js using Express, MySQL2, and PlanetScale. We'll start by setting up a new Database in PlanetScale and then seed it with Harry Potter character and wand data. Then, we'll create endpoints in Express to expose that data to API consumers.

Final Source Code (with seed scripts) - https://github.com/jamesqquick/node-express-planetscale-and-harry-potter
MySQL2 Package - https://www.npmjs.com/package/mysql2
Existing Harry Potter API - https://hp-api.herokuapp.com/

00:00 - Intro
00:40 - What We’ll Build
01:20 - Database Setup
02:15 - Project Setup
05:50 - Connect to MySQL in Node.js with PlanetScale Password
06:40 - Seed the Database with Harry Potter Data
08:57 - Create Harry Potter Character Endpoints
15:30 - Create Harry Potter Wand Endpoints
16:13 - Add Error Handling
19:00 - Wrap Up

📚 Learn more about PlanetScale
• Website: https://planetscale.com/
• Docs: https://docs.planetscale.com/

——————————————————

💬 Follow PlanetScale on social media
• Twitter: https://twitter.com/planetscale
• TikTok: https://www.tiktok.com/@planetscale
• Twitch: https://www.twitch.tv/planetscale
• LinkedIn: https://www.linkedin.com/company/planetscale/

Видео Build a Harry Potter API with Node.js/Express, MySQL, and PlanetScale канала PlanetScale