Skip to content

Blog

Performant database tree traversal with Rails
Engineering

Performant database tree traversal with Rails

Learn how to solve a tree traversal N+1 query problem in your Rails application.

Mike Coutermarsh
Announcing PlanetScale Scaler Pro
Company

Announcing PlanetScale Scaler Pro

See how Scaler Pro combines the best of our current plans for companies of all sizes while enabling you to grow with the best database for serverless.

Nick Van Wiggeren
Build a library app with Laravel 10 and MySQL
Tutorials

Build a library app with Laravel 10 and MySQL

Learn how to build a Laravel application backed by a MySQL PlanetScale database.

Olususi Oluyemi
How PlanetScale keeps your data safe
Engineering

How PlanetScale keeps your data safe

A detailed description of the multi-layered approach PlanetScale takes to ensure your data is safe.

Sam Lambert
Announcing Vitess 17
Open source

Announcing Vitess 17

In this release of Vitess, several significant enhancements have been introduced to improve the compatibility, performance, and usability of the system.

Matt Lord
Datetimes versus timestamps in MySQL
Engineering

Datetimes versus timestamps in MySQL

Learn the differences between datetimes and timestamps in MySQL, the DATE, YEAR, and TIME columns, timezones, and when to use each.

Aaron Francis
Build an expense tracker app with Symfony and MySQL
Tutorials

Build an expense tracker app with Symfony and MySQL

Learn how to build a use MySQL with Symfony by building an expense tracking application using a PlanetScale MySQL database.

Olususi Oluyemi
Generated Hash Columns in MySQL
Engineering

Generated Hash Columns in MySQL

Creating generated hash columns in MySQL for faster strict equality lookups.

Aaron Francis
Using PlanetScale with Serverless Framework Node applications on AWS
Tutorials

Using PlanetScale with Serverless Framework Node applications on AWS

Learn how to integrate PlanetScale with Node applications built using the Serverless Framework on AWS.

Matthieu Napoli
PlanetScale joins AWS ISV Accelerate
Company

PlanetScale joins AWS ISV Accelerate

PlanetScale has deepened its relationship with AWS to benefit customers who use AWS services, officially joining the AWS ISV Accelerate Program!

Nick Van Wiggeren
Announcing the Hightouch integration
Product

Announcing the Hightouch integration

Learn how to sync data between PlanetScale and other platforms using Hightouch.

Brian Morrison II
Using redundant conditions to unlock indexes in MySQL
Engineering

Using redundant conditions to unlock indexes in MySQL

Using redundant conditions as a method to unlock obfuscated indexes and improve performance in MySQL.

Aaron Francis
Optimizing query planning in Vitess: a step-by-step approach
Open source

Optimizing query planning in Vitess: a step-by-step approach

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.

Andres Taylor
Pulling back the curtain: the new database overview page
Product

Pulling back the curtain: the new database overview page

Learn about the latest updates we made to our database overview page: load balancers, shards, and more.

Holly Guevara
Announcing the Larabelles Laracon US conference giveaway, sponsored by PlanetScale
Community

Announcing the Larabelles Laracon US conference giveaway, sponsored by PlanetScale

PlanetScale is sponsoring Larabelles, which will give three folks who have been historically under-represented or marginalised due to their gender a trip to Laracon US in July.

Taylor Barnett
PlanetScale is now available on the Google Cloud Marketplace
Company

PlanetScale is now available on the Google Cloud Marketplace

We’re excited to announce that PlanetScale is now available on the Google Cloud Marketplace.

Nick Van Wiggeren
Character sets and collations in MySQL
Engineering

Character sets and collations in MySQL

Understanding the differences between character sets and collations in MySQL.

Aaron Francis
Integrate Cloudflare Workers with PlanetScale
Tutorials

Integrate Cloudflare Workers with PlanetScale

A guide on how to natively integrate your PlanetScale database into Cloudflare workers easily and securely.

Brian Morrison II
Backward compatible database changes
Engineering

Backward compatible database changes

Learn about safely using the expand, migrate, and contract pattern to make database schema changes without downtime and data loss.

Taylor Barnett
Why isn’t MySQL using my index?
Engineering

Why isn’t MySQL using my index?

There are several reasons why MySQL might not consider your index, and in this article we’ll explore some of the most common ones.

Aaron Francis
Serverless Laravel applications with AWS Lambda and PlanetScale
Engineering

Serverless Laravel applications with AWS Lambda and PlanetScale

Learn how to create serverless Laravel applications by deploying them to AWS Lambda and using PlanetScale as the database.

Matthieu Napoli
Build a Rust API with Rocket, Diesel, and MySQL
Tutorials

Build a Rust API with Rocket, Diesel, and MySQL

Learn how to build a Rust API using Rocket, Diesel, and a MySQL database hosted on PlanetScale.

Olususi Oluyemi
Database branching: three-way merge for schema changes
Engineering

Database branching: three-way merge for schema changes

Learn how PlanetScale uses Git-like three-way diff to resolve schema change conflicts across database branches.

Shlomi Noach
Query performance analysis with Insights
Product

Query performance analysis with Insights

You can now use Insights to view time-series performance data on a per-query pattern basis.

Rafer Hazen
Pagination in MySQL
Engineering

Pagination in MySQL

An overview of the different ways to paginate in MySQL including limit/offset pagination and cursor pagination plus the pros and cons of each.

Aaron Francis
Safely making database schema changes
Product

Safely making database schema changes

How to prevent schema changes from being scary with database best practices and PlanetScale.

Taylor Barnett
What is database sharding and how does it work?
Engineering

What is database sharding and how does it work?

Learn what database sharding is, how sharding works, and some common sharding frameworks and tools.

Justin Gage
An update to our workflow: safe migrations
Product

An update to our workflow: safe migrations

Learn about our latest update safe migrations and how it affects our branching workflow.

Nick Van Wiggeren
Announcing the PlanetScale GitHub Actions
Product

Announcing the PlanetScale GitHub Actions

Easily integrate common PlanetScale operations directly into your GitHub Actions Workflows.

Brian Morrison II