I am trying to listen to supabase realtime changes when parentTodos is null. How can I do that? const { createClient } = require('@supabase/supabase-js') const supabase = createClient(process.env.SUPABASE_URL, process.env.SUPABASE_KEY, {}) // Set your custom JWT here supabase.realtime.setAuth('your-custom-jwt') const channel =…
I have a "trademarks" table like this: create table public.trademarks ( id bigint generated always as identity, owner_id text null, trademark text null, constraint trademarks_pkey primary key (id) ) tablespace pg_default; My goal is to pass a text to a…
When creating a new user in Postgres, I have a trigger that automatically creates a chat for him (like saved messages in telegram). I also have a chat_members table in the database that stores chat members in a many-to-many relationship…
For authorization flow, in middleware, I want to equal any value in a .eq statement. A normal user should only see a post if they created it. An admin should see any post though. const userMatcher = user.role === "admin"…
I am Running this piece of code: import { useEffect, useState } from 'react'; import { createClient } from '@supabase/supabase-js'; const supabase = createClient("https://<project>.supabase.co", '<anon-key>'); const GetBalance = () => { const [data, setData] = useState([]); useEffect(() => { getData();…
very very new here and to PGSQL creating an app using flutterflow. I am trying to create a trigger function that will update a coloumn called 'holes' when a new row is added to the scorecard table using a subquery…
I have a COLUMN in a Postgres table which has values with the following pattern. INPUT-X INPUT-X-Y INPUT-X-Y-Z INPUT-X-Y-Z-A-... I am trying to count the number of entries in COLUMN where the value begins with INPUT and contains a given…
I am trying to query my posts table for a post, which contains the user's user_id and I want to join it with the profiles table using the user_id. post table schema: (post_id: uuid, created_at: timestamptz, image_url: text, user_id: uuid,…
so i have created this method that does 2 things, one after another, the first thing this method does is sign up the user using supabase, the second thing is it saves the users info on a table, here is…
Let's say I have a bands and a genres table who are connected through a join table called j_band_genres. Combined, this is my data: ID Names Genres 1 The Beatles Pop, Rock 2 The Rolling Stones Rock 3 Boney M.…