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.
1,791
questions
-1
votes
1
answer
465
views
Error : Supabase url is required , Python
I've been faced SupabaseException: supabase_url is required.
Here are codes
import os
from supabase import create_client, Client
url: str = os.environ.get('https://mine.supabase.co')
key: str = os....
-1
votes
1
answer
614
views
Nuxt 3 image src binding
I am trying to render an avatar image using Nuxt3.
So far I have
<template>
...
<img :src="avatarUrl.value"/>
...
</template>
<script ...
user9361734
-1
votes
3
answers
760
views
How to stop supabase which is running on localhost 3000?
I wanted to know what supabase is so I installed it using this local development guide enter link description here
it was few weeks back, i was simply checking port 3000 and supabase is running i have ...
- 21
-1
votes
0
answers
17
views
I want to get the user's info after user verifies email in supabase
I want to get the user's info after user verifies email in supabase.
Is there anything something like auth events for email verification? I want to save some basic user's info in my DB but, after ...
-1
votes
0
answers
12
views
user cant change the password on Nextjs and supabase [closed]
im trying to let the user to update his password using an API with supabase token but its not working
here is my code
// ** React Imports
import { useState, ChangeEvent, ReactNode, useEffect } from '...
- 637
-1
votes
0
answers
10
views
Does Supabase support synonym dictionaries?
I am using the full text search with Supabase but have run into some words that need to be fixed. eg. "Mathematics" is not picking up "Maths". I want to create a synonyms ...
- 1
-1
votes
0
answers
8
views
Using a backend script to bulk insert data in Self Hosted Supabase in Ubuntu
I am new to Supabase and I wonder how to implement a backend script to insert/update data in a Self Hosted Supabase without using the Supabase Dashboard. I have a master data (very large CSV/Excel ...
- 71
-1
votes
0
answers
9
views
Why is supabase not returning the data that i'm trying to fetch
Yesterday, fetching data from a table in supabase worked perfectly fine, I'm using React along with React query for fetching, But today when I got back to developing the app, fetching does not work ...
-1
votes
0
answers
73
views
Using Supabase CLI within Docker Image
I installed Supabase in a docker container using these instructions:
https://supabase.com/docs/guides/self-hosting/docker
Now, I want to generate TypeScript types for my database. Apparently, this is ...
- 179
-1
votes
1
answer
92
views
React not re-rendering
When i moved my code to a newer version of react for some reason its not rendering and updating 'total votes' when i click on any of the below buttons.
Edit: Also when i tried to print my data in the ...
- 1
-1
votes
1
answer
376
views
What is the best plain vanilla timestamp format to save in database (coming from Javascript (PostgreSQL/ Supabase)?
The authors of the npm package Moments state that Moments is deprecated and in maintainance mode only.
The authors recommend we move away from Moments; while it does recommend a few other libraries, I ...
- 760
-1
votes
1
answer
141
views
Supabase Edge Function Can't Send Email
I'm trying to send and email using SmtpClient from deno, and configuring it using gmail app password. strange thing is when i serve the function locally emails get sent but once deployed i get the ...
- 149
-1
votes
1
answer
217
views
Next, supabase, vercel - vercel drops supabase connection
For the last month, at least once every day, Vercel has dropped the connection to supabase.
The Supabase 'support' people say it has nothing to do with supabase (the error is 'user not found - and the ...
- 2,615
-1
votes
1
answer
259
views
How to manage multiple SQL schemas in a multi-tenant database?
I am working on a SaaS and we decided to go for a Multi-Tenant approach with each tenant having its schema.
What we have now:
We have a stored procedures that we use to bootstrap a schema from scratch....
- 386
-1
votes
1
answer
154
views
How to send back multiple partial responses for an HTTP Post request?
I am implementing a Supabase Edge function, which runs on Deno runtime, and uses the Oak framework. During the processing of my HTTP POST request, I want to send back partial responses to the client. ...
- 137
-1
votes
1
answer
589
views
Google OAuth works on localhost but not on production server [closed]
I have set up Google OAuth using Superbase, and it's working fine on my localhost:3000, but not on my production site which is hosted on Vercel.
The problem is like this on my production server.
I ...
- 83
-1
votes
1
answer
120
views
I am trying to deploy supabase in environment. Supabase real time is failing because of ipv6. How to disable ipv6 in supabase?
I am trying to deploy supabase in environment. Supabase real time is failing because of ipv6. How to disable ipv6 in supabase?
Error message below:
22:43:42.151 [error] Failed to start Ranch listener ...
-1
votes
1
answer
313
views
upload file on supabase using appsmith corrupt image
I'm trying to upload an image on supabase storage with appsmith and the file picker option.
It work but my file is corrupt and i don't know why.
export default {
function: async () => {
const ...
- 1
-1
votes
1
answer
305
views
Flutter/Supabase - problem with multiple OR in filters
I am using Supabase as my Flutter app backend, and I've hit a problem trying to build a complex SQL query using the Flutter
Here is the query I am trying to create in SQL...
select
"instanceId&...
- 1,462
-1
votes
1
answer
560
views
Deep-Link Error with Flutter and Supabase. Unhandled Exception: AuthException(message: No access_token detected., statusCode: null)
I have a working small Project which uses a supabase-backend for Data and Authentication. Everything works as intended and especially the OAuth works like a charm.
Now i wanted to implement Deep-Links ...
- 794
-1
votes
1
answer
386
views
To download an Image from an URL using Javascript and then publish it to Supabase Storage
I am interested to download an image from an URL for instance "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQo2zi7aWGrKd8eTtROEbeG4noyYyEicLaqpMOmqXXN&s%22" and then pass it to ...
-1
votes
1
answer
535
views
How to create a sequence for integers in PostgreSQL?
I'm trying to create a sequence for a product id to start at 100 in Supabase SQL editor and I'm getting this error:
Failed to validate SQL query: syntax error at or near ")"
What am I ...
- 655
-1
votes
1
answer
74
views
Postgres JSONB equivalent to MongoDB $ifNull (aggregation)
I am in a process of using Postgres database (Supabase) instead of MongoDB. Sorry I am still rather new to Postgres, worked only with MongoDB previously.
For some columns it is still preferable and ...
- 513
-1
votes
1
answer
274
views
How to run supabase functions in the admin API?
I have been using Supabase for a couple months and I really like what I see. User authentication is pretty simple. I have sign up with email verification, sign in, and password reset all working. My ...
- 11
-1
votes
1
answer
596
views
Supabase: Could not read Signup params: json: cannot unmarshal object into Go struct field SignupParams.email of type string
I have been trying to setup supabase with email and password to allow users to sign up but somehow I keep getting this error:
AuthApiError: Could not read Signup params: json: cannot unmarshal object ...
-1
votes
1
answer
2k
views
Unhandled Runtime Error TypeError: posts.map is not a function
I am learning nextjs and decides to follow the [build reddit clone tutorial] I found on Youtube, however I kept on running into
posts.map is not a function
please help me out.
Thanks in advance.
(I'm ...
- 11
-1
votes
1
answer
69
views
Does anyone who has experience with loading GA4 log data to Supabase database?
I work as a growth marketer in a startup.
For various growth marketing activities, I'm using raw data by linking GA4 and Big Query.
By the way, my company is trying to build a user's DB called Service ...
- 1
-1
votes
1
answer
202
views
SupaBase plpsql
I am trying to create a function and trigger to run on auth.users insert and cannot get the function to be applied to the table, it is a syntax error and I ma not to familiar with plpgsql.
If anyone ...
- 189
-1
votes
1
answer
913
views
How to get total likes count of a post from supabase backend?
I have two tables one for post and one for likes.
Post table stores all the post information.
Likes table has 3 columns
id,
post_id
user_id
Now I need help to figure out how to get total number of ...
- 27
-1
votes
1
answer
1k
views
How can I model a limit of number of Rows in a Table in Postgres
i am currently learning how to work with databases in a full stack web development context. I want to model a scenario where students can enroll into a variety of events which have a certain capacity. ...
- 11
-2
votes
3
answers
3k
views
Flutter Supabase - Join Tables
I have 2 tables
Department(id, department_name)
Programs(id, program_name, department_id)
dept_id in Programs is the foreign key from Department table
I want to join department_id in Program table ...
-2
votes
1
answer
32
views
Is it a good idea to use EF with Supabase? [closed]
I am creating an application with .NET and Supabase.
I would like to take advantage of Supabase's Postgres database.
The flow of my application is that the Frontend authenticates in Supabase, but ...
-2
votes
2
answers
629
views
can I create tables and RLS via any external API or similar?
I need to create a custom admin tool, where I create tables and RLS rules outside the Supabase admin dashboard.
Is this possible?
- 733
-2
votes
4
answers
313
views
Why is array.map() not a function?
I want to map an array from react's useState hook, but I get the error:
TypeError: documents.map is not a function
This is my code:
const [docs, setDocs] = useState(documents);
const rows = ...
-2
votes
2
answers
1k
views
having some problems reading data from Supabase in flutter [closed]
I'm trying to build a basic Crud app with Supabase. I'm trying to read some data from a table but when I debug, it shows an error: "unexpected null Value".
My model
import 'package:...
- 1
-2
votes
0
answers
23
views
getting error when trying to launch kotlin jar file that use supabase "java.lang.NoClassDefFoundError"
when i try to launch the jar file that i build from my kotlin program on desktop in the intillij IDE it work perfectly but when i try to run it using JAR with the terminal it show me this error
"...
-2
votes
1
answer
322
views
Is there any clean way to append items to a one-to-many relationship?
Very innocent question
If we have an array of items in a table cell, is there any way to append data to it without having the need to fetch the data of the whole row to get its content, in order to ...
-2
votes
1
answer
62
views
Array is populated but individual element is undefined javascript [duplicate]
Array is being populated how I wanted it to after formatting some data that I took from a database, but accessing an individual element returns undefined using console.log. I wanted to use this array ...
-3
votes
0
answers
29
views
Group and average a supabase table
Table name: Scores
| name | score |
----------------
| Bob | 12 |
| John | 8 |
| John | 6 |
| Bob | 10 |
| John | 7 |
I'm trying to grab each unique name from the table, sum their ...
- 19
-3
votes
1
answer
63
views
GET http://localhost:3000/ 500 (Internal Server Error)
Yesterday I had to add some changes to my database table and all the data was lost, which it wasn't a problem because I'm just developing the project. The problem arises after I did that. I started to ...
- 1
-4
votes
1
answer
89
views
How do I perform a join supabase statement in python code
Below is a code where I am trying to perform a join operation. I have a table citizen which has a foreign key location_id from table location. Now i want to retrieve the the name of location when of ...
