Benchmarking Databases on Vercel | Prime Reacts

  Рет қаралды 44,870

ThePrimeTime

ThePrimeTime

Жыл бұрын

Recorded live on twitch, GET IN
/ theprimeagen
MY MAIN YT CHANNEL: Has well edited engineering videos
/ theprimeagen
Discord
/ discord

Пікірлер: 80
@ThePrimeTimeagen
@ThePrimeTimeagen Жыл бұрын
i reached out to the author and he said he used only free tiers for this test. Hence the reason there is no planetscale replication as its not available in the free world.
@rumplstiltztinkerstein
@rumplstiltztinkerstein Жыл бұрын
When people mentioned the 't' in Toronto, you should have started saying "Oronto" instead xD
@cookie_doki
@cookie_doki Жыл бұрын
What about supabase replication? Supabase got destroyed here but it didn't look like they enabled replication.
@glommeryt
@glommeryt Жыл бұрын
​@Cookie note that all setups were provided by the database vendors themselves! (author here). This is not a benchmark where we set up other vendors, this is organized by Vercel and each vendor set up their own systems.
@Pscribbled
@Pscribbled Жыл бұрын
18:11 I looked at the docs and Turso is essentially a read only replica as well. The difference is for writes, you still use the edge as an endpoint but it sends the write over to the primary.
@ThePrimeTimeagen
@ThePrimeTimeagen Жыл бұрын
ok, that is pretty neet. but good to know.
@Pscribbled
@Pscribbled Жыл бұрын
Not sure how planet scale works but I guess the benefit or turso is that you can just write to the replica and call it a day. You can offload the slow request to the primary to turso. I’d be interested in how they keep their system fault tolerant so that they don’t drop writes if a node fails
@seannewell397
@seannewell397 Жыл бұрын
For optimistic updates I bet this would still slap (ie experiences like Linear)
@igorcastilhos
@igorcastilhos Жыл бұрын
Brazil mentioned! Yeahhh, come to Brazil Prime, we will give you some Pão de Queijo and Coxinha with caldo de cana. During the night time you will drink Cachaça💚💛💙
@TheGuigaboy
@TheGuigaboy Жыл бұрын
This is aewsome! As a software engenieer based in Brazil, we plan our applications to make as few requests as possible to anything in America and in many ocasions the latency is a deal breaker. Truely life changer lol
@TheGuigaboy
@TheGuigaboy Жыл бұрын
+ Turso website is the fastest one i visited in a looooong time
@glommeryt
@glommeryt Жыл бұрын
​@Tunema hey - author of the blog here. I was actually born and raised in Brazil, although by now my Portuguese sucks a bit! Glad to see you liked the website
@crazycoder9356
@crazycoder9356 Жыл бұрын
coé parça
@TheGuigaboy
@TheGuigaboy Жыл бұрын
@@crazycoder9356 doidera meu brod
@Craftidore
@Craftidore Жыл бұрын
Eager to see Prime turn back into his primary for of 'cat' (for context, the title at the time of watching is "Benchmarking Databases on Vercel | Prime Recats", in case Prime fixes it later)
@cam545
@cam545 Жыл бұрын
I came here to find hot databases in my area, not disappointed
@coreyalexbarker
@coreyalexbarker Жыл бұрын
The idea of having read replicas everywhere sounds great in theory, but replication lag can be a killer. Especially for those cases where you require your data be fresh everywhere and have to enforce sync writes (and sync replication). If your data can be a bit stale though, and use async replication, the more replicas the merrier.
@VuTuanIT
@VuTuanIT Жыл бұрын
If the data need to be fresh then you just need to read directly on the write connection. Does it work in this case?
@seannewell397
@seannewell397 Жыл бұрын
I question when this actually is important. Stock tickers? Your avg CRUD SaaS probably won't care even for up to a minute lag. >5min and we have problems tho for sure.
@stephanjacob17
@stephanjacob17 Жыл бұрын
Your pronunciation of Rio de Janeiro is suprisingly good
@Richetechguy
@Richetechguy Жыл бұрын
Great experience working with Turso so far, definitely suggest trying it out, def tried this out b/c of Prime.
@asdfssdfghgdfy5940
@asdfssdfghgdfy5940 Жыл бұрын
Watching this from Australia in 240p because of how bad the internet is
@Red-vi3xb
@Red-vi3xb Жыл бұрын
NGL prime your literally the Dr Dis of programmming,love that i came across your channel had fun learning and getting enterained these past few days
@draakisback
@draakisback 10 ай бұрын
Turso is interesting, they use raft consensus as far as I can tell to synchronize the various read state replicas across edges. On one of my previous projects, we combined raft with CRDTs to build a time series database and let me tell you, I wish this thing was not proprietary because I would absolutely be pushing it as the best distributed time series database out there. It just makes sense to do time series this way since you rarely are deleting or mutating data in a time series table. Anyway, I also wish that turso was open source.
@ThePrimeTimeagen
@ThePrimeTimeagen 10 ай бұрын
you can always ask Glauber on twitter. he is pretty open about a lot of the decisions they make
@draakisback
@draakisback 10 ай бұрын
@@ThePrimeTimeagen hmm, might be worth getting an actual Twitter account one of these days...
@dn5426
@dn5426 Жыл бұрын
marketing benchmarks always have some amount of bs in them.
@danielvaughn4551
@danielvaughn4551 Жыл бұрын
I'm super interested in Planetscale, though they don't support foreign keys and it just freaks me out lol. I've never used a db without fks.
@CARPB147
@CARPB147 9 ай бұрын
Even Oracle didn't support FKs until v8.x. From Oracle v4 through v7 it was a royal handicap not having them.
@Wolfeur
@Wolfeur Жыл бұрын
Remember, the name…is the Pruh-mEE-gen!
@nachovc
@nachovc Жыл бұрын
This is interesting because of the freemium perspective, but it doesn't bring fundamental shifts. I'm more interested in seeing how Cloudflare would do with their Distributed SQLite approach if they really get to make read/write replicas. At this moment, No-SQL alternatives like FaunaDB or CoakroachDB seems to be the ones actually breaking the molds with respect of edge data.
@personcalledjames
@personcalledjames Жыл бұрын
The benchmark should have been done with Planetscale's read replication turned on for it to be a fair comparison. I'd be very interested to see how that would affect the results.
@ThePrimeTimeagen
@ThePrimeTimeagen Жыл бұрын
yeah, the 1v1 results show a big difference as is but the read replication is a pay for feature only. i reached out to the author and he said he used only free tiers for this test.
@glommeryt
@glommeryt Жыл бұрын
Author here! The tool is provided by Vercel, not us, and each database contributed their own setups - including Planetscale. That said, this is not really a benchmark against Planestcale - they actually did fantastic ! You are right that with read replicas planetscale (and others) can achieve this, but there is a reason they - and others - didn't add replicas in this test. It's quite expensive! The advantage of Turso, that I tried to touch on the article, is how easy and cheap (the free tier alone already has 3 locations) is to set up replication. Great comment, though! ❤
@denissorn
@denissorn Жыл бұрын
Like Vuk Karadžić said: "Write as you speak and read as it is written."
@aztro8323
@aztro8323 Жыл бұрын
Prime recats
@SamualN
@SamualN Жыл бұрын
tiger beetle is real
@samuelschwager
@samuelschwager Жыл бұрын
I walked on a Pierre and watched some boats
@after_alec
@after_alec Жыл бұрын
Blazingly fast
@Dev-Siri
@Dev-Siri Жыл бұрын
YOU ARE GOING TO BRAZIL
@imyerf5382
@imyerf5382 Жыл бұрын
As a Helena,MT guy … I’m concerned
@cheebadigga4092
@cheebadigga4092 Жыл бұрын
it happens once every twice
@ardawanx
@ardawanx Жыл бұрын
12:20 @ThePrimeTime, could you pls make a video about what defines a really good engineer and how can achieve that level?
@maluraq
@maluraq Жыл бұрын
Canadians are just excited they got referenced at all
@Turalcar
@Turalcar 4 ай бұрын
7:18 You could go 1 step further and pronounce Detroit as De-true-ah
@TheStruders
@TheStruders Жыл бұрын
Is the added complexity of the edge and distributed systems worth the small performance gains? Maybe? Maybe not?
@willi1978
@willi1978 9 ай бұрын
or keep everything local, like in an android app
@CuevasGPablo16
@CuevasGPablo16 3 ай бұрын
Chile mentioned
@GMUStudentDesign
@GMUStudentDesign 2 ай бұрын
Anyone know of write speed graphs please?! Wouldn’t Turso writes be slower?!
@heroe1486
@heroe1486 Жыл бұрын
Why shouldn't you deploy at the edge ? Just read the pretty inconvenient cons on Vercel's own page ( + ignoring the fact that you have to write JS on the backend 😅)
@ThePrimeTimeagen
@ThePrimeTimeagen Жыл бұрын
Yeah the JavaScript thing kind of sucks
@jonasrothmann1536
@jonasrothmann1536 Жыл бұрын
Doesnt vercel edge use CF workers which supports rust?
@invinciblemode
@invinciblemode Жыл бұрын
Prime Recats 🐱
@SuRFaceGoD
@SuRFaceGoD Жыл бұрын
7:39 pure?
@hexnaught
@hexnaught Жыл бұрын
Wonder how this compares to Cockroach DBs offerings ?
@mjerez6029
@mjerez6029 10 ай бұрын
this guy is discovering that the water is wet... do we really need these kind of articles to state the obvious? apparently yes. There is CDN and and there is data-centers. Edge computing is a wicked concept. but apparently people need to spend millions before realize.
@caseyclayton01
@caseyclayton01 Жыл бұрын
I lived there for a couple of years and got dirty looks for pronouncing it as Pierre my first month. I liked living in Sioux Falls more, outside of the scars of being a Cobol dev the first year I was there and then Java, so not much better.
@ripple123
@ripple123 Жыл бұрын
RECATS
@zeyadkenawi8268
@zeyadkenawi8268 Жыл бұрын
won't that be very expensive? You literally have a database per edge + cross region costs are pretty high in the cloud so that will add another hidden cost just to get a couple of milleseconds.
@WhiteThunder121
@WhiteThunder121 Жыл бұрын
Why should I use Edge to access my database 😭
@zezkai7887
@zezkai7887 Жыл бұрын
Why don't you like C++? I know Rust is great and doesn't have hidden execution paths, but at least in C++, you can recover from Out of Memory errors. (Just to note, I really like Rust.)
@jonforhan9196
@jonforhan9196 Жыл бұрын
C++‘s share Pointers are thread safe by default meaning they have extra over head on construction because they are atomic. Rust has Rc and Arc for specific use case. Rust io and string manipulation is leagues ahead of C++. The compiler, build tools, packages and ecosystem are better. CMake is horrible, i build recursive globing smart CMake scripts with for loops macros function… it’s horrible. Cargo is a dream to work with. Again the dependency management is just better. And Rust is just plain more fun to write in
@DMSBrian24
@DMSBrian24 Жыл бұрын
Other than terrible ecosystem/toolchain, C++ is extremely hard to learn and extremely easy to cause some serious issues in without even realizing it. It's super feature-bloated and those features are not easily discoverable, a lot of the more modern changes are good but at this point it's almost impossible to know what's best practice, what you should do and what you should avoid, reading someone else's code can be hell even if you're already very proficient at it. There's less and less junior C++ jobs nowadays, because juniors are useless at writing C++, you're either very good at it or you're useless, or even potentially detrimental to the project if your mistakes go unnoticed. Since better alternatives exist nowadays, there's simply no reason to use it, and no reason for new devs to learn it.
@tsalVlog
@tsalVlog Жыл бұрын
JAY SAHN
@Rundik
@Rundik Жыл бұрын
Pretty misleading messages on their landung page. They put the text "Open source" at the top when it's not actually open source. Just some library they are using is open source and it's just a fork of sqlite
@jduartea
@jduartea Жыл бұрын
Hello from SANTIAGO DE CHILE
@JorgetePanete
@JorgetePanete Жыл бұрын
Recats meow
@Swadand04
@Swadand04 Жыл бұрын
pee-air
@jacobeperry
@jacobeperry Жыл бұрын
I want to see the graph of viewers anger after the pronunciation section! 😂😂😂😂
@TigreXspalterLP
@TigreXspalterLP Жыл бұрын
you should disclose the sponsorship. this is basically an ad
@ThePrimeTimeagen
@ThePrimeTimeagen Жыл бұрын
ok real talk, i wasn't paid to read this. yeah i am sponsored on various things for the overall company behind it, but this was a "non sponsored" content. reasonably speaking, do i put ad or not on it? i genuinely don't know
@TigreXspalterLP
@TigreXspalterLP Жыл бұрын
@@ThePrimeTimeagen you should clarify your relationship with turso at the beginning of the video similar to linustechtips does with his investment in framework even if the video is not directly sponsored. you obfuscated this relationship by saying "this is my favorite database", "he is a very nice guy" and "turso engineers are very smart people" without disclosing the sponsorship. you also did it again in the pinned message e.g. you did not reach out to "the author", but to your sponsor. this is a problem, because i watch your videos to learn about new tech. these statements make it look like this is the best thing ever and i should check out libsql and turso. but not disclosing the relationship undermines your credibility a lot for me, because i have now to double check every project you talk about.
@BracingRex6989
@BracingRex6989 Жыл бұрын
brasil ? BRAsil ! BRASILLLLLLLLLLLLLLLLLL !!!
@jeremey__
@jeremey__ Жыл бұрын
redis is best
@duztdruid
@duztdruid Жыл бұрын
No mention of the elephant in the room: who wants to use an Sqlite based database in a world where everyone is used to the capabilities of eg. Postgres.
@eitanseri-levi2169
@eitanseri-levi2169 9 ай бұрын
bruh
@Jensemann099
@Jensemann099 Жыл бұрын
shout louder XD
@anandmahamuni5442
@anandmahamuni5442 Жыл бұрын
Bro looks and sounds like drdisrespect
@liquidcode1704
@liquidcode1704 Жыл бұрын
I always called it "pee air" ever since I was little (but I'm from WV and maybe we all have fukd accents)
@ThePrimeTimeagen
@ThePrimeTimeagen Жыл бұрын
that is the only way to pronounce it
FRAUD IN CODE With FTX | Prime Reacts
17:03
ThePrimeTime
Рет қаралды 93 М.
Prime React: Fast Inverse Square Root - A Quake III Algorithm
30:19
ThePrimeTime
Рет қаралды 148 М.
🌊Насколько Глубокий Океан ? #shorts
00:42
Homemade Professional Spy Trick To Unlock A Phone 🔍
00:55
Crafty Champions
Рет қаралды 58 МЛН
Life After SQL (EdgeDB Is Fascinating)
15:40
Theo - t3․gg
Рет қаралды 54 М.
Is "edge" computing really faster?
8:14
Fireship
Рет қаралды 562 М.
React is Holding Me Hostage!!! | Prime Reacts
28:44
ThePrimeTime
Рет қаралды 99 М.
Vercel Gave Up On Edge
17:50
Theo - t3․gg
Рет қаралды 97 М.
Migration Lesson: Don't Use Prisma | Prime Reacts
29:16
ThePrimeTime
Рет қаралды 145 М.
15 futuristic databases you’ve never heard of
8:42
Fireship
Рет қаралды 649 М.
Is Stack OverFlow Evil? | Prime Reacts
38:13
ThePrimeTime
Рет қаралды 202 М.
Beyond Surreal? A closer look at NewSQL Relational Data
7:52
Beyond Fireship
Рет қаралды 197 М.
A Jr Dev For Life?? | Prime Reacts
21:33
ThePrimeTime
Рет қаралды 279 М.
Телефон в воде 🤯
0:28
FATA MORGANA
Рет қаралды 1,2 МЛН
iOS 18 vs Samsung, Xiaomi,Tecno, Android
0:54
AndroHack
Рет қаралды 92 М.
SSD с кулером и скоростью 1 ГБ/с
0:47
Rozetked
Рет қаралды 365 М.
Gizli Apple Watch Özelliği😱
0:14
Safak Novruz
Рет қаралды 4 МЛН
Неразрушаемый смартфон
1:00
Status
Рет қаралды 1,8 МЛН