A place for developers to talk about building on Farcaster.

/dev

Is it me or Supabase sucks? 

I’ve been playing around for the last few hours and I still haven’t been able to do very basic stuff

Currently tinkering in web3. Previously Growth @ Dune. I like the ocean and summer mornings 

About to do the same so I'll let you know 😂

Full Stack Dev | Head of Developer Relations at /pinata | Technical Writer | Tinkering with everything | stevedylan.dev/links

So far so good, but not sure what stack you’re using so results could vary 😬

I’m using next JS, my problem is with their API, I can’t find easy ways to create upserts of nested records

Hmm, not sure I can help there 😬 I did find this: https://supabase.com/docs/reference/javascript/upsert as well as this https://stackoverflow.com/questions/74316422/upsert-an-array-of-objects-using-supabase-and-reactjs

Could be a matter of segmenting?

Yeah I see what you’re saying; I think that’s done when you create the database? I could be wrong but in table creation there are fields to make certain columns linked to columns on other databases.

Also not familiar with prisma but I did find this 👀

Also not familiar with prisma but I did find this 👀 https://www.prisma.io/docs/guides/database/supabase#commonalities-with-other-database-providers

Thanks, but how do you upsert an element that has a relationship to another table? 

Meaning, a model user and a model posts, how would I go about creating a new post, and upserting the user? Does that make sense? 

This is straight forward using Prisma but not with Supabase AFAIK