PlanetScale

@planetscale.com

The database platform built for scale. Postgres and Vitess/MySQL. https://planetscale.com Discord: http://discord.gg/pDUGAAFEJx Status: http://planetscalestatus.com

You can't manage what you can't measure. View detailed graphs for any available query metric in Insights: CPU time, blocks read/written, cache hit ratio, and more.

Sharding is how you scale relational databases. Bottlenecks like server write limits, data size, and slow backups mean eventually, your data should live on multiple servers. Learn how we do this at PlanetScale with Neki and Vitess in our latest blog.

Vitalize migrated to PlanetScale and saw: - P95 latency dropped to 2ms - Heavy JSONB reads dropped from 50s -> 1.2s - Half the vCPUs with better performance - Actionable performance info with Query Insights Read all about their migration:

From Supabase to PlanetScale: Zero Downtime, 400GB, 150 Million Rows - Vitalize

Our recent migration to PlanetScale ensures our platform can scale reliably in an industry where precision and speed directly affect patient care.

vitalize.care

Magicare migrated to PlanetScale and achieved an 85%+ reduction in query latency, 17× faster materialized view refreshes, and a 6× smaller database footprint per instance. Read the article for all the details.

How Magicare cut query latency by 85% by moving to PlanetScale - Magicare.ai

Magicare drives better patient outcomes, automates your busywork, and increases employee happiness—all from one simple dashboard purpose built for post acute healthcare.

magicare.ai

It's easy to introduce slow queries into your workload. Tracking them down should be easy too. PlanetScale Insights shows you which queries are slow and why. Combined with our MCP server, you can automate fixing them.

Bild

Most database benchmarks are bad. The problems are often subtle. Mismatched instances, cold caches, and coordinated omission all produce misleading results. Today, we’re publishing guidance on how to do it right, and updating our acceptable use policy to allow benchmarking.

Bild

pgvectorscale augments pgvector with StreamingDiskANN, making larger-than-RAM vector indexes achievable in Postgres. It also adds statistical binary quantization for improved search recall over regular quantization. PlanetScale supports both. Try them today.

Bild

Postgres RLS sounds great in theory: embedded access control right in the database. In practice, there's complexity in policy configuration, managing your attack surface, and performance implications. Our latest article takes a deep dive into RLS.

Bild

Postgres has three ways to isolate tenants: - Logical databases - Per-tenant schemas - Tenant ID in a shared schema Counterintuitively, the last is the best way to scale. Read about why in our latest article.

Autumn migrated to PlanetScale and got: - Query latency reduction from ~100ms to < 10ms - Support and tooling to identify + fix slow queries - Significant decrease in CPU usage - Connection scalability Read about their migration: pscale.link/autumn-to-ps

Migrating Autumn to PlanetScale

How we migrated our core database to <a href="https://planetscale.com/" target="_blank" rel="noopener noreferrer">PlanetScale</a>, and why it's been a game-changer for performance, reliability, and de...

pscale.link

Sharding is the best way to scale a database. But how does it work? And what's the best way to ensure data and queries are evenly distributed? Our interactive article on database sharding teaches you how.

pgcopydb is the best way to migrate to PlanetScale Postgres. We've used it to move multi-TB databases at speeds over 2 TB/hr. PlanetScale's custom fork adds PG 17/18 support, better CDC, and resilient retry.

Bild

Postgres wasn't designed as a job queue, but many apps use it as one right alongside analytics, OLTP, and everything else. Our latest blog goes deep on what to be aware of when doing this and how the situation has improved for Postgres over time.

Traffic Control lets you limit how much of your Postgres compute resources any one workload can consume. You can warn, block, or do a mixture of both when queries exceed these limits.

We're excited to share we're partnering with Stripe as part of their Stripe Projects developer preview. Create & manage PlanetScale Postgres + Vitess databases straight from the Stripe CLI. All of your dev tool provisioning and billing now centralized in one place. planetscale.com/blog/planets...

Stripe Projects partnership: Provision PlanetScale Postgres and MySQL databases from the Stripe CLI — PlanetScale

PlanetScale is a co-design and launch partner for the Stripe Projects developer preview, allowing you or your coding agents to provision and manage databases and other dev tools directly from the Stri...

planetscale.com

Query Insights just got way more powerful. We now track tag metadata at the per-query level. This allows you to filter queries by tag, see per-tag performance breakdowns, and set resource budgets with Traffic Control.

Bild