PlanetScale Blog

PlanetScale | https://planetscale.com/ | Software Engineer - PlanetScale Postgres | Remote (AMER, LATAM & EMEA) | Base range: $120,000 - $290,000 USD I'm the hiring manager for this position. Come build the best Postgres product on the planet with super talented folks, very high autonomy, tier-zero databases for some of the biggest and fastest growing data sets. Apply at https://job-boards.greenhouse.io/planetscale/jobs/4251150009. Feel free to contact me on LinkedIn or Bluesky if you'd like to talk more about the role. Tell me why Postgres extensions are both great and terrible.

Check out PlanetScale [0] (if you use MySQL). Their hobby tier is free and very generous. If you get to the point of needing more, $30/mo isn't bad for what you get. It's way better than Aurora Serverless V1 or V2 which I was super excited for but turned out to not be worth it all. It failed scaling so much that I had to crank it up before an event or it would never find a good "migration point" or whatever they called it. Aurora Serverless' marketing is straight lies and their pricing is opposite of what I think of when I hear "serverless", $45/mo per DB if you want a single instance in V1 or 0.5 of one in V2. At least V1 allowed you to scale to 0, they removed that in V2. [0] https://planetscale.com/

It's still a bit early for the company but if you like RDS, PlanetScale might be worth a look too: https://planetscale.com/

PlanetScale is an awesome DB that handles sharding and size-balancing — plus they have an incredible free tier. https://planetscale.com/ Rust is a memory-safe systems programming language that has earned the title of most beloved language on StackOverflow’s annual developer survey for the past six years running. https://www.rust-lang.org/ These two technologies seemed like a match made in heaven. The best in database technology with an unbeatably fast and secure access layer. There was just one problem… …no one had ever done it before. Until now! Let us know if you have any questions :)

typo in link - should be https://planetscale.com/blog/rls-sounds-great-until-it-isnt

This has been post before, but planetscale also has a great sql for developers course: https://planetscale.com/learn/courses/mysql-for-developers

Thank you for sharing it, kind sir. Your explanation on b+trees (https://planetscale.com/blog/btrees-and-database-indexes) is probably the best one I've ever seen on the internet.

(I'm on the team that made this) The raw numbers are one thing, but the overall performance of pg is another. If you check out https://planetscale.com/blog/benchmarking-postgres-17-vs-18 for example, in the average QPS chart, you can see that there isn't a very large difference in QPS between GP3 at 10k iops and NVMe at 300k iops. So currently I wouldn't recommend this new storage for the highest end workloads, but it's also a beta project that's still got a lot of room for growth! I'm very enthusiastic about how far we can take this!

Hi, thank you for your work on this and being willing to answer questions on it. "We guarantee durability via replication". I've starting noticing this pattern more where distributed systems provide durability by replicating data rather than writing it to disk and achieving the best of both worlds. I'm curious 1. Is there a name for this technique? 2. How do you calculate your availability? This blog post[1] has some rough details but I'd love to see the math. 3. I'm guessing a key part of this is putting the replicas in different AZs and assuming failures aren't correlated so you can multiply the probabilities directly. How do you validate that failures across AZs are statistically independent? Thanks! [1] https://planetscale.com/blog/planetscale-metal-theres-no-replacement-f…

More information about bloat detection here: https://planetscale.com/docs/postgres/monitoring/schema-recommendation…

i'll take the opposite side. i was very impressed with their website. the very first line: > The world’s fastest and most scalable cloud databases the second line: > PlanetScale brings you the fastest databases available in the cloud. Both our Postgres and Vitess databases deliver exceptional speed and reliability, with Vitess adding ultra scalability through horizontal sharding. i know exactly what they do. zero fluff. and, i'm now interested. https://planetscale.com/

It's real Postgres operated by PlanetScale. You get HA by default, the best performance, query insights, etc. https://planetscale.com/blog/benchmarking-postgres

Their dashboards and metrics are really good. Plus the performance is great even on their non-metal offering too. I hope to one day be able to justify the upgrade to it. Here's their announcement blog post with a bit more info, like their benchmarks: https://planetscale.com/blog/planetscale-for-postgres

Great article! Here's one more, including animations on B-trees: https://planetscale.com/blog/btrees-and-database-indexes

Love the work. Looks quite similar to what PlanetScale Boost does[1]. Basically the same but as a front-end to someone's existing database? (disclaimer: I work at PS). [1]: https://planetscale.com/blog/how-planetscale-boost-serves-your-sql-que…

All you need to know is, Tailwind is used by some of the best designers and websites in the world. https://www.openai.com/ https://www.shopify.com/ https://www.netflix.com/tudum/top10/ https://www.theverge.com/ https://www.loom.com/ https://githubnext.com/ https://planetscale.com/

Besides the obvious (Stripe), WorkOS treats their docs as a product and is probably my all time favorite (just look at their arrow key shortcuts). WorkOS: https://workos.com/docs Twingate: https://www.twingate.com/docs/ Railway: https://docs.railway.app/ Planetscale: https://planetscale.com/ Evervault: https://docs.evervault.com/ Mintlify is also the best alternative to ReadMe or GitBook that I've found.

That is pretty great, especially with such a generous free plan for testing. However, no support for FOREIGN KEYs is a bit of a bummer. However, they explain it very well.[0] Thanks for the reply! Will definitely give PlanetScale a try over the weekend! [0] https://planetscale.com/docs/learn/operating-without-foreign-key-const…

Great question! We have a technical blog post about how PlanetScale Boost is implemented: https://planetscale.com/blog/how-planetscale-boost-serves-your-sql-que… In short, it can be compared in consistency to an up-to-date read replica; PlanetScale Boost uses Vitess' VStream to process events as they happen and keep itself up to date. The blog has much more information if you're curious.

I don't know about how postgres compares to others, but if you're looking for an easy-to-manage relational DB, there are a handful of new cloud-native databases that have come out in the last few years. The ones I know of are Planetscale and Cockroach DB. https://planetscale.com/ https://www.cockroachlabs.com/

You don't run the database itself there, you connect to it remotely. I've not had a chance to try them yet, but PlanetScale Portals look like a great solution there. https://planetscale.com/blog/introducing-planetscale-portals-read-only…

Serverless DBaaS providers and HTTP APIs are a huge new development. Mongo Atlas Serverless, Planetscale (MySQL/Vitess https://planetscale.com), Upstash (Redis, https://upstash.com) and Neon (upcoming Postgres). They add features like merge requests on DDL and make managing DBs as easy as managing Lambda functions. This reduces maintenance overhead significantly.

That's an excellent guideline. I want to throw another example into the ring if folks are researching this space: Planetscale does a good job at https://planetscale.com/blog In particular "Generics can make your Go code slower"[1] which received deservedly a lot of attention here. 1 - https://planetscale.com/blog/generics-can-make-your-go-code-slower

About "Why is this so much slower?" this article is a must-read: https://planetscale.com/blog/generics-can-make-your-go-code-slower

I wouldn't say it's the whole point but very important one. For simple types the current Go implementation does produce monomorphic functions but for others, for example interfaces and other pointer types, it does pass around a dict with metadata in runtime. Check out this excellent blog post: https://planetscale.com/blog/generics-can-make-your-go-code-slower.

Planet Scale is probably the closest to what you're describing here. https://planetscale.com/

Or even better, something like PlanetScale [1]. It was founded by the maintainers of Vitess. [1]: https://www.planetscale.com/

>For MySQL you have to do manual sharding which is extremely hard. Vitess [1] and PlanetScale [2] ? [1] https://vitess.io [2] https://www.planetscale.com

You forgot the read the original text above my response. > I looked Neon recently, and it appears that it's designed as a SaaS product from the outset; while it is technically possible to self-host the individual components of the architecture, it does not look trivial, in large part because the control plane is closed source (and probably extremely specific to Neon's SaaS operations). This is a good reason to go with multigres vs Neki (assuming Neki gets integrated into planetscale vs a standalone multigres ). The two announcement's regarding Neki smells like its going to be proprietary or heavily tied into planetscale. See the gauging interest two months ago with sign ups. The current signing up ... Feel very marketing focused. https://planetscale.com/blog/planetscale-for-postgres#nova-vitess-for-… > If your company runs Postgres at a significant scale and this is something that interests you, reach out. > Sign up for the private preview of PlanetScale for Postgres waitlist here. https://planetscale.com/blog/announcing-neki > To stay up to date with the latest developments on Neki you can signup at neki.dev. Where as the multigres via Supabase points to github repo's, the license, etc... https://supabase.com/blog/multigres-vitess-for-postgres > Like Vitess, Multigres will be open source using the same license: Apache 2. You can follow the repo here. We shall see, but one is running and acting like pure open source project, and another is being announced…

https://planetscale.com/ would be a good bet.