Safely making database schema changes
How to prevent schema changes from being scary with database best practices and PlanetScale.
What is database sharding and how does it work?
Learn what databse sharding is, how sharding works, and some common sharding frameworks and tools.
An update to our workflow: safe migrations
Learn about our latest update safe migrations and how it affects our branching workflow.
Announcing the PlanetScale GitHub Actions
Easily integrate common PlanetScale operations directly into your GitHub Actions Workflows.
How to read MySQL EXPLAINs
Learn how to read the output in MySQL EXPLAIN plans so you can utilize them to improve query performance.
Connection pooling in Vitess
Connection pooling reduces the overhead of establishing new database connections. Learn how connection pooling works and how it is handled in Vitess.
How to upgrade from MySQL 5.7 to 8.0
Learn what you should look out for when upgrading an existing database from MySQL 5.7 to 8 and how to change your database to be compatible with the new version.
Zero downtime Rails migrations with the PlanetScale Rails gem
Learn about the Ruby on Rails workflow that protects your database and application from accidental downtime and data loss.
Build a products listing application with Golang and MySQL
Learn how to build a products listing application with Golang and a MySQL database.
Introducing the Issues Calendar for GitHub Projects
Use this open source GitHub integration to view your GitHub project issues in a customizable calendar.
Build a user management API with Nest.js and MySQL
Learn how to build a Nest.js API connect it to a MySQL database add a schema and data and and run database queries.
Using MySQL with SQLAlchemy: Hands-on examples
Learn how to using Python SQLAlchemy with MySQL by working through an example of creating tables, inserting data, and querying data with both raw SQL and SQLAlchemy ORM.
Improvements to database branch pages
Learn about some of the latest enhancements we made to the Branching page in the PlanetScale dashboard.
Announcing Vitess 16
Vitess 16 is now generally available with updates to VDiff v2 VTOrc MySQL compatibility and more.
What are the disadvantages of database indexes?
Learn about some of the possible downsides of using database indexes and how to remove unused database indexes in MySQL.
Migrating from Postgres to MySQL
Learn how to migrate from Postgres to MySQL Postgres vs MySQL incompatibilities and more.
Introducing the PlanetScale API and OAuth applications
Manage your databases programmatically with the PlanetScale API.
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.
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.
Support’s notes from the field
A quick glimpse on Support at PlanetScale and the issues we see the most often.
Solving N+1’s with Rails `exists?` queries
Learn how to solve your Rails applications N+1’s caused by `exists?` queries.
Faster MySQL with HTTP/3
In this article we explore how our HTTP/3 API compares to the latency of a traditional MySQL client.
What is a query planner?
Learn how query planning works and why query planners are important.
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.
Rails’ safety mechanisms
A comprehensive overview of Rails’ many safety features that can help you prevent painful mistakes.
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.
Secure your connection string with AWS KMS
Learn how to encrypt your connection strings so that not even AWS can access them.
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
PlanetScale and HIPAA
PlanetScale can now enter into Business Associate Agreements (BAA) with customers on an Enterprise plan.
