Blog
By Matt Lord |
Learn the main differences between MariaDB and MySQL, why you might choose one over the other, scaling options, and how Vitess fits into the picture. →
By Taylor Barnett |
Learn about safely using the expand, migrate, and contract pattern to make database schema changes without downtime and data loss. →
By Aaron Francis |
There are several reasons why MySQL might not consider your index, and in this article we’ll explore some of the most common ones. →
By Matthieu Napoli |
Learn how to create serverless Laravel applications by deploying them to AWS Lambda and using PlanetScale as the database. →
By Shlomi Noach |
Learn how PlanetScale uses Git-like three-way diff to resolve schema change conflicts across database branches. →
By Aaron Francis |
Everything you need to know about MySQL as an application developer, with a focus on improving query performance. After covering the high-level overview, we’ll put the learnings to the test with some hands-on examples. →
By Aaron Francis |
An overview of the different ways to paginate in MySQL including limit/offset pagination and cursor pagination plus the pros and cons of each. →
By Justin Gage |
Learn what database sharding is, how sharding works, and some common sharding frameworks and tools. →
By Savannah Longoria |
Learn how to read the output in MySQL EXPLAIN plans so you can utilize them to improve query performance. →
By Mike Coutermarsh |
Learn about the Ruby on Rails workflow that protects your database and application from accidental downtime and data loss. →
By Savannah Longoria |
What does the MySQL 5.7 EOL means for your database? Learn considerations to upgrade 8.0 and how PlanetScale can help you upgrade with no downtime or data loss. →
By JD Lien |
Learn about some of the possible downsides of using database indexes and how to remove unused database indexes in MySQL. →
By Jonah Berquist |
Learn about sharding, connection pooling, and more from PlanetScale Technical Solutions Architect Jonah Berquist. →
By Mike Coutermarsh |
Learn how to solve your Rails applications N+1’s caused by `exists?` queries. →
By Matt Robenolt |
In this article we explore how our HTTP/3 API compares to the latency of a traditional MySQL client. →
By Savannah Longoria |
Learn how PlanetScale simplifies the process of running Temporal in production by looking at how our customer runs heavy production workloads. →
By Jason Charnes |
A comprehensive overview of Rails’ many safety features that can help you prevent painful mistakes. →
By Mike Coutermarsh |
Learn how to configure your database in a multi-region Rails application to decrease latency across the globe. →
By Liz van Dijk |
Learn how to use PlanetScale to safely include your database in your serverless functions without hitting connection limits in MySQL. →
By Brian Morrison II |
Gain a deeper understanding of the MySQL integer types by exploring the different options (INT BIGINT MEDIUMINT etc) and how they are stored. →
By Aaron Francis |
A comprehensive overview of Laravel’s many safety features that can help you prevent painful mistakes. →
By Aaron Francis |
Learn how to index JSON in MySQL with generated columns and functional indexes. →
By Brian Morrison II |
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. →