Questions tagged [supabase]

Supabase is a collection of open source tools to build modern applications quickly and efficiently. It uses the PostgreSQL database to power its authentication, database, and storage features. Use this tag when you are having problems, and not to ask for new features.

Supabase is a combination of open source tools. It builds the features of Firebase using enterprise-grade, open source products. Supabase is not a 1-to-1 mapping of Firebase. Its aim is to give developers a Firebase-like developer experience using open source tools.

Supabase has an official JavaScript library as well as community built Dart, Rust, Kotlin, C# and Python libraries.

Supabase is composed of four components

  • Database
  • Authentication
  • Storage
  • Functions (coming soon)
1213 questions
5
votes
2 answers

Error: Get config: Unable to establish a connection to query-engine-node-api library in Prisma and nextjs

I use nextjs fresh project with Prisma and supabase database. I'm using ubuntu. No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 22.04 LTS Release: 22.04 Codename: jammy when I run Prisma push and generate command in…
5
votes
4 answers

keep user logged in while using supabase in react native

I built an auth function that looks like this: const handleLogin = async (type) => { const { user, error } = type === "LOGIN" ? await supabase.auth.signIn({ email, password }) : await supabase.auth.signUp({ email, password…
5
votes
2 answers

How to change the redirecting url for Google OAuth with supabase?

I am trying to set up a website with supabase using Google OAuth for authentication. It's fairly easy and convenient to set up and works really well, by following this tutorial and consulting the docs. But unfortunately the Google login page says…
jost21
  • 1,084
  • 3
  • 15
  • 29
5
votes
4 answers

supabase in Next JS returning an empty array when data is in relevant tables

It seems I am always returning an empty array when trying to pull data from my tables. This is how I am doing it, after following the docs and several tutorials. const [tableData, setTableData] = useState([]); async function getTableData() { …
mrpbennett
  • 1,527
  • 15
  • 40
5
votes
2 answers

Use Supabase with deno

I'm trying to use Supabase with deno. I used import { createClient } from "https://esm.sh/@supabase/supabase-js" but it only gives me errors like Module '"deno:///missing_dependency.d.ts"' uses 'export =' and cannot be used with 'export *'
5
votes
1 answer

How To Update Entire Row In Supabase Table? (Getting 400 Error)

I am trying to make an input form where the user can change several values in one row simultaneously which get submitted to the database using the update() method. The values are being read from the Supabase Table into several input fields as…
Reuben Rapose
  • 157
  • 2
  • 8
5
votes
2 answers

Supabase login get user session and profile at the same time

Is there a way to get the user session and profile at the same time? The way I did it would be get the user session first after login then fetch the user profile using the id. const [authsession, setSession] = useState(null); const [loading,…
Naterz
  • 387
  • 4
  • 14
5
votes
2 answers

Only allow read if user has exact document id postgresql row level security/supabase

Is there a way for a user to only be able to read a document only if they have the exact document ID? I want to avoid creating users, so the only security is a random guid saved in browser memory - settings will be saved in "settings" table with…
5
votes
2 answers

PostgREST - Add authenticated user id on insert

I need to automatically add an author of an inserted row in one of its columns. I am using postgREST (using Supabase cloud service) and I don't want users to add whoever they want as the author. Is there a way to automatically add user id of the…
TomasB
  • 604
  • 5
  • 18
5
votes
1 answer

How to upload file from python Flask web app to Supabase Storage

I want to be able to upload a file from Flask to Supabase Storage, but it only has documentation for the javascript api link to docs. Also, I can't find any examples or any open source project that does that. Here it is my function to upload: def…
5
votes
2 answers

Cannot insert to table with authenticated role policy in Supabase

I'm trying to insert a row in my table which has RLS enabled and the Enable insert for authenticated users only policy added. Unfortunately, I cannot insert even though I'm correctly login. Steps to reproduce: Create submissions table create table…
KevinTale
  • 1,658
  • 3
  • 25
  • 47
5
votes
0 answers

Running Supabase locally with DataGrip, 'relation "public.users" does not exist'

I'm running Supabase locally, using Docker, on MacOS. I initialized a Next.js project with Supabase, and connected the locally created database to JetBrains DataGrip. I can see and adjust the data in DataGrip without issue. But when I try to query…
sandypockets
  • 350
  • 3
  • 13
5
votes
1 answer

Is there a way to perform full text search on multiple columns on Supabase with Javascript?

I've tried using many symbols to separate columns; ||, |, &&, & with and without spaces. For instance .textSearch("username, title, description", "..."); .textSearch("username|title|description", "..."); And nothing has worked :(
5
votes
1 answer

Supabase third party oAuth providers are returning null?

I'm trying to implement Facebook, Google and Twitter authentication. So far, I've set up the apps within the respective developer platforms, added those keys/secrets to my Supabase console, and created this graphql resolver: /* eslint-disable…
J. Jackson
  • 3,326
  • 8
  • 34
  • 74
5
votes
5 answers

Error: supabaseUrl is required (supabase) postgresql

i'm using supabase postgresql online, in which important create a .env file where is my online DMBS's URL and anon key is saved and a "supabase client" file also create to access DBMS and tables and the import "supabase client" in the require file.…
1 2
3
80 81