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

Supabase

Hello everyone 👋 

Is there a way to calculate distance between coordinates just like firebase Geofire in supabase?

You will need to create an RPC function for this. 

and fyi: you can't really say like firebase, because geolocation in firebase is just trash and costy.

anyway, lets say u have a geo location stored in ur database u can then easily do this

```
ST_Distance(myTable.savedLocation, ST_GeogFromText(my_location))
```

this will return u a distance between two locations, u can also use it to order by ur query 🙂

a simple function can be

```
$$;
CREATE
OR REPLACE FUNCTION public.select_nearby_feed(my_location text) RETURNS SETOF feed LANGUAGE sql AS $$ 
   select * from feed 
    ORDER BY ST_Distance(feed.location, ST_GeogFromText(my_location)), created_at DESC;
$$;
```

and from flutter. 

```
_supabase.client.rpc('select_nearby_feed', params: {'my_location', 'POINT(longitude latitude)'})
.execute();
```

or you can wait til supabase functions are out

You can also do it on client side with this package
https://pub.dev/packages/geolocator

Example:
https://stackoverflow.com/questions/60503089/how-to-calculate-distance-between-two-location-on-flutterresult-should-be-mete

Did you get this resolved?  I’m doing this using a PostgreSQL function and can share it with you if you need it.