Emulating foreign key constraints with Drizzle relationships
Learn how to build virtual relationships between tables in PlanetScale while using the Drizzle TypeScript ORM.
Build a contacts app with Node, Express, and MySQL
Learn how to build a contacts web app with Node, Express, and PlanetScale.
Build a library app with Laravel 10 and MySQL
Learn how to build a Laravel application backed by a MySQL PlanetScale database.
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.
Using PlanetScale with Serverless Framework Node applications on AWS
Learn how to integrate PlanetScale with Node applications built using the Serverless Framework on AWS.
Integrate Cloudflare Workers with PlanetScale
A guide on how to natively integrate your PlanetScale database into Cloudflare workers easily and securely.
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 Python 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 in MySQL.
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.
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.
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.