Skip to content

Blog

Connection pooling in Vitess
Engineering

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.

Harshit Gangal
How to Upgrade from MySQL 5.7 to 8.0
Tutorials

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.

JD Lien
Zero downtime Rails migrations with the PlanetScale Rails gem
Engineering

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.

Mike Coutermarsh
Build a products listing application with Golang and MySQL
Tutorials

Build a products listing application with Golang and MySQL

Learn how to build a products listing application with Golang and a MySQL database.

Olususi Oluyemi
Introducing the Issues Calendar for GitHub Projects
Community

Introducing the Issues Calendar for GitHub Projects

Use this open source GitHub integration to view your GitHub project issues in a customizable calendar.

Brian Morrison II
Build a user management API with Nest.js and MySQL
Tutorials

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.

Olususi Oluyemi
Using MySQL with SQLAlchemy: Hands-on Examples
Tutorials

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.

Anthony Herbert
Improvements to database branch pages
Product

Improvements to database branch pages

Learn about some of the latest enhancements we made to the Branching page in the PlanetScale dashboard.

Jason Long
Announcing Vitess 16
Open source

Announcing Vitess 16

Vitess 16 is now generally available with updates to VDiff v2 VTOrc MySQL compatibility and more.

Vitess Engineering Team
What are the disadvantages of database indexes?
Engineering

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.

JD Lien
Migrating from Postgres to MySQL
Tutorials

Migrating from Postgres to MySQL

Learn how to migrate from Postgres to MySQL Postgres vs MySQL incompatibilities and more.

Adnan Kukic
Introducing the PlanetScale API and OAuth applications
Product

Introducing the PlanetScale API and OAuth applications

Manage your databases programmatically with the PlanetScale API.

Frances Thai, Taylor Barnett
Common MySQL errors and how to fix them
Tutorials

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.

Mary Gathoni
What is the N+1 Query Problem and How to Solve it?
Tutorials

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.

JD Lien
Support’s notes from the field
Tutorials

Support’s notes from the field

A quick glimpse on Support at PlanetScale and the issues we see the most often.

Mike Stojan
Solving N+1’s with Rails `exists?` queries
Engineering

Solving N+1’s with Rails `exists?` queries

Learn how to solve your Rails applications N+1’s caused by `exists?` queries.

Mike Coutermarsh
Faster MySQL with HTTP/3
Engineering

Faster MySQL with HTTP/3

In this article we explore how our HTTP/3 API compares to the latency of a traditional MySQL client.

Matt Robenolt
What is a query planner?
Engineering

What is a query planner?

Learn how query planning works and why query planners are important.

Andres Taylor
Temporal workflows at scale: Part 2 — Sharding in production
Engineering

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.

Savannah Longoria
Rails’ safety mechanisms
Engineering

Rails’ safety mechanisms

A comprehensive overview of Rails’ many safety features that can help you prevent painful mistakes.

Jason Charnes
Building a multi-region Rails application with PlanetScale
Engineering

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.

Mike Coutermarsh
Secure your connection string with AWS KMS
Tutorials

Secure your connection string with AWS KMS

Learn how to encrypt your connection strings so that not even AWS can access them.

Brian Morrison II
All of the tech PlanetScale replaces
Product

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

Brian Morrison II
PlanetScale and HIPAA
Company

PlanetScale and HIPAA

PlanetScale can now enter into Business Associate Agreements (BAA) with customers on an Enterprise plan.

Sam Kottler
How PlanetScale Boost serves your SQL queries instantly
Engineering

How PlanetScale Boost serves your SQL queries instantly

Learn how we use a partial materialization engine for database caching alongside your database.

Vicent Marti
Introducing PlanetScale Boost
Product

Introducing PlanetScale Boost

Up to 1 000× faster queries in just a few clicks with our groundbreaking caching technology.

Rick Branson
One million connections
Engineering

One million connections

Learn how to use PlanetScale to safely include your database in your serverless functions without hitting connection limits in MySQL.

Liz van Dijk
MySQL Integers: INT BIGINT and more
Engineering

MySQL Integers: INT BIGINT and more

Gain a deeper understanding of the MySQL integer types by exploring the different options (INT BIGINT MEDIUMINT etc) and how they are stored.

Brian Morrison II
Announcing Vitess 15
Open source

Announcing Vitess 15

Vitess 15 is now generally available with updates to VTOrc VTAdmin MySQL compatibility and more.

Vitess Engineering Team