not really working

hello

do we have a CDN?

Hi guys, i have a Saas project, where there can be multiple apps with their own users/login. Is it possible to use the same database for login to different apps, or do i have to create new project for each app? EG: in my saas project, i have a client named A. He will be able to create his own project inside my saas project. Within his own project, he will be able to let users login to his project. The supabase login will be used here. BUT Lets say that there is also client B. He does also offer application with login like client A. An end user is customer for both apps, he can't login to second app, as there will be duplicates in the user table. How would i solve this?

hello need your help guys, I have a table that has a foreign key to about three tables I want to implement an RLS on the main table, the main table has an isPrivate boolean flag if it's true only people under the same company can view this row and I want to apply it on the three related tables as well Is this possible? Can I get a guide on how it would look like in a policy?

is it possible to create new tables programmatically from an authenticated web client?

yes but its advised against

thanks! can it be done through the supabase JS api or I need to use PostgREST? I can't find anything about it in the docs

Would someone have an idea how I could leverage the Row-Level Security features when using a direct DB connection with an ORM (Knex.js/Objection.js)?

Does anyone know how I can create a policy that disallows selecting of certain fields?

Is this fine? I got 2 columns referencing into a single table "users"

sql
CREATE TABLE public.team_requests (
    user_id uuid NOT NULL REFERENCES public.users (id),
    team_id uuid NOT NULL REFERENCES public.teams (id),
    type VARCHAR NOT NULL,
    created_by uuid NOT NULL REFERENCES public.users (id),
    created_at TIMESTAMP DEFAULT now() NOT NULL,
    updated_at TIMESTAMP DEFAULT now() NOT NULL,
    deleted_at TIMESTAMP
);

My realtime subscriptions just keep growing and growing. Don't no why... I'm re-creating my realtime subscriptions in my React app whenever specific data changes and it's done in a single place like: subscriptions.forEach((subscription) => subscription.unsubscribe()); createSubscriptions(); But supabase.getSubscriptions().length just keep getting larger and larger? Anyone has any clue why?

Hi how to query using SQL lang?

yes, you can reference the same table multiple times. if your column "type" is more like an enum, just create one.

to join

users

do something like

col1, col2, col3, requester:user_id(*), creator:created_by(*)

. Both

requester

and

creator

are the keys to the joined user data

hey I feel like the Svelte QuickStart tutorial on Supabase docs is kinda outdated isnt it

okay so i have been getting a weird error. it says fetch is not a function when trying to read data from a table. I am using svelte

Hi All! Just bugging my head with this for the last 1-2 hrs. I am trying to fetch some data from a table that I created and I am using the API with the provided libraries. Thats my code.

But, even if the network is 200, I never get the data back, the console.log(data) simply shows an empty array. When there are actually 3 rows of data in my table. Do u think it might an issue of the promise never resolving? Is there a way to resolve it?

When there's an error with the results, supabase doesn't throw so the try catch block will most likely not catch all the errors

Rather add the property error to the destructed object i.e.

const { data, error } = await ...

And then check against that property as to what the issue is from there

no issue, the error is coming back as null.

and network request status is 200

I'd say it's probably to do with your table name being camelCased - Postgres is weird about that. If you change the table name and your request to

user_profile

, does it work?

If there is no error there also, check if your row level security entries are not the issue there, I usually disable them to debug, and bring them back after I've confirmed that the data is coming through

Also, yes @User a 100%

Thanks for that, is something I did not know. However, did not fix the issue 😛 same behavior

Mind jumping in the voice channel to go over this? @User