Query insights have cut infrastructure costs and let full‑stack teams manage databases independentlyIn 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.
