Stack Overflow
Stack Overflow

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
3
votes
1 answer

How to add additional user metadata upon login with Google using Supabase Auth?

I would like to get the first name and last name from the logged in user's Google profile. Upon checking, Google is using givenName and familyName. Is it possible to only do this with Supabase alone or will I need to use the Google API for this…
Larra
  • 346
  • 4
  • 14
3
votes
1 answer

How to link a storage bucket file into an item in a table

How can I link a file in my storage bucket into a table? Let's say I have an item like this Name: user, CreatedAt: date, pfp: storageFile I want the file to be linked to the pfp field.
Khaled-The-Dev
  • 121
  • 9
3
votes
1 answer

supabase.auth.getUser() returns error on vue-router route guard

I am attempting to build a Vue application that uses Supabase authentication. Inside one of the route guards in the router file, I implemented supabase.auth.getUser() in order to retrieve the user login status for a conditional that prevents next()…
JS_is_awesome18
  • 1,587
  • 7
  • 23
  • 67
3
votes
1 answer

How to add Supabase Order by in get request using Postman

I need to add order in supabase result while calling the supabase bash in postman. I am doing same in flutter like below Future getPropertiesFromBirmingham() async { var response = await client .from('properties') .limit(10) …
Paras Goyal
  • 31
  • 4
3
votes
0 answers

Auto-Incrementing IDs in Composite Primary Key

In my app, there are organizations that can create tasks. Instead of having a serial task ID, I would like to have an incrementing task ID for each organization ID. Just like in GitHub, where repo + issue number identifies the issue. Tasks look like…
ccssmnn
  • 306
  • 4
  • 11
3
votes
0 answers

Supabase SSR getSession always returns null

I've tried to check for session on server side in my NextJS project. I've used supabaseService client and also "createServerSupabaseClient" from @supabase/auth-helpers-nextjs both of those checks returns session null even tho I'm logged in in the…
Floky99
  • 562
  • 2
  • 8
  • 17
3
votes
3 answers

Supabase returns empty array

I have a messages table , under a 'public' schema in Supabase. I'm trying to fetch all rows from my local dev environment, but nothing is returned. I'm trying: const response = await supabase.from('messages').select('*'); I see the request in the…
George Katsanos
  • 13,524
  • 16
  • 62
  • 98
3
votes
0 answers

Deno Deploy --cert flag

How can I add --cert flag when my project run on deno deploy? I am using deno fresh and supabase postgres. When in local environment I use --cert flag to set certificate, but in deno deploy I didn't know how to set --cert flag
Bilal Bera
  • 29
  • 2
3
votes
2 answers

Nexts.js 13 + Supabase > What's the proper way to create a user context

I'm building an app with Next.js 13 and Supabase for the backend, and I've been stuck on figuring out the best/proper way to go about creating a context/provider for the current logged in user. The flow to retrieve the user from Supabase is…
Ryan Roberts
  • 318
  • 1
  • 4
  • 12
3
votes
1 answer

Update multiple rows in a single query in a Supabase Database (postgres)

I looking to update multiple rows via a single query in Supabase. I'm struggling to find an example of how to do it online. For this example here is how the data exists the database's 'food'…
Jake Anderson
  • 309
  • 1
  • 4
  • 18
3
votes
2 answers

What's the equivalent of this Supabase query in SQL ( Postgresql )

I have a table "store" and a table "product". Each store has multiple products but a product only has one store ( one to many relationship ). The tables might look something like: store: id, name product: id, name, store_id when querying the store…
Pierre
  • 33
  • 4
3
votes
1 answer

NextJs + supabase not deploying supabaseUrl is required

i'm trying to deploy my project but i keep getting this error saying that supabaseUrl is required. I'm getting this error This is my supabaseClient.js import { createClient } from "@supabase/supabase-js"; const supabaseUrl =…
José Carlos
  • 626
  • 3
  • 23
3
votes
1 answer

Supabase database size issue

I am quite new to Supabase. Please clarify this: I have a table in the database and its only 32KB in size.(2 columns and 2 rows of data only) So why it is showing a Database Space Usage (under Settings > Database Usage) as 30 MB out of 512 MB Does…
orthodontistxxx
  • 31
  • 2
3
votes
2 answers

Cannot access env variables next.js

I'm creating an app with Next.js and Supabase. When I create the client in /utils/supabase-client.js, it throws the error that Error: supabaseUrl is required.. Here is my file: import { createClient } from '@supabase/supabase-js' const supabaseUrl…
Emiliano
  • 437
  • 1
  • 4
  • 14
3
votes
1 answer

Supabase: How to automatically update a timestamp field after updating a row?

What DB I am using? Supabase hosted version What do I need? After I update a row with .update({ name: 'Middle Earth' }) method I need to automatically update also a timestamp in my table. How can I update automatically a timestamp?
Jakub Szlaur
  • 1,852
  • 10
  • 39
1 2 3
…
80 81