Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Has anyone use the PostGis extension on Supabase?

If you have a general setup question I might be able to help.  I have a single geometry point column in a table that I set with lat/lon from javascript, but I'm not doing any processing on it yet... more for the future to show things on a map if I get that far.

What is your column type? (jsonb?) You did not have the chance to test with lines and polygons by any chance?

My column is geometry(Point, 4326) set up thru the SQL editor.  No testing other than making sure it updates correctly from a js supabase insert with:
"SRID=4326;POINT(" + geo.coords.long + " " + geo.coords.lat + ")"

I know it works because my PHPstorm IDE database utility shows the rows correctly on a map with that data sent up.

this uses postgis. could be a good resource for you https://github.com/dshukertjr/spot