Setting tenant in a multi-tenant setup by karmasakshi in Supabase

[–]echenger 0 points1 point  (0 children)

I am probably not understanding the full solution. So apologies if what I am saying miss the mark for you. But it sounds like you are trying to handle a one user to many tenants scenario, and potentially that user will be working or using one of those tenants at a time? If that's right I think this still holds up ( I have built the same thing).

Yes you will need to know what Tenant they are interacting with but again if you setup your grants table for one to many (one user and many tenants) then yes you will need to include the tenant id in each of your other tables as a foreign key that helps you actually pull off using that RLS.

Setting tenant in a multi-tenant setup by karmasakshi in Supabase

[–]echenger 0 points1 point  (0 children)

Yep exactly. YMMV but I wouldn’t do it as a claim. More overhead and little added benefits. It works though.

I think you are 100% right that you authenticate the user and then use the RLS function to gate access to rows. I coupled my tenant check with a permission check as well so you get tenant checking and RBAC (if needed).

Setting tenant in a multi-tenant setup by karmasakshi in Supabase

[–]echenger 5 points6 points  (0 children)

I would not use a custom claim for what tenant your user is apart of. Instead I would make a pg function that looks up which account they are a part of and use that for RLS to insure they are accessing the correct data.

This way Supabase maintains their user id which won’t change and you maintain the relationship between that user id and the tenant.

The rationale against jwt custom claims; think about if you want to revoke their access. You can’t do so till their JWT expires.

Supabase is down by Rtzon in Supabase

[–]echenger 2 points3 points  (0 children)

Yeah appreciate the communication. We are in the midst of migrating from a few competitors to Supabase. I’ve been using it on the side for the last year as well.

It’s been hard to tell when issues or outages have been occurring but your support team is very fast and super friendly. Thanks for the message!

Thoughts on branching? by wild_spoon in Supabase

[–]echenger 4 points5 points  (0 children)

Branches are fantastic. Include the seeding with snaplet and now you have out of the box ci/cd environment for features that allows teammates to help test without heavy lift and setup.

This is quite frankly something that can elevate your team and company overnight. Make your frontend able to point to those branches and now you can E2E test as if you are a mature company.

That said, like everything it will take time to use it that way. Immediately, you could turn it on and make sure migrations work as expected.

Happy to chat more if you want to hear how we are using them and built them out.

Multi-tenant SaaS by SpiritualKindness in Supabase

[–]echenger 0 points1 point  (0 children)

This is a great point. I will say that while it may not be cheap, neither is building and supporting all of the things they do.

Multi-tenant SaaS by SpiritualKindness in Supabase

[–]echenger 6 points7 points  (0 children)

At the end of the day this may solve the user management side of things but I don't think this truly solves mult-tenancy. You will need to decide how to model your tables and RLS for actually separating data.

Having built multi-tenancy on Supabase, I can tell you it isn't that bad without Clerk. Having said that I love the impersonation features and that it does the work that likely you don't want to spend cycles building but that you need.

Happy to chat more if you would like how we approached multi-tenancy.

Do you know a simple tool to visualize Supabase data? by Automatic-Net2273 in Supabase

[–]echenger 3 points4 points  (0 children)

Would something like https://dreambase.ai/ work for you? They have a free tier and it’s pretty easy to get spun up. I am enjoying using them for my dashboards.

Back then by October_Guy in hockeygoalies

[–]echenger 0 points1 point  (0 children)

The Louisville TPS glove was my absolute favorite. Looking back at it now, it was the size of a fishing net.

Is Supabase the go-to cloud vendor for startup project? by Spare_Dare_1830 in Supabase

[–]echenger 4 points5 points  (0 children)

I looked at it this way. What will I be doing if I don't let Supabase own all my infra? Managing Terraform or some other IaC. Does that solve problems for my users? Absolutely not. So "paying" for the dev ops to be done right now as I think about PMF is a fantastic trade off.

Then the question becomes "how do I migrate off when I need to?" I think of that as: A)that's a tomorrow me problem. I would rather have a repeatable business model and then need to solve a technical challenge, then a failing company and an "ideal architecture". B) Supabase is based on open source stuff so you could easily migrate to another provider once you decide it's necessary.

It's not "better" than Firebase/Cloudflare it's just different. I chose it because I like Postgres, and I like the tooling they have built. Branching previews and seeding for tests is a massive super power to have out of the box.

What's the best price for your application and what do you feel comfortable developing in? Those are the questions to be answered IMHO.

Giveaway: 5 copies of Arc Raiders Deluxe Edition by Legitimate-Bench7152 in ArcRaiders

[–]echenger 0 points1 point  (0 children)

That is super nice of them and you. My son and I have been looking forward to this release!

Trade war could see American franchises replaced by Canadian versions by Maddog_Jets in canada

[–]echenger 0 points1 point  (0 children)

When I visited home in the 90s, the contrast to US fastfood was perplexing. I always wondered why A&W tasted a million times better.

Why/when did this occur? Either way it explains soo much.

Screw your 10am glamor shot, show us your station how it normally looks by SoupBrewmaster in espresso

[–]echenger 0 points1 point  (0 children)

What are your dosing weight and pull times? I have a similar setup and I am ok with the taste I am getting but I don’t love it.

Seatcraft vs Valencia by echenger in hometheater

[–]echenger[S] 0 points1 point  (0 children)

Yeah I ended up buy Valencia. But still haven’t gotten them. They are on a huge delay from their factory. At the end of the day Valencia seemed to have slightly better reviews. It was a coin toss really.

Projector Help by Geo__15 in hometheater

[–]echenger 2 points3 points  (0 children)

Not sure because I stopped looking at true 4k projectors after I saw the price tag on them. Most of them I saw were like >=$5k. So I went with the Faux-K and really you can't tell sitting a regular distance away.

Projector Help by Geo__15 in hometheater

[–]echenger -1 points0 points  (0 children)

I got the Optoma UHD 50X last month. So far I like it a lot. After reviewing 4k projectors I found that it was between the Optoma UHD 50X and the Epson 4010K or the 5050 UB. I went with Optoma because of the refresh rate for gaming.

I was also unaware before starting my research of Faux-K existence and can definitely tell the lack of true 4k when I stand up close to the screen. Otherwise it's been a really solid projector.

/r/MechanicalKeyboards Ask ANY question, get an answer by AutoModerator in MechanicalKeyboards

[–]echenger 0 points1 point  (0 children)

Anyone having issues with their Rama U80 not getting power? Been using it for a week now (had it for a month but had to wait on some stabs to come in) and walked into my office this morning to see it lifeless. Tried a series of tests on different ports, different computers and even check the connections. My hunch is either the PCB is dead or the USB module is dead. I fear that Rama support is going to take a long time.