Yea I think it is. I am just getting ~150ms of latency on getUser and then another 150ms latency on getting the profile for that user. then for my actual resource request another ~150ms of latency

Maybe they are releasing Supabase Functions this week, can check if using them is faster if they pass in the authenticated user in the request for u...

Yea that might be a pretty cool way to solve it. Either way open to hearing if anyone else approached this any other way.

Supabase Launch week is here people, are we all excited?

OMG OMG OMG

😆

it's launch week already

can't wait for the Twitter Spaces!

(ICYMI: https://twitter.com/supabase/status/1463885464142815242)

Inner joins are coming to the

supabase-js

client library, this is great thanks for your work @User https://postgrest.org/en/v9.0/releases/v9.0.0.html#resource-embedding-with-top-level-filtering

Thank you @User for your contributions to the Supabase Auth library, he has been adding many third party providers recently and is doing an awesome job.

Python libraries are being updated by @User, @User and others.

❤️ more soon™️

RLS is coming for Realtime this launch week

I have an app where

users

can subscribe to

pages

and submit

comments

on

pages

. I have a

users

table, a

pages

table, a

users_pages

table, and a

comments

table. I can currently pull a requested

page

, along with the

users

subscribed to it, with the following function. Is there anyway I can edit this to pull all of the

comments

for the requested page as well? Trying to fetch all of the

page

data in a single trip.

javascript
 const { data, error } = await supabase
    .from('pages')
    .select(`*, users(id, email)`)
    .eq('slug', request.body.get('slug'))

Hi, where I can report an error in a blog post?

You can create an issue!

I did a PR directly with the fixes

Just a follow-up to this. I contacted the support yesterday and they got back to me this morning and fixed the issue soon afterwards. Apologies for not posting this in a thread but wanted to give a shoutout to the great email support.

Can I create some users via the dashboard without having to associate email addresses or them having to create passwords or anything? I just want to use the Auth features to give different privileges to different clients, but I'm not planning to add account creation, login etc to my app

ie - I have one IOT device that should only be able to insert data into a bucket And I have the public user that should only be able to read a certain type of data from a bucket and I want one other user that can interact with some table

Anyone know if you can bypass email verifications via dashboard/other. Wondering how this would work for E2E testing, seeding dummy users, etc. I want email verifications… but not for local dev and testing.

clark@kent.com
peter@parker.com
bwayne@thebat.com

Dashboard > Auth > Settings, turn off "Enable email confirmations".

That would turn it off for the whole project. I’m more looking for dev | test VS production. Maintaining a second app seems overkill and tedious at scale.

Turn it on during production then...

?! One does not simply stop developing once an app ships.

But u dont want to create separate projects...

Why would you want to maintain separate projects, policies, features when the only thing different is a test user account? Like I said, that’s tedious to keep in sync at scale.

I think u can try to suggest to Supabase. But the test user accts u just need to verify once, its a one-time confirmation...

Maybe u can ask how u can confirm the users manually via code/sql by writing into the user record.