What are the reasons to use FastAPI -> Supabase Client -> PostgREST -> PostgreSQL, vs FastAPI -> PostgreSQL?

[dnk8n]

I am interested in using both Supabase and FastAPI. I love both systems, and integrating them is very interesting. I am just interested in where each shines, how things might be better together, how one should best seperate concerns to leverage the best out of each framework.

[dnk8n]

Maybe it's better to import the automatic Supabase API into the FastAPI openai spec to unify the two APIs, so that they work side by side rather then one over the other.

E.g. Supabase for generic endpoints, FastAPI for more specific.

Maybe measuring the latency introduced by not going directly to PostgreSQL is minimal, and by going via Supabase, we get more cacheable, and more query optimized results.