226 questions
1
vote
1
answer
818
views
supabase ilike with multiple reference table
Is it possible to do filters or with multiple reference tables, like if we do it in raw postgresql query like below (just for example):
SELECT reports.*, report_categories.*, report_details.* FROM ...
- 632
1
vote
1
answer
1k
views
Supabase & NodeJS: Invalid claim: AuthApiError: invalid claim: missing sub claim with getUser(jwt)
I have a custom backend that needs to authenticate users before letting them request some Express endpoints.
It works that way: NextJS (front-end) sends a request to NodeJS/Express (backend) with a ...
- 57
2
votes
2
answers
952
views
Supabase, Clerk, React, Vite: Multiple GoTrueClient instances detected in the same browser context
I'm trying to create a very basic app in which I'm using Clerk for Auth and supabase as my db. I've followed the tutorials that I could find and stitched something together which works pretty well ...
- 153
0
votes
1
answer
1k
views
Only able to get specific columns with Supabase and Next.js
I'm only able to fetch certain columns out of my database. I'd like to get every row out of my table, but when I select all, nothing is returned. My table (shows) has 9 columns. I just created the ...
- 1
0
votes
0
answers
1k
views
Supabase and Next.js - How to make change password page accessible only to authenticated users
I have a next.js application and I am following the documentation for allowing users to reset passwords.
So far, I built the password reset page and made it publicly accessible with a form asking for ...
- 51
0
votes
1
answer
919
views
Supabase Auth: Google Oauth is succesful, but onAuthStateChange is not triggered
I'm building a Google slides add on. The DB operations are implemented using Supabase and the frontend using React.
I'm trying to use Supabase oauth to authenticate the user via Google.
Here's my code:...
- 645
1
vote
1
answer
1k
views
How to join table many to one via supabase in reactjs?
I have a table where when I test it with the following query select *, category_product from product inner join category on product.category_id = category.id inner join type on product.type_product = ...
- 11
1
vote
1
answer
949
views
Supabase Auth UI + Google Sign in not reaching AuthProvider
I'm using Vite + React Router v6 + Supabase Auth components with a Google OAuth provider. I double checked that the Google credentials are in Supabase configuration, https://{my_supabase_id}.supabase....
- 3,258
1
vote
2
answers
891
views
What is causing the error Cannot find name 'useSupabaseClient'. when using Nuxt 3 and Supabase?
Using npm I have installed Nuxt 3 and Supabase but in vs code I keep getting the following error;
Cannot find name 'useSupabaseClient'.
When I run npm run dev I get the following error message on the ...
- 11
4
votes
2
answers
4k
views
How to upload an image from gallery to supabase storage
I want users to be able to pick a profile picture from the gallery using the Image Picker from expo and upload it to supabase in a filename that is structured like this userid.jpeg. I then want to ...
- 41
0
votes
1
answer
135
views
How do I use goto and make my Log in page the first thing the user sees?
Does anyone know what I'm doing wrong? My homepage is at src/routes/+page.server and I want users to be redirected there after they log in/sign up. Also, when I run this website, the first thing I see ...
- 1
0
votes
1
answer
490
views
Database operations and changes not working in Supabase Edge Functions
Any database operation I perform inside an edge function is not working as expected. For example, if I insert a record, it will not persist to the database or if I select, it returns 0 records. I don'...
- 169
0
votes
1
answer
2k
views
supabase bucket getPublicUrl returns url that doesnt work
I'm using the supabase js API to create a public bucket and upload images to it.
This works so far:
const { data: bucket, error } = await supabase.storage.createBucket(
bucketName,
{
...
2
votes
3
answers
2k
views
Supabase RPC functions return 204 every time, but don't update table
I'm in my backend (Node and Typescript).
In my rpc function, Im just trying to append jsonb to a jsonb array:
BEGIN
UPDATE public.profile
SET checking_tokens = checking_tokens || input::JSONB
...
- 125
0
votes
1
answer
2k
views
Having trouble creating user with supabase.auth.admin.createUser() method with error message "Database error creating new user"
I'm trying to create a user with supabase.auth.admin.createUser() method in my Next.js project, but it fails with error
{
message: "Database error creating new user"
name: "...
- 1
3
votes
1
answer
751
views
How to link supabase table with foreign key to User Data, using NestJS and typeorm?
I just create a Supabase DB using NestJS and TypeORM. I have some entities like this:
@Entity()
export class UserService {
@PrimaryGeneratedColumn()
id: number;
@OneToOne(type => User)...
- 69
2
votes
1
answer
699
views
Supabase getBucket function is giving a 404 error
I am trying to follow supabase's documentation at "https://supabase.com/docs/reference/javascript/storage-getbucket" to retrieve bucket details. When I write the following code, I get a 404 ...
- 31
0
votes
1
answer
349
views
supabase nextjs pagerouter problem while authantication
I am using supabase along with nextjs page router and i don't know how to set this thingand in middleware.ts there is an error in "lib/database.types"i don't know about where to get it ,...
3
votes
0
answers
670
views
Electron : how to manage user auth in main and renderer process?
I am building an Electron App with this user flow:
1- User logs in
2- Enters local db credentials
3- App fetch local db every X minutes
4- App sends data to somewhere else logged in as the user
Since ...
- 425
0
votes
0
answers
138
views
Unable to access session data after sign in with OAuth provider (specifically Github) in next js + @supabase/ssr
I am creating a next app that protects some urls based on user authentication. I have an auth form set up like this
import { getUrl } from "@/lib/utils";
import { Button } from "./ui/...
- 228
1
vote
0
answers
588
views
Disable supabase reads but allow real-time updates to anon and authenticated
I want to use supabase only for real-time updates of the PostgreSQL database.
Meaning that I don't want to allow anon/authenticated to read/update/insert/delete, but only want to push live changes ...
- 185
0
votes
1
answer
497
views
Unable to get valid response from Supabase local CLI through javascript client library
I am trying to connect a react native app to a local Supabase development set up. I am doing so using the localhost API url and the provided anon key:
const supabaseUrl = 'http://localhost:54321'
...
- 31
0
votes
1
answer
394
views
Enabling PostgreSQL Realtime Monitoring with Supabase and Bun Backend: Need Help Troubleshooting
I'm developing an application with a Supabase backend, and I'm currently attempting to deploy a separate, very simple backend using Bun with TypeScript and the Supabase-js npm library. The goal of ...
1
vote
0
answers
860
views
Supabase self-referencing many-to-many relationship failing
I want to implement a many-to-many relationship between rows of the same table. Imagine I have a books table and I want each book to have a list of related books to be queried and displayed on my site....
- 71
7
votes
2
answers
3k
views
ReferenceError: window is not defined in React Native project after adding Supabase call
I'm using a React Native project with Expo v49, and I added a Supabase call to read some data from the database, and it works on ios/android,
But when I open the web version, I get "...
- 71