@@scott_itall8638 No just pay for a VPS and host all your project there. It’s a lot cheaper when you have a gazzilion amount of side projects. Spin up whatever services, database you need. If you need more compute scale up vertically. Easy
@tedspens6 ай бұрын
Thanks, Ben. This is the comparison I need. Like your project, what i'm working on also calls for a relational db and, ideally, will need to scale very large very quickly. In fact I'm considering dishing out the $40 a month for planet scale for just that reason. I'm not familiar with Turso and not sure I'd feel comfortable trusting the scalability without a proven track record.
@bmdavis4196 ай бұрын
Yea its a really tough call, I love new tech, but the DB is a scary ass place to have new tech idk we will see
@dandogamer6 ай бұрын
Define the scale you need and what do you mean by really quickly?
@tedspens6 ай бұрын
@@dandogamer There are no hard numbers or timelines, only that if successful, it will require massive resources.
@vicentealmeida13366 ай бұрын
The founders have a very solid track record, plus they are now working with some big clients. But yes nothing proven yet.
@nro3376 ай бұрын
Great video, really important that it ultimately comes down to one's use case.
@MattHeslington6 ай бұрын
13:06 You should have perhaps started with this. You're basically talking about which brands you like if all you need a database for is to put stuff in tables in SQL. There are significant differences between SQlite, MySQL and Postgres if your databse needs go a little bit beyond that.And while MongoDB is called non-relational as it is NoSQL, it's extremely easy to write relational-style queries with it using Mongoose.
@tomreisinger38366 ай бұрын
Have you already taken a look at Neon DB?
@devyb-cc6 ай бұрын
Also, with the AI hype makes it a lot harder to choose one, for seamless integration with embeddings. Sooo many choices (like frontend frameworks 💁)
@bmdavis4196 ай бұрын
facts
@sabin4546 ай бұрын
amazing video
@chizidotdev6 ай бұрын
Saw the title and my brain instantly screamed PostgreSQL. Edit: Title is a bit incomplete… Should be “Picking a Database Provider is hard”
@ustav_o5 ай бұрын
i like turso bc its fast and its free plan its rlly good
@rahulagarwal9686 ай бұрын
When using Planetscale, how to connect it with Flutter and How can I implement Auth and Storage ? Since I am new to Flutter and have only used Firebase and Supabase.
@zBrain06 ай бұрын
I see a couple of comments about the thumbnail but nobody has mentioned the fact that you put Excel on there. Well played LOL I watched the entire video just to see if you actually tried to make an argument for that.
@bmdavis4196 ай бұрын
Excel is there because it’s the best database, which requires no explanation
@itsResists6 ай бұрын
Any opinions on Railway for using MySQL or postgreSQL?
@bmdavis4196 ай бұрын
it works great, but it lacks a lot of the features these other providers have and requires you do more work yourself. Great for dev, but in prod that gets dicey
@vatsalyavigyaverma54946 ай бұрын
@@bmdavis419 yes that's my huddle tbf, like I can do horizontal pod autoscaling for astro/svelte/nextjs in kubernetes but for database i am still noob
@bmdavis4196 ай бұрын
@@vatsalyavigyaverma5494 same and that is EXACTLY why I use a provider, DB is the one piece that cannot break period, I don't want to risk that
@lcarv206 ай бұрын
Firestore in the thumbnail as a trap hein? XD
@bmdavis4196 ай бұрын
just take everything I said about mongoDB and replace the word MongoDB with Firestore, and its the same thing lol
@martg06 ай бұрын
What about DynamoDB?
@lardosian6 ай бұрын
AWS is pain in his words so you can rule that one out!
@loek86386 ай бұрын
excel is goat
@ouss6 ай бұрын
Convex is the future
@Cruzylife6 ай бұрын
serverless is not soy dev...fast and easy to ship
@bmdavis4196 ай бұрын
agreed, its just the current thing people are mad about lol, VPSs are trendy
@SadeghMirzaee-fd8lg6 ай бұрын
(Irrelevant again but actually relevant) Happy to see that your posture, body language and even your facial expressions improved so much. :) good job buddy. 👍
@laztheripper6 ай бұрын
It isn't hard because the only good choice is postgres :)
@cotyhamilton6 ай бұрын
It’s me, I’m the one who shits on mongodb
@abdirahmann6 ай бұрын
Ben i'll make life easy for you, just use postgres with supabase, you'll never go wrong, but don't use the supabase API, its a trap, they over-promise and under-deliver. You can't run transactions using their API, once you get away from tiny TO-DO apps, it just falls apart, but i like their auth ngl, Postgres is SOLID and the supabase dashboard is a nice addon.
@zBrain06 ай бұрын
I am currently building out a project using supabase and your comment intrigues me. As far as I can tell the way to create a transaction like operation would probably be to create an endpoint out of a stored procedure. Alternatively, for things that do require a transaction I suppose I could use a sveltekit endpoint and have a backup plan like drizzle available. Curious what you are using for an API back end? Appreciate any feedback.
@abdirahmann6 ай бұрын
@@zBrain0 Please just save yourself some headache, DON'T write postgres functions to call over rpc, I'll tell you why: 1. They are SUPER HARD to debug 2. How are you going to do input validation, you'll have to write a bunch of IF statements in PG which are ugly and HUGE AF!, you might say... well use pg_jsonschema, i hear you but the community arround it is small and docs are pathetic! 3. The worst DX imaginable!, no autocomplete, no nothing, its like writing regular text! HORRIBLE 4. Having a ton of business logic in Postgres will slowly make your RLS rules Huge and very unoptimized!, you slowly find yourself writing business logic in RLS rules! 5. Your codebase will be disjointed, some logic in pg functions and others in JS, you'll be miserable! Just write all your API in a normal backend, am not just saying this, I've gone through this horror of rewriting my entire app to have a proper backend and if you ever spent time in github issues, you'll quickly see the frustration of devs. Simple feature requests take forever to be implemented by supabase! Its insane, one of the features, "transactions in supabase" has been open for 5 years, they haven't fixed it since they launched, CRAZY!! SUPABASE Storage is also somewhat bad because they don't maintain it very well, its a light wrapper on S3 and the storage server has inconsistent responses, this has also been an issue for ages but they just don't care, they'll rather invest in flashy AI nonsense than fix a trivial bug in their backlog! I really wish they did better than this, when i discovered supabase, i was sold, but then reality hit me 💀💀. Their dashboards are great though and auth is good! anyways take care 😃👍
@abdirahmann6 ай бұрын
@@zBrain0 i made a very detailed and really good reply but KZbin decided to remove it for some odd reason, maybe it was a very huge comment! tldr, you'll be having a nightmare writing rpc functions, not debuggable and they are just awful, spend time in suapabse github issues and you'll see what am talking about!
@abdirahmann6 ай бұрын
@@zBrain0 youtube just keeps deleting my replies, idk what to tell ya!
@bmdavis4196 ай бұрын
honestly I agree, I've said before that IMO supabase is just postgres, with awesome open source tools built on top (dashboard, auth, storage, etc.) the client API library is rough tho
@drewbird876 ай бұрын
Have you met Convex?
@SonAyoD6 ай бұрын
I have!
@vatsalyavigyaverma54946 ай бұрын
Why not postgres? Like I host everything and never develop for big companies so I use MySQL or postgres
@bmdavis4196 ай бұрын
Supabase is how I would use postgres
@yunyang62676 ай бұрын
Ben in 2030: Next.js or Svelte? Planetscale or Turso? NextAuth or Lucia?
@user-qq7yc1qp8z6 ай бұрын
For personal staff I use supabase, for clients we use postgress on AWS RDS in the company.
@iriel492ki6 ай бұрын
DynamoDB is 100% slept on. Spend a little time learning how to model for it and you can build out some tremendously complex apps. Yeah, it's not going to get you super strong relationships like a relational DB, but the fact that it is absurdly cheap, scales to zero, and remains hyper performant at insanely high scale makes it one of the top choices for indie hackers and start ups imo. Source: I have a side project that generates almost 1k MRR built on appsync, lambda, and dynamodb and it costs me literally less than $2 a month. And I'll never have to worry about scaling in/out a db while always having ultra performance. It's full auto pilot and I love it.
@kylerjohnson9886 ай бұрын
I hate AWS, but I have to admit you make some good points. How do you get a total count of records? Do you create an aggregate document and update counts on add/delete operations?
@iriel492ki6 ай бұрын
@@kylerjohnson988 That's exactly how I've done it at my job. If you have a low write frequency you can just directly update that counter. Alternatively, if you expect a lot of writes/updates you can always use a dynamo stream and have a lambda manage that counter async.
@robgreene37456 ай бұрын
@@kylerjohnson988you don't
@user-qq7yc1qp8z6 ай бұрын
@@kylerjohnson988why you hate aws ? It’s the best cloud provider rn.
@joseph0x456 ай бұрын
I came here to complain about not seeing Postgres on the thumbnail
@MarkVergelBanguis6 ай бұрын
For me its always Mongo or Postgre
@ThannMalin6 ай бұрын
There is no wrong with Firebase
@averstrum63726 ай бұрын
Excel on the thumbnail of this vid?
@bmdavis4196 ай бұрын
B/c it’s the best database
@r-i-ch6 ай бұрын
Thanks for the rundown!
@labhamjain39156 ай бұрын
For me it was pretty clear I'll use localhosted pg 😂
@Ramnathk6 ай бұрын
Any reason u did not consider Fauna or Surreal DB that look like a good fit for your social app?
@bmdavis4196 ай бұрын
Too new and I'm a SQL guy
@vicentealmeida13366 ай бұрын
What you think of some hybrid database stack here, is it absurd to use supabase and turso together. Using supabase features, like auth, webhooks... to interact with turso database. Supabase free tier has quite a small storage space for the database, combining somehow with turso big storage capacity could be interesting.
@gie48306 ай бұрын
I'm also thinking of going with this. I'm currently still using supabase auth and db but planning on switching. After reading the drizzle orm, it looks like an easy migrate. The last thing I'm still considering is how is tursos libsql at larger scale and how long will the current pricing stay low like this.
@vicentealmeida13366 ай бұрын
Also you could keep supabase storage for frequent writen data, like a usersession that stays in supabase while the session is active. If the user logs out or session expires move it to Turso, get it again once the user logs in again. It seems to be a way to navigate the free tier and keeping the strength of each service. Also supabase doesn't seem to have a limit on data. @@gie4830
@hakuna_matata_hakuna6 ай бұрын
how are you still shilling those rug pullers , if you're building a social site a graph db is the way to go anyways
@FredT346 ай бұрын
You Should Try EdgeDB Seriously !!
@abdirahmann6 ай бұрын
is this even a real db? 🤣🤣🤣💀
@MattHeslington6 ай бұрын
As soon as the free cloud tier becomes available, I can see edgedb being a serious contender. Really powerful data structures and querying and built-in auth
@MattHeslington6 ай бұрын
No Geospatial data querying though
@naga_sg6 ай бұрын
first
@tedspens6 ай бұрын
First reply!
@ashimov19706 ай бұрын
Why no consideration given to Xata? It's definitely the best of the best nowadays
@bmdavis4196 ай бұрын
I don't have any experience with it, its on the (long) list of stuff I want to try
@PTBKoo6 ай бұрын
I’ve been testing xata and moving data over from planetscale and drizzle just released a xata connector. One of the reasons I chose xata is they have the best free tier (15gb with no limits on reads and writes). They use aws aurora pg under the hood and it seems good so far but who know how long this free tier will last as it seems to good to be true.