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

Supabase

Not sure I follow—`length(text)` gives the number of characters for  `text`, while count gives the number of results for a given query?

You really should ask these questions in one of the help forums as some of us hesitate to offer help in this thread as moderators keep saying not here...

Anyway you will need to do a view with the length as a calculated column, add a calculated column to your table, or use an rpc call  to a postgres function and return a table with a select and your length.  

You could also just do an array map  on the result in javascript...

My bad I didn't understand correctly <@616263168762576918>

appreciate the help regardless, <@!371564915414007809>  🙂 

and <@!764524500162445402> thank you, calculated column will do then, I believe.  (and apologies for ending up in the wrong channel)

for posterior, here's the copy&paste for a calculated column:
`alter table tablename add column int generated always as (length(content)) stored;`

Hi, how can i create admin permissions in supabase so enable myself and my cofounder to both invite new team members to our supabase instance? Right now only one of us is "owner" and can invite others. Thank you!

Is there a way to use the pg_hashids extension within the supabase js functions or is pg_hashid only available when writing raw sql?

Hey guys, would it be possible import over 200 million records into Supabase that is coming from a text file?

This should be possible but your text file would need to be processed somehow or have to already conform to your table columns. So CSV import is something you could do. I found this article online about how to import large CSVs into Postgres https://www.tractionondemand.com/blog/using-copy-in-postgres-for-importing-large-csvs/

I concur with what silentworks said.

COPY is definitely one way to go, but getting it as CSV format which has the same columns as your table is crucial.

If you can manage that, then something like this, along with some sort of lib to stream the data, can help clear the table and import the new data (but won't clear the table unless the import succeeds):

```sql
BEGIN;
    TRUNCATE TABLE my_table;
    COPY public.my_table (column_1, column_2, column_3) FROM STDIN CSV HEADER;
COMMIT;
```

Depending on the specifics of the data (e.g. for delimiting, or handling quotes in the data), you might also need to look at adding some additional info after `HEADER`:

```sql
QUOTE '\"' ESCAPE ''''
```

Thanks a bunch <@!107176742342402048> and <@!336983535074279444>

Is this possible to do from within the supabase console? As in import that CSV file?

Ok I found an option to do this but the CSV file I need to import is like 8GB.. again.. 200 million records.

Really not sure what the best course of action is here

If you're hosting it on the Supabase platform (i.e. not self-hosting), and you're not on the pay as you go plan, you're unlikely to be able to import that much data as you'll hit disk space limits and the import will fail.

I know this, because I hit my limits last year, still needed more space to import even more data, and ultimately ended up switching to self-hosting to resolve it.

The most reliable option for importing huge datasets is to use postgres COPY via either a streaming library, or via a dedicated tool like pgadmin.

Ok I think its best if I self host supabase then thanks <@!336983535074279444>

Its just if I do pay to upgrade will it even work? I guess I'll need to ask the support team

Import large amount of data into Postgres

does oauth login work with local development? https://supabase.com/docs/guides/local-development

i keep getting `"Unsupported provider: Provider is not enabled"`

and i followed  everything here https://supabase.com/docs/guides/auth/auth-discord

My other appli cation that users discord login works perfectly fine

I saw this issue but it doesnt answer the original question

https://github.com/supabase/supabase/discussions/2818

what is a gotrue config? there is no mention of anything about configuring a gotrue file in the supabase docs

See here https://github.com/supabase/cli/pull/138   being worked on if you use the CLI.

Gotrue config is the env vars which are passed to the auth docker container (which is what you should have if you set it up locally)

so does that mean i completely ignore https://supabase.com/docs/guides/auth/auth-discord

im still confused. so basically all i have to do is create a .env file and put all the oauth credentials in there and it'll just work?

If you've already got the containers running, then it's the docker container env vars you'll need to update - creating a .env file and hoping it works !== updating the container variables.

I'd suggest looking at https://github.com/supabase/gotrue#external-authentication-providers for more details on what options can be configured. We should really have had this in the help channel too, rather than general

ok ill take a look thanks... maybe the docs should mention all this cause i couldnt find any information about this or maybe i missed it somewhere

ok i added my oauth credentials to .env file but still doesnt work

restarted local server and still doesnt work

if anyone has any ideas, please send me a message. thanks

Is there a way to kind of export the changes made in a project (to be saved in git) so it's easy to remake the whole project from scratch?

Look at migrations and what it means. It's exactly that, chagnes made in the db structure etc... 🙂

I'm handling migrations of the database schema, I was questioning all the changes that happen on the UI

<@!318748405515943936> https://supabase.com/docs/guides/local-development#migrations 🙂

Like the auth client and configuration, email templates, Turning on Realtime on tables, enabling extensions, and so on

Some things can be synced while others cannot. From your list here you can't sync auth client configurations or email templates because these currently aren't stored in your own database. The others listed can be synced with the use of migrations as <@!91906219538677760> has pointed out.

Thank you! I feel it's always better to plan how working in a team would go

like if we 2 in a team working locally, how can we sync? database dumps?