Error in SQL editor

Hi I have this query

let query = supabase
    .from("nft")
    .select(
      `*,
   user_details ( verified_user, id, twitter ),
   files:screenshot_file_id (file_name),
   admin_actions(*)
   `
    )
    .order("id", { ascending: false });

for

admin_actions(*)

how can i add ascending: false to that?

i did it through js

I am working on a multi-tenant app, if following approach appropriate: https://drawsql.app/connection01/diagrams/supabase-multi-tenant 1) User signup on my app (using auth.users table) a single user is created, no separate user per organization. 2) App shows them two tab: - Create a new Organization - List of organizations (they can select one and perform all CRUD stuffs as per RLS) 3) If they choose to create a new organization, a new organisation is created in

public.organizations

with created link to auth.users 4) All columns that contains organizations data contains two column

user_id

and

organization_id

5) RLS policies check if user is a member of the organization using

auth.users.raw_user_meta_data

multi-tennant app

When do auth-call (signup for example) why two DB-calls?

When I create a new function it says succefully created but functions page is always empty. When I try to create same function with same name it says it already exists. Refreshed page but still same

Yeah, I guess your function can take the client as argument and use that.

Function page not showing functions created

hello fellow supabase'rs. Have anyone implemented some auth where a user is only allowed to have a single session at a time? I.e. if I log on on one device, then it logs me off on all other devices

Hello everyone, I have the following question. If you put a million files in one folder on the server, then during browser requests (to display a picture or download a file), the server will slow down terribly. Therefore, the folder is usually divided into subfolders by dates, for example, by year and month, such as images/users/2022-2/ , images/users/2022-3/. In my backend, I do just that - first I create a subfolder, then I put the file there. But firstly, the subbase does not have a method for creating a folder, and secondly, it says that you can create folders as you like, the correct or incorrect structure is not indicated. We can definitely accumulate a million files in one folder and nothing will happen? That is, is it provided for in the final storage or not?

Is there a service disruption? All my requests seem to time out. When I load this page:

https://app.supabase.io/project/[project_id]/api

it loads forever. I can still look at the data in the tables though

Servixw disruption

Folder in storage

Automatically logging out user from other devices

Hi my supabase.auth.signIn() is not returning anything using supabase-js.

Sign In method not returning anything

Hello everyone, I am having some trouble with the js client

signIn()

method. I've added the users into my `auth.users`table using a sql dump from another PostgreSQL db (modified it a bit so I could add the required fields), now when I try running

supabase.auth.signIn()

passing the users' `email`and

password

I get the following error:

json
"error": {
    "message": "Database error querying schema",
    "status": 500
}

Yet, If I add a new user using the

signUp()

method I am able to login the newly created user without any problems. Is there any thing that I might have done wrong on during the migration process? > I looked into this discussion https://github.com/supabase/supabase/discussions/3440 and I am unsure if they are related issues as I am not self hosting the db. Thanks in advance 🙂

do we have any kind of guide for structuring our code while building apps with supabase and (react or nextjs)?

Standard code conventions should be followed as usual 🙂

Getting a "An error has occured: NetworkError when attempting to fetch resource." when performing a query in the sql editor. Is it me or the server that's having issues?

Does supabase support TG_OP in their functions?

Hey guys I can't see a tier for pro pay as you go in the dashboard. I'm already on the pro plan but want to move to pro + pay as you go. Anyone have any ideas? Thanks

Contact support and they'll discuss your requirements

Thanks @User

TG_OP

I can't seem to delete a column. I get stuck on the loading. Doing it from the SQL editor doesn't work either. any clues?

https://app.supabase.io/support/new can you open a support ticket?