what is the equivalent of

.single()

for curl requests?

somebody figured out a good and expandable query function like this but for other queries like gt() etc. as well? const getCollection = (c, q, eq) => { await supabase .from(c) .select(q) .eq(eq) }

Is there a way to stop having

unknown[]

coming back from the db? I'd rather have like

string[]

or

number[]

. Seems like the rest api url doesn't like those? Getting them from here:

https://myurl.supabase.co/rest/v1/?

What is fastest way to migrate new tables from one supabase to another? I've got my pgAdmin UI up and I am tempted to copy the generated CREATE sql from the source database and execute it on the target database. Are there any problems with this?

Hello everyone, does supabase work with php?

Hello ! This thread has been automatically created from your message in 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.

Hello ! This thread has been automatically created from your message in 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.

Where can i find "Supabase Hooks" ?

Hi all. I'm using rpc to insert values to a table. After I execute the function, I'm getting this error:

{"code":"42P01","hint":null,"details":null}

I have a Nextjs + PostgreSQL project, that I started to use Prisma with... Does Supabase work well with a existing PostgreSQL?

Hi, i need to select all data from the DB and then rank it by points (number) naturally I'd do

const { data, error } = await supabase.from('some_table').select('*');

but what after that? Also can I run SQL commands with a SQL syntax from my application?

I'm trying to execute.

supabase start

but i got this error

Error: Error starting database: ERROR:  schema "graphql_public" does not exist

Hi! I've been trying to get the "remember me" functionality for my site working and I'm having trouble with the access/refresh token setup. So, let's say I have a navigation guard for some routes (like

/user/profile

) and want to check if the current user is authenticated:

js
async function isAuthenticated() {
   // User has session?
   if(supabase.auth.session == null) {
      // We don't, check if there's an old session in storage (local/session Storage)
      const oldSession = getStorageSession();
      // Has it expired yet?
      if (oldSession.expiresAt >= Date.now()) {
        loginWithRefreshToken(); 
        return true;
      }
      else {
        // setAuth with old session (does Supabase handle this automatically?)
        await supabase.auth.setAuth(oldSession.access_token);
        return true;
      }
   }
   else {
    // We have a session, is it expired though?
    if(supabase.auth.session.expiresAt >= Date.now() {
      loginWithRefreshToken();
      return true;
    }
   }
  // On error logging in with refresh token, returns false.
}

However, I receive "Invalid access token" after trying to login with the refresh token... Is there any step I'm missing, or is there any misunderstandings with how I should handle authentication with Supabase Auth?

Hello, I need clarification about GDPR. My app is based in EU and I have picked Frankfurt Region for my instance. Is Supabase GDPR compliant? If not, is it "safe" to use it with EU data? This is very critical for most apps that are based in EU.

So, on one Mac app.supabase.io loads.... but on another computer that site DOES NOT load, it’s the site, but a blank black screen

Hi, I can't create a 2nd project in my supabase account despite only having 1 organization and 1 project. What should I do?

Anyone have advice on the best setup for multiple authenticated users having access to the same row when using RLS on a table? Do you just store an array of UUIDs in the record and then test to see if the array contains the UUID on request?

Hey guys, I've been trying to run this code in my SQL editor and haven't gotten updates on my table to work. Can anyone help point out what's wrong?

CREATE OR REPLACE FUNCTION public.test_fn(row_id bigint) RETURNS void AS $$
    UPDATE restaurants SET name = 'test'
    WHERE row_id = 36;
$$ language sql volatile;

Hello ! This thread has been automatically created from your message in 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.

Is there any documentation on "supabase db branch" CLI commands?

Hi guys, I'm using Supabase for the first time and I'm working on an API using Vercel's Serverless functions. I wanted to use Connection Pooling for this, and I was wondering what are the steps for it? I can see that it's enabled in my Database settings, but I only really used

createClient

with my

SUPABASE_KEY

and

SUPABASE_URL

. So is connection pooling handled under the hood by Supabase? Or am I missing something?

Are there any examples of deploying supabase on fly.io?

Hello @Rihito! 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.

Should i use UUID or INT8 for id?

How can I use int32? The maximum int is int8 which can store a max length of 8

How to work on a database other than the default one (named

postgres

)? The

CREATE DATABASE

command works. But the Table editor seems hard-coded to the default

postgres

database. Extensions can not be enabled on the created database. Did I miss something?

Hi! Short question: Is there any way to get more typesafe results from the supabase service? I'm trying to build an application in angular and right now I need to check in my components if all the fields from a row are present, i.e.

How can I debug why my custom SMTP email isn't working?

I set up a basic RLS policy on a new table I created, called client_profiles. The policy is for select, and the rule is simple: (uid() = agent_id), yet, I'm getting no items back now. I guess more my question is how can I troubleshoot to see WHY rls failed or "chose to protect"...is there anywhere I can see why maybe the ids aren't matching, etc?

whats the best (or easiest) way to sync / continuously update OAuth avatars (in my case, Discord) with Supabase's auth?