I’m sure I’m doing something wrong but there are no docs

Yeah, I'm using JS client, so I can't help much.

They should be fairly similar in how they work.

Are you able to do an update without any filters?

I think the update in the python client is just broken. Cause there is no match and the other filters don't work either.

I don't want to use JS as I like Pandas so much.

Python is in beta is it not? Seems like a reasonable conclusion that you're looking at bugs. But I haven't tried not using filters with JS client.

yes, it is in beta, but it is also the #1 used language in the world

Why not make a thread for all these questions, since they're all related to the Python lib? Also 'most used language in the world' varies from different data sources. StackOverflow dev survey 2020 says JS (62.4%) and Python (41.6%), while the TIOBE index says C is ranked top with Python in second place, and yet PYPL says Python is top.

I have managed to get it to work with JS, using the obvious syntax of just .update({}) and even with filters. It does seem maybe the python client is buggy or not complete

Python buggy. But any idea on my previous question? 😅

Which question?

is their any more docs on the python library for updating a row?

@User was dealing with an issue using python update

It appears its buggy as its in beta

I don’t think updating actually works. It isn’t listed in docs. It throws errors when used similar to js examples. Match() doesn’t even exist.

I managed to get js version working no problem but I want to use Python so I’m stuck with either using rest, Postgres directly, or slugging through js

ah okay same wanted to use python but ill just go with js then

Prisma has great documentation imo

most things I've worked with do

@User I'm using the python library in production, but we've had to patch the supabase client and gotrue in some places to fix issues. Eventually we'll hopefully get all those changes upstream. Anyway, we update existing records with: client.table(our_table).insert(data, upsert=True).execute()

What if you want to update one column for all rows with 0. I've tried

.insert({"balance": "0"}, upsert=True)

and I get violate constraints with other columns being null.

We haven't done so. Our clients always write single records

ah okay thank you

Thanks. Method#2 worked!

I wrote this article, and hope it would be helpful. https://thomasejembi.hashnode.dev/supabase-password-reset-functionality-with-react

i feel like the docs are helpful for basic data manipulation. But i need help, what is the best way to fetch a user's posts? do i fetch user data , then fetch from posts with the user id?

depends on how you structured your data

I'm assuming (correct me if I'm wrong) that u have a table for ur posts and I assume you have a foreign key in that table that connects to the user's id

you can then do two things