https://supabase.com/ logo
Join Discord
Powered by
I want to create food delivery app it
# jobs
a
I want to create food delivery app, it will have restaurants, users, food dishes, etc. Just usual food delivery app. I want to create api in supabase and want to hire someone as mentor. I already know node js, express, supa base, hasura. I just dont feel confident. So, i want to hire someone for hourly rate. Please DM me your hourly rate and experience with supabase.
m
But supabase already does most of the work, it generates the API for you (only CRUD options tho), you just have to do the DB modeling yourself
You also got that one service written in elixir, live-updates or something
only thing you should worry about is prolly how to model your DB and how to deploy to servers etc. (the DevOps part)
a
you are correct, but i might have some questions
like, it looks like, i cant create custom roles in supabase? if yes, there are ton of roles inside supabase
i can use any of them instead of manager, admin, reception, delivery boy
i hope if i pick one role, it wont interfere with supabase internal working
m
unfortunately no, i dont think so
i am making a similar solution, integrating Personio API, so handful of tricks to be played regarding roles and stuff
if you want, we could hop on a call or in a dm, i got several solutions regarding roles
j
Why not create an API that serves as a "gateway" to Supabase and any other services that you want to integrate with.
So one api that handles everything including Supabase. That way you can build your roles, and anything else you want into it.
m
you’d have a single point of failure in the system that way
it would basically turn the whole supabase stqck into monolith
id rather just add more services to the current docker compose stack
t
what I've done in my projects is a separate 
user_roles
database that maps user ids to a role (usually an int2). then, I use RLS to restrict databases depending on what number your role is
i would recommend to build up a well-defined system for this (i usually just have a google docs that also includes the schema, policy and database functions/trigger descriptions, etc.)
but do whatever works for you!
btw, you need to be a little bit careful with the RLS of the user_roles database itself, make sure you don't have any infinite recursion errors 😂
i recommend to make it be readable for everyone, or at least authenticated users
e
supabase
3 Views
PreviousNext
Powered by