Im making a recipe website with nextjs and supabase. I have an occasions table which has a foreign key to many recipes. I can easily query the occasions for all recipe in that occasion however I want to paginate so…
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…
Iam using the row level security in supabase with nest.js, So how can I set runtime variables safely to the DB so that I can be sure that the variables sync with each app user (due to the http request…
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…
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 started learning about prisma and supabase and would like to implement both technologies in my Next.js app. After running npx prisma migrate dev --name init I was faced with the following error: Environment variables loaded from .env Prisma schema…
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';…
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…