📹 The future of AI infrastructure: optimize and shard your database with agents.Watch the talk
Simeon Griggs [@simeonGriggs] |
Yo, I heard you liked databases, so we put logical databases in your database cluster so you can database while you database →
Fatih Arslan [@fatih] |
Kubernetes is a framework for feedback controllers: write down what you want, observe what exists, make the next change, and repeat. →
Connections lets you monitor and manage all active connections to Postgres and Vitess databases. See active sessions, identify locking patterns, and keep debugging even when normal application connections are exhausted. →
Tom Pang |
Large DELETEs add work instead of reclaiming it. Structure your database so deletion becomes DROP TABLE or TRUNCATE. →
Simeon Griggs [@simeonGriggs] |
Reducing the size and frequency of requests to your database has the double benefit of making your applications faster and cheaper. →
Simeon Griggs [@simeonGriggs] |
The best way for you and your agents to see how your database actually performs in production. →
Transparent database benchmarks help customers make better decisions and push vendors to build better products. →
Benchmarking is hard. Done wrong it is very misleading, and unfortunately it is frequently done wrong. Let's explore how not to make silly mistakes. →
Josh Brown [@0ximjosh] |
PostgreSQL's Row Level Security sounds like a clean way to enforce access control at the database layer, but the foot-guns, pooling incompatibilities, and performance traps often make it more trouble than it's worth. →
Simeon Griggs [@simeonGriggs] |
There are many ways to slice a Postgres database for multi-tenant applications. Let's look at the three most common approaches and the trade-offs. →
Simeon Griggs [@simeonGriggs] |
Dead tuples from high-churn job queues can silently degrade your Postgres database when vacuum falls behind—especially alongside competing workloads. Traffic Control keeps cleanup on track. →
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. →
Simeon Griggs [@simeonGriggs] |
A high memory percentage in PlanetScale Postgres is not necessarily a problem. Let's compare how memory and CPU usage are different, how not all memory usage is created equal, and which signals actually require attention. →
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 Stripe CLI. →
Enforce real-time limits on your Postgres query traffic to protect your database from runaway queries and unexpected load spikes. →
PgBouncer is the perfect pairing for Postgres's biggest weakness: connection management. Tuning it just right is important to make this work well, and here we cover everything you need to know →
Simeon Griggs [@simeonGriggs] |
Build a real-time application with PlanetScale and the Cloudflare global network. Infrastructure choices you won't need to migrate away from once you hit scale. →
Connect Claude, Cursor, and other AI tools directly to your PlanetScale database to optimize schemas, debug queries, and monitor app performance. →
What are database transactions and how do SQL databases isolate one transaction from another? →