Skip to content

BlogTutorials

Sync user data between Clerk and a PlanetScale MySQL database
Tutorials

Sync user data between Clerk and a PlanetScale MySQL database

Learn how to sync user data from a Clerk project into your PlanetScale MySQL database with webhooks using Netlify and Netlify Functions.

Brian Morrison II
Emulating foreign key constraints with Drizzle relationships
Tutorials

Emulating foreign key constraints with Drizzle relationships

Learn how to build virtual relationships between tables in PlanetScale while using the Drizzle TypeScript ORM.

Brian Morrison II
Build a contacts app with Node, Express, and MySQL
Tutorials

Build a contacts app with Node, Express, and MySQL

Learn how to build a contacts web app with Node, Express, and PlanetScale.

Olususi Oluyemi
Build a library app with Laravel 10 and MySQL
Tutorials

Build a library app with Laravel 10 and MySQL

Learn how to build a Laravel application backed by a MySQL PlanetScale database.

Olususi Oluyemi
Build an expense tracker app with Symfony and MySQL
Tutorials

Build an expense tracker app with Symfony and MySQL

Learn how to build a use MySQL with Symfony by building an expense tracking application using a PlanetScale MySQL database.

Olususi Oluyemi
Using PlanetScale with Serverless Framework Node applications on AWS
Tutorials

Using PlanetScale with Serverless Framework Node applications on AWS

Learn how to integrate PlanetScale with Node applications built using the Serverless Framework on AWS.

Matthieu Napoli
Integrate Cloudflare Workers with PlanetScale
Tutorials

Integrate Cloudflare Workers with PlanetScale

A guide on how to natively integrate your PlanetScale database into Cloudflare workers easily and securely.

Brian Morrison II
Build a Rust API with Rocket, Diesel, and MySQL
Tutorials

Build a Rust API with Rocket, Diesel, and MySQL

Learn how to build a Rust API using Rocket, Diesel, and a MySQL database hosted on PlanetScale.

Olususi Oluyemi
How to read MySQL EXPLAINs
Tutorials

How to read MySQL EXPLAINs

Learn how to read the output in MySQL EXPLAIN plans so you can utilize them to improve query performance.

Savannah Longoria
How to upgrade from MySQL 5.7 to 8.0
Tutorials

How to upgrade from MySQL 5.7 to 8.0

Learn what you should look out for when upgrading an existing database from MySQL 5.7 to 8 and how to change your database to be compatible with the new version.

JD Lien
Build a products listing application with Golang and MySQL
Tutorials

Build a products listing application with Golang and MySQL

Learn how to build a products listing application with Golang and a MySQL database.

Olususi Oluyemi
Build a user management API with Nest.js and MySQL
Tutorials

Build a user management API with Nest.js and MySQL

Learn how to build a Nest.js API connect it to a MySQL database add a schema and data and and run database queries.

Olususi Oluyemi
Using MySQL with SQLAlchemy: Hands-on examples
Tutorials

Using MySQL with SQLAlchemy: Hands-on examples

Learn how to using Python SQLAlchemy with MySQL by working through an example of creating tables, inserting data, and querying data with both raw SQL and SQLAlchemy ORM.

Anthony Herbert
Migrating from Postgres to MySQL
Tutorials

Migrating from Postgres to MySQL

Learn how to migrate from Postgres to MySQL Postgres vs MySQL incompatibilities and more.

Adnan Kukic
Common MySQL errors and how to fix them
Tutorials

Common MySQL errors and how to fix them

An overview of some common MySQL error codes you may run into what they mean and how to solve them.

Mary Gathoni
What is the N+1 query problem and how to solve it?
Tutorials

What is the N+1 query problem and how to solve it?

Learn what the N+1 queries problem is by working through an example N+1 query updating it to a JOIN statement and going over how to identify them in the future.

JD Lien
Support’s notes from the field
Tutorials

Support’s notes from the field

A quick glimpse on Support at PlanetScale and the issues we see the most often.

Mike Stojan
Secure your connection string with AWS KMS
Tutorials

Secure your connection string with AWS KMS

Learn how to encrypt your connection strings so that not even AWS can access them.

Brian Morrison II
Introduction to MySQL joins
Tutorials

Introduction to MySQL joins

Learn how and when to use inner joins, outer joins, left joins, and right joins in MySQL.

JD Lien
Using the PlanetScale serverless driver with AWS Lambda functions
Tutorials

Using the PlanetScale serverless driver with AWS Lambda functions

Learn how to use the PlanetScale serverless driver by creating a serverless API in AWS with JavaScript.

Brian Morrison II
Declarative MySQL schemas with Atlas CLI
Tutorials

Declarative MySQL schemas with Atlas CLI

Learn how to use Atlas CLI with PlanetScale to define your database as code.

Brian Morrison II
Build a multi-stage pipeline with PlanetScale and AWS
Tutorials

Build a multi-stage pipeline with PlanetScale and AWS

Learn how to build an automated DevOps pipeline with AWS Lightsail CodeBuild and PlanetScale.

Brian Morrison II
Run SQL script files on a PlanetScale database
Tutorials

Run SQL script files on a PlanetScale database

Learn how to run commands in batch against a PlanetScale database using the PlanetScale CLI.

Brian Morrison II
Replace your Django database with PlanetScale
Tutorials

Replace your Django database with PlanetScale

Learn how to swap out an existing Django database and replace it with a PlanetScale database.

Alex Nnakweu
Connect to a MySQL database in Python
Tutorials

Connect to a MySQL database in Python

Connect a Python app to MySQL database with mysqlclient mysql-connector-python PyMySQL and aiomysql.

Holly Guevara
Getting started with the PlanetScale CLI
Tutorials

Getting started with the PlanetScale CLI

Learn how to quickly get up and running with the PlanetScale CLI.

Brian Morrison II
How to prevent SQL injection attacks in Node.js
Tutorials

How to prevent SQL injection attacks in Node.js

Don’t let SQL injection attacks hurt your business.

James Q Quick
Database schema design 101 for relational databases
Tutorials

Database schema design 101 for relational databases

This database schema design guide walks you through walk through the basics of creating and designing schemas for relational databases.

Camila Ramos
Build a Laravel application with a MySQL database
Tutorials

Build a Laravel application with a MySQL database

Learn how to build a Laravel CRUD application connect it to a MySQL database and seed it with data.

Holly Guevara
How to seed a database with Prisma and Next.js
Tutorials

How to seed a database with Prisma and Next.js

Use Prisma and Next.js to automatically populate your database with data.

James Q Quick