What is our primary use case?
My main use case for PlanetScale is to deploy MySQL and Postgres databases. Earlier, PlanetScale only offered MySQL and did not offer Postgres. Because I work with many startups, I recommend PlanetScale because it makes deploying easy, monitoring easy, and logging easy. It is straightforward to see query insights and use recommendations from PlanetScale to improve performance.
When PlanetScale makes deploying and monitoring easy, it allows me to manage my own MySQL without using tools such as Vitess and having a primary database with read replicas. Instead of doing all that, in PlanetScale, using only the UI, we can configure the number of read replicas that we need and it will automatically handle copying data from the primary database to read replicas. Deploying becomes extremely easy. Additionally, creating branches of the database for different environments is straightforward. Most startups use two to three environments, so we can use three different branches on PlanetScale and maintain three different environments.
Regarding my main use case and how I use PlanetScale, databases are where bottlenecks in scaling occur. PlanetScale shows which queries take a long time to execute and provides recommendations on adding or removing indexes. Often, if you add too many indexes, the database starts working slowly. PlanetScale provides recommendations to both add some indexes as well as change or remove some indexes. This way, we can achieve better performance while keeping resource usage small, without adding more RAM or processor capacity to the database.
What is most valuable?
In my opinion, the best features PlanetScale offers are recommendations and statistics on queries.
Insights on queries have helped me and my teams significantly. For example, once while I was a CTO at Commutech, I received insights from a query that showed one specific query which checked permissions was selecting all permissions for a user instead of selecting a specific row. This increased the load on the database. Receiving that one insight helped me rewrite that query to only select the permission that needed to be checked, which made scaling possible. Such insights that pinpoint exact problems help in resolving scaling issues.
PlanetScale positively impacts my organization by greatly improving productivity and saving significant costs. Typically, if I were to manage my own database, I would need someone to manage that infrastructure, keep updating things, and maintain backups. PlanetScale handles all of that, including backups. We can restore to a point in time using PlanetScale. All these things would normally require a specially skilled person to manage a database. Instead of that, we can have the full-stack developer developing the product manage the database themselves instead of hiring a specialized person just for management. Rather than spending on a DevOps person, we can spend that budget on a developer and build more features instead of spending money on just maintaining infrastructure.
What needs improvement?
PlanetScale solves most of the issues I would have faced if I were not using it, so there is nothing specific that I would like to add within PlanetScale.
Regarding needed improvements, I wish PlanetScale would have a free tier so that startups could try it and then opt in for a paid feature. Earlier they did offer a free tier, but now they do not have any free tier. It could be as small as even 200 megabytes of data that would suffice. However, there needs to be some free tier so that people can try it out.
For how long have I used the solution?
I have been using PlanetScale for around three to four years.
What do I think about the stability of the solution?
In my experience, PlanetScale is very stable.
What do I think about the scalability of the solution?
PlanetScale's scalability is amazing. It scales very easily with hardly any human effort involved.
Which solution did I use previously and why did I switch?
I used AWS as my primary provider and used RDS before PlanetScale, but the minimum pricing for RDS itself is 12 lakh rupees per year, whereas in PlanetScale we calculated it would be around 30,000 rupees a year. That is a significant difference. I had to switch because of monetary reasons. The savings exceed 99 percent for any person who switches from AWS RDS to PlanetScale.
What was our ROI?
Typically, when a startup starts, in the initial first year the scale is not high enough. We have to spend on PlanetScale, roughly $20 to $25 per month. So $25 per month becomes around $300, which is approximately 30,000 rupees. Whereas a developer would have cost me around 50 lakhs plus the infrastructure cost, approximately 12 to 15 lakhs. That totals 65 lakhs, and I only have to spend 30,000 rupees on this. Typically when I use PlanetScale, in the first year I save at least 64 lakh rupees.
What's my experience with pricing, setup cost, and licensing?
My experience with pricing, setup cost, and licensing is that pricing is good enough to be used at enterprise level. It is not cheap, but it is appropriately priced. I do not find it costly at all.
Which other solutions did I evaluate?
Before choosing PlanetScale, I tried Neon and Supabase, but their reliability was inconsistent. Especially with Neon, the reliability was too low. All the applications I usually build need high uptime, which is not the case with Supabase and Neon, and therefore I had to choose PlanetScale.
What other advice do I have?
Specific outcomes or metrics show direct savings that I observe since switching to PlanetScale. On a scale of one to ten, I give PlanetScale a ten because ease of use stands out to me most.
The best features PlanetScale offers are recommendations and statistics on queries. Insights on queries have helped me and my teams significantly. For example, once while I was a CTO at Commutech, I received insights from a query that showed one specific query which checked permissions was selecting all permissions for a user instead of selecting a specific row. This increased the load on the database. Receiving that one insight helped me rewrite that query to only select the permission that needed to be checked, which made scaling possible. Such insights that pinpoint exact problems help in resolving scaling issues.
I have never needed to reach out for customer support, so I cannot evaluate it.
PlanetScale positively impacts my organization by greatly improving productivity and saving significant costs. Typically, if I were to manage my own database, I would need someone to manage that infrastructure, keep updating things, and maintain backups. PlanetScale handles all of that, including backups, and we can restore to a point in time using PlanetScale. All these things would normally require a specially skilled person to manage a database. Instead of that, we can have the full-stack developer developing the product manage the database themselves instead of hiring a specialized person just for management. Rather than spending on a DevOps person, we can spend that budget on a developer and build more features instead of spending money on just maintaining infrastructure.
PlanetScale's performance under heavy workload is incredible. Essentially, our job is to increase its size or the number of read replicas when it performs poorly. However, so far performance has not been an issue.
If someone from PlanetScale is reading this, I strongly recommend that they bring back their free tier so that people can try it out more. Additionally, it would be very helpful for people doing hobby projects. Because it is not always easily possible to keep paying a recurring charge for hobby projects. Having some kind of a hobby tier would be tremendously helpful. I have rated this product a ten out of ten.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Other