Blog
Get the RSS feedJD Lien |
Learn about some of the possible downsides of using database indexes and how to remove unused database indexes in MySQL. →
Join PlanetScale’s Lead Infrastructure Engineer for Edge connectivity for an explainer on our findings regarding HTTP/3 and the MySQL protocol. →
Learn how to migrate from Postgres to MySQL, Postgres vs MySQL incompatibilities, and more. →
An overview of some common MySQL error codes you may run into, what they mean, and how to solve them. →
Learn about sharding, connection pooling, and more from PlanetScale Technical Solutions Architect Jonah Berquist. →
JD Lien |
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. →
A quick glimpse on Support at PlanetScale and the issues we see the most often. →
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. →
A comprehensive overview of Rails’ many safety features that can help you prevent painful mistakes. →
Learn how to configure your database in a multi-region Rails application to decrease latency across the globe. →
Learn how to encrypt your connection strings so that not even AWS can access them. →
PlanetScale Vitess is more than just a drop-in replacement for MySQL. Learn about everything PlanetScale can do for you. →
PlanetScale can now enter into Business Associate Agreements (BAA) with customers on an Enterprise plan. →
Learn how to use PlanetScale to safely include your database in your serverless functions without hitting connection limits in MySQL. →
Gain a deeper understanding of the MySQL integer types by exploring the different options (INT BIGINT MEDIUMINT etc) and how they are stored. →
Vitess 15 is now generally available with updates to VTOrc, VTAdmin, MySQL compatibility, and more. →
Learn what Vitess is, how it works, and how it can improve your database‘s resilience, scalability, and performance. →
A comprehensive overview of Laravel’s many safety features that can help you prevent painful mistakes. →
Florent Poinsard, Harshit Gangal |
Learn how we detected and optimized two slow queries in arewefastyet using PlanetScale Insights. →
JD Lien |
Learn how and when to use inner joins, outer joins, left joins, and right joins in MySQL. →
Learn how to index JSON in MySQL with generated columns and functional indexes. →