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

Supabase

go to your storage tab, go to policies, and create a policy that allows your users to insert into objects. (i just used a template)

Okay thanks, will give you a feedback when I've tried it

Hi <@596095993515343897> , I included this policy but it's still giving me the same error

it gives you an error when you try to upload files?

I'm afraid I cannot help you any further then, because this is all I know and it worked for me 😦

You should get help from the team in Github discussions on the repo

Okay, can I ask one more thing....to init your supabase client, you used the supabase URL and public key yh?

Same thing I'm doing, don't know why it's not working

After creating a new project from scratch, if you visit the `/auth/settings` page and scroll down to the logs, the first line of the logs will be:
```
w transaction: failed to connect to `host=db.{projectId}.supabase.co user=supabase_auth_admin database=postgres`: server error (FATAL: password authentication failed for user \"supabase_auth_admin\" (SQLSTATE 28P01))"
```
I've tested twice now and gotten the exact same error in the logs. I assume it is safe to ignore, but can anyone confirm that is definitely safe to ignore that error?

yes! safe to ignore. This happens because the auth server comes online before the database is quite ready to accept connections

ok cool, figured it was not a big deal but thanks for confirming!

Can some help me how to implement query like this one?

2nd from is of user_from user uid of user  and 3rd row is user_to uid of user who he is following

Is the user uuid always the same one or is it a parameter that you pass in?

Yeah that i written here would be the current user uid

Mean it is the query to get posts of whom a current user is following

So this uuid would be dynamic and not static right?

I have written static to check is the query works

The best way to do this is to create a database function and call it via the `.rpc` method on the SDK

I can’t give an example right now as I’m on my mobile, but if you check the Supabase GitHub discussion board you will find examples I’ve given in the past. Just search for .rpc and you should get some results

you could simply do this:

```
final response = await _supabase.client
        .from('posts')
        .select(
          "*, user:user_id(id, username, profile_picture)"
        )
        .eq('user_id', uid)
        .execute();
```

for friends table, my table is designed in a way like this

friends_table -> follower , following, created_at, both follower and following are primary keys. 

then simply to get followers from supabase 

```
final response = await _supabase.client
        .from(FRIENDS_DB)
        .select(
          "*, following_user:follower(id, username, profile_picture), "
          "follower_user:following(id, username, profile_picture)",
        )
        .eq('following', uid)
        .execute();
```

to get followings

```
final response = await _supabase.client
        .from(FRIENDS_DB)
        .select(
          "*, follower_user:follower(id, username, profile_picture), "
          "following_user:following(id, username, profile_picture)",
        )
        .eq('follower', uid)
        .execute();
```

Hey I made rpc method but having issue in return type can you help me out

Open an Discussion on https://github.com/supabase/supabase/discussions and I will assist you there

<@!649997861240438784> I've replied to your discussion topic I'll paste the link here for anyone wanting to get involved or having the same question https://github.com/supabase/supabase/discussions/2741

<@!649997861240438784> can you modify the title to **How do I get query data from a database function?**

You're welcome, I'm sure this will be useful to someone else in the future too. At some point I will try and work out how to do this with the actual function UI in the dashboard.

I want to get the post whom a user is following

User_from the uid of user who is following and user_to the uid of user whom user following

It would be similar if tell me in JavaScript

<@649997861240438784> please create a thread and continue the conversation there as it’s easier to keep track that way

Hey guys .... does anyone have an example project using superbase auth and real-time chatting  based on Expo  react-native CLI

<@&844001800214020128> just wanted to double check if y'all could help here

Please send an email to beta@supabase.io for this request or use the feedback widget inside the dashboard

Hi.
Could somebody tell me are there any limitations in database space, users, storage and other things mentioned in price plan if supabase is self hosted?

If it's self hosted your limit is your budget for the services you will need to self host it

so if I host is on my own device there's no limit? 🙂

From what I can see, yes there are no limits. Just know that the Dashboard isn't available to be self hosted as yet, so you will need to use a Postgres client to interact with the DB or create your own Dashboard.

That's okay.
Is it known when will dashboard be done?

Dashboard is ticked off on the Supabase GitHub page https://github.com/supabase/supabase so it's probably not a planned feature to make it selfhostable. For now if you are looking for a user interface with you database just use pgadmin

Anyone have any experience using Supabase with Prisma?

I'm a big fan of the Prisma ORM, and think it will make working with the Supabase API a big easier. I looked at this article (https://dev.to/prisma/set-up-a-free-postgresql-database-on-supabase-to-use-with-prisma-3pk6), but wasn't sure if it would totally screw up authentication or any Supabase-specific features?

Hi , please can I message you privately regarding Prisma ? <@628243486214324246>

<@720546026288578592> were you able to assist <@628243486214324246>? I'm running into the same problem, i wish to access auth.user from prisma and create a relation with another table.

<@204800367836266497> hi, no I was the one who needed help.