How do Database Indexes Work?
Learn how database indexes work under the hood and how they can be used to speed up queries
Getting started with the PlanetScale CLI
Learn how to quickly get up and running with the PlanetScale CLI.
Consensus algorithms at scale: Part 8 - Closing thoughts
In the final installment of the consensus algorithm series we pull everything together with some final thoughts.
Deploy requests now alert on potential unwanted changes
We’ve updated our Deploy Request UI to alert when a schema change could produce unintended changes
Consensus algorithms at scale: Part 7 - Propagating requests
In part 7 of the Consensus algorithm series we combine everything we’ve worked at to cover propagating requests
Identifying slow Rails queries with sqlcommenter
Learn how to use sqlcommenter with Rails
Announcing Vitess 14
Learn about what was just released in Vitess 14
Grouping and aggregations on Vitess
Vitess is a database proxy that creates an illusion of a single database when in reality the query is sent to multiple MySQL instances.
Consensus algorithms at scale: Part 6 - Completing requests
In part 6 of the Consensus algorithms series we look at how to handle request completions
Introducing PlanetScale Insights: Advanced query monitoring
Insights gives you a faster way to debug and monitor your PlanetScale database queries
Extract, load, and transform your data with PlanetScale Connect
Use PlanetScale Connect to easily perform ELT (Extract, Load, Transform) actions on your data to fulfill your application needs.
Introducing PlanetScale Portals: Read-only regions
Put your data where your users and applications are.
The operational relational schema paradigm
An exploration of the current landscape of schema change methodology and what the future should look like.
Consensus algorithms at scale: Part 5 - Handling races
In part 5 of our consensus algorithms series we discuss how we handle race conditions and forward progress requirements.
Consensus algorithms at scale: Part 4 - Establishment and revocation
In part 4 of the consensus algorithms series we look at how algorithm leaders are established and revoked.
Why we chose NanoIDs for PlanetScale’s API
Learn why PlanetScale used NanoID to generate obscure and URL friendly identifiers.
Revert a migration without losing data
Learn how PlanetScale lets you revert changes to your database after a migration with no downtime and zero data loss.
Behind the scenes: How schema reverts work
Learn how we used VReplication to allow for migration reverts with data retention.
How to Prevent SQL Injection Attacks in Node.js
Don’t let SQL injection attacks hurt your business.
Database schema design 101 for relational databases
This database schema design guide walks you through walk through the basics of creating and designing schemas for relational databases.
Introducing Beam
We’re sharing the PlanetScale-powered communication tool we use internally.
Announcing Vitess 13
Learn about the Vitess 13 release.
How we made PlanetScale’s background jobs self-healing
How to build self-healing background jobs into your application with background queueing systems like Sidekiq.
Build a Laravel application with a MySQL database
Learn how to build a Laravel CRUD application connect it to a MySQL database and seed it with data.
How to seed a database with Prisma and Next.js
Use Prisma and Next.js to automatically populate your database with data.
Introduction to Laravel caching
Learn how to speed up your Laravel applications with caching.
Using the PlanetScale CLI with GitHub Actions workflows
Learn how to build automated workflows to develop and operate PlanetScale databases with GitHub Actions.
Using entropy for user-friendly strong passwords
When implementing user authentication with passwords throw out the password rules you know.
How to set up Next.js with Prisma and PlanetScale
A step-by-step guide for using PlanetScale and Prisma with Next.js.