Codú

PlanetScale Blog's Coding Profile

Avatar for PlanetScale Blog

PlanetScale Blog

@planetscale-blog

planetscale.com/blog

Articles (17)

PlanetScale Blog13 min

Patterns for Postgres Traffic Control

Last week we introducedDatabase Traffic Control™. TrafficControl lets you attach resource budgets to slices of your Postgres traffic,like keeping your checkout flow running while a runaway analytics query getsshed instead. We have already discussed some scenarios where youshould use Traffic Control,...

0
0
PlanetScale Blog7 min

Graceful degradation in Postgres

Not all traffic is created equal.When a database is overwhelmed, you want the important queries to keep executing, even if that means shedding lower-priority work.This is a much better outcome than the alternative: a total database outage. PlanetScale's Traffic Control makes this feasible at the dat...

0
0
PlanetScale Blog9 min

High memory usage in Postgres is good, actually

Houseplants often die from over-watering, not neglect. It is easy to project human needs onto them: "If I am thirsty, they must be thirsty too." But many indoor plants actually benefit from drying out between waterings. Similarly, your empathy can lead to misinterpreting signals from your database....

0
0
PlanetScale Blog9 min

Enhanced tagging in Postgres Query Insights

As part of yesterday's Traffic Control launch, we made enhancements to the Insights query tagging feature for Postgres databases. Insights has supported query tags for some time, but they were previously only attached as metadata on individual notable query logs. With yesterday's release, tags are n...

0
0
PlanetScale Blog12 min

Behind the scenes: How Database Traffic Control works

Today, we released Database Traffic Control™, a feature for mitigating and preventing database overload due to unexpectedly expensive SQL queries. For an overview, read the blog post introducing the feature, and to get started using it, read the reference documentation. This post is a deep dive into...

0
0
PlanetScale Blog4 min

Introducing Database Traffic Control

Postgres has a fundamental gap when it comes to managing query traffic. When an unexpected spike of bad queries, or runaway workload hits your database, Postgres has no good way to fight back. It accepts every query thrown at it until performance degrades or, in the worst case, the server goes down....

0
0
PlanetScale Blog10 min

Scaling Postgres connections with PgBouncer

The Postgres process-per-connection architecture has an elegant simplicity, but hinders performance when tons of clients need to connect simultaneously. The near-universal choice for solving this problem is PgBouncer.Though there are upcoming systems like Neki which will solve this problem in a more...

0
0
PlanetScale Blog2 min

Drizzle joins PlanetScale

I am excited to announce that the Drizzle team is joining PlanetScale to continue their mission of building the best database tools for JavaScript and TypeScript. Drizzle’s ORM has risen to become the default thanks to the team’s obsession with performance and developer experience, two things Planet...

0
0
PlanetScale Blog7 min

Video Conferencing with Postgres

Yesterday on X, SpacetimeDB tweeted that they had done "the world's first video call over a database" and, in their own way, invited anyone else to give it a try. Credit to them - it's a cool idea! In short, they built a frontend that captures audio and video from the browser's media APIs, encodes t...

0
0
PlanetScale Blog4 min

Introducing the PlanetScale MCP server

Today we're releasing the new PlanetScale MCP server, bringing your database directly into your AI tools. With the Model Context Protocol (MCP), Claude, Cursor, Open Code, and other AI tools can now connect to the PlanetScale API to help you improve and better understand your database. What is the P...

0
0
PlanetScale Blog12 min

Database Transactions

Transactions are fundamental to how SQL databases work.Trillions of transactions execute every single day, across the thousands of applications that rely on SQL databases. What is a database transaction? A transaction is a sequence of actions that we want to perform on a database as a single, atomic...

0
0
PlanetScale Blog4 min

Automating our changelog with Cursor commands

Ever since Cursor commands were released, we've been usingthem to find ways to shortcut common tasks at PlanetScale. A Cursor command allows you to add slash (/actions) commands directly into Cursor. Each command guides the LLM on completing a common and repeatable workflow for you. Updating our cha...

0
0
PlanetScale Blog2 min

Postgres 18 is now available

Postgres 18 is now available on PlanetScale.Starting today, when you create a new database, the default version will be 18.1.You can select a prior version using the dropdown on the database creation page. This combined with our recent launches of $5 single-node databases and $50 Metal databases mak...

0
0
PlanetScale Blog3 min

Using MotherDuck with PlanetScale

DuckDB has gained significant traction for OLAP workloads.It's powerful, flexible, and has a feature-rich SQL dialect, making it perfect to use for analytics alongside OLTP-oriented relational databases. Today, we're excited to announce support for the pg_duckdb extension for Postgres databases on P...

0
0
PlanetScale Blog3 min

$50 PlanetScale Metal is GA for Postgres

Today we’re making PlanetScale Metal for Postgres available in smaller sizes and at much lower price points, all the way down to the new M-10 for as little as $50 per month.We’ve lowered the floor from 16GiB of RAM with four sizes all the way to 1GiB and paired these with eight storage capacities ra...

0
0