supabase trpc and db tables setup question
I'm working on a full stack react assessment.
The project requirements specify:
I'm considering using Supabase-only (auth + database + real-time updates) and skipping tRPC altogether — since the spec seems to treat them as mutually exclusive.
That said, I know that Supabase doesn't have tRPC-style routing out of the box, but:
And for db tables, what's the best way to define tables in this case? Since there’s no backend/ORM layer , should I just create the tables directly in the Supabase UI (or via SQL in the SQL Editor)? Or is there a way I should still define them in code and do migrations?
The project requirements specify:
- Frontend: React 18+, TypeScript, Tailwind CSS
- Backend: tRPC, PostgreSQL or Supabase
I'm considering using Supabase-only (auth + database + real-time updates) and skipping tRPC altogether — since the spec seems to treat them as mutually exclusive.
That said, I know that Supabase doesn't have tRPC-style routing out of the box, but:
- The Supabase client SDK gives me types
- I can do input validation with Zod or custom logic in the frontend
And for db tables, what's the best way to define tables in this case? Since there’s no backend/ORM layer , should I just create the tables directly in the Supabase UI (or via SQL in the SQL Editor)? Or is there a way I should still define them in code and do migrations?
