Only really makes sense to use prisma if ur gonna use typescript

Greetings! How can i upload a csv file to supabase bucket using python? any help will be appreciated. thnx

Here's a funny one. I was connecting my local setup to my database and getting the error

Error: Error parsing connection string: Make sure the URL is percent-encoded.

The issue: my randomly generated password has an

@

in it. Oops.

Hey

does anyone have any tutorials for how I can configure Supabase for a native app for Android

On your website I only saw a Flutter tutorial but I didn't see a native one

Can anyone please help me with this?

I have Schemas: - User {id, name, email, posts: Post[]} - Post {id, title, content, userId} When I select user with supabase-js SDK, I want the user data such as it gives: {id: 1, name: "soham", email:"sohamshah456@gmail.com", posts:[{id:1, userId:"1", title:"Wow", content:"I am content"}, {id:1, title:"Wow", content:"I am content", userId:"1"}]} Basically, I want the data to be populated. How to do this with our supabase-SDK SQL query?

Hi, are you using the JavaScript SDK ?

Yes

Then you can query foreign tables by specifying in the

select()

arguments. Here's the doc section about it: https://supabase.com/docs/reference/javascript/select#query-foreign-tables

In your case that's gonna look something like

await supabase.from("users").select("*, posts(*))

Thanks!😁😁😁

Does supabase support offline-first?

What can be the possible reasons for getting 403 (42501) on supabase requests from supabase-js SDK?

https://stackoverflow.com/questions/67551593/supabase-client-permission-denied-for-schema-public Can we get a better workaround for this?

Offline support

Destroying entire database

Is supabase-js SDK faster than prisma in terms of performance?

How do you make a Supabase logo dark in light mode ?

👆

How do you do dynamic full search? I have this, but tableName is not a type and I don't think tsvector("*") is possible. create or replace function searchDB(tableName text, recherche text) -- 1 returns setof tableName as $$ select * from tableName where to_tsvector("*") @@ to_tsquery(recherche); $$ language plpgsql;

To anyone who is coming from firestore - who is using supabase more or less with a JSONB field? Besides no partial update possibilities and limited query options, it looks quite good

You may find some answers in the following discussion that was posted today in

r/PostgreSQL

about JSONB: https://www.reddit.com/r/PostgreSQL/comments/sndijh/when_do_json_columns_make_sense_in_postgres/

ah wow thanks! I have large objects of travel bookings and I find it not easy to maintain all relations to other tables (or mapping tables) because I have to add the relations by myself (e.g. create an accommodation, then add the used images to the many-to-many relation table) and can't use transactions (via JS SDK). So I'm considering to switch to JSONB for the core data, because I don't need really the relations. But partial updates and extended query options would be nice to have. Otherwise I have to use services such as algolia 😅

I don't really have much experience with JSONB beyond insert and select the entire object. Though based on what I've read, you can create an index on JSONB fields -- not sure if that helps. Also, look up

pg_trgm

to see if it helps avoiding algolia... I was just searching and this article came up and looks interesting (it has a section for "GIN Trigram Indexes" using

pg_trgm

on JSONB) : https://dev.to/scalegrid/using-jsonb-in-postgresql-how-to-effectively-store-index-json-data-in-postgresql-5d7e

Hi folks, just joined the server and am wondering if there is any progress with supabase on Kubernetes that I might be able to help with?

I guess it's kind of secret, but is there a public roadmap what supabase is going to do? 🙂 - I like to be surprised with great features (as usual), but sometimes it helps to know what might come in the future

Is there a way to easily write "select length(column) from ..." with the JS library?

Yes https://supabase.com/docs/reference/javascript/select#querying-with-count-option