Emulating foreign key constraints with Drizzle relationships
Learn how to build virtual relationships between tables in PlanetScale while using the Drizzle TypeScript ORM.
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.
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.
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.
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.
Using the PlanetScale CLI with GitHub Actions workflows
Learn how to build automated workflows to develop and operate PlanetScale databases with GitHub Actions.
How to set up Next.js with Prisma and PlanetScale
A step-by-step guide for using PlanetScale and Prisma with Next.js.
Introducing Prisma’s Data Platform PlanetScale integration
Create a PlanetScale database on the Prisma Data Platform; immediately store and query data from the browser
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.
