Hey everyone, I have a reservation app, let's just...
# helpe
erik_flywheel
10/17/2021, 11:16 AMHey everyone, I have a reservation app, let's just call it airbnb since the functionality is similar. I need to show available listings (listings without reservations during the time period the user selects: start date - end date). I have a sql script that'll return the available listings, but how can I call that via the api?
Should I use a stored procedure? A view doesn't work because I'd have to create one for every query
s
silentworks
10/17/2021, 11:54 AMYes a function would work in this case and you call it via the
.rpce
erik_flywheel
10/17/2021, 12:01 PMWhat's the process for this? Create the remote procedure then call it via API?
erik_flywheel
10/17/2021, 12:01 PMfor reference, I'm not using JS
erik_flywheel
10/17/2021, 12:02 PMonly the api
s
silentworks
10/17/2021, 12:02 PMOh, not sure what the call looks like for the API, but you could use JS and then see what url is being called
e
erik_flywheel
10/17/2021, 12:03 PMokay, are there any docs for creating .rpc?
erik_flywheel
10/17/2021, 12:03 PMor is it always calling .rpc w/ the parameters?
s
silentworks
10/17/2021, 12:05 PMNot sure what you mean, a rpc is just a Postgres function
silentworks
10/17/2021, 12:05 PMThis is up to you the developer, I mean if you don't need parameters then I would like to think a view would suffice.
e
erik_flywheel
10/17/2021, 12:06 PMI have two pieces: the sql script that returns the available listings and the user's start_date end_date.
I'll always pass the start_date & end_date w/ each call. but where does the available_listings script go?
s
silentworks
10/17/2021, 12:08 PMYou write it in a Postgres Function
silentworks
10/17/2021, 12:09 PMsilentworks
10/17/2021, 12:10 PMI'm curious as to why you are calling the API endpoints directly instead of using one of the client libraries?
e
erik_flywheel
10/17/2021, 12:12 PMwe build mobile apps for clients on adalo
erik_flywheel
10/17/2021, 12:12 PMcan only call via API.
erik_flywheel
10/17/2021, 12:13 PMthere are several devs using supabase x adalo. Usually it's pretty easy but this is a unique scenario where we can't filter or select since we need to see how the inverse of the reservation table (availability)
erik_flywheel
10/17/2021, 12:14 PMAlso, password changing is a problem if you remember that convo awhile ago.
s
silentworks
10/17/2021, 12:14 PMYeah I remember that convo
e
erik_flywheel
10/17/2021, 12:14 PMwe have to build a web app to do that
s
silentworks
10/17/2021, 12:15 PMI should take a look into Adalo one day, so many new awesome tech out there now
e
erik_flywheel
10/17/2021, 12:15 PMyeah, absolutely. it's probably the easiest "no code" app builder. Very intuitive & easy
erik_flywheel
10/17/2021, 12:16 PMthanks for this. will try and work through these docs and see if we can get it working
s
silentworks
10/17/2021, 12:16 PMOk no problem