Skip to content

Blog

The challenges of supporting foreign key constraints
Engineering

The challenges of supporting foreign key constraints

Today, PlanetScale launched support for foreign key constraints. This article covers some of the behind-the-scenes technical challenges we had to overcome to support them.

Shlomi Noach, Manan Gupta
What is HTAP?
Engineering

What is HTAP?

Learn what HTAP is, how HTAP compares to OLAP and OLTP, and some pros and cons of HTAP.

Savannah Longoria
Introducing Insights Anomalies
Product

Introducing Insights Anomalies

This new update to PlanetScale Insights introduces smart query monitoring to detect slower than expected queries in your database.

Rafer Hazen
Webhook security: a hands-on guide
Engineering

Webhook security: a hands-on guide

Learn what went into building PlanetScale webhooks from a security perspective. This article covers SSRF, webhook validation, DDoS, and more.

Mike Coutermarsh
Three surprising benefits of sharding a MySQL database
Engineering

Three surprising benefits of sharding a MySQL database

There is more to sharding than simply increasing data throughput. In this article, we explore three different benefits of sharding your database.

Brian Morrison II
MySQL replication: Best practices and considerations
Engineering

MySQL replication: Best practices and considerations

Learn the best practices for configuring MySQL replication, and how to ensure your data is always available.

Brian Morrison II
A guide to HTML email with Ruby on Rails and Tailwind CSS
Engineering

A guide to HTML email with Ruby on Rails and Tailwind CSS

Learn how to build HTML emails using Rails and Tailwind CSS. We also cover how to overcome some common obstacles such as Gmail message clipping, large file size, Apple autolinking, and more.

Ayrton
PlanetScale ranks 188th in Deloitte’s top 500 fastest-growing companies
Company

PlanetScale ranks 188th in Deloitte’s top 500 fastest-growing companies

We are pleased to announce that PlanetScale has been named on the Deloitte Technology Fast 500™.

Sam Lambert
Announcing Vitess 18
Open source

Announcing Vitess 18

Vitess 18 is now generally available, with a number of new enhancements designed to improve usability, performance, and MySQL compatibility.

Vitess Engineering Team
Announcing the Fivetran integration
Product

Announcing the Fivetran integration

Learn how you can extract, load, and transform your PlanetScale data with Fivetran.

Taylor Barnett, Katie Sipos
Safely dropping MySQL tables
Product

Safely dropping MySQL tables

Learn how to safely drop tables in MySQL by checking if the table is still in use and how PlanetScale makes this process much easier.

David Graham
Introducing webhooks
Product

Introducing webhooks

You can now automatically trigger HTTP callbacks on events in PlanetScale to build custom integrations, notifications, and workflows.

Taylor Barnett, Mike Coutermarsh
What is MySQL replication and when should you use it?
Engineering

What is MySQL replication and when should you use it?

Learn about what database replication is and some real-world use cases of MySQL replication that can benefit your database scalability strategy.

Brian Morrison II
Sync user data between Clerk and a PlanetScale MySQL database
Tutorials

Sync user data between Clerk and a PlanetScale MySQL database

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

Brian Morrison II
Introducing PlanetScale Managed on AWS and GCP
Product

Introducing PlanetScale Managed on AWS and GCP

Deploy PlanetScale in your AWS or GCP account with our Enterprise PlanetScale Managed plan.

James Cunningham
Introducing database reports
Product

Introducing database reports

Bringing weekly reports of the most important parts of your database, straight to your inbox.

Frances Thai
Distributed caching systems and MySQL
Engineering

Distributed caching systems and MySQL

Learn what distributed caching systems are, how they complement MySQL databases, and potential issues you might face when implementing them.

Brian Morrison II
What is MySQL partitioning?
Engineering

What is MySQL partitioning?

Learn the basics of MySQL partitioning, including partitioning with range, list, and key strategies, as well as how partitioning relates to database sharding.

Brian Morrison II
Personalizing your onboarding with Markdoc
Engineering

Personalizing your onboarding with Markdoc

Learn how we utilized Markdoc to create custom, extendable product onboarding at PlanetScale.

Ayrton
PlanetScale is bringing vector search and storage to MySQL
Company

PlanetScale is bringing vector search and storage to MySQL

We are adding vector storage and search to MySQL, enabling you to use PlanetScale for your AI use cases.

Nick Van Wiggeren
PlanetScale Managed is now PCI compliant
Product

PlanetScale Managed is now PCI compliant

PlanetScale Managed on AWS is now PCI compliant.

Frank Fink
How to Scale your Database and when to Shard MySQL
Engineering

How to Scale your Database and when to Shard MySQL

Not sure when to shard your MySQL database? This article covers when you should consider horizontal sharding as a scaling strategy in MySQL and some other scaling options before then.

Jonah Berquist
Scaling hundreds of thousands of database clusters on Kubernetes
Engineering

Scaling hundreds of thousands of database clusters on Kubernetes

Explore what to consider when deploying databases to Kubernetes, and how PlanetScale utilizes Kubernetes and Vitess to run hundreds of thousands of databases.

Brian Morrison II
Streamline database management using the PlanetScale Netlify integration
Product

Streamline database management using the PlanetScale Netlify integration

Learn how to use the new PlanetScale Netlify integration to simplify the process of wiring up a database to your Netlify applications.

Taylor Barnett
Emulating foreign key constraints with Drizzle relationships
Tutorials

Emulating foreign key constraints with Drizzle relationships

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

Brian Morrison II
Horizontal sharding for MySQL made easy
Engineering

Horizontal sharding for MySQL made easy

Historically, there has been the belief that you cannot horizontally scale and shard MySQL, learn how Vitess has made MySQL sharding at the database layer a reality.

Lucy Burns, Taylor Barnett
Deploying multiple schema changes at once
Engineering

Deploying multiple schema changes at once

Why PlanetScale deploys branch changes near-atomically, and how it applies concurrency and dependency resolution without impacting production databases.

Shlomi Noach
What makes up a PlanetScale database?
Product

What makes up a PlanetScale database?

Learn about all of the tech driving every PlanetScale database.

Brian Morrison II
Introducing IP restrictions
Product

Introducing IP restrictions

PlanetScale now supports IP restrictions for database passwords as another tool to operate your database securely.

Iheanyi Ekechukwu, David Graham, Ayrton