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
2
votes
3 answers

Supabase: policy to allow a specific user by email to select rows doesn't work

I'm trying to add a policy to a policy_test table in supabase in order to allow only me (with my email) to select rows. This is the policy I have added: table policy_test CREATE POLICY "Only I can select rows from this table" ON…
Diego Ulloa
  • 500
  • 8
  • 19
2
votes
4 answers

supabase bucket policy to insert file not working

I am trying to insert a file into a supabase public bucket, I've created basic policies to insert, select. when I try to upload a file though it returns { statusCode: '401', error: 'Invalid JWT', message: 'new row violates row-level security…
risky last
  • 385
  • 4
  • 12
2
votes
1 answer

How to use ."in" filter in Supabase URL

I am trying to use ".in" filter of Supabase using its URL. However I can't query for more than 1 filter. Working url https://DATABASE_URL/rest/v1/patients?payer=in.(TERM1) Here I get all the rows where payer is TERM1. However, when I try the…
Yash
  • 223
  • 2
  • 11
2
votes
1 answer

Unable to run pg_dump from Supabase

I intend to backup my postgres database at Supabase $ pg_dump -h db.PROJECT_REF.supabase.co -U postgres --clean --schema-only > supabase_backup.sql I ran the command GRANT ALL ON ALL SEQUENCES IN SCHEMA auth TO postgres; grant all on…
Nditah
  • 1,429
  • 19
  • 23
2
votes
2 answers

Pass a value from an api into an object as to insert a new row into the database

Using type=radio along with bind:group as shown in my example this will add the row to the database, but it only works for 1 entry plus the user needs to check the radio. Staring with just adding 1 correctly is a good start, but my goal is to add…
Dustin
  • 21
  • 4
2
votes
2 answers

Supabase REST: how to refresh token?

I'm using the supabase api (REST) with SWR. I have almost all endpoints to login, logout, invite, update an user, etc, but I can't find the endpoint to refresh the token. Anyone knows about this endpoint? I…
Diego Ulloa
  • 500
  • 8
  • 19
2
votes
1 answer

Can I use a service like Firebase or Supabase in a Tauri desktop application?

I am a full-stack web developer that has experience with JavaScript and React. I want to create a desktop application using these technologies using a framework like Tauri. I enjoy using services like Firebase, Supabase & AWS Amplify. Can I use…
2
votes
1 answer

Hostname resolving error in Stepzen Graphiql explorer when connecting with Supabase Postgresql database

I have set up Stepzen as described in the Getting Started Docs. I get the following error when running stepzen start: { "data": { "getProfilesList": null }, "errors": [ { "message": "database error: can't prepare the statement…
Abdullah
  • 488
  • 6
  • 16
2
votes
1 answer

How i can pull all data project production to local enviroment in supabase

I have created a project using supabase platform directly and not in local enviroment so all tables are in production, but now i need a local enviroment for development o test so i created a local project using this guide but the project is from…
2
votes
2 answers

Uploading Base64 images to supabase

My website wants to reduce the amount of things users can do with the images...so for added security, we want to keep the image sources as a base64 strings instead of a supabase storage URL. Is this possible through supabase storage, do will I have…
2
votes
1 answer

Supabase and Google Apps Script

Is it possible to use Supabase with Google Apps Script (GAS)? I'm new to Supabase and I've never tried to import external library to GAS before. I'm planning to use Supabase as a database for my project in GAS. The project is built to run a bot in a…
2
votes
0 answers

supabase.auth.onAuthStateChange Not Working when React app is in iframe

I am using Supabase user authentication in a React app hosted at https://example.com that is running inside an iframe injected by a Chrome extension chrome-sidebar when the browser is on a different domain/website https://google.com. By adding…
2
votes
2 answers

Is there a way to remove previous session without hard refreshing (sveltekit and Supabase)

im practicing authentication at the moment with sveltekit and Supabase RLS is on and one of the issues im having is after i log out, and i sign in with another email, i can see the info from the previous session and when i hard refresh, then i see…
2
votes
1 answer

Can I Auth a user through Firebase and use Supabase (private) buckets without relying on Supabase Auth users limitation

I have an Ionic application that use a pretty small file(1kb) to store user info. I want to implement cloud backup for it. The user just need to download it once, when restoring backup. All other operations are uploads. Firebase can provide Auth,…
Rafael de Castro
  • 888
  • 4
  • 16
  • 37
2
votes
1 answer

SUPABASE/JavsScript: how to DELETE user metadata?

Is there a way to delete user metadata in Supabase? They offer update() option, but it seems it works as patch request, so I can't find a way to delete it. Here's their code: ```const { user, error } = await supabase.auth.update({ data: {…