I'm currently working on a Flutter project using Supabase as the backend. I'm trying to implement a stream on RPC (Remote Procedure Call) functions to receive real-time updates, but I'm facing issues. I've tried using the asStream() method, but it…
Whenever delete is performed, supabase database is updated instantly but not in UI, If manually refreshed then updated list is shown to the UI... what to do please help!! I have added EntryTable, inside it I am rendering EntryRow, that…
I am working in supabase postgres and wrote multiple postgres functions DROP FUNCTION IF EXISTS setup_auth_user; CREATE OR REPLACE FUNCTION setup_auth_user( email_value TEXT, name_value TEXT, password_value TEXT, wallet_address_value TEXT, private_key_value TEXT ) RETURNS user_info AS $$ DECLARE updated_user_info user_info; BEGIN…
I have a test project a Supabase website with these 2 tables : and this is my main file : import 'package:flutter/material.dart'; import 'package:supabase_flutter/supabase_flutter.dart'; Future<void> main() async { WidgetsFlutterBinding.ensureInitialized(); await Supabase.initialize( url: 'https://fszmicgacuftwaxzrydi.supabase.co', anonKey: 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6ImZzem1pY2dhY3VmdHdheHpyeWRpIiwicm9sZSI6ImFub24iLCJpYXQiOjE3MTQ4MDY0MzIsImV4cCI6MjAzMDM4MjQzMn0.BhjbhjnuuIcFDZwtUF7FWehbna7KSrChm_s7UAJpRLdukvtko', ); runApp(MyApp()); } final supabase…
npm i drizzle-orm postgres npm ERR! code ERESOLVE npm ERR! ERESOLVE could not resolve npm ERR! npm ERR! While resolving: [email protected] npm ERR! Found: [email protected] npm ERR! node_modules/react npm ERR! peer react@"^18.2.0" from [email protected] npm ERR! node_modules/next npm ERR! next@"14.2.3"…
For four days I have been having trouble connecting to Supabase servers. I have a free plan for the development of my project with Flutter, but for four days, the authentication service has stopped working, I no longer have access…
I have 2 tables: Events Attendance I wrote a function that gets triggered on every row insert or update in the Attendance table, to update "Event"."attendees_count" column by incrementing by +1 if it's an insert, decrement by -1 if attendance…
In my Postgres database I naively created a column in table Foos as a json[] that looks like this: TABLE Foos id | ... | baas -------------------------------- 1 | ... | [ | ... | { | ... | "name":…
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 want to make a full search query on a spécific value of my jsonb like the format of the json is : { "highlights": { "concise": null, "complete": null }, "gist": { "concise": [ { "text": "", "isHighlighted": false,…