]

Guys, apologies if that is the wrong channel for that but, I am scraping the documentation and I am not able to find a way to pass jwt to python. I want to pretty much write to RLS table, I have to token but cannot pass it to the API, here is my code:

def ConfigureUser(jwt):
    d = supabase.auth.set_auth(access_token=jwt)
    #data = supabase.table("user_settings").select("*").execute()
    
    data2 = supabase.table("user_settings").insert({"RoleId":"123","VerifyChannelId": "123"}, returning="minimal").execute()
    print (data2)

Any help please?

Hey @Lsec are you using a framework?(e.g. Flask, Django, FastAPI)

hello

how to use general channel?

Good news, our tag Wiki is approved

I actually messaged supabase’s team about a temporary quota increase so I could fix a few reported bugs on Github (Py lib) and they literally said you’ll need to upgrade your plan

Kinda just stopped doing what I was doing because it simply wasn’t worth it anymore

“Sustain over time” I only need it for a month!

Hey Rawa, Sorry to hear that the quota increase request didn't go through - how were you hoping to use the quota increase? I don't really have context here as the requests are handled by growth but if you could provide more detail we could make a stronger case

I wanted to make very large i/o requests to the database, 100k write/read per minute/second (all dummy data to be transparent, to test the asyncio side of the Py lib) but 100 items in the db was showing 27MB of space. I don’t know much about how postgres works on supabase (soft, hard limits) but I was like no way this is fitting 100k

So I emailed the team for a increase (so I could run as many tests as I like, again, still dummy data) and this is what they said.

Oh ok are you looking for an increase in the size of the DB storage? Like growth mentioned, we don't actually impose a strict limit so you should be able to exceed the space shown on the dashboard. Could we trouble you try give the load test a try first and let us know if you run into errors? Feel free to reach out to me at support[at]supabase.io thereafter if it doesn't work and I'll see what I can do

Hey all, Big fan of supabase! Just started building a product. I've set up the schema and am trying to push data into the DB via the python supabase library. I've taken the credentials from the Auth part of the website but I am always stuck on: > postgrest.exceptions.APIError: {'code': '42501', 'details': None, 'hint': None, 'message': 'permission denied for table Organization'} What are the reasons that could be it? I did run this script thinking it could be it:

grant usage on schema public to postgres, anon, authenticated, service_role;
alter default privileges in schema public grant all on tables to postgres, anon, authenticated, service_role;
alter default privileges in schema public grant all on functions to postgres, anon, authenticated, service_role;
alter default privileges in schema public grant all on sequences to postgres, anon, authenticated, service_role;

alter default privileges for user supabase_admin in schema public grant all
    on sequences to postgres, anon, authenticated, service_role;
alter default privileges for user supabase_admin in schema public grant all
    on tables to postgres, anon, authenticated, service_role;
alter default privileges for user supabase_admin in schema public grant all
    on functions to postgres, anon, authenticated, service_role;

But no luck

Any help will be appreciated!

Ooof... I'd use supabase if it had Python support

nope... I've realised scaling this thing costs a lot of money. I leave you guys right here.

Hi everyone, I was not sure if this is the correct channel, but I have a quick question. I was using the supabase as my database for my BE beyond the auth layer in FE. Previously, I was able to use SQLAlchemy create_engine to reach with a simple DATABASE_URI

postgresql://postgres:XXXX@YYY.supabase.co:5432

. However, for a while, I am not able to do it, I am getting the following error:

port 5432 failed: Connection refused
    Is the server running on that host and accepting TCP/IP connections?

I thought maybe supabase is introduced recently SSL Certificates, but it also did not work. Does anyone have previous experience with this issue?

Hi everyone I was not sure if this is

How should I go about integrating a flask backend with supabase? I want to be able to modify user data and perform additional actions on file storage etc from within a flask server, while leveraging user auth from firebase

Hi, how can I perform a generic query, like an INSERT INTO with ON CONFLICT DO UPDATE, with the supabase-py interface?

Im learning Python and this is showing as a syntax error on Replit can anyone help?

export SUPABASE_URL=<<the value under config > URL>>
export SUPABASE_KEY=<<the value present in Project API keys > anon public>> 
export SUPABASE_SECRET_KEY=<<the value present in Project API keys > service_role secret>>
import json
from dotenv import load_dotenv
from supabase import create_client, Client
from faker import Faker
import faker_commerce

Im learning Python and this is showing

@everyone fast join >< https://discord.gg/tiktokhub

@everyone fast join >< https://discord.gg/tiktokhub

Anyone know how to implement magic link using supabase-py?

Hi

i'm trying to implement google login in my python flask application