Hey all! I'm looking for a way to run a search against a jsonb column's values only, and not the keys. So for example given a column called

info

with data like:

{ topic: "postgres" }

, I'd like for this row to be returned if the provided search value string contains

"postgres"

but not if it includes

"topic"

I was able to create a new column on the table that is a concatenation of other columns to run text search against that generated column (using the docs https://supabase.com/docs/guides/database/full-text-search#searchable-columns), but so far haven't been able to figure out the syntax to do this with a jsonb column for the values only, I get the whole stringified object in there, which is ok but not ideal as some of the keys are fairly generic and shouldn't match on a text search. Thanks in advance!

Hey would anybody be williing to hop in a vc for about 2 mins, I'm having some difficulty understanding how Supabase works and how I can send and receive data from it. I'm new to Web Dev so I will ask some dumb questions.

How can I query the "many" entities in a one-to-many relationship but only retrieve ones where the parent (the "one" in one-to-many) has a column with a certain value? My database has a sessions table and actions table, where each action can have many sessions but each session can only have one action. I'd like to query for all sessions where their related action has a "goal" column with a certain value. How do I go about this?

Hi, I am new to React Native Development and I was trying to integrate supabase with Expo, during development of auth system, I got an error ->

undefined is not an object (evaluation 'this.localStorage.getItem')

How to remove this issue?

Hi, all! 👋 Question about getting Realtime to work for a table that has RLS policies enabled – In my app, Stripe fires off a webhook to my

/api/stripe-webhooks

endpoint, then I make an update to my

profiles

table using the data I receive. Even though I have Realtime turned on for that table and my client-side app has subscribed to receive `UPDATE`s, no Realtime events are received. This is because I have row-level security (RLS) enabled for the

profiles

table, and when my

/api/stripe-webhooks

endpoint handler function is called, no user is authenticated, so the RLS checks fail. How can I keep RLS activated to lock down access to my

profiles

table, but still receive Realtime updates in my client-side app when the current user's row in the

profiles

table gets updated? More Details: - I'm using username/password auth. - The RLS policy on my

profiles

table is

uid() = id

for all CRUD operations. - I'm using SvelteKit the supabase-js client the for the client-side app. Thanks in advance for any help you can give! 🙌

Hello, I am trying to build an app using expo and supabase and in auth part, I got an error ->

[Unhandled promise rejection: TypeError: undefined is not an object (evaluating '_supabase.supabase.auth')]

Kindly help me..

hi.. so i just updated my images row with empty array in supabase with no .match() method.. is there a way for me to get the image data back? thanks...

Hey folks! Is the OpenAPI schema available in the local CLI version? I'm trying to look at http://localhost:54321/v1/rest but just getting a

"no Route matched with those values"

I'm having a CORS issue when I setup the Next.js Quickstart. Is anyone else getting

Referrer Policy: strict-origin-when-cross-origin

when they try to make a request locally? Here's a link to more details on github https://github.com/supabase/supabase/discussions/5906

Hello, has anyone got the python realtime library to work? It will not work for me regardless of the channel name I use. Inserting records into the web UI and trying to capture them from the listening websocket. It does connect and shows in the Supabase dashbord

Hello, I can't find out how to replicate a left join in supabase js cli. some postgresql query like:

select s.id, s.status, u.id, u.firstname, u.lastname
  from subscriptions as s
  left join users as u on s.user_id = u.id
  where u.firstname = 'John';

will only return subscriptions of users called 'John'. but with:

supabaseClientCli
        .from('subscriptions')
        .select('id, status, user:users(id, firstname, lastname)')
        .eq('user.firstname', 'John')

I get all subscriptions, with

user: null

if

user.firstname

isn't John... help appreciated!

Does anybody know how to get a JSON Web Key Secret URI form Supabase? (JWKs)

is there any reason that the Socket.IO Postgres Adapter wouldn't work with supabase? https://socket.io/docs/v4/postgres-adapter/

Hello, is there anyone having this issue? After signing in to the web application the screen shrink if it is opened through phone browser. I'm using next and Chakra ui by the way. How do I fix it? Everything seems fine in my code.

Hello, please i'm having issues setting up the Supabase local emulator for testing. Can anyone help me out here?

Hi All, we are planning to migrate from Firebase to Supabase, we don't have much data but have good amount of firebase functions.

Hello, I'm trying to sign-in using discord oauth. I checked to signup in Authentication>Users. but 401 error returned in frontend. what should I look at ?

Hi ,I'm trying to run a local instance of supabase using the cli. Following the instructions and using the API url referenced in the local studio

http://supabase_kong_<project_dir_name>:8000

I am getting the following error when making a call with the supabase js client,

net::ERR_NAME_NOT_RESOLVED

. What is the appropriate host name for the local dev supabase url ? Anyone have any ideas as to why I might be seeing this error? Note, I'm running all this on a mac.

Is there an easy way to get the query string params sent to a SvelteKit endpoint? Looks like I can get the full URL as shown below, but I don't see an easy way to get the query string params.

ts
export async function post(event: RequestEvent): Promise<RequestHandlerOutput> {
  console.log(event.request.url);
}

Example: If the request is sent to

http://localhost:3000/api/my-endpoint?test=abc123

, I want to access the value of

test

, which would be

abc123

. Thanks for any help you can give!

hey y'all wondering if theres a way to get the union of types in these tables from the generated types. Have a call that gets these rooms, then gets the users that have the roomId as a key relation

id,
slug,
params,
players:users(id, publicAddress, name)

Hello! I migrated from staging to main 3 days ago and accidentally dropped all of the original rows. Is there a backup that I can access or any way to recover the data? Much appreciated!

Does anyone know if it is possible to set an rpc query up for subscription, so that the results of the query are automatically refreshed on the page?

hey, some basic queries are returning null here, is there something wrong?

Inserts into my table have stopped working, I am now getting

URL using bad or illegal format or missing URL

anyone know what it could be?

It seems like supabase has issues on Swift side. Anyone know how to fix this?

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

Hey, I'm trying to update my public user table whenever the auth table email changes This is what someone else has tried but doesnt work. Anyone have any ideas? https://github.com/supabase/supabase/discussions/5421

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

Hi can I connect supabase with redis?