Logical Databases and Role Management

PlanetScale Postgres now supports creating and managing multiple logical databases within a single database cluster. This allows for better isolation of schemas and data for different applications, such as side projects, within a shared infrastructure. The platform provides tools and guidance for automating the creation of logical databases and their associated roles, including managing permissions at the database and schema level to enforce the principle of least privilege. This capability aims to simplify multi-application deployments on a single cluster, especially for development and testing environments, while also offering guidance on when to scale to dedicated clusters for production workloads.