The One We've All Been Sleeping On (probably)

Рет қаралды 24,523

11 ай бұрын

Supabase is a full Backend as a Service platform that until now I never really tried/took seriously. I always thought it was a weaker firebase, but I was VERY wrong.
EXAMPLE APP REPO: github.com/bmdavis419/encelad...
SUPABASE: supabase.com/database
my stuff
twitter: / benjamin41902
insiderviz: www.insiderviz.com/
#Svelte #Supabase #WebDev

Пікірлер: 110

@abhiramsatpute 11 ай бұрын

You have the skill to provide the best summarization as well as elaboration videos ! Cheers

@rtql8d 11 ай бұрын

I've built a couple of projects with it and agree with all points. The fact that you can move your DB out whenever you want is an awesome bonus.

@lukeweston1234 11 ай бұрын

I’m really enjoying it, only learning curve is getting better with stored procedures and row level security

@laptopuser5198 11 ай бұрын

This video was in my recommendations, I'm now subbed

@r-i-ch 11 ай бұрын

Looking forward to the full deep-dive! (crosses fingers for a Svelte UI)

@supirman 8 ай бұрын

I'be built a few commercial products with it. Overall its pretty awesome, saves me a ton of time. There are some things you end up having to work around that a regular server backend would make easier, but overall its been great for me.

@JohnMcclaned 11 ай бұрын

Can you please make a video using the ts-rest library? It looks awesome but there is no content on it! Thanks :)

@mmzzzmeemee 11 ай бұрын

sweet! i'm definitely interested in drizzle + supabase

@fdimb 11 ай бұрын

Hi Ben! Thanks for testing all those stacks and frameworks on your videos. Right now which stack do you think gives you the best trade between performance, developer experience and features? I've been trying to give Nuxt a go because of the devx and features but I've ended up using Solid-Start on my personal projects lately. Probably because it has more similarities with React which is what I can use at work when I need to do full-stack or client side apps, but I always wonder if I'd end up with a better, faster and cleaner experience with Vue (Nuxt) or Svelte, although I love the component approach of React/Solid with Tailwind/Uno as native HTML/CSS feels dated sometimes

$@bradyfractal6653$

@bradyfractal6653 11 ай бұрын

Svelte is the best by far.

@bmdavis419 11 ай бұрын

This is the million dollar question I'm working to answer (still don't have the answer sadly), but I think pound for pound I would say any any js meta framework (next, nuxt, sveltekit, solid start, etc), edge runtime, planetscale serverless, drizzle orm, custom auth, vercel hosting, although supabase might end up being really compelling depending on how it feels in production

@fdimb 11 ай бұрын

@@bradyfractal6653 I don't disagree, although I'm not sure which approach I prefer.

@fdimb 11 ай бұрын

@@bmdavis419 thank you for the reply! I don't think there's a single answer as it greatly depends on the approach you feel most productive with, it feels so good to find a stack where you can focus on being productive without much sacrifices

@abhiramsatpute 8 ай бұрын

@@bmdavis419 wouldn't you want custom auth to be handled by clerk or kinde into the nextauth as well ?

@nuttbaked 11 ай бұрын

🙏 need a sveltekit + supabase + drizzle setup/tutorial video

@armant11 4 ай бұрын

With lucia v3 maybe?

@arvindrao8240 9 ай бұрын

Been using supabase as my remote db with nextjs with prisma as the ORM for my side project. Liking it so far. Do you think 500 mb of database space of their free tier is pretty much sufficient?

@perc-ai 11 ай бұрын

lets gooooooooo

@poorpotato4467 11 ай бұрын

thoughts on pocketbase vs supabase? seems like supabase might have more features, and I like the easy raw SQL for table definitions (pocketbase has a JSON schema).

@bmdavis419 11 ай бұрын

Yea I think supabase is better. Way more features, way more power, and a full platform/company supporting it (and sql >>>)

@tcurdt 11 ай бұрын

I guess the main appeal of pocketbase is that it is so much more lightweight.

@killerpredater1 11 ай бұрын

How is the performance on server less function? I’ve ran into issues with getting slow response time with my queries even with pgbouner in the past.

@bmdavis419 11 ай бұрын

Its been good in my testing, but cold starts are a thing, sadly not able to do edge runtime for our serverside code

@yatinm9250 7 ай бұрын

The response time of Supabase is too slow and the cache support isn't there yet which can be very good with traditional backends.

@hectorcast943 11 ай бұрын

Hey bro, I need some advise, am using GOLANG In the backend and next js as the frontend. Am Using GOLANG jwt auth, and based on that, I used sessions in the frontend. Is that okay?

@bmdavis419 11 ай бұрын

Yep thats pretty much what I did in the golang + sveltekit auth video

@mcchikin2751 7 ай бұрын

Nice content brother

@nikhil182 11 ай бұрын

Hey man! Love the videos you make, btw do you have a discord channel? It's high time you make one if not.

@0x6po 11 ай бұрын

Finally

@Mindflays_ 11 ай бұрын

I’d like to hear your thoughts on drizzle bs prisma, I’ve been using prisma but have heard good things about drizzle

@bmdavis419 11 ай бұрын

Currently the big difference is that drizzle works easily on the edge, prisma does not and its much heavier, although I still really like it, definitely gonna make some sort of "its hard to let go of prisma" video soon

@khalilbessaad5553 11 ай бұрын

I have 2 questions: 1. What's the benefit of running supabase locally rather than using their cloud service? 2. Why use drizzle rather than just the supabase SDK?

@isaacfink123 11 ай бұрын

Not the creator but I used supabase a ton 1. Running locally allows you to test and debug a lot faster, especially with migrations 2. Drizzle is better then supabase cli for a few reason, it doesn't have the postgrest restrictions so you can do complicated nested queries and inserts, it also has much better typescript support, but it doesn't support supabase's rls so you'll need to manage authorization on your own

@khalilbessaad5553 11 ай бұрын

@@isaacfink123 thank you for the response. So Drizzle for the db operations and you'd keep supabase sdks for auth related stuff?

@bmdavis419 11 ай бұрын

That’s how I’m doing it yep

@khalilbessaad5553 11 ай бұрын

@@bmdavis419 cool approach! I'll be sure to try it out

@andrew121410 11 ай бұрын

Appwrite?

@blackdash225 2 ай бұрын

supabase is goated

@ohsnoot 11 ай бұрын

Is this supabase self-hosted? How hard was it to set up

@bmdavis419 11 ай бұрын

This is actually local, I will be deploying to supabase's service

@ooijaz6063 11 ай бұрын

Unfortunately supabase is known for being hard to setup locally, there are no available one-click installers which will give you fully featured supabase instances, there are docs about the setup steps, but they require good knowledge of each supabase component and architecture.

@dandogamer 11 ай бұрын

I've never tried to self host supabase but I've heard similar stories of it being hard to setup and require a decent amount of cpu and memory to do so

@ohsnoot 11 ай бұрын

Same here, github issues is filled with complaints about it

@ashimov1970 11 ай бұрын

What's your take on Neon, Convex, and Pocketbase vs SQLite?

@Kats0unam1 11 ай бұрын

Why not test them yourself ?

@bmdavis419 11 ай бұрын

Planet scale and neon are both very compelling options as they serve as git for your database which I love

@ashimov1970 11 ай бұрын

@@Kats0unam1I have no clue about testing that stuff, about how that job is supposed to be done

@ishaanmalhotra3008 11 ай бұрын

So this is way quicker and easier than writing a backend in go

@Kats0unam1 11 ай бұрын

Its not comparable tho.

@jenny2814. 11 ай бұрын

you really think you can write a backend in go that works? XD

@Kats0unam1 11 ай бұрын

@@jenny2814. My Go backend works... are you drunk?

@jenny2814. 11 ай бұрын

@@Kats0unam1 yeah it works because nobody uses it

@Kats0unam1 11 ай бұрын

@@jenny2814. what ? You do know the entire cloud infra is built with Go right ? Docker, Kubernetes. Netflix has services running Go. Dude seriously, stfu. lmao

@GulshanurRahman 11 ай бұрын

Hi, what is the font on your vscode?

@bmdavis419 11 ай бұрын

Jet brains nerd font mono

@bingchilling9942 11 ай бұрын

but how does it scale? i have heard that doesn't scale very well, i mean its built on top of typescript and not something like go(pocketbase)

@bmdavis419 11 ай бұрын

It is very much "just postgres", most things are capped in scale by their data layer and postgres scales plenty for me lol, like if I get to the point where postgres is not scaling enough then I have a MASSIVE, very successful app

@bhumit070 11 ай бұрын

pocketbase wont scale as well due to sqlite

@abdirahmann 11 ай бұрын

@@bmdavis419This is VERY TRUE cause soo many devs are stuck with scaling scaling scaling... what are you scaling if you don't have any users eh?? 🤷‍♂️ and by the time the need to scale comes around, you have an actual reason that will justify hiring specialists to handle the scaling!

@tonyhart2744 11 ай бұрын

@@abdirahmann true, if you have problem with scaling then you wouldnt use supabase in the first place its unreasonable when JS dev talk about scaling on their app

@dandogamer 11 ай бұрын

@@bhumit070 you can use livestream or marmot to scale out. Litefs cloud handles this for you if you dont fancy setting it up yourself. But even without this sqlite scales enough for most startups

@edwardspresume 11 ай бұрын

How would you compare Supabase vs Planetscale?

@bmdavis419 11 ай бұрын

I can’t give a full honest take yet, these are my first impressions and I’ve yet to use it in prod, once I do there will definitely be a video!

@edwardspresume 10 ай бұрын

@@bmdavis419 Ok, appreciate what you do!

@wisdomelue 11 ай бұрын

same here😂

@breezycodes 11 ай бұрын

Bro, a lot of ppl make dall-e wrappers and call it a startup 🤣😂🤣 I guess this is my sign to give supabase a try. Have you ever tried Strapi?

@bmdavis419 11 ай бұрын

I’ve never done any serious work with a headless cms before so no, although I hope to in the future

@breezycodes 11 ай бұрын

@bmdavis419 give it a try, you will be glad you did. After I learned how to customize it and create custom endpoints and logic, I find it hard to create my own backend from scratch again lol

@grechuli 11 ай бұрын

I also like nHost. Imo it's a notch above Supabase. It's basically Hasura with file storage, auth, real-time, rest api, graphql, serverless functions. It also uses Postgres, has automatic migrations, local environment working with Docker (WSL mandatory if on Windows).

@skateboarderlucc 11 ай бұрын

what is the community like? I feel like these all-in-ones sound great, but you eventually encounter bugs that usually lead you to a github issue :( Such was the case with Appwrite.

@perc-ai 11 ай бұрын

what is the name of this stack bro

@bmdavis419 11 ай бұрын

I am terrible at naming things, right now its just sveltekit + supabase lol

@doogilie3814 11 ай бұрын

fireship calls it the sukit stack 🤓

@anon3118 11 ай бұрын

Supakit

@perc-ai 11 ай бұрын

@@bmdavis419 supakit i like that lol

@michaelai8274 11 ай бұрын

@@anon3118 cool

@zacharymontgomery9328 11 ай бұрын

Wait, it's all postgres? Always has been.

@bmdavis419 11 ай бұрын

Indeed.

@awakenwithoutcoffee 4 ай бұрын

Supabase vs Convex ?

@faeancestor 11 ай бұрын

is it true that you are a genius?

@bmdavis419 11 ай бұрын

It is in fact not true, although I wish it was lol

@seanknowles9985 11 ай бұрын

Does it offer offline sync?

@TheYeti 11 ай бұрын

excited for deep dive but u gotta get some sleep bro

@bmdavis419 11 ай бұрын

I mean, yea lol

@abhiramsatpute 11 ай бұрын

I was also concerned about the dark circles, he's the real batman for us hehe

@Michael-Martell 11 ай бұрын

Supabase has Authentication? … 🧐🤨

@Scuffy 9 ай бұрын

Does it have hosting like firebase, I can only find it says self hosting for supabase but firebase it actually hosts it for me.

@bmdavis419 8 ай бұрын

Nah supabase has its entire thing available in a hosted product, it works great I highly recommend

@seanknowles9985 11 ай бұрын

500 realtime connections only.....

@bmdavis419 11 ай бұрын

Then $10 per thousand, which is definitely not cheap but it’s a pretty painful thing to implement yourself so for a startup optimizing for speed it’s pretty compelling

@seanknowles9985 11 ай бұрын

@@bmdavis419 at the moment, Deno and convex are my shouts for startup MVP work. Deno deploy and PWA with convex on the backend.

@greendsnow 11 ай бұрын

You're still wrong. it's much slower than pocketbase SQLite. 32gb ram can handle 400rps with supabase

@nicolaichristensen6531 11 ай бұрын

Very rarely will the choice ever be SQLite? How in the world do you want to scale SQLite? There's also a reason it's "lite", it's not got the same features as something like Postgres.

@TheStruders 11 ай бұрын

@@nicolaichristensen6531sqlite scales extremely well... who cares if the name is "lite", that is a terrible reason to avoid it

@animeshsingh4290 11 ай бұрын

@@TheStrudersNo it does not buddy

@greendsnow 10 ай бұрын

@@nicolaichristensen6531 When the time comes you can copy your database to PlanetScale and figure out your ways to establish security, auth, email sending and file uploads along with it...

@greendsnow 10 ай бұрын

Also like 4GB RAM is enough to serve 500K users and 10_000 concurrent database subscriptions with Pocketbase + Sqlite... And that's before you upgrade to the next larger machine.