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
April 27, 2023
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
March 29, 2023
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
March 24, 2023
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
March 17, 2023
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
March 13, 2023
Using MySQL with SQLAlchemy: Hands-on examples
Tutorials

Using MySQL with SQLAlchemy: Hands-on examples

Learn how to using 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
March 7, 2023
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.

Ado Kukic
February 9, 2023
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
January 27, 2023
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
January 18, 2023
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
January 11, 2023
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
December 7, 2022
Introduction to MySQL joins
Tutorials

Introduction to MySQL joins

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

JD Lien
October 7, 2022
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
September 21, 2022
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
September 16, 2022
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
September 13, 2022
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
August 25, 2022
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
August 11, 2022
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
August 4, 2022
Getting started with the PlanetScale CLI
Product

Getting started with the PlanetScale CLI

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

Brian Morrison II
July 12, 2022
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
March 3, 2022
Schema design 101 for relational databases
Tutorials

Schema design 101 for relational databases

Whether you’re coming from a NoSQL background or have never used a database, we’ll walk through the basics of relational database schema design.

Camila Ramos
March 2, 2022
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
February 15, 2022
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
February 11, 2022
Using the PlanetScale CLI with GitHub Actions workflows
Tutorials

Using the PlanetScale CLI with GitHub Actions workflows

Learn how to build automated workflows to develop and operate PlanetScale databases with GitHub Actions.

Taylor Barnett
February 3, 2022
Create a Harry Potter API with Node.js/Express, MySQL, and PlanetScale
Tutorials

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

Learn how to build a Harry Potter API using Node.js, Express, and PlanetScale

James Q Quick
January 26, 2022
How to set up Next.js with Prisma and PlanetScale
Tutorials

How to set up Next.js with Prisma and PlanetScale

A step-by-step guide for using PlanetScale and Prisma with Next.js.

Camila Ramos
January 20, 2022
Deploy your Dusty Domains for good with Netlify
Tutorials

Deploy your Dusty Domains for good with Netlify

Deploy your forgotten domains in the month of December for a good cause with Netlify and friends.

Taylor Barnett
December 1, 2021
Introducing Prisma’s Data Platform PlanetScale integration
Tutorials

Introducing Prisma’s Data Platform PlanetScale integration

Create a PlanetScale database on the Prisma Data Platform; immediately store and query data from the browser

Taylor Barnett
November 18, 2021
Building a Next.js app with Netlify, NextAuth.js, Prisma, and a PlanetScale serverless database
Tutorials

Building a Next.js app with Netlify, NextAuth.js, Prisma, and a PlanetScale serverless database

A new dynamic Next.js starter app with authentication and PlanetScale built-in, ready to be deployed to Netlify

Taylor Barnett
November 15, 2021
Using PlanetScale with JetBrains DataGrip
Tutorials

Using PlanetScale with JetBrains DataGrip

Connect PlanetScale to JetBrains DataGrip to use database branching, deploy requests, and non-blocking schema changes

Taylor Barnett
October 4, 2021
Quick deploys using the Web Console
Tutorials

Quick deploys using the Web Console

Deploy a TypeScript app using the PlanetScale Vercel integration and Web Console

Elom Gomez
September 13, 2021
Integrating PlanetScale with Vercel in a few steps
Tutorials

Integrating PlanetScale with Vercel in a few steps

Together, Vercel and PlanetScale combine a serverless platform with a scalable and easy-to-use database, providing an incredible development experience with limitless scale.

Nick Van Wiggeren
July 1, 2021
MySQL semi-sync replication: durability, consistency and split brains
Tutorials

MySQL semi-sync replication: durability, consistency and split brains

We look at some basics and follow up to present scenarios that require higher level intervention to ensure availability and to avoid split brains from taking place.

Shlomi Noach
October 2, 2020