If you need a serverless PostgreSQL option that auto-scales and can handle a lot of traffic, Xata is a good choice. It's a serverless data platform for PostgreSQL that automatically scales to meet demand. It also supports features like zero-downtime schema migrations, full-text search with Elasticsearch, and elastic scaling. Xata also supports a variety of frameworks and tools, and offers a generous free tier with 10 database branches and 15 GB data storage.
Another good option is Neon. This serverless Postgres platform offers fast provisioning, autoscaling and branching for isolated DB copies. It also offers read replicas, point-in-time recovery and support for multiple languages and frameworks. Neon's pricing tiers are flexible, including a free tier and scalable plans for growing projects.
If you prefer a more open-source focused option, check out Supabase. It offers a Postgres database with 100% portability, user authentication, real-time data synchronization and an in-built SQL editor. Supabase also comes with templates for common use cases and supports frameworks like Next.js and Flutter. Its free tier has unlimited API requests, so it's good for small to medium-sized apps.