This isn't so much a help request as a curious question. I learned from perusing github that supabase's js client for the postgres db is based on PostgREST. So that made me curious if it is possible to access the PostgREST api "directly" – which is to say, in the manner I would normally use a REST API, with
fetch()
fetch()
and http-urls, as described in PostgREST docs.
I didn't see any mention of it in the supabase docs, but I imagine it would be possible. If it is, could someone give me a quick rundown of how? And also: which version of the PostgREST docs should I be looking at?
As to why I would want to do this – I have no need at the moment but I notice there are some things possible through PostgREST that aren't (apparently) possible via supabase's js client. Notably aggregate functions and transactions. So I was curious if it was possible to still use those features of postgres just in a more cumbersome way.
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.