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

Supabase

https://twitter.com/silentworks/status/1454372504852733953

From the looks of it no. Also Its not realistic lol

Hey,
I’m trying to add authentication to my react native app but I need to store the email address and userId of the user in my own database(expressJs, mongoose). 
How does authenticating the requests to my backend works? Any tutorials?

<@!816438679970119691> 👋🏼 How come your not using the supabase database? If you were using that you could make use of triggers and RLS

Unfortunately I have already setup the project using mongoose so it will take some time converting all the code to supabase. I will consider it for my next project

You can configure the maximum number of rows to be returned

does the python wrapper for supabase can connect stuff on postREST

How can I set up an on insert RLS policy? Google has returned me no examples of help, and my requests always error even if I set with check to just be true.

```sql
CREATE POLICY "Allow users to insert their credentials"
    ON public.credentials
    AS PERMISSIVE
    FOR insert
    TO public
    with check(true);
```

But the library then decides to say `"new row violates row-level security policy for table "credentials""`

the library also returns the new row u inserted

or u can set the return type of the query to be `minimal`

Now to get update to work so I can upsert

Does on conflict require to be able to select?

That's not even an English sentence. Please try again

is the supabase-python lib ready enough to connect to postREST

I would presume yes. Please have a look at the GitHub repos for that info. Also postgrest is a core part and I believe there is a library called python-postgrest

hmm I could connect to postREST just like in a local postgress server right? I just have to give a link?

Is there an easy way to export a supabase project and import it into a new project?

At the moment there is no easy UI way of doing this, but you can export the project using `pg_dump` and re-import it again. There is a guide here https://supabase.io/docs/guides/database#migrating-between-projects

You can't at the moment, but you can export your database and import it into a new project, you can read more from the guide https://supabase.io/docs/guides/database#migrating-between-projects

quick note in case others attempt to follow that guide -- I found myself needing to exclude the auth.identities table in order to pg_dump successfully

`--exclude-table=auth.identities \ `

also not sure if this is a version change w PostgreSQL but the commands listed in that guide needed `-f` flags before the filename in each of the commands.

final command that worked for me was:

`pg_dump \              
-h db.PROJECT_REF.supabase.co \
-U postgres \
--clean \
--schema-only \
--exclude-table=auth.identities \
-f supabase_schema.sql`

Hey all I am running supabase from netlify with pg bouncer at the url `postgres://[pass]@db.[dbname].supabase.co:6543/postgres?pgbouncer=true` This is the second weekend in a row where my site has gotten a decent amount of views and I keep hitting this error message.

```
Error querying the database: db error: ERROR: no more connections allowed (max_client_conn)
```
Am I doing something wrong? Looking at the connections in supabase doesn't seem to look like I am using them. Maybe I configured something wrong