I was working on React.js with Supabase SDK. It was working fine, but I realized that it was not working sometimes. Actually it didn't many any requests when I checked Network tab on browser. console.log("hello"); const { data, error }…
I'm working on a query in Supabase where I need to select specific columns from a table based on multiple conditions. Specifically, I need to select columns a, b, and c from a table where column e is equal to…
I have table 'MyTable' containing the column 'observations' of type jsonb. The Json structure is as following: { ... obsList: [ { species: 'Goldfinch', number: 2 }, { species: 'House sparrow', number: 4 }, ... ] } If I want…
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 =…
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.…
I want to somehow get my return value after getting session. App.jsx file import { useEffect, useState } from 'react' import './App.css' import {Navigate} from 'react-router-dom' import { supabase } from './helpers/supabaseClient' function App() { const [session, setSession] = useState(null)…