Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Gonna be better to talk, and avoid to flood :p

Hey everyone I have a question about using supabase as a auth provider for an api
I log the user in and get the access token, but I am not sure how to use that access token to make requests to supabase again.
I try to create the client using the access_token as the key but no dice

of course I just needed to ask lol, figured it out by using supabase.auth.api.get_user(jwt)

Is supabase slow/down or something? All of my SQL queries are (suddenly) slow as heck

yeah my queries are randomly slowing down

Never had the time to try it, but does the API support querying tables in the public schema as well as views?

Hi, just wondering how supabase is handling input validations?

anyone wants to continue or contribute my supabase and notus template project

Damn guys I loved implementing RLS on my new Database... This is miles away from Firebase rules 🤯

Hello everyone, is there any **.new** domain such as **supa.new** for creating a new Supabase project 👀 ??

are there any good nextjs + supabase tutorials out there?

I'm curious about user authentication. Would it be possible to connect my Keycloak server?

Particularly, would it be an ordinary use of Supabase to host just my JWT-secured API and database with Supabase?

Good suggestion, what about putting in <#867348150741237790>  😉

And also to answer to your question: not yet, but i think it could be awesome if we have this feature :p

Morning! Just noticed this PR https://github.com/supabase/supabase-js/pull/252

Am I missing something or it is indeed supposed to not access localStorage unless methods are actually used?

Was gonna start working on a lazy access approach to prevent client totally breaking if it doesn’t have access to localStorage even if you don’t use Supabase (but you’ll still have imported).

Then I noticed the PR and got excited - it doesn’t seem to do that though.

*Note: I might’ve just missed something in my codebase that actually initializes the client and the PR actually does what it says it does*, but wanted to see if anyone had any thoughts on it before I started my day

Okay skimming through my repo on the phone guess I found the obvious culprit - exporting an instance of the client from `createClient` so I am actually initializing it even if not needed

Hello! How's supabase handling real-time notifications?

Hi there, I got an error saying I need to reload the schema cache. I tried to run `NOTIFY pgrst, 'reload schema';` as [this answer](https://github.com/supabase/supabase/discussions/2935#discussioncomment-1230889) said, but it still doesn't work. Should I wait for a period? if yes, how long?

What does `relation "auth.users" does not exist` mean? I want to create a users table in SQL editor but got this.

Here is the SQL
```SQL
-- 创建一个公开用户表
create table public.users (
  id          uuid not null primary key, -- UUID from auth.users
  email       text unique,
  nickname    text,
  avatar_url      text,
  updated_at  timestamp with time zone default timezone('utc' :: text, now()) not null,
  created_at  timestamp with time zone default timezone('utc' :: text, now()) not null
);

-- 新增一行用户数据的函数
create function public.handle_new_user()
-- 权限：https://github.com/supabase/supabase/discussions/306#discussioncomment-138424
returns trigger as $$
begin
  insert into public.users (id, email, nickname)
  values (new.id, new.email, split_part(new.email, '@', 1));
  return new;
end;
$$ language plpgsql security definer;

-- 每当新用户注册时就触发上述函数
create trigger sync_user
  after insert on auth.users
  for each row execute procedure public.handle_new_user();

-- 创建用户表 RLS
alter table public.users enable row level security;

create policy "用户数据可以被所有人查看"
  on public.users for select
  using ( true );

create policy "只有自己才可以插入自己的数据"
  on public.users for insert
  with check ( auth.uid() = id );

create policy "只有自己才可以更新自己的数据"
  on public.users for update
  using ( auth.uid() = id );

-- 头像存储
insert into storage.buckets (id, name)
values ('avatars', 'avatars');

create policy "图片是公开的"
  on storage.objects for select
  using ( true );

create policy "登录用户才可以上传"
  on storage.objects for insert
  with check (
        role() = 'authenticated':: text
    );
```

Does anyone else seem to get logged out/have their session expire every minute or so? I keep getting an unauthorized message when working with my tables and having to click log in 5 or so times every few minutes to get it to work

Yes, every time after I run some SQL code 😭

Super annoying. I wonder if there are some issues going on behind the scenes

Seems like I can't create a relation with `auth.users`, should create with `public.users`.

you should be able to use something like this to set up a public users table based on the auth.users table 
```
create table public.profiles (
  id uuid references auth.users not null,
  first_name text,
  last_name text,

  primary key (id)
);

alter table public.profiles enable row level security;
```