Blog
Learn how to solve a tree traversal N+1 query problem in your Rails application. →
Sharding and partitioning are two common ways to improve performance, manageability, and availability of larger databases. →
A detailed description of the multi-layered approach PlanetScale takes to ensure your data is safe. →
Learn the differences between datetimes and timestamps in MySQL, the DATE, YEAR, and TIME columns, timezones, and when to use each. →
Creating generated hash columns in MySQL for faster strict equality lookups. →
Using redundant conditions as a method to unlock obfuscated indexes and improve performance in MySQL. →
Understanding the differences between character sets and collations in MySQL. →
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. →
Learn about safely using the expand, migrate, and contract pattern to make database schema changes without downtime and data loss. →
There are several reasons why MySQL might not consider your index, and in this article we’ll explore some of the most common ones. →
Learn how to create serverless Laravel applications by deploying them to AWS Lambda and using PlanetScale as the database. →
Learn how PlanetScale uses Git-like three-way diff to resolve schema change conflicts across database branches. →
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. →
An overview of the different ways to paginate in MySQL including limit/offset pagination and cursor pagination plus the pros and cons of each. →
Learn what database sharding is, how sharding works, and some common sharding frameworks and tools. →
Learn how to read the output in MySQL EXPLAIN plans so you can utilize them to improve query performance. →
Learn about the Ruby on Rails workflow that protects your database and application from accidental downtime and data loss. →
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. →
Learn how to use PlanetScale within DevOps pipelines. →
JD Lien |
Learn about some of the possible downsides of using database indexes and how to remove unused database indexes in MySQL. →
Learn about sharding, connection pooling, and more from PlanetScale Technical Solutions Architect Jonah Berquist. →
Learn how to solve your Rails applications N+1’s caused by `exists?` queries. →
In this article we explore how our HTTP/3 API compares to the latency of a traditional MySQL client. →
Learn how query planning works and why query planners are important. →
Learn how PlanetScale simplifies the process of running Temporal in production by looking at how our customer runs heavy production workloads. →