"Just use Postgres" they said.
So we built an app that streams multi-gigabyte video files right from Postgres.
Does it work? Yes. Should you do it? Nope.
But we learned a lot along the way.
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.
The first SF Database Meetup is in session!
We’re joined by @ovaistariq for an in-depth conversation about building and scaling database systems at Uber and now at Tigris Data.
For the past year I've had really one mission, and that's make it as easy as possible to migrate your databases to @PlanetScale. Through customer convos we evolved our process and launched our Discovery CLI (planetscale.com/docs/postgres/…) which we'd feed into an internal tool,
Everyone’s least favorite alert: nothing changed, everything is on fire.
Traffic Control solved the immediate performance problem. Figuring out why it happened led us to an interesting investigation of the Postgres query planner:
After moving to PlanetScale Metal, Autumn saw a 10x decrease in query latency.
"Migration was much easier than we had anticipated. We were worried it’d take us weeks, but it ended up taking only 2 days."
useautumn.com/blog/migrating…
Our migration specialists move customers to PlanetScale every day, often at several terabytes per hour. Whatever your workload, we can help.
To get a head start, run our migration assessment tool and share the results with our team:
Bootstrap, Twitter, MooTools, and building the right primitives for AI with Jacob Thornton.
00:00 Why Jacob is @fat on every platform
04:30 Early years at Twitter, joining the JS illuminati
07:01 Creating Bootstrap with @mdo
13:31 Bootstrap and open source sustainability
23:16
Your Postgres database is continually hunting to kill queries... to protect itself from deadlocks.
Deadlocks can quickly escalate into bad performance and even downtime. Learn why and how to avoid it.
Join us in SF on August 31 for CRITICAL mass, a talk series held under NDA and Chatham House rules, going deep on how PlanetScale achieves extreme reliability. No recording, no record, just a moment in time.
