anybody using

ltree

with supabase? Cannot get path queries to work in supabase...

What's is the

instance_id

in the

users

table and how is it same/different than the

id

?

My project isnt showing up in the supabase dashboard

Hi everyone, I want to create a Get request in SQL editor. Why am I getting a POST request?

create or replace function get_device_info(id uuid)
returns setof devices as $$ 
  select devices
  from devices
  where devices.id = $1;
$$ language sql immutable;

Im using Realtime Subscriptions at Row Level like this:

.from('countries:id=eq.200')

. Now im want to listen to when id is changing to something else like

201

, but was

200

before (i.e.

payload.old.id === 200

but

payload.new.id === 201

). It seems that my row level subscription with

eq.200

isn't catching this change, since the id gets changed to

201

. Is there any way to listen to "old" values?

Hey guys, I have one question about using supabase (or technically any other BaaS) with the ionic framework (angular). How do you handle some verifications like if the user has paid for a premium account (let's say via stripe)? Are you combining supabase with a backend server or do you just handle everything in the application? (Which, as am I aware is a security risk since it's a public facing code and not a server one). Hopefully this is the right channel for this, since technically it applies even to other front-end frameworks. Thank you!

Not sure if this is asked before, but I was just wondering if there had been any updates on the proposed MFA release in recent months?

how can i get the url of an image if the bucket is private? in the documentation i have only seen for a public bucket

let's say i build a realtime game, do we know what the max amount of connections we can support over w/sockets?

I'm currently getting the following error while using custom DB

Hey everyone, do you have a ballpark estimate for when the thumbnail feature will be implemented? I know devs talked about launching it around this month but i dont know where can i get some updates

For realtime notifications on INSERT, what RLS is required? I have insert policy that limits

uid() = user_id

and a select policy that requires

authenticated

role, but do not receive notifications. (confirmed that if I turn off RLS notifications occur)

can anyone point me to where we can access a database backup? we're paying for the pro tier but I can't seem to find this feature

How can I authorize a user on my API server? It'd be nice if I could send their JWT to the API server but I assume that client code doesn't have access to JWTs because they're stored in headers / cookies

I am having troubles triggering an edge function after an update/create of a certain table (via a Function Hook). The logs for the this function never show it being invoked. Am I missing something?

has anyone been able to properly implement the supabase and sveltekit auth?

Hey everyone, sorry for the repeat question, but does Supabase have a referral program? Thanks!

Has anyone had success querying a many-to-one relationship with postgrest? I've a table with music artists, and another table of albums which has a foreign key back to the corresponding artist id. Can I query an artist and get all of their albums in a nested response? A 'reverse' foreign key lookup is what I'm after essentially. For example:

supabase.from('artist').select('*, album(*)').eq('id', 5).limit(1).single()

I was selecting rows for my logged-in Next.js page with an RLS policy in place to just grab my current user's rows on that table... and if I refreshed, they were coming up empty in the console, but if I left to another page and came back they were in fine. What would a hard refresh be doing to scrub that, and how can I reinforce it so the select will always know what's going on?

Actually the JWT is stored in localStorage, which is what I came here to ask about. Is it really secure for Supabase to be storing the JWT there? I just tried copy pasting the key and token into another browser's localStorage without signing in, upon refresh I got signed in without typing anything. I'm assuming it's because Supabase just checks localStorage for the token key and if there's something there sends it to the server, so this is intended behaviour. The thing is it's not that hard to access localStorage from a random chrome extension for example? So what's stopping someone from getting the jwt upon sign in, sending it to themselves and impersonating the user? I apologise if this is perhaps an industry standard that is followed for authentication and there's something I'm missing. I'm simply trying to learn as well. Thanks.

i'm having a really weird issue here; JSON objects that are returned by supabase are being put in alphabetical order, when i need it not to. i inputted the json right into the database so it cant be anything with stringifying on the client, so what do i do? thanks!

I have been using supabase client (js) initialized with anon key & google auth in place, to fetch the data from the table. I have enabled RLS on one of the table (rule is to allow only authenticated users), it only returns empty even after logging in and supabaseClient.auth.session() is still shows a valid JWT

is

supabase.auth.api.getUserByCookie

making a fetch request to the server? Is is possible to determine the user ID and legitimacy of the JWT synchronously ?

I was wondering if it's possible to log out user on the server-side in next.js? I tried this, but it does not do anything```export const getServerSideProps: GetServerSideProps = withPageAuth({ redirectTo: '/auth/sign-in', authRequired: true, async getServerSideProps(ctx) { const session = await supabaseServerClient(ctx).auth.session(); await supabaseServerClient(ctx).auth.api.signOut(session!.access_token); return { redirect: { permanent: false, destination: '/auth/sign-in', } } } });```

Hi, I am trying to connect my supabase DB by using

psql

command but keep getting the error below

% psql -h db.XXXXXXXXXX.supabase.co -U postgres -d postgres
psql: error: connection to server at "db.XXXXXXXXXX.supabase.co" (XXXXXXXXXX), port 5432 failed: Connection refused
    Is the server running on that host and accepting TCP/IP connections?

I have tried restarting the server from the web UI, but still cannot connect from my machine.

Has anyone had problems with Realtime subscriptions recently? Mine simply don't activate and logs never see them (replication turned on, RLS disabled, socket connects with 101 status code)

Is 📷 Instagram auth 🔒 technically part of "Login with Facebook" or just not supported yet? Searching the discord for "instagram" reveals a couple of people asking about it but no replies as of yet

Hello, for some reason this morning my project is taking forever to connect despite there being ample memory/CPU IO budget remaining. It is hurting mission critical tasks for my customers. The support form is not submitting (and not giving me a reason for why it's not submitting) so thought I'd post this message here. Can someone help me fix this asap please?

I'm currently in the process of migrating from supabase to PlanetScale right now. What would be the best way to do this? I have a prisma layer on top of my PlanetScale db. Here are the ways I've thought of: 1. Use the supabase js client and prisma in the same project to transfer all the data over through queries. 2. Somehow export the table data as json and then import it that way? I'm probably gonna go with the first method but I wanted to ask in here just in case there was some better way cause the way I'm proposing feels kinda hacky

@User I know I should avoid pinging y'all but congrats on the interface update. Looks SNAZZY