Blog
Get the RSS feedLearn 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. →
Learn how to integrate PlanetScale with Node applications built using the Serverless Framework on AWS. →
Nick Van Wiggeren [@NickVanWig] |
PlanetScale has deepened its relationship with AWS to benefit customers who use AWS services, officially joining the AWS ISV Accelerate Program! →
Learn how to sync data between PlanetScale and other platforms using Hightouch. →
Using redundant conditions as a method to unlock obfuscated indexes and improve performance in MySQL. →
See how Vitess acts as a database proxy that creates an illusion of a single database when technically, the query is sent to multiple MySQL instances. →
Learn about the latest updates we made to our database overview page: load balancers, shards, and more. →
Nick Van Wiggeren [@NickVanWig] |
Explore the evolution of “Database DevOps” and its impact on development workflows in this tech talk. →
Nick Van Wiggeren [@NickVanWig] |
We’re excited to announce that PlanetScale is now available on the Google Cloud Marketplace. →
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. →
You can now use Insights to view time-series performance data on a per-query pattern basis. →
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. →
How to prevent schema changes from being scary with database best practices and PlanetScale. →
Learn what database sharding is, how sharding works, and some common sharding frameworks and tools. →
Nick Van Wiggeren [@NickVanWig] |
Learn about our latest update safe migrations and how it affects our branching workflow. →
Learn how the schema migrations are performed iteratively by evolving change scripts. →
Learn how the schema migrations are performed using a single state definition. →
Easily integrate common PlanetScale operations directly into your GitHub Actions workflows. →