Blog
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 Vicent Marti |
Learn how we use a partial materialization engine for database caching alongside your database. →
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. →
By Mike Stojan |
Learn what the MySQL JSON data type is when to use MySQL JSON and some caveats to using JSON documents in relational databases. →
By Jonah Berquist |
Discover how PlanetScale handles one million queries per second (QPS) with horizontal sharding in MySQL →
By Holly Guevara |
Learn how to run no downtime non-blocking schema migrations in your production Laravel app with PlanetScale. →
By Jason Long |
Learn about the lightweight and highly collaborative process our product design team follows to ship quickly at PlanetScale. →
By Mike Coutermarsh |
Introducing FastPage a new gem for ActiveRecord that speeds up deep pagination queries. →