One Postgres cluster, many apps

This post details how to manage multiple applications within a single PlanetScale Postgres database cluster by creating and isolating logical databases and roles. It explains the concepts of database clusters, branches, logical databases, and roles, and provides manual steps for creating logical databases, revoking public connect permissions, creating application-specific roles, and granting granular permissions. It then introduces Infrastructure as Code (IaC) tools like Terraform, Pulumi, and SST as more robust methods for automating this process, focusing on a Pulumi example to manage roles via the PlanetScale API and logical databases/grants within Postgres.