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.
How to read MySQL EXPLAINs
Learn how to read the output in MySQL EXPLAIN plans so you can utilize them to improve query performance.
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.
Build a products listing application with Golang and MySQL
Learn how to build a products listing application with Golang and a MySQL database.
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.
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.
Migrating from Postgres to MySQL
Learn how to migrate from Postgres to MySQL, Postgres vs MySQL incompatibilities, and more.
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.
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.
Support’s notes from the field
A quick glimpse on Support at PlanetScale and the issues we see the most often.
Secure your connection string with AWS KMS
Learn how to encrypt your connection strings so that not even AWS can access them.
Introduction to MySQL joins
Learn how and when to use inner joins, outer joins, left joins, and right joins.
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.
Declarative MySQL schemas with Atlas CLI
Learn how to use Atlas CLI with PlanetScale to define your database as code.
Build a multi-stage pipeline with PlanetScale and AWS
Learn how to build an automated DevOps pipeline with AWS Lightsail, CodeBuild, and PlanetScale.
Run SQL script files on a PlanetScale database
Learn how to run commands in batch against a PlanetScale database using the PlanetScale CLI.
Replace your Django database with PlanetScale
Learn how to swap out an existing Django database and replace it with a PlanetScale database.
Connect to a MySQL database in Python
Connect a Python app to MySQL database with mysqlclient, mysql-connector-python, PyMySQL, and aiomysql.
Getting started with the PlanetScale CLI
Learn how to quickly get up and running with the PlanetScale CLI.
How to prevent SQL injection attacks in Node.js
Don’t let SQL injection attacks hurt your business.
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.
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.
How to seed a database with Prisma and Next.js
Use Prisma and Next.js to automatically populate your database with data.
Using the PlanetScale CLI with GitHub Actions workflows
Learn how to build automated workflows to develop and operate PlanetScale databases with GitHub Actions.
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
How to set up Next.js with Prisma and PlanetScale
A step-by-step guide for using PlanetScale and Prisma with Next.js.
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.
Introducing Prisma’s Data Platform PlanetScale integration
Create a PlanetScale database on the Prisma Data Platform; immediately store and query data from the browser
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
Using PlanetScale with JetBrains DataGrip
Connect PlanetScale to JetBrains DataGrip to use database branching, deploy requests, and non-blocking schema changes
Quick deploys using the Web Console
Deploy a TypeScript app using the PlanetScale Vercel integration and Web Console
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.
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.
