Phenomenal post. Thank you Cody! Always providing relevant and insightful content

Hey, thanks for this video, has helped me understand convex more. I’ve ran into some of the issues you’ve pointed out with supabase, going to try out convex now 🙏

Thanks for going in such details man! Much appreciated!

Thanks for the video! I've been using Supabase for work over the past 6 months. You can generate types based on your schema using the Supabase CLI and pass it as a type arg when using the SDK to provide type safety. I've enjoyed using it, but I'm interested in trying Convex for a personal project.

Greatly explained each aspects from both!

loving these comparison videos :)

This video dropped at just the right time - I'm a Supabase user but have been watching your videos using Convex with Clerk and I'm torn between the two. I only want to choose 1 of them going forward so this video could help!

Great introspection. Thanks for your unfiltered review :)

Great video , a very thorough comparison. Convex looks really good and they should continue to work with content creators because they are the first resource folk use to learn a new tech and you have some excellent examples. Btw I use Supabase because of their auth and Postgress support. Attended their launch weekend where their cofounder talked about their auth service .

Thank you for this video! I may give convex a try and see how it goes. I've been trying to use supabase for a side project but have run into a lot of the pitfalls mentioned in this video.

I attended a coding bootcamp and we used Supabase for the first couple months… It allowed us to get feel for backend development so when we continued on to learning Express and PostgreSQL, we were more familiar with the concepts (Tables, Joins, SQL, Auth, RLS, etc). I think it’s the perfect tool when you’re learning or just want to get an app up and running.

You are a machine bruh, great vid!

great video again!

Interesting. First time hearing about Convex

Something I've always wondered is how well these scale and if they're suitable for projects beyond a SaaS? If I'm not mistaken, most, if not all, BaaS are just wrappers around AWS? I get that the DX is the main selling point of them, but what is the tradeoff from using these all in one backend solutions versus building up your own infrastructure via AWS? I mean the function calls on convex are $2 per million versus $0.2 per million on AWS lamda (or $0.60 per million for edge). That's a 10x markup! Btw great video on the comparison. Love your vids as always. This was just something I've always been curious about.

Thanks for this video

Going to give convex another shot after watching this. I'm a supabase fan but you've articulated my fusturations over some of the things like rpc very well. Convex for me is a slight learning curve and I really wish there was more guides and tutorials and tutorials that are not 3 hours long going over it.

man I love tech so much!

Cody please tell me what you use for the flowcharts, do you use a graphics tablet? Or normal mouse? You have strong eraserio skills lol

Thoughts on pricing between both services?

With Convex they only host it right? Like there's no way to actually own your app/platform/data like is at least possible with Supabase (and with other BaaS)?

I always wanted to like Supabase. I do like a few things, but I have always felt friction. Will give Convex a go, thanks!

Does convex Have support for Svelte,Vue ? you should have included front end Framework support in the comparison. Convex is only focused on react on the frontend

Really nice video! :D Have you compared price scaling for Convex + Clerk compared to Supabase? Another question, is there something you have found in Convex that Supabase is completely missing or vice versa? (other than Auth missing within Convex)

with supabase, we can connect to postgresql with third party data analyst and follow everything we want. And in convex? How to connect with other data analyst tools?

In terms of schema, you can do it all in code with supabase too, you have both options. You actually don't have to use the ui at all.

i am having a seperate backend that used for generating ai response. How can i use convex to make an api request to my be endpoints. Thank you

You should switch the icons in the thumbnail, the heaviest side should be the best, in this case, convex. Very important information

no pricing on the list?

Hello can you create a video how you handle stripe taxes across 200+ countries?

nice video, im curious what you think appwrite?

This was super useful. Thanks so much Cody. Definitely switching to Convex as a default BaaS

we use drizzle orm with postgresql database which gives best developer experience.

Hi junior dev here, do you mind showing how to host convex in the cloud or a server now that its open source

I love you babe! You’re doing great!!!

Could the recompilation of convex be a problem if I don't have a performant laptop?

1. Can I create a database that is linked to the respective users with Convex? 2. I have created a schema that references the user and then creates a table with sunbeds based on the `tokenIdentifier`. At least that's the plan. It is not working yet.

definitely type safety and atomicity are two reasons why I would pick convex without hesitation I've been using convex for some time and I like it I got a bit sidetracked by actions and mutations distinctions. The docs tell you to use mutations as much as possible and schedule actions from the mutations. But I noticed that in practice what you want by default is to call an action directly from the frontend, for, say, calling a 3rd party and then writing the response in the DB and show a loading state while this happens

Would it be possible to compare convex with appwrite ? And how they compare in terms of the cloud functions

I think convex could very much be that sweet spot between when you manage everything yourself, databases authentication... And low code where you don't have to write code really, I'm not sure it just feels like that to me

In wonder if you ever tried firebase. I am curious what your thoughts are.

What about firebase?

You notice much in terms of performance between them? I've used Supabase, and there was a lot of situations where performance was a problem.

cody, i very much disagree with you on the security (authorization) part, here's why... 1. When figuring out whether a user is allowed to *read* a row or *write* to a table, him getting the permission depends on what state/data they have in the DB, for example, say you want a user to not be able to create a shop if he's not verified, you can write an RLS policy to deny him *write* access to that table if he doesn't meet the requirements, compare that to having authz rules on the application layer, you'll have to make a network req to get the appropriate data in-order to evaluate the conditions on the server, this add more latency!!! 2. i believe separating authz rules from business logic gives you better security because you don't have to worry about having to write a bunch of *WHERE* clauses in order to protect the data, it add too much fluff on the actual SQL that deals with business logic, this problem become bigger once you have a sizable team where all devs have to simultaneously think of authz and business logic EVERYTIME!!!, that's crazy talk!!! Have a good one

Hi. I am an aspiring web developer. I am building projects in nodejs with express, mongodb and vite- react. I’m not a fan of nextjs. However I’ve seen you have plenty videos with tech, not only using nextjs. Do you have a video presenting tech stacks of js in 2024? I mean I want to be focused on ts, node, react.

Did you try using a server actions to call a Supabase. Basically you define all functions in actions.ts file or what ever and use them to call supabase from server components, kid of similar seperation of concerns ))

Im the only one here thinking memerank has a great potential?

regarding vendor lock-in, I think convex was just open-sourced today (like 4 hours ago), I think convex is pretty cool, however, I'd still prefer Postgres over convex's custom db, but that's only because I've used Postgres for almost all my professional career, and I think the Postgres is literally the best db available.

In the first 5 minutes I was already sold on convex

Convex is incredible. Makes it stupid easy to create apps.

23:20 Haha yes that is how i feel right now. Got sucked into Supabase because of how easy auth is, and the simple premade client for next/react, but then hit some big walls as I tried to create some user roles. I am deep in postgres rabbitholes right now, which is exactly what i was initially trying to avoid. Oops.

I agree, learning curve is crazy, but I prefer "database lockin" over "vendor lockin" as well as, Auth in supabase is sweet! Supabase is more battle tested. I am starting a project, I decided to go with supabase... Maybe next time I will do convex. But your content seems like it will shift towards convex :(

I think Supabase being "just Postgres" is potentially a pro or a con depending on how you look at it. The trade off of it being something you might have to learn is that if you ever want to migrate from Supabase it'll be much easier, since you can deploy/host Postgres pretty much anywhere. Not sure you'd get the same benefits with Convex Also, I feel like Postgres is pretty much a "figured out" system. I know that whatever I'd need to do I can more easily find a solution through pg extensions or even ChatGPT. Probably not the case with Convex (as much)

Do you have a MS in CS?

Convex seems awesome. I hate supabase. When I started a new job at a startup where the juniors that I took over from had supabase queries straight in reaction components, the first thing I did was to take all of that out and wrap Prisma around a standard db string to supabase until the we eventually migrated the db itself to RDS, but had I known about Convex back then I would probably switch to that. For permissions (authZ) I use casl. It has a plugin for Prisma. I'll see if I can write a Convex plugin but even without that it's fairly straightforward to use it out the box

You missed probably one of the most important points of interest. Pricing. Which is more cost effective and at scale...

Supabase + Prisma or Drizzle solves most of the issues

Something I think you didn't mention is that you can't really write complex queries with the Supabase "ORM". You can't do a left join or a simple join between two tables that don't share a foreign key. I started a project with Supa and was pretty disappointed that I had to jump to table views or functions the moment I needed more than a basic select

Convex looks super easy to use and sounds great but looking at thier investors the top of the list is Andreessen Horowitz and that dude is aspiring to Lex Luther levels of bad guy. Looks like he is also a key invesor in Clerk too. I'll stick with Supabase 😁

One thing you missed is that you can't self host convex at this point. While supabase does provied self hosting through the docker image but it's not that good as compared to their service.

because convex cuts me a check

Cuz It’s simple Convex is the sponsor of the this video 😂

This honestly just seems way too convoluted, I'd rather stick with a traditional API backend and call endpoints in my frontend

Strapi never being included as an option in comparisons like these makes me think they will sooner or later go bankrupt😅

Front end devs will do anything to avoid learning a real backend language

Supabase all day