Hello, im using self-hosted version of supabase running on docker-compose. I have a question regarding storage, how can I change it to my own S3 bucket?

How to prevent user from updating created_at

Links sent to email always go to root route,how do I configure this?

authentication settings

now that i’m awake i can answer questions for this haha

Thank you but I have tried and it is not working

it needs to be the exact url if i’m correct, not just the domain

hey y'all o/

I'm trying out supabase with prisma and was wondering if it's at all possible to use row based security with prisma?

it seems redundant to create a user model/table when supabase already has one for auth

Evening all - does anyone know if it's possible to reset the API key for Supabase? I'm working on a little side project using an unfamiliar frontend framework and managed to expose the key in version control... 🤦‍♂️ I'm using the package https://github.com/supabase-community/nuxt-supabase and currently have the URL and API key in my

nuxt-config.js

but this seems like it's probably a bad idea...

hey I have a quick postgREST question, it seems that request.headers nor request are available when I call current_settting() in my postgres function, does that need to be enabled somewhere or maybe i'm missing some privileges? any suggestions?

ah I found the answer. for future searchers there was a syntax change in postgres 14 https://supabase.com/blog/2021/11/28/postgrest-9#postgresql-14-compatibility there are correct examples in the docs as long as you have them set to v9.0 or higher https://postgrest.org/en/v9.0/api.html

I'm trying to order a custom request. I get de data back, but it is not ordered the way I want. Here is my function:

I guess that would depend on the value of

ordre[1]

, no?

API key

ordre[1] is a boolean saying if it's ascending or not

Hi, I am wondering what a js/ts testing setup with supabase normally looks like. Do people use the Supabase Docker in their CI/CD?

Hey guys, I'm getting an error running

docker-compose -f docker-compose.yml -f ./dev/docker-compose.dev.yml up

using default .env details. Everything works great until one of the containers tries to query the database when I get the following:

prolog
supabase-rest      | An error ocurred when trying to query database settings for the config parameters
supabase-rest      | ConnectionError (Just "connection to server at \"db\" (172.19.0.4), port 5432 failed: Connection refused\n\tIs the server running on that host and accepting TCP/IP connections?\n")
supabase-rest      | Attempting to connect to the database...
supabase-rest      | {"details":"connection to server at \"db\" (172.19.0.4), port 5432 failed: Connection refused\n\tIs the server running on that host and accepting TCP/IP connections?\n"}
...
supabase-auth      | level=fatal msg="running db migrations: Migrator: problem creating schema migrations: couldn't start a new transaction: could not create new transaction: failed to connect to `host=db user=postgres database=postgres`: dial error (dial tcp 172.19.0.4:5432: connect: connection refused)"

I'm pretty new to all of this (and especially docker) so I don't know what to try next. No error logs. I'm on Debian 11 on Digitalocean, but I also tried the one-click docker image on Ubuntu 20.04 and got the same issue. I don't think there are any firewall entries besides the ones docker has made. Don't see any relevant issues on Github, and can't find any good tutorials on how to properly self-host on a dedicated vps (besides the catch-all self-hosting docs). Any suggestions? I feel like I'm probably just missing something stupid 😦 Since I'm still using default .env I shouldn't have to make any updates to docker-compose.yml right?

hi, did anything change in regards to some IP allowlisting or anything? I cant connect to prod db in preview deployments on vercel anymore, and neither locally when running a build in a nextjs project -- exclusively on feature branches however. prod works as usual, oddly enough. the connection string is unchanged and I double verified it 🤔 this occurs exclusively in a nextjs route prerender fwiw. edit: now thinking about it.. thats more likely the issue rather than ip range allowlisting 🤔 further edit: not only happening on the branch, could reproduce outside. im seeing 7-8 active connections in the supabase app, even when its 7 i cant connect to it 🤷

Hey guys. For some reason .list() is returning an empty array when there are contents in the folder.

const { data, error } = await supabase.storage
            .from('images')
            .list('test')

Probably a policy issue (RLS) on the bucket. You have to supply policy on storage.

That's what I am thinking. I listed it as public but will update the privacy policy anyway

Yes, public only has to do with the public url. Everything else still needs RLS.

Hey anybody built a custom socail auth with Salesforce + Supabase before?

👋 can anyone help me figure out how to filter a query based on a value in a text array using the supabase-js library? In the code below, the

title

column is

text

and

tags

column is

text[]

. I would like to query them both using the

or

filter to see if a given

searchTerm

was there. Is this possible?

js
const response = await supabaseClient
  .from('items')
  .select('*')
  .or(
    `title.ilike.%${searchTerm}%,tags.cs{${searchTerm}}`
  )

The above example does not work.. any ideas

@User is the

searchTerm

a string or an array?

Does it yield a specific error or just an empty result set?

searchTerm

is a string

The error for the above code is:

json
{
    "reason": "Problem fetching feed",
    "error": "\"failed to parse logic tree ((title.ilike.%reading%,tags.cs{reading}))\" (line 1, column 43)"
}