I've been actually looking for that sorting by closest to you. I didn't want to handle the sorting in the frontend. I am glad supabase covers that too 😊
😮 Wow, gradually my love for Supabase is increasing. And it's history that to whomever i love they just leave i am also afraid if Supabase also do this with us. Like, Closes the open source or restricts the features on self-host.
So with this setup I can only get the restaurants (if I want the lat,lng) through the function, right? Does that impact billing in comparison to a "normal" query? Let's say my users all fetch 1000 restaurants, this function will be called a fair amount.. Would love some insight on that. Either way also want to express my gratitude for this kind of functionality, which I was missing dearly with firebase
This is nice… but how do I store these functions on my local database so I can use them via an API call? I hope they will show up in database migrations too, so I can push them to the production database? (I have a free account…)
As long as you include the function creation statements in your migration file, you will be able to have them available locally, as well as push them to prod with Supabase CLI!
First, you create the Postgres function shown in this video. Then you can call them using custom functions: docs.flutterflow.io/customizing-your-app/custom-functions
Could you please provide a sample on how to parse the POINT back to CLLocation in Swift, or least the String format? I managed to save the long and lat following the "POINT(lat long)" format from the iOS client to the Supabase database. But how to parse it back to long and lat after it's been converted to something like this: 0101000020E6100000A4DFBE0E9C91614044FAEDEBC0494240?
You should do the conversion on the database side and not on the client side. You can use functions like `st_y()` and `st_x()` to do so. supabase.com/docs/guides/database/extensions/postgis#finding-all-data-points-within-a-bounding-box
@@Supabase Is there a more detailed Swift documentation on this? I think this is a pretty common scenario but complex enough for people without SQL experience to figure out. I have a struct for encapsulating user details, which includes other user info plus their location. Does this mean I should do the insert/upsert as "long: float8 and lat: float8"? And then when I have to perform queries like, return nearby users within 10 km radius, that's where I have to perform the rpc call? Please have a documentation/video for handling this part in Swift.
I've been actually looking for that sorting by closest to you. I didn't want to handle the sorting in the frontend. I am glad supabase covers that too 😊
This is exactly what I've been learning for my app. Did I forget to set RLS policies on my mind? You guys totally read it!
let’s appreciate the steady path of awesome improvements 👏
😮 Wow, gradually my love for Supabase is increasing.
And it's history that to whomever i love they just leave i am also afraid if Supabase also do this with us.
Like, Closes the open source or restricts the features on self-host.
Awesome! Greetings from México.
You have good pronunciation for a japanese guy!
Awesome
Please make timescaledb extension tutorial ❤
So with this setup I can only get the restaurants (if I want the lat,lng) through the function, right? Does that impact billing in comparison to a "normal" query?
Let's say my users all fetch 1000 restaurants, this function will be called a fair amount..
Would love some insight on that. Either way also want to express my gratitude for this kind of functionality, which I was missing dearly with firebase
This is nice… but how do I store these functions on my local database so I can use them via an API call? I hope they will show up in database migrations too, so I can push them to the production database? (I have a free account…)
As long as you include the function creation statements in your migration file, you will be able to have them available locally, as well as push them to prod with Supabase CLI!
Wow
❤❤❤❤❤❤❤❤❤
how can i do that in flutterflow
First, you create the Postgres function shown in this video. Then you can call them using custom functions: docs.flutterflow.io/customizing-your-app/custom-functions
@@Supabase Thank you, Let's do it.
@@Supabase can I just do a rest api call from flutterflow instead?
Could you please provide a sample on how to parse the POINT back to CLLocation in Swift, or least the String format? I managed to save the long and lat following the "POINT(lat long)" format from the iOS client to the Supabase database. But how to parse it back to long and lat after it's been converted to something like this: 0101000020E6100000A4DFBE0E9C91614044FAEDEBC0494240?
You should do the conversion on the database side and not on the client side. You can use functions like `st_y()` and `st_x()` to do so. supabase.com/docs/guides/database/extensions/postgis#finding-all-data-points-within-a-bounding-box
@@Supabase Is there a more detailed Swift documentation on this? I think this is a pretty common scenario but complex enough for people without SQL experience to figure out.
I have a struct for encapsulating user details, which includes other user info plus their location. Does this mean I should do the insert/upsert as "long: float8 and lat: float8"? And then when I have to perform queries like, return nearby users within 10 km radius, that's where I have to perform the rpc call? Please have a documentation/video for handling this part in Swift.
Can I use geo queries in Expo React-Native?
Yup, you can use geo queries on any front-end frameworks. You just have to call the database functions.
@@Supabase so I am able to fetch all transactions created within a certain radius? Thats what I wanna do.
looks extremely complicated.
It might at first, but once you dip your feet into it, you will get the hang of it!