supabase trpc and db tables setup question
I'm working on a full stack react assessment.
The project requirements specify:
- Frontend: React 18+, TypeScript, Tailwind CSS
- Backend: tRPC, PostgreSQL or Supabase
Additional requirements include input validation, type-safe API routes, error handling, etc.
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
Would using Supabase directly (via the JS client) be considered acceptable here? Or do people typically combine Supabase with tRPC for more control?
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
Additional requirements include input validation, type-safe API routes, error handling, etc.
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
Would using Supabase directly (via the JS client) be considered acceptable here? Or do people typically combine Supabase with tRPC for more control?
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?
