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

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

prisma Error: p1001: Can't reach database server at `db.xocheossqzkirwnhzxxm.supabase.co`:`5432`

I started learning about prisma and supabase and would like to implement both technologies in my Next.js app. After running npx prisma migrate dev --name init I was faced with the following error: Environment variables loaded from .env …
Jacob Mutale
  • 55
  • 1
  • 3
2
votes
2 answers

new row violates row-level security policy for table "tasks"

I am new to supabase and am trying to integrate my Todo App made with BlueBase, a Framework based on react and react native. And, I am facing such a problem. CreateTaskScreen.tsx import React from 'react'; import CreateTaskForm from…
Muneeb
  • 43
  • 1
  • 9
2
votes
1 answer

How do you find table intersections in PostgREST clients?

Simple question from a rookie to PostgREST - is there an intersect function for the equivalent below PSQL query? select a from table1 intersect select a from table2; I read through the documentation https://postgrest.org/en/stable/ and didn't see…
walle
  • 21
  • 2
2
votes
1 answer

How to set expiry time for reset password link - Supabase

Have some doubts in Supabase reset-password How can we make the email link a One-time click to reset the password? If the user uses that link again it should not reset the password. How can we make the expiry time on the reset password link to 5…
Haris George
  • 291
  • 5
  • 16
2
votes
2 answers

How to get url of uploaded media in supabase storage in flutter?

In flutter for uploading image according to doc is final avatarFile = File('path/to/file'); final response = await supabase .storage .from('avatars') .upload('public/avatar1.png', avatarFile, fileOptions: FileOptions( cacheControl:…
tailor
  • 373
  • 4
  • 19
2
votes
1 answer

How to use ."in" filter in Supabase URL

I am trying to use ".in" filter of Supabase using its URL. However I can't query for more than 1 filter. Working url https://DATABASE_URL/rest/v1/patients?payer=in.(TERM1) Here I get all the rows where payer is TERM1. However, when I try the…
Yash
  • 223
  • 2
  • 11
2
votes
1 answer

How i can pull all data project production to local enviroment in supabase

I have created a project using supabase platform directly and not in local enviroment so all tables are in production, but now i need a local enviroment for development o test so i created a local project using this guide but the project is from…
Ivan Gustin
  • 39
  • 6
2
votes
2 answers

Uploading Base64 images to supabase

My website wants to reduce the amount of things users can do with the images...so for added security, we want to keep the image sources as a base64 strings instead of a supabase storage URL. Is this possible through supabase storage, do will I have…
Supabase Support
  • 51
  • 2
2
votes
1 answer

Supabase and Google Apps Script

Is it possible to use Supabase with Google Apps Script (GAS)? I'm new to Supabase and I've never tried to import external library to GAS before. I'm planning to use Supabase as a database for my project in GAS. The project is built to run a bot in a…
Ersih Frans
  • 77
  • 6
2
votes
1 answer

Stripe webhook checkout.session items to Supabase

Im using next.js and Stripe webhooks to insert checkout sessions to Supabase that will create a customer's order history. I'm able to get the information about the whole order written to a table called 'orders', but am wondering what the best way…
Steve
  • 71
  • 6
2
votes
5 answers

Get supabase `user` server side in next.js

I am attempting to get the current logged in supabase user while server side. I have attempted to use const user = supabase.auth.user(); but I always get a null response. I have also attempted const user = supabase.auth.getUserByCookie(req) but it…
Brenton Beltrami
  • 333
  • 6
  • 11
2
votes
1 answer

Designing a Multi-tenant SAAS Database with Postgres RLS

I want to design a multi-tenant SAAS database with PostgreSQL and RLS. I want to be able to host all users and the tenants in the same database and isolate their data with RLS. In my use case it makes sense for tenants to share a certain user data…
Ghost
  • 45
  • 1
  • 8
1 2 3
…
21 22