Blog
Get the RSS feedBy Shlomi Noach |
Learn how PlanetScale uses Git-like three-way diff to resolve schema change conflicts across database branches. →
By Rafer Hazen |
You can now use Insights to view time-series performance data on a per-query pattern basis. →
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 Taylor Barnett |
How to prevent schema changes from being scary with database best practices and PlanetScale. →
By Justin Gage |
Learn what database sharding is, how sharding works, and some common sharding frameworks and tools. →
By Nick Van Wiggeren |
Learn about our latest update safe migrations and how it affects our branching workflow. →
By Brian Morrison II |
Learn how the schema migrations are performed iteratively by evolving change scripts. →
By Brian Morrison II |
Learn how the schema migrations are performed using a single state definition. →
By Brian Morrison II |
Easily integrate common PlanetScale operations directly into your GitHub Actions workflows. →
By Liz van Dijk |
PlanetScale and Netlify join forces to cover how to integrate PlanetScale into Netlify Functions for common SaaS application use cases. →
By Savannah Longoria |
Learn how to read the output in MySQL EXPLAIN plans so you can utilize them to improve query performance. →
By Harshit Gangal |
Connection pooling reduces the overhead of establishing new database connections. Learn how connection pooling works and how it is handled in Vitess. →
By JD Lien |
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. →
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 Anthony Herbert |
Learn how to use Python SQLAlchemy with MySQL by working through an example of creating tables, inserting data, and querying data with both raw SQL and SQLAlchemy ORM. →
By Jason Long |
Learn about some of the latest enhancements we made to the Branching page in the PlanetScale dashboard. →
By Vitess Engineering Team |
Vitess 16 is now generally available with updates to VDiff v2, VTOrc, MySQL compatibility, and more. →
By JD Lien |
Learn about some of the possible downsides of using database indexes and how to remove unused database indexes in MySQL. →
By Matt Robenolt |
Join PlanetScale’s Lead Infrastructure Engineer for Edge connectivity for an explainer on our findings regarding HTTP/3 and the MySQL protocol. →
By Adnan Kukic |
Learn how to migrate from Postgres to MySQL, Postgres vs MySQL incompatibilities, and more. →
By Frances Thai, Taylor Barnett |
Manage your databases programmatically with the PlanetScale API. →
By Mary Gathoni |
An overview of some common MySQL error codes you may run into, what they mean, and how to solve them. →