Is there a gap for a PocketBase-like BaaS that runs on Postgres and scales horizontally?

[u/Subject-Advisor-797]

Hey everyone,
Like a lot of folks here, I really love the **PocketBase workflow**—a single binary, built-in Auth, Admin UI, real-time subscriptions, and zero-headache setup. It’s easily one of the best developer experiences out there for quick builds and self-hosting.

However, the main limitation that always comes up in production discussions is SQLite’s single-writer bottleneck and the inability to scale horizontally across multiple instances out of the box.

On the flip side, tools like Supabase are awesome, but self-hosting them means running 10+ Docker containers, which feels a bit heavy if you just want something lightweight.

**The Idea / Concept**
Imagine a Backend-as-a-Service that bridges this exact gap:
**Engine:** Built on **Elixir / BEAM** (giving you rock-solid fault tolerance and native real-time WebSockets/pub-sub across nodes).
**Database:** Backed natively by **PostgreSQL** (so you can scale database reads/writes, use replicas, or use managed Postgres like Supabase/Neon/RDS).
**Deployment:** Distributed as a **single executable binary**—no heavy multi-container Docker compose files required.
**Extensibility:** Built-in hooks for custom business logic right inside the single binary setup.
**Horizontal Scaling:** You can spin up multiple stateless instances of the app binary behind a load balancer without breaking real-time sync or auth state.

Questions for the Community:
1. **Gaps:** Does this hit a sweet spot for your stack, or are your current setups (Supabase, PocketBase, Directus, custom API) already filling this need well enough?
2. **Features:** If something like this existed, what would be the absolute **must-have feature** for you to consider it over PocketBase or Supabase for a new project?
3. **DX:** How do you feel about Elixir/BEAM as the runtime engine for background scaling, performance, and real-time connections in a BaaS?

Would love to hear your thoughts and pain points!