I am fairly new to SQL and wondering how to remove a specific element from the JSONB data below: [ {"id":101,"content":"lorem ipsum", "username":"user_1"}, {"id":102,"content":"lorem ipsum", "username":"user_2"}, {"id":103,"content":"lorem ipsum", "username":"user_3"} ] In this case I want to remove the object with…
I have a parent component containing a child component with a form. I want to get the data from the form and upload it to the database but I just cannot figure out how. Here is my code for the…
This is the useEffect code in the React component. import { useSession } from '@supabase/auth-helpers-react' const session = useSession() useEffect(() => { if (session) { console.debug('stay in page') } else { console.debug('goto login') router.push('/login').then( () => { console.debug('goto login done')…
I am following this guide to use Supabase locally with Datagrip: https://supabase.com/docs/guides/getting-started/local-development#why-develop-locally. However, I could not connect to local db using Datagrip in my MacBook Apple Silicon M1. While the Docker instance is running, I used postgres username with both…
I am trying to retrieve data from a table, bit it is getting stuck in an infinite recursive loop due to my RLS policies, which look at the same table. I have a table called 'community_members' that links 'community_id' to…
I want to insert data in case the 'id' doesn't exist, and update it if the 'id' does exist AND the existing 'timestamp' is less than the new 'timestamp'. So far I haven't figured out how to add this condition…
After using the hosted db, I'm trying to set up a local and staging env but seems not easy as I thought.... I've follow this guide https://supabase.com/docs/guides/cli/managing-environments#deploy-a-migration and after run supabase start I encouraged in this error anyone can help…
My Supabase JS client performs an INSERT on the messages table using the following. import { createClient } from "@supabase/supabase-js"; const supabase = createClient( "MY SUPABASE URL", "MY ANON KEY" ); async function insertMessage(sender, content, file, parent) { return await…
I'm trying to do unit test with Supabase in Flutter like the code bellow: import 'package:bloc_test/bloc_test.dart'; import 'package:flutter_test/flutter_test.dart'; import 'package:mockito/mockito.dart'; import 'package:supabase_flutter/supabase_flutter.dart'; class TestMClass { SupabaseClient client; TestMClass({ required this.client, }); Future<AuthResponse> signinMc() async { final respnse = await client.auth…
I am trying to add raw_user_metadata on the auth.users table when a new user creates an account. However, I'm unable to find the documentation for how to do so in Flutter. The documentation exists for the Javascript client library so…