Qwik JS Full Stack App | Supabase Setup | Part 3

When developing a Full Stack SAAS application with Qwik JS on the frontend (or any other frontend), you will likely need users. This means having the ability to authenticate that a user is who they say they are and then authorise them to access certain pages and functionality on the site depending on their role. In this video, we setup Supabase in such a way that it will create a profiles record within a profiles table that we create, for each user that gets created. When a user signs in, we can then control the pages that they should view using Supabase and Qwik JS with ease.

Coding Courses:

Coding Packages:

[brachypelma]

I tried bumbling around and figuring stuff out myself, and only got frustrated. Then I came here, and everything is clear as day. I like that you explain not just of what you're doing, but why. Thank you so much for making this series.

[johncornyn]

This video doesn't have enough comments about how great this series is. SO I'm adding one, thanks so much for working through Qwik and Supabase and sharing your hard won knowledge. It IS valuable!

[JavierCarrion]

I loving supabase. I want to tell you I really appreciate your detailed explanation about policies. You are doing a great job I am learning a lot. So, I am going to shut up and code!

[Cazineer]

Amazing series! I'm eagerly waiting for the next video!

[ernestaszemaitis]

I am stuck with a superbase trigger. I can't set trigger on auth.users. In Add a new Trigger > Conditions to fire trigger > Table there is only one 'profiles' table. What am i doing wrong?

[hsider]

I've had an interest in SSG apps recently is this is just amazing to see, Qwik is fantastic and suprabase seem as a good alt to firebase. Keep rocking I can't thank you enough 👌

[santosharakere]

I had to use `(auth.uid() = id)`, just using uid() was throwing error.

[keepkoolpt]

awesome series, everything was clear and very well explained, keep going and thanks for your work, love it, this deserve a lot more attention

[jhaiufltb]

Hello! I started a new supabase project and want to edit foreign key relation for `id` (3:13 in the video).
But got the message:

Failed to update column "id": failed to update pg.columns with the given ID: cannot cast type bigint to uuid

I didn't get luck with googling the message, how to do this successfully? Thank you!

[jackepner]

Text and varchar are basically the same, except varchar allows you to place a limit on the number of characters.

[quilagameplay]

(auth.uid() = id) will work for policy

[catafest-work]

I got this error: Error adding policy: failed to create pg.policies: function uid() does not exist, here is defined this uid() ?

[jackepner]

Running into a lot of problems... id created as int8 is fine, but can't link to uuid, being different types. I try to change the original id column to text or varchar, and says it has to be an int type. So... don't see a way to link those as you have.

[tomasnevoral]

what do think about pocketbase, i have small project to create rezervation page for trainings and i am big fan of go programing language so i was thinking about that, because rest of backend is also go so i will ship only one binary.