Is anyone struggling to get row-level realtime subscriptions working? I've noticed when I use the catch-all subscription, things work as I expect, however if I switch to row-level, I don't receive any updates. ie:

typescript
// ✅ this is working correctly (able to receive INSERT, UPDATE and DELETE events for the `board_cards` table):
const subscription = await supabase
  .from('*')
  .on('*', handler)
  .subscribe();

// ❌ this is NOT working correctly (unable to receive INSERT, UPDATE and DELETE events for the `board_cards` ):
const subscription = await supabase
  .from(`board_cards:list_id=eq.${someId}`)
  .on('*', handler)
  .subscribe();

row level realtime not working

Is there a good way to sort through arrays in the DB? For example, I have an array of names as one of the columns. Is there a way to filter for rows where a certain name appears in that array?

I'm guessing you are looking for .contains('main_exports', ['oil']) from the Supabase js filters. main_exports is an array column.

Fantastic. Thank you.

So in that case if oil is in the array it would return it?

Anyone know why arrays are always returning empty when clearly having a value? Im trying to get back a row and the column is defined as an array, but when I fetch it the array is completely empty.

Been trying to figure this out since the beginning of the month. Its so bizarre

Btw I should mention this happens when grabbing from the new payload

im using real time insert

I just used an array for the first time and didn’t run into this

Did you fetch the data with realtime? Im reading from the

payload.new

variable

Not too familiar with real-time, new to supabase

I just got the column from the DB and the array was there

Yea that works fine for me as well, but when fetching with real-time data for whatever reason it returns empty.

How I can use realtime db with Row level security? In Vue I'm trying to use code from docs (https://supabase.com/docs/reference/javascript/subscribe#listening-to-row-level-changes)

mounted(){
supabase
      .from(`Cards:uid.${this.$store.state.user.id`}) \\ or 'Cards'
      .on('*', (payload) => {
        console.log('Change received!', payload);
      })
      .subscribe();
}

Cards is a Table uid it's a column with user auth id and this doesn't work for me :/ Any ideas?

realtime question with RLS, vue

someone made web push notification using supabase?

When a user logs in, my app doesn't detected its logged in until the page is refreshed. I'm using Google Auth. How do I fix this?

is there a way to modify the items im inserting into my supabase table from the editor and inserting a foreign key i retrieved from another table. i wanted a way to be able to do this without having to pick a foreign key and assigning it through the sdk

I’m not sure if there’s a better way, but I used this to detect whether or not the user signed in or out on the webpage using an external oauth2 method https://supabase.com/docs/reference/javascript/auth-onauthstatechange

Hi guys, just wondering if anyone can point me through the right direction, I’m making a business directory where users can review a business by leaving a rating from. 1-10 I have a table with all the business names and details. How would implement a voting system for only logged in users. I was thinking adding a column with a count of votes, but don’t know how to make sure logged in users can vote once

Thank you!

user voting db design

Hello guys, I started a new discussion about the possibility to send a custom header paramenter using supabase-js https://github.com/supabase/supabase/discussions/4755 If anyone have some solutions, ideas, or want contribute on the conversation please partecipate ❤️

Hi Guys, 2 questions please. 1. I’m using NextJs and all the tutorials online are fetching and manipulating data on client side, even validating user auth, is this the right approach (considering it’s used on the official todo example on supabase docs) 2. I’m already using tailwind NextJs, but I like the Auth component from supabase ui and how easy it is to implement, is adding supabase ui a good practice after I fully installed tailwind ? In terms of bundle size and speeds. I only want certain components and not the full ui experience Thank you 🙏🏽

nextjs with supabase

HI Guys with the supabase-js library the docs show this example. Is this possible with typescript, when I try and access a column of a sub table, in the example username on user I get a type error as that isn't a direct column?

Is there a way to call an

rpc()

function with a parameter that's an array (that's mapped to a custom postgres

enum[]

)? (Details in thread)

Anybody have any suggestions on updating json arrays with the library? I can't seem to get it working at the moment and was wondering if anyone else had any luck