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
0 answers

Supabase auth Facebook error: Error getting user email from external provider

I'm trying to test out my Nuxt app with Facebook login but I keep getting an error on the address bar: ?error=server_error&error_description=Error+getting+user+email+from+external+provider#_=_ No other errors on the console. I got all set up:…
Larra
  • 346
  • 4
  • 14
2
votes
1 answer

Supabase SQL Database Functions and Parameters

In my supabase database, I have a list of words along with their uuids in the form of uuid word unique_chars found_count x1 apple 4 0 y2 banana 3 0 I want to return all words, which contain a specific letter – say "E" (called "main…
j___.___j
  • 286
  • 1
  • 3
  • 20
2
votes
1 answer

Can I use my own custom component for Supabase auth-helpers?

I can't get the Auth component provided by @supabase/auth-ui-react to match my design and I'd also like to add additional inputs. Can I use my own Auth component and still use @supabase/auth-helpers-react auth system that comes with…
Mintee
  • 505
  • 4
  • 22
2
votes
1 answer

How to implement a callback when auth state changes in supabase

I'm struggling to implement an idea. If a user is logged in, I want to show a hidden div. For example in firebase I can do this: firebase.auth.signInAnonymessly() // Detecting if the auth state changed firebase.auth.onAuthStateChanged((user) => { …
2
votes
2 answers

nextjs-ts-user-management, how to handle redirect to login page using @supabase/auth-helpers-nextjs?

TLDR: I'm leveraging https://github.com/supabase/supabase/tree/master/examples/user-management/nextjs-ts-user-management to build basically a TODO/hello world app and it's amazing. But you will notice that the way they handle loginpage/protected…
Jar
  • 1,766
  • 1
  • 21
  • 27
2
votes
1 answer

How to login a user // set a user as logged-in manually in Supabase?

I'm using Supabase for auth, and I want to set a user as logged-in using my custom logic. I'm looking for something like the following: if (logic-that-checks-if-user-performed-authentication-criteria) { supabase.auth.setUserAsLoggedIn({email:…
Sumit Ghosh
  • 1,033
  • 10
  • 29
2
votes
1 answer

Is it possible to set up posgresql cron job to invoke supabsae edge function?

I'm trying to set up CRON job using postresql with supabase edge function. Is it at all possible? This edge function is inserting data to a table and it works properly when invoked using curl. I found out that there is http extension to use GET or…
xkm
  • 21
  • 1
2
votes
0 answers

supabase and hasura local dev: pg invalid response to SSL negotiation

Existing project managed with hasura{cli, console}. Already migrated pg database from heroku-to-supabase. The goal is to use SupabaseClient on the backend (with NextApiRequest handlers) for…
renderVis
  • 21
  • 4
2
votes
1 answer

Provide two separate json from complex json using supabase in flutter

I have two tables in Supabase, one called places which stores just basic information of the place such as name etc. The other called places_information which stores addresses and other details. A place could have many addresses such as a franchise…
iKreateCode
  • 189
  • 3
  • 13
2
votes
1 answer

How to use bigint safely with Supabase JS

Postgres' bigint type holds 64 bit integers. But the Supabase JS library returns those values as JS numbers, which cannot safely store 64 bit integers AFAIK. What would be the correct way to handle 64 bit integers in Supabase?
Sumit Ghosh
  • 1,033
  • 10
  • 29
2
votes
1 answer

Importing Data into a Table in Supabase

Is it possible to import data into a table in supabase? For example if I have either a csv file or a json file -- can I import that data into a table via the backend of supabase?
Moshe
  • 6,011
  • 16
  • 60
  • 112
2
votes
1 answer

TypeError: supabaseClient.auth.getSession is not a function. Error with NextJS and Supabse

I'm using supabase auth helper package to React and Next in my project. Immediately, when I start the page, I get an error message that says the following: And it is that I am not calling that supabaseClient.auth.getSession() method. Which makes me…
Cesar Mejias
  • 191
  • 1
  • 7
2
votes
1 answer

How to insert timestamp without timezone using Supabase-JS client?

I want to insert current timestamp without timezone to Supabase. I know I can set default value of the timestamp column to NOW() but there can be some delay in the timing and I need it precise. I have tried Date.now() but got the error: date/time…
Jakub Szlaur
  • 1,852
  • 10
  • 39
2
votes
2 answers

SvelteKit + Supabase - get data onMount, keep pre-fetch working

I am building the site which seems fairly simple show data on page from database. I want it to be as fast as possible. It already works/partially works in 3 ways: #Approach 1 +page.server.js -> gets data from Supabase +page.svelte -> gets data and…
2
votes
1 answer

Error:createClient is not defined When using supabase cdn

I'm using Supabase CDN's for a project. When I call the createClient() function this error comes up: createClient is not defined I tried it with an older version of the CDN, with another browser and using the old method of…