Is it possible to migrate the database from the US to another location ?

Hello @NinjaNuur! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

Hey, I have the following tables inventory_batch

batch_id: uuid PK
created_at: int4

inventory_item

batch_id: uuid FK
name: varchar

Is it possible to select all

inventory_batch

and get all

inventory_item

with the same batch_id for each row. Or do I have to make a separate call on inventory_item?

Its certain I'm doing something wrong. I installed Supabase (Docker) on a VM on my Proxmox server. In my browser (Brave) on my Win10 laptop, I can go to http://supabase:3000. Supabase is in my hosts file and resolves to the VM IP. In the browser, I do see the Supbase main screen as expected. However, when I click on the included "Default" project it loads forever. Literally. It never finishes loading. What did I mess up?

I know there's auth.uid() available in rls policies, but I'm using discord. is there a way to access

supabase.auth.user().identities[0].identity_data.provider_id

within an RLS policy?

Question about magic link auth. I can only get it to work on the same browser that made the request. Is there a way to remote authenticate? e.g I request the email in a desktop app but follow the log in link on my phone, and have the desktop app get the successful auth too?

Couple of related questions about S3 store: - is there a CDN (e.g. Cloudfront) that is connected to the store for downloading large files? - is there a way to move S3 files from a personal AWS account to the Supabase storage buckets? We handle a LOT of data for multiple vendors …. For music production sample libraries, one product can be 200GB and there are thousands of products hosted by our system, but the files are currently all stored on the private S3 accounts of the vendors, we’d like to move that all to supabase if possible and absorb the cost on their behalf

Hi, I have a basic question. Could I relate an item in a table to different type? For example, item 1's parent is a item from the table A, item 2's parent is an item from the table B.

Hi, I want to generate graphql types or preview with graphiq but during generating there is an error

GraphQLError: Names must only contain [_a-zA-Z0-9] but "channels.delete" does not.

Hello @STILLWATER;! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

Hello @hoesmean! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

Im running supabase locally as mention here https://supabase.com/docs/guides/local-development#accessing-services-directly . I can access everything. When creating a supabase user i cannot use supabase signIn because icannot bypass the email verification. Is there any way to bypass email verification in supabase local development?

I'd like to know how I can rate limit the access to supabase edge function endpoints if these are exposed client-side and might get spammed by a malicious actor. I can imagine the risk of using up all the available tier of 0.5/2M functions calls pretty quickly unless a rate limit of some kind is enforced. I know the supabase uses kong but cannot find info on configuring/enforcing rate limits rules. Any suggestions is highly appreciated.

Hello guys, is there a way to call an API and return filtered data based on a column's value? in the example below, I want to return data with the "name" = "Football"

json

curl 'https://uhqhezqfibinawwjment.supabase.co/rest/v1/Services?id=eq.1&select=*' \
-H "apikey: SUPABASE_KEY" \
-H "Authorization: Bearer SUPABASE_KEY" \

json

[
    {
        "id": "18379db8-a931-4ede-9352-7ad719c990bf",
        "created_at": "2022-05-14T10:47:53+00:00",
        "name": "Football",
        "description": "Enjoy with your friends playing football",
        "duration": 60,
        "location": null,
        "slots": 2,
        "price": 25,
        "vendor_id": "aa98fcd2-4d64-420e-80f9-070df422f2d4"
    },
    {
        "id": "fbff8aec-b55c-4372-9bd3-ed7126679285",
        "created_at": "2022-05-15T15:37:27+00:00",
        "name": "Basketball",
        "description": "We play basketball, for fun",
        "duration": 60,
        "location": null,
        "slots": 5,
        "price": 20,
        "vendor_id": "aa98fcd2-4d64-420e-80f9-070df422f2d4"
    }
]

not sure what it is exactly but with an external auth provider (discord) the logins keep looping. i redirect back to the page i login from and it doesn't detect the login

Is there a way to customise the email/pass auth so that it is employee id / password? I'm building a QR check in app, the employees all have employee ids but not email addresses. I am not sure there is an auth method currently suited to this right?

I am using cron jobs(postgres inbuilt functionality) with stored procedures, it seems like they are not running as expected, if you see the above graph few hours per day they seem doesn't run at all. Don't see any error logs or any logs at all to debug.

Why is there/what is the reason for a new SIGNED_IN event whenever you switch back and forth between tabs?

Hello @Franck! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

Hey everyone, question on RLS policies. I have two types of users, regular and admin. Regular users can manage their own records only, while admins can manage all records. I was able to do this on a records table with the following policy. (uid() IN ( SELECT profiles.id FROM profiles WHERE (profiles.is_admin = true))) However this doesn't work for the profiles table. Any ideas on what I'm doing wrong?

Hello @Zarckk! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

Hello @Zarckk! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

Hi guys, I'm new to Supabase and I am having trouble to add a column to a public table that links to auth.users raw_user_meta_data. It is saying "There is no unique constrains matching given keys for 'users'". No RLS are set for now. I have a react app running, set OAuth with Google and created a public table called "posts" which already save in the table the registered user_uuid when posting. I don't get how to directly obtain user metadata when selecting posts in my app... Really appreciate if you could guide me on this 🙂 Thanks!

has anyone used react table with supabase yet?

Hello @StickSeas! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

Is there any way to get the access token post-auth on the server side? I have seen this issue (and commented on it) but I desperately need a solution, as I'm using Go on the backend (irrelevant but it may help in some instance) and Next.js on the frontend. However I would like to use little to no JS on the client side, and relying solely on SSR for the pages. Issue in question: https://github.com/supabase/gotrue/issues/279

Hi guys, I have a quick question. Sometimes when I login with 'supabase.auth.signIn()'I get a 'Bad Request' Error. Does anyone know what is the reason for this?

Hi, I'm not sure why this is happening

Is there a way to merge a

jsonb

column when upserting with Supabase? For example if I have a table on Postgres with a

jsonb

column containing

{"a": 1, "b": 2}

and I want to upsert a record with the same id and

{"b": 10, "c": 20}

as the

jsonb

column value. Without Supabase this looks like

sql
insert into the_table (id, json_column)
values (1, '{"b": 10, "c": 20}'::jsonb)
on conflict (id) do update
   set json_column = table_name.json_column || excluded.json_column;

With Supabase it doesn't seem you can provide do something like

typescript
await supabase
  .from('the_table')
  .upsert({ id: 1, json_column: {"b": 10, "c": 20} }, { onConflict: 'json_column <something here?>' })

Hello. In review of the documentation for Edge Functions, I can't find the specified memory limit: https://supabase.com/docs/guides/functions What is the runtime memory limit during each invocation of an edge function?