Skip to content

Blog

🚧 Pardon our dust while we transition our blog to our new website.
Faster MySQL with HTTP/3
Product

Faster MySQL with HTTP/3

Join PlanetScale’s Lead Infrastructure Engineer for Edge connectivity for an explainer on our findings regarding HTTP/3 and the MySQL protocol.

Matt Robenolt
Migrating from Postgres to MySQL
Tutorials

Migrating from Postgres to MySQL

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

Adnan Kukic
Introducing the PlanetScale API and OAuth applications
Product

Introducing the PlanetScale API and OAuth applications

Manage your databases programmatically with the PlanetScale API.

Frances Thai, Taylor Barnett
Common MySQL errors and how to fix them
Tutorials

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.

Mary Gathoni
MySQL scaling made easy
Engineering

MySQL scaling made easy

Learn about sharding, connection pooling, and more from PlanetScale Technical Solutions Architect Jonah Berquist.

Jonah Berquist
What is the N+1 Query Problem and How to Solve it?
Tutorials

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.

JD Lien
Support’s notes from the field
Tutorials

Support’s notes from the field

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

Mike Stojan
Solving N+1’s with Rails `exists?` queries
Engineering

Solving N+1’s with Rails `exists?` queries

Learn how to solve your Rails applications N+1’s caused by `exists?` queries.

Mike Coutermarsh
Faster MySQL with HTTP/3
Engineering

Faster MySQL with HTTP/3

In this article we explore how our HTTP/3 API compares to the latency of a traditional MySQL client.

Matt Robenolt
What is a query planner?
Engineering

What is a query planner?

Learn how query planning works and why query planners are important.

Andres Taylor
Temporal workflows at scale: Part 2 — Sharding in production
Engineering

Temporal workflows at scale: Part 2 — Sharding in production

Learn how PlanetScale simplifies the process of running Temporal in production by looking at how our customer runs heavy production workloads.

Savannah Longoria
Rails’ safety mechanisms
Engineering

Rails’ safety mechanisms

A comprehensive overview of Rails’ many safety features that can help you prevent painful mistakes.

Jason Charnes
Building a multi-region Rails application with PlanetScale
Engineering

Building a multi-region Rails application with PlanetScale

Learn how to configure your database in a multi-region Rails application to decrease latency across the globe.

Mike Coutermarsh
Secure your connection string with AWS KMS
Tutorials

Secure your connection string with AWS KMS

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

Brian Morrison II
All of the tech PlanetScale replaces
Product

All of the tech PlanetScale replaces

PlanetScale is more than just a drop-in replacement for MySQL. Learn about everything PlanetScale can do for you

Brian Morrison II
PlanetScale and HIPAA
Company

PlanetScale and HIPAA

PlanetScale can now enter into Business Associate Agreements (BAA) with customers on an Enterprise plan.

Sam Kottler
How PlanetScale Boost serves your SQL queries instantly
Engineering

How PlanetScale Boost serves your SQL queries instantly

Learn how we use a partial materialization engine for database caching alongside your database.

Vicent Marti
Introducing PlanetScale Boost
Product

Introducing PlanetScale Boost

Up to 1 000× faster queries in just a few clicks with our groundbreaking caching technology.

Rick Branson
One million connections
Engineering

One million connections

Learn how to use PlanetScale to safely include your database in your serverless functions without hitting connection limits in MySQL.

Liz van Dijk
MySQL Integers: INT BIGINT and more
Engineering

MySQL Integers: INT BIGINT and more

Gain a deeper understanding of the MySQL integer types by exploring the different options (INT BIGINT MEDIUMINT etc) and how they are stored.

Brian Morrison II
Announcing Vitess 15
Vitess

Announcing Vitess 15

Vitess 15 is now generally available with updates to VTOrc VTAdmin MySQL compatibility and more.

Vitess Engineering Team
What is Vitess: resiliency, scalability, and performance
Vitess

What is Vitess: resiliency, scalability, and performance

Learn what Vitess is, how it works, and how it can improve your database‘s resilience, scalability, and performance.

Brian Morrison II
Laravel’s safety mechanisms
Engineering

Laravel’s safety mechanisms

A comprehensive overview of Laravel’s many safety features that can help you prevent painful mistakes.

Aaron Francis
Optimizing queries in arewefastyet
Vitess

Optimizing queries in arewefastyet

Learn how we detected and optimized two slow queries in arewefastyet using PlanetScale Insights.

Florent Poinsard, Harshit Gangal
Introduction to MySQL joins
Tutorials

Introduction to MySQL joins

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

JD Lien
Indexing JSON in MySQL
Engineering

Indexing JSON in MySQL

Learn how to index JSON in MySQL with generated columns and functional indexes.

Aaron Francis
MySQL data types: VARCHAR and CHAR
Engineering

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.

Brian Morrison II
Debugging database errors with Insights
Product

Debugging database errors with Insights

Learn about the new PlanetScale Insights database errors feature.

Rafer Hazen
The MySQL JSON data type
Engineering

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.

Mike Stojan