There are so many projects I could use pocketbase for, if only it supported Postgres.
I get the philosophical reasons behind why it doesn’t and why it’s SQLite only.
It’s just that in a corporate environment, I could trivially deliver full production ready applications because there is a team that handles all the Postgres replication/failover/ha/dr/backups/recovery for me. Pocketbase with pg would be super simple to deploy to a pod, getting 95% of production readiness done.
I am also building similar product but with different approach And just using SQLite for now but plan on adding Postgres support ( orm I am using supports it ) … but nowhere near production ready. Due to buzz around products like litestream I feel like just SQLite is also viable nowadays. I also have own cdc based replication thing wip but yeah just having fun stage
like others have said, try sup abase
https://supabase.com/docs/guides/self-hosting/docker
i havent tried self hosting but it doesn't look too tricky
Supabase? https://supabase.com/
> There are so many projects I could use pocketbase for, if only it supported Postgres.
So... you want Supabase? which is what Pocketbase is inspired by.