i am breaking up with supabase - for now

In this video I am going to show you how to talk about my experienced of using supabase for the past 2 years.

Support the channel : 🙏🌸

Follow me:   👇

[DailyWebCoding]

By the way, I’m still using Supabase for my current project with my team, but we're transitioning to Drizzle instead. So our current stack includes: Next.js, Supabase (for PostgreSQL and auth), and Drizzle ORM

[wrongturn_w]

So no database?
I really think we should normalize knowing multiple languages. Developers should be comfortable switching between code bases.

[levato]

I really like using Supabase with Drizzle in my project. Drizzle also introduced recently working with RLS policies, which I haven't looked at yet but sounds like a solution.

[adriandev]

Yeah, I straight up started with drizzle setup, but drizzle has it's own issues with supabase, they have docs about rls, but they don't mention the issues there

[amerrashed]

I think using supabase for auth is still the best option. For database, i'm using drizzle orm with postgresql, either Neon or supabase.

[Spielberg]

I’m using drizzle and supabase for auth.

Also drizzle supports RLS now so it is the best of both worlds. It is fast aswelll

[thegame]

What would you replace the auth part of Supabase with, if you switch to Drizzle?

[XmNfwvhhDeLCja]

Personally I am moving away. As long as you are using SSR supabase may be enough but if you need complex auth logic it becomes a nightmare. The only way to secure ressources is to use RLS, which are executed on every row… What a nightmare when you want to build a scalable system. They suggest building logic into the DB but this is not a good idea as it makes the whole system harder to maintain in the long run. Even their pooler is a bit laggy. I finally built my own .NET api and created my own pooler, deactivating theirs. Th last but I need to handle is my auth server and then I’ll be free to book an RDS instance for half the price and way better performances as it will be in the same VPC as my api.

[calvincrane]

Thanks for the video, maybe use a code editor for videos as it was frustrating to watch. I'm not complaining just saying I would have preferred that. Ask your subscribers by poll?

[werix_]

But what's the solution? I am curious... I use it similar ... so same problem lol

[mahmoudalkateb]

Also i have noticed that if the query becomes really heavy supabase client will stop the query, and you would have to pump up Compute size.

[businessoftechnology]

You say you are leaving, but you don't say what solution solves your problems. Every solution tends to have tradeoffs. You mentioned some for your team, but hearing a complaint session without a pivot solution was disappointing.

P.S. I agree that choosing Supabase isn't all advantages.

[kalilbarry]

Personally, in a world where AI exists, it doesn’t bother me. Let’s say I’m working in your team, I can just paste your SQL code into an LLM and ask for an explanation.

Also in my case, I mostly use RPC for transactions and it’s ok

[gerald_at]

You could write a edge function to do the 2 inserts

[devfren]

I kind of like writing the plpsql functions because it makes it easy to create new frontends. Eg i have a next app but I made a discord bot in python and they’re both using the same rpc

[TimTan]

Just use normal postgres and a node server with knex to communicate with it, all ur logic lives in the server

[inyourfacerockon]

better to use typeorm, it works well with ts, maybe this issue arises only because you are working with your team. But supabase suits best if working on a solo project.

[maskman]

So what is your second favorite db? firebase? appwrite? mongodb?

[david.walters]

What are your thoughts on Firebase? Why not use it?

[nextcontentxyz]

supabase client is not great with databases, instead using any other orm like drizzle and prisma.