Supabase #help

Needle

04/14/2022, 4:16 PM

Hello @Koen! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! 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.

aquaspirit

04/14/2022, 5:57 PM

how do wipe the all data while keeping the table structure?

AshwaqAzan

04/14/2022, 7:49 PM

Hello everyone, I want to signin users by phone only "No password".. is it possible to do it using supabase api as My sms provider is not in the list of Supabase sms providers

Efizzz

04/14/2022, 8:38 PM

Am I dumb? I have been really trying to insert into my supabase, but it's just not working. Method looks like:

Copy code

javascript
  const insertListing = async () => {
    try {
      const { data, error } = await client
        .from("product")
        .insert([{ title: "hello" }], { returning: "minimal" });
      console.log(data || error);
    } catch (error) {
      alert(error.message);
    }
  };

I see that I am an authenticated user in the session when I run the function And I can see that I am hitting the API: 200 OPTIONS /rest/vi/product But I get an error in my console: FetchError: Failed to fetch Not sure what it's trying to fetch if minimal is on... and this is an insert any way. Should this be an OPTIONS rather than POST?

Chezaur

04/14/2022, 8:47 PM

I am trying to add a comments section with the users who commented and the comment content and relate that data back to the posts table, I'm not entirely sure how to do this in SQL or the Supabase GUI. I need a bit of help with this, I know they are called many to many relationships but I'm not entirely sure how to do this in practice.

denik1981

04/14/2022, 10:22 PM

I'm wondering if I can integrate a Nextjs app using Next-auth for Google/Facebook authentication and Supabase for basic email/password authentication. Is this possible and/or advisable? Any example repo where I could look for something like this?

Muezz

04/14/2022, 11:02 PM

Copy code

sql
if new."category" is "rand_category"
  then
    //Do somthing
  else
    //Do somthing else
  end if;

kodestallion

04/14/2022, 11:17 PM

Hi guys, I am not sure if this is an isolated incident or not. But recently I have been coming across this issue whenever accessing Supabase. Does anyone know what could be the issue?

eoin

04/15/2022, 12:28 AM

Does anybody have an example where a user's

uid

is checked within an array or jsonb cell for their RLS policy? What I want: An RLS policy which checks if

auth.uid()

is a value within a

players

array or jsonb column cell to determine if they should be able to see the

/game/uuid

page.

nikivi

04/15/2022, 1:33 AM

where do I get SUPABASE URL from

Needle

04/15/2022, 1:33 AM

Hello @nikivi! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! 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.

Needle

04/15/2022, 1:33 AM

/title

command! We have solved your problem? Click the button below to archive it.

Needle

04/15/2022, 1:33 AM

/title

command! We have solved your problem? Click the button below to archive it.

Needle

04/15/2022, 1:33 AM

/title

command! We have solved your problem? Click the button below to archive it.

chrisb2244

04/15/2022, 1:38 AM

Is it possible to set/get the owner of a file using the storage API (with service_key is fine)? Looking at the source code in supabase/storage-js I think the owner must be controlled by the headers, but I'm not sure... There are commented out functions for getMetadata and updateMetadata, but I don't know if those should be available or not (since they're commented, I mean via a direct fetch rather than via supabase.storage.getMetadata or similar...) I'm assuming there is some concept of ownership, since I can use things like

(uid() = owner)

in RLS policies... The goal is to create user profiles with avatars when transferring from a previous site - I can create the users but I don't want to have their images be owned by some sort of admin role...

jar

04/15/2022, 2:44 AM

is it possible to see the plpgsql that the ui wrote for me undernieth the hood. I want to start using editor with more freedoms but looking at that would help me learn

Needle

04/15/2022, 3:50 AM

Hello @Ape R Us! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! 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.

Kariak

04/15/2022, 4:23 AM

Hi this is maybe a noob question but I’m not sure how to model a couple tables in my Supabase db. Basic idea is for people to create and join competitions. I’m using a profile table and a competitions table. The competition table would have an array of profiles in it. How would I reference what competitions a profile is enrolled in? Iterating through all competitions for a users profile seems slow. Would a shared table where the user id and the competition ID be best or is there a better way with Supabase?

Ape R Us

04/15/2022, 5:40 AM

hey guys, can i get some help to understand this. I want when someone enters a number, that inputs appear and the data from those would go into a new object that i can push to supabase for example

Copy code

let num = 0;
let totalAttendees = [];
let attendee = {
        id: 1,
        first: '',
        age: undefined
    };
function addPerson() {
        total = [...total, attendee];
    }

const add = async (totalAttendees) => {         
try {  const { error } = await supabase.from('name').upsert(totalAttendees);             
if (error) throw error;
} catch (e) { 
console.log(e.message);         
} finally {
 console.log('success');        
 }    
};

this is the input to select how much forms should appear

Copy code

<input type="number" class="bg-transparent" bind:value={num} />

this is me iterating

Copy code

{#each Array(num) as _, i}
    <div>
        <input type="text" bind:value={attendee.first} class="bg-transparent" placeholder="first" />
        <input type="number" bind:value={attendee.age} class="bg-transparent" placeholder="age" />
        <button type="button" on:click={addPerson}>add</button>
    </div>
{/each}

it works, however the problem im getting is that when i enter info in any field its updating in all, is there anyway where each div inputs will be unique so it wont update

Hostile_Zombie

04/15/2022, 7:10 AM

Hey, does anyone have any information about setting up things like rate limiting and logging for the Edge functions? There is some initial information about a "Relay" but it doesn't go into any details about actual implementations you can set up. https://supabase.com/blog/2022/03/31/supabase-edge-functions "The Relay acts as an API gateway, authenticating the JWT, and providing some additional functionality like logging and rate-limiting."

akito

04/15/2022, 8:04 AM

Would it be possible to create a write-only policy for buckets within Supabase (i.e. upload file, receive ID, but can't access), and how would it be implemented? Would it suffice to only allow users to

INSERT

(corresponding to

copyObject

getSignedObject

, and

createObject

)? I'm not sure whether

getSignedObject

returns just a hash or the actual object like

getObject

does. Also, how would I implement limiting to prevent a malicious user from filling up my storage bucket with junk?

prattjc

04/15/2022, 8:30 AM

Hello guys, I regularly get 502 errors, do you guys know where that could come from ?

charbs

04/15/2022, 10:23 AM

Hi all - whre do i get access to a graphql playground or documentation on what queries are available after i enable

PG_GRAPHQL

baran

04/15/2022, 10:34 AM

I have a hard time understanding this behavior: If signUp() is called for an existing confirmed user: If "Enable email confirmations" is enabled on the "Authentication" -> "Settings" page, an obfuscated / fake user object will be returned. Why not return an error with a message "User already registered" like in the case where "Enable email confirmations" is disabled?

H𝑶𝑳𝒀 𝑺𝑯𝑶𝑻

04/15/2022, 11:14 AM

Hello all, sorry as I am new to supabase but I keep getting a 404 response from the server everytime I attempt to bring the website live. Sometimes supabase records interaction but the insert() methods I have put in dont seem to add data to the tables. RLS is not enabled in that table but thats all i know

Jonathan H

04/15/2022, 1:52 PM

Hi. Although I'm an experienced programmer, I'm pretty new to the web-app side of things, so please excuse me if there is the answer to this is obvious. I would like a workflow where an employer would set up an employee entry for their company and then invite the employee to connect to it. If the employee is already a member of the system then they should just log in as per normal and then their account would be linked to the employee entry, otherwise, they create a new account for themselves and it is automatically linked to the employee entry. I want the option of doing it this way around because I don't want the employer's configuration of their company information to be stalled by employees not being signed up yet (some may be on holiday for example). How might this be achieved?

Invader

04/15/2022, 5:50 PM

Where can we find the exact specs of Supabase pro plan?

dope

04/15/2022, 5:59 PM

Hello, I'm new to working with a database like supabase and I'm wondering how can I update all (replace with a different value) rows from specific column in a table every 24 hours? (I'm possibly looking for a SQL query solution)

Derek

04/15/2022, 8:19 PM

Is is possible to create unique together rows and join tables in supabase? I'm guess it cannot be done with the UI and needs to be created via sql?

bill92

04/15/2022, 10:17 PM

For supabase functions, the only available runtime is Deno?