Introduction to MySQL joins
Learn how and when to use inner joins, outer joins, left joins, and right joins in MySQL.
Indexing JSON in MySQL
Learn how to index JSON in MySQL with generated columns and functional indexes.
MySQL data types: VARCHAR and CHAR
In this entry of the series we explore using VARCHAR and CHAR data types in your database and give some pointers on which type is best to use and when.
Debugging database errors with Insights
Learn about the new PlanetScale Insights database errors feature.
The MySQL JSON data type
Learn what the MySQL JSON data type is when to use MySQL JSON and some caveats to using JSON documents in relational databases.
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.
TAOBench: Running social media workloads on PlanetScale
Learn how we used TAOBench with PlanetScale to benchmark social media workloads
Gated Deployments: addressing the complexity of schema deployments at scale
We just introduced a new feature Gated Deployments that gives you more control over when your schema changes deploy.
One million queries per second with MySQL
Discover how PlanetScale handles one million queries per second (QPS) with horizontal sharding in MySQL
Zero downtime Laravel migrations
Learn how to run no downtime non-blocking schema migrations in your production Laravel app with PlanetScale.
Run SQL script files on a PlanetScale database
Learn how to run commands in batch against a PlanetScale database using the PlanetScale CLI.
How product design works at PlanetScale
Learn about the lightweight and highly collaborative process our product design team follows to ship quickly at PlanetScale.
Introducing the PlanetScale serverless driver for JavaScript
You can now use PlanetScale in HTTP-only environments like Cloudflare Workers, Vercel Edge Functions, and Netlify Edge Functions.
Introducing FastPage: Faster offset pagination for Rails apps
Introducing FastPage a new gem for ActiveRecord that speeds up deep pagination queries.
How to kill Sidekiq jobs in Ruby on Rails
Learn how PlanetScale uses a custom middleware to kill our Sidekiq jobs in production without relying on deploys.
Replace your Django database with PlanetScale
Learn how to swap out an existing Django database and replace it with a PlanetScale database.
Database DevOps
Learn how PlanetScale enables databases to seamlessly fit into the DevOps lifecycle.
Connect to a MySQL database in Python
Connect a Python app to MySQL database with mysqlclient mysql-connector-python PyMySQL and aiomysql.
How PlanetScale prevents MySQL downtime
Learn how PlanetScale protects against downtime due to human error system immaturity and app issues.
Ruby on Rails: 3 tips for deleting data at scale
Learn how to delete data in large Rails apps with destroy_async delete destroy and scheduled cron jobs.
The Slotted Counter Pattern
Handle MySQL increment counter bursts with the Slotted Counter Pattern
Behind the scenes: How we built Password Roles
Learn how we leveraged Vitess ACLs and VTTablet to build our password roles functionality
Temporal Workflows at scale with PlanetScale: Part 1
Learn how to create a more reliable workflow with Temporal and PlanetScale
Announcing Teams: An easier way to manage database administrator access
Learn how you can manage database access with Teams and Directory Sync
We now display PlanetScale system status directly in your dashboard
Learn about how we built the new in-app system status using Vercel edge functions and StatusPage
How do database indexes work?
Learn how database indexes work under the hood and how they can be used to speed up queries
Getting started with the PlanetScale CLI
Learn how to quickly get up and running with the PlanetScale CLI.