When I have images in storage, how can I reach them in my frontend?

export async function getStaticProps() {
  let { data } = await supabaseAdmin.storage.from("gallery").select("*");
  return {
    props: {
      images: data,
    },
  };
}

This doesnt work.

hello, in local development (with docker) where i can enter Google credentials ?

Hello, I added a unique constraint to a column via the SQL editor but I don't know how to delete it. any help?

Hi sorry for creating one more post, got awesome help but i struggle a bit with a thing.

export async function getStaticProps() {
  const { data, error } = await supabaseAdmin.storage
    .from("gallery")
    .list("categories/sport", {
      limit: 100,
      offset: 0,
    });
  return {
    props: {
      images: data,
    },
  };
}

in this code in sport folder i have two sub folders, football and golf with images in those subfolder. how could I retrive all the images from each subfolder into categories/sport? so when i go to sport i want to retrive all the images from sports subfolders images if you understand me! 😄

hey, experiencing extremely slow loading times/timeouts on my supabase instance on a app running right now which is in production. is there anyone i can speak to to trouble shoot this issue?

If I run the following function through the JS library, and the email address does not exist in the Auth table, shouldn't I get an error back? let { data, error } = await supabase.auth.api.resetPasswordForEmail(email)

Hey guys, is it possible to do nested queries using the js client?

Is there a way to see a log of Custom SMTP actions? I am trying to figure out why I am not getting email with the Custom SMTP setup.

Hey everyone, I'm the worst at SQL and I'm trying to create a RLS policy as follows: Plan ---- id, isPublic, ... PlansOnUsers ---- planId, userId Grant access to Plans only when plan isPublic = true or when user is accessing a plan with their own userId, does that make any sense? Is it possible?

Hi Jon, in regard to this tut https://leveluptutorials.com/tutorials/realtime-remix-with-supabase/create-a-higher-order-function-helper-for-serverside-supabase-queries I'm getting an Error: Cannot initialize 'routeModules'. This normally occurs when you have server code in your client modules.

Hey feeling like I'm blind here. With the following query `data === []`:

console.log('getOneJobFromDb', jobAddress)
let { data, error } = await supabase
    .from('jobs')
    .select('*')
    .ilike('address', jobAddress) // using ilike to manage case-insensitive search
if (error) {console.log('eerrrororor', error)}
console.log('DATA',data)

I expect to receive ONE hit. Because when I copy paste the value of

jobAddress

into the filter in the table exploration of app.supabase.com, it yields the expected result:

For some reason supabase is not adding site url there (Docker)

Anyone have an idea how to resolve the following error? First time trying to do this. I'm running on an m1 pro machine and did a fresh docker install.. supabase start Error restoring branch main: Branch was not dumped. Error: Error response from daemon: error creating overlay mount to /var/lib/docker/overlay2/bef748b6cfd52bcbc9b6c5394f41dbc99f732cda25be0afa6844c7496ece2de7-init/merged: too many levels of symbolic links

I managed to fix it myself. I removed all the images. Probably got corrupted at the first attempt.

hey guys! Supabase newbie here. I have just done a 'login' page and now trying to retrive data from the fetch API. When i try this i get an error: "permission denied for table [name]" code 42501. Do you need to pass in any clever credentials or is it smart enough to cover the auth tokens etc? RLS is disabled so not sure how to resolve.

Hello everyone! I was wondering what is the best way possible today for executing different writes from an action?, a transaction-like process. To be more specific, when I create a user (auth), I want to create a row linked to this user in different tables in public database (ex. wallet, profile, etc). I was thinking about create a trigger, which calls a function, that function will handle the insert in different tables and it would work. But I was thinking... what if some of these inserts fails for any reason, will I end up with inconsistent data? with partial inserts or any thing like that?, if so... there's any way to avoid that risk? thanks a lot in advance

Hello, is there any article or documentation on the upgrade process of a self hosted supabase docker image to prevent downtime? I did not find any guideline on upgrading the self hosted supabase instance at all, thanks in advance.

Not sure if this is a feature or a bug, but - When I try to create a column in the supabase UI like "postIds" which is an array of uuids that are meant to reference records in another table - I'm only able to create it if I don't include a foreign key relation. Is this just just a Postgres limitation, or...?

I deployed supabase via the helm chart in the fork of the most recent PRs on the community helm chart repo. It comes up fine but when i try to connect to 'default project' in studio the api call to the rest service fails with a 401

Hello. Not sure what is the issue, but I cannot sign up to Supabase. I clicked "Start your project" and then signed in to my Github account, but this is the error that is displayed in the address bar: #error=unauthorized_client&error_code=401&error_description=Unverified+email+with+github I haven't receive any confirmation email (besides the one from Github informing me that I am sharing data with Supabase)... Did I do anything wrong? (Edge browser arm64, macOS)

Hi, in my storage I have categories/sport/football and inside football i have 2 images, and in sport folder i have a also a subfolder, golf with 1 image. But could I somehow grab that sport folder and get back all the images from each subfolder from sport folder?

const { data, error } = await supabaseAdmin.storage
    .from("gallery")
    .list("categories/sport", {
      limit: 100,
      offset: 0,
    });

Wiht this i just get back the folder, but not the images or subfolder. Is this possible?

I have supabase running now and have been able to use it, but I only have the 'default project' and I don't see how to create new projects

can i read a json response in sql editor without just saying [object Object] ...

Hello everyone! does anyone knows how can I set the limit for the records to INSERT for a particular table?, what I want to achieve is to prevent the user to be able to INSERT multiple rows in a single call. I can do that from the front-end but of course I would like to ensure that from the DB itself for security reasons. Thanks in advance!

Hi everyone, does anyone knows about raw query feature in javascript version?

My database is getting reseted (all data is getting deleted) when i run supabase stop and supabase start again on my local environment, how do i fix it?

Can I getPublicUrl from sql?

select publicURL from storage.objects where id = '...'

something like this maybe. But i dont see a url in that so maybe something else

Hello, is their anyway to check a user input filed in rls policy. So what I want to achieve is to check in user profile if the location field id matches to a data which is coming from front end. Thanks

Hello, I wanted to ask about triggers on delete event. Is there a way to use something like "new" keyword for removed row? It seems that if I'm using

new

in function triggered by on delete trigger, it's not working properly. Thanks for help 🙂

Is there a way to limit rows from

talents

based on data from

proposals

table in this query? Like I only want rows from

talents

if if a match between

talents.id

and

proposals.talent_id

let { data, error } = await supabase
            .from('jobs')
            .select(`*, proposals(*), talents(*)`)
            .ilike('address', jobAddress)