I plan to host the entire stack myself. I'm just concerned that Supabase might alter my database. Also, I'm unsure whether to proxy my database requests from my FastAPI app through Supabase (they seem to have a Python SDK) or leave it as it is now. I have PgBouncer, so I guess I don't need their custom balancer, and beyond that, it might not offer much. I'm just curious if such a setup has been used in practice and how successful it has been.
I’m looking at it for the realtime channels feature WAL to websockets), and knowing that somebody is running the open source thing in production is comforting. Good luck.
OpenAPI specs can save weeks even on small projects, when you need to autogenerate multiple clients in different languages after the API part is ready btw