(sorry i went offline in between) to change the timeout for the database client you can do

py
supabase.postgrest.session.timeout = x

where

supabase

is defined as you had shown in the earlier snippet

Awesome thanks! I'll give that a shot

Is x in seconds or ms?

seconds i believe. it's just the timeout arg for the httpx clientsession https://www.python-httpx.org/quickstart/#timeouts

This worked! My timeout issue is on the upstream server now lol

Haha

You could try connecting directly to the database with something like psycopg2/asyncpg and write SQL to insert your dataset now, and then use supabase-py to do the simpler queries

You can find the db connection string in the project settings

https://supabase.com/docs/reference/javascript/auth-api-getuser#fetch-the-user-object-using-the-access_token-jwt= is there a way to do this using the python sdk?

getUser() | Supabase

Does anyone have experience using Supabase as a database with Django on GCP? I'm able to connect to the database locally, but when I deploy to Google App Engine I get a HTTP 500 error. For additional context, when I swapped out the connection with a different postgres instance (digital ocean) I am able to connect from my app engine environment without making any other changes. I'm assuming it has something to do with with the SSL cert, but app engine uses SSL by default, so not sure what other avenues to test.

Does anyone have experience using

Hello all, How do you guys handle database error in python? I’m getting a “key already exists error” (which is wanted) but from that I’d like to make an if statement. How’d I go about that?

Hello all

how to get all items from a table where a column is null.

supabase.table('vehicles').select('id').is('deleted', None).execute()

python library does not seem to support the

.is

like in subabase-js

how to get all items from a table where

What's the correct approach to set a timestamp from python? Use datetime?

i'm trying to use supabase for my tiny discord bot, and am currently testing it to see if it works, but for some reason, even though i put some sample data in my table, the request always comes up empty

py
supabase = supabase.create_client(url, key)
data = supabase.table("lengths").select("*").execute()
print(data.data)

output: [] looking at the api logs, the requests are successful, it's just not giving any data

Don't use any of your environment, but that is what would happen if you are not meeting RLS policy.

how would i set up an RLS policy that would only allow me to modify the table?

If you want to only modify from the dashboard then just turn on RLS and don't have an insert or update policy. You would need a select policy for users to select your data. Either true for all or select specific roles

nah i'm looking to insert/update values with the bot

I don't know enough about bots to say. If you can safely use service role key (it can't be seen in the code by users) then that would work. Next would be having to generate a user for the bot and deal with signing/refreshing etc. There may be other ways using an extra row with a code you can include in the insert or with headers.

yeah my code is closed source, will look into the service role key, thanks

I created a PR for providing an interface similar to this one https://supabase.com/docs/reference/javascript/auth-update#notes

for gotrue client

Hi there, I'm currently using Supabase to try and upload a .txt file to a public bucket named "training-data", but for some reason, it's giving me this error:

storage3.utils.StorageException: {'statusCode': 400, 'error': 'Key is not present in table "buckets".', 'message': 'insert or update on table "objects" violates foreign key constraint "objects_bucketId_fkey"'}

I made sure to create all the necessary object policies to allow for insertion, as well as make the bucket itself public. Here is my code:

py
from supabase import create_client
from dotenv import load_dotenv
import os

load_dotenv()
url = os.environ.get("DEPLOY_URL")
key = os.environ.get("DEPLOY_KEY")


supabase = create_client(url, key)

file = "test.txt"
# data = supabase.storage().from_("public/training-data").download("test.txt")
# print(data)

supabase.storage().from_("public/training-data").upload("test.txt", file)

If anyone has any suggestions, please let me know.

FYI, when I manually upload "test.txt" to the bucket then try to download it (using the commented-out lines), it works, so I know it's not an authentication problem.

Hiya! Is there documentation for python and Django? I’m currently learning Django and want to know if I can do database connection with supabase instead of the default SQLite?

Using Supabase as a Database with Django