Stack Overflow
Stack Overflow

Questions tagged [supabase-database]

Supabase is a database solution powered by PostgreSQL. Under the hood, Supabase uses PostgREST, an open source tool to make automatically create REST API for PostgreSQL databases. Supabase utilizes row level security feature on top of PostgREST to provide authorization. Use this tag when you are having problems, and not to ask for new features.

Supabase Database is a component of Supabase that automatically creates RESTful APIs for your Supabase database backed by PostgreSQL. Under the hood, Supabase uses PostgREST, an open source tool to create REST APIs for your PostgreSQL database. Supabase utilizes row level security feature on top of PostgREST to provide authorization. Use this tag when you are having problems, and not to ask for new features.

Supabase Database comes with:

  • intuitive table editor
  • clients in various languages to communicate with the database
  • SQL editor to easily run SQL on your database
330 questions
0
votes
1 answer

Get token parameter inside of .ConfirmationURL to reset password on reset password template supabase

i need get the token to reset password user in the reset password email template becuase i will send this token in firebase deep link but the parameter .ConfirmationURL has url with more information, i just need get the token, there is the…
Ivan Gustin
  • 39
  • 6
0
votes
1 answer

Supabase stream with filter does not work with delete operation

I have one stream listening changes from a table in supabase, insert and update operations works fine, when occurs one change the stream on flutter listen and re draw the widget but if I delete one row in the database or through the app the stream…
Ivan Gustin
  • 39
  • 6
0
votes
2 answers

Unable to pass data from next.js into Supabase due to Primary key error

I have written some code that will take in user input from a few input boxes, and pass them to the corresponsing table on Supabase. This is what the code looks like const initialState = { solution_id: '', organization_id: '', budget_usd: '',…
Yan Xu
  • 27
  • 1
  • 5
0
votes
0 answers

How to post data to supabase through next.js

I currently have a simple next.js website where users can look at projects for an organization, and at the bottom of the page, the user can input a new project through the use of a form with multiple inputs. The database that i am currently using is…
Yan Xu
  • 27
  • 1
  • 5
0
votes
1 answer

How can I filter by a value inside a pivot table using Supabase?

I'm building a bike rental app where users can reserve bikes for a certain number of days. Bikes and users have a many-to-many relationship, there's a bike_user pivot table that contains the information about reservation start and end dates. See the…
lumenwrites
  • 1,287
  • 4
  • 18
  • 35
0
votes
1 answer

How can I offer a download bundle that doesn't trigger the zip warning on browsers?

My application allows subscribers to download a bundle of video editing templates compressed into a zip file. Chrome is preventing the download due to security. Is there better way to bundle the files, or a process to get vetted by Google to allow…
JohnnyK
  • 93
  • 1
  • 6
0
votes
1 answer

How to refactore Supabase CRUD Functions from a Sveltekit Store efficiently

I been trying to get the hang of supabase as a new dev and it took a while to understand. I don't think my code is efficient event though it works. Any help would be greatly appreciated! My current store looks like this import { writable } from…
Nicholas Singh
  • 71
  • 9
0
votes
1 answer

Supabase-Py: TypeError: __init__() got an unexpected keyword argument 'headers' when making client

I have been using supabase in python without problem but today I got an error when I went to create my client. Code is below, all help would be great. Code from supabase import create_client, Client supabaseUrl = 'REDACTED' supabaseKey =…
Garberchov
  • 67
  • 1
  • 15
0
votes
1 answer

Can't use http_get() in a supabase trigger function

So I'm kind of new to databases in general, or at least not very experienced. But in general I think I kind of understand how it all works. So I had a trigger function to add row to a profile table when a new user signs up, it was all working as…
torwent
  • 1
0
votes
1 answer

Postgres with cron job doesn't work on get request

I am working on a cron job to return results for every minute. select cron.schedule( 'webhook-every-minutex', -- name of the cron job '* * * * *', -- every minute $$ select content::json->'results' from…
user4150758
  • 384
  • 4
  • 17
0
votes
0 answers

Supabase calls outdated function even when it is deleted

I've created a new function in Supabase as follows: drop function if exists select_whitelist_airdrop_address; create or replace function select_whitelist_airdrop_address(airdrop_address text) returns table(owner text, hash text) as $$ select…
methuselah
  • 12,766
  • 47
  • 165
  • 315
0
votes
1 answer

Unsure why supabase is not returning values from foreign table

I have a query that also selects from a foreign table. The current table already has a foreign key relationship. Here is my query const { data, error } = await supabase .from('comments') …
Electric Dragon
  • 176
  • 5
  • 17
0
votes
1 answer

Failed to create function: Syntax error at or near "*"

I am trying to create a trigger in Supabase with the following code that will help me update a certain value in another table. Following is the trigger code for the supabase function BEGIN DECLARE num integer; SELECT count(*) into num FROM…
Electric Dragon
  • 176
  • 5
  • 17
0
votes
0 answers

Supabase RLS not restricting reads

I am using Supabase and I have RLS enabled on my database table but I can still read data with the anonymous key. Why is this? const { createClient } = require('@supabase/supabase-js') const supabaseUrl =…
Jordan Baron
  • 141
  • 1
  • 12
0
votes
1 answer

SupaBase Public URL - How to show all users avatar?

Framework: Next.js with SupaBase Im trying to get all users avatar that are stored in a column in a table -> "Profiles" I only get the image name "placeholder.png", how do I get the public URL, and map over it for each user? This is my…
Charlie Østergaard
  • 191
  • 1
  • 14
1 2 3
…
21
22