I have the following table called "profile": id, name, created_at Every user ( with SupaBase ) has his own row in the "profile" table with his user_id as the key ( id ) I added RLS so that only the…
I want to build an app (in react js) for myself, my family, and some close friends (+/- 40 people). But having this app live, anyone could go on the apps web address and submit a sign up form, and…
How to check the last record of a user in supabase. I would only need by means of the user ID to find his last record "date" in a descending way I have something like the following, but this would…
I am struggling getting the difference of two Timestamps in milliseconds. My current approach was SELECT * FROM EXTRACT(EPOCH FROM(NOW()::TIMESTAMP - '2022-10-23 16:34:53.227')) which was described on a bad website as returning the difference in seconds but in fact returning…
Every solution I see has to do with people having case sensitive column names. The query select * from users works, but when I say select * from users where username=maxspiri, I get error column maxspiri doesn't exist. Here is…
Inspired by the Supabase docs, I have this code in a React Native app: useEffect(() => { if (session?.user?.id === null) return const channel = supabase .channel('value-db-changes', { selfBroadcast: true }) .on( 'postgres_changes', { event: 'UPDATE', schema: 'public', table: 'messages',…
I am new to supabase and am trying to integrate my Todo App made with BlueBase, a Framework based on react and react native. And, I am facing such a problem. CreateTaskScreen.tsx import React from 'react'; import CreateTaskForm from '../../components/CreateTaskForm';…
Most of the blogs and stacks suggests below database for chat. message_table -id -message -conversationId -sender -receiverId conversation_table -id -conversationId Now message_table look like this. So, for the chat screen I subscribe the message table. final mySubscription = supabase .from('message_table')…
I want to write an SELECT statement using Supabase-JS library, where it would return all rows whose associated_campaigns (array of UUIDs) column is either null or doesn't contain input string. I'm trying with something like this, where campaign_id is input…
I want to create an enum column in a Supabase table. Supabase uses Postgres under the hood, so I understand that technically it is possible if I do it manually using SQL. But is there any way I can do…