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

Supabase

Hi, does the realtime work with RLS?  I know in the past it didn't...

Hi, it does not. We are working on it though. Till then you can disable realtime for private tables. https://supabase.io/docs/guides/auth#disable-realtime-for-private-tables

Hi there. Is there somewhere I can see the feature parity with firebase?

https://supabase.io/docs#what-it-isnt
we dont aim to have a 1 to 1 feature mapping with Firebase but if there is some feature you would like to see, open an issue for it 🙂

I think it was mostly support for custom JWT token that was missing before

hello. i had a question about how the pricing works, i see that it is priced for storage so how does it scale? like does it scale infinitely or are there restrictions in docs somewhere that i missed

<@!414972572732489748> got any screenshots of the job board ?😍

i built https://pirate-moor-1615008438.versoly.page/ (might lag a little at the start, using Vue.dev) lol

Hi people👋 just wondering what would be the recommended approach to implement Select/Enum type in supabase tables.
Thanks🙏🏼

I usually create separate table with the options to choose from then set a foreign key reference

```
— table for the options
create table select_options (
  id uuid primary key default uuid_generate_v4(),
  name text not null
);

— some other table
create table other_table (
  select_option_id uuid references select_options not null
);
```

there's a nice trick mentioned in "SQL Antipatterns" by Bill Karwin  (the chapter was "don't use Enum" 🙂 )
```
create table options (
  option_type varchar primary key
);
create table items (
  id bigint primary key,
  option_type references options
);
insert into options (option_type) values ('allowed'), ('allowed_as_well');
```
it's quite convenient, as you get to control what values are accepted, you keep your relational guarantees, it stays readable and you get to save quite a bit of joins

How can we search through multiple columns in supabase??

Just add more query params . Eg: ```javascript
supabase.from(“todos”).select().eq(“isDone”, true).like(“label”,”Search term”)
```

Tried but if i use same kind of params it returns null data if i use different params it is giving error "operator does not exist"

Got it You can use .or() to search through multiple column

Hi guys, is it possible to selfhost supabase with the Dashboard UI?

wow this is nice <@!136913357990002688>. This is as far as I've come so far
You can follow progress here: https://github.com/kiwicopple/open-source-job-board

Hi!

Do we have to satisfy `SELECT` RLS policy before a user can make an `INSERT` record?

You do not but, iirc postgrest attempts to return on insert even with minimal return.

Or something like that. I remember not being able to skip a return so I had to grant select permissions.

has there been any guide been written on postgrest for supabase? I've been seeing a lot of people struggle with writing queries on the client sdk because the docs touch crud operations only and afaik you can still leverage the flexibility of postgrest even via the client side sdk to achieve most of the stuff that people wanna do

man I love when I get dm’d by scammers on discord

watch to see where requests go, and spam their database with others so they can’t even collect stuff lmao

never realized how easy it is to spam a database, only reason I filter all of my data that gets submitted to my table.

Hey all! I am a React dev and im looking to switch from firebase to supabase. Any docs I can find how to interact with database on Supabase from a React app?

Yes! There is a next.js example: https://supabase.io/docs/guides/with-nextjs and a react one: https://supabase.io/docs/guides/with-react