Blog

By Brian Morrison II | October 20, 2023

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

By Brian Morrison II | September 6, 2023

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

By Matthieu Napoli | June 13, 2023

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

By Brian Morrison II | May 17, 2023

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

By Brian Morrison II | April 5, 2023

Learn how the schema migrations are performed iteratively by evolving change scripts. →

By Brian Morrison II | April 5, 2023

Learn how the schema migrations are performed using a single state definition. →

By JD Lien | March 24, 2023

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. →

By Anthony Herbert | March 7, 2023

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

By Adnan Kukic | February 9, 2023

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

By Mary Gathoni | January 27, 2023

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

By JD Lien | January 18, 2023

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. →

By Mike Stojan | January 11, 2023

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

By Brian Morrison II | December 7, 2022

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

By JD Lien | October 7, 2022

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

By Brian Morrison II | September 21, 2022

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

By Brian Morrison II | September 16, 2022

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

By Brian Morrison II | September 13, 2022

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

By Brian Morrison II | August 25, 2022

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

By Brian Morrison II | July 12, 2022

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

By James Q Quick | March 3, 2022

Don’t let SQL injection attacks hurt your business. →

By Camila Ramos | March 2, 2022

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

By Holly Guevara | February 15, 2022

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

By James Q Quick | February 11, 2022

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

By Taylor Barnett | February 3, 2022

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

By Camila Ramos | January 20, 2022

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