How to Choose a Database (SQL vs. NoSQL)
Вставка
- Опубліковано 5 тра 2024
- In this video I will describe my process of choosing a database between row and column oriented SQL databases, as well as NoSQL databases.
For convenience here are the chapters:
00:30 - SQL databases
00:38 - Row oriented databases
03:41 - Column oriented databases
05:14 - NoSQL databases
05:25 - Document databases
08:00 - Sharding
09:16 - Streaming databases
=== Links ===
☕️ Discord
links.withmarko.com/discord
☕️ My free Mac window manager
links.withmarko.com/one-menu
☕️ My Notion Template
links.withmarko.com/notion-te...
☕️ Wallpapers:
withmarko.com/wallpapers
=== Business Inquiries ===
Email: business@withmarko.com
Instagram: @withmarko - Наука та технологія
Great stuff, +1 for next episode about vector, graph, object oriented etc. databases!
uuuuh something about vectors or graphs would be nice
yes please! make a video about graph databases
Totally! Would love one about these!
Nice explanation, Marko! Personally, I choose pretty simply: if I need joints I stick to SQL, if not, I choose NoSQL :)
Fair 👍
For others out there, normalization isn't there just because of "limited disk space". The reduction of data duplication is to help prevent anomalies (i.e.: potential corruption) from inserts, updates and deletes. I'm sure Marko knows that, but for those just learning, that's another aspect to why normalization is often done.
Absolutely love how you broke these down so, YES! I would definitely appreciate a video or videos on other database types.
As an AI Engineer, I work with vector databases a lot. Hearing another perspective on how they are built and how they work would definitely be of benefit.
Cheers.
Hey thanks for the comment! :) I would love to do another deep dive soon! :)
Definitely want a follow-up video. I really like the way you explan things and would enjoy watching a deep dive.
honestly super helpful high level summary for me! Love to see more of this style
Thanks Marko, I test the builds of SQL based scripts so it’s great to get an understanding of the design choices behind them.
That was awesome, Marko! I'd love to see more content about databases and their use cases for sure! Hvala i lijep pozdrav! :)
this was very informative, thank you marko. Keep em coming!
Amazing video! I'd really love to see the second part with the other types of database.
Really good format in my opinion!
Mannn what a class you just gave. Great explanations!!
Bro this video came perfect, i'm about to choose a databse
This is a masterpiece, I have not seen different DB engines broken down in a simplest form like this. Great video ❤️
Hey thank! I'm glad you enjoyed the video :)
A great explanation of different types of databases. Great work, Marko!!
Thanks!
Great explanation! Love this type of content.
Nice overview! Gotta show my students this.
This is really nice. Nice byte sized (pun intended), cohesive and straight to the point. It doesnt get into unwanted depth and focuses on the important distinction between the DB types. Well done
Hey thanks, I really appreciate this comment 🙏
Awesome! Keep going with this format.
awesome explaination, thanks for that, it made all the documentation that i have read more clear.
Nice and simple explanation. TOP!
this was a very nice video, really enjoyed it
Hey Man. I am living in Oslo, and I've been following you in your page since a year. Thanks for the valuable information 🙂.
Would definitely like to see more videos like this.
loving the more technicals vids!
Great video, learned some new stuff 🙌
Great video and explanation!
Great videos educational and entertaining!
Wow, I learn something new and interesting today, thanks.
this is really great video
Thank you
Great video, thanks!
Very Helpful Video:)
super video Marko
Amazing Video!
Great explanation about the different databases :) With that title I was expecting some real example about some specific use case, the db you choose and why.
Oh, thanks for the comment :) I changed it to "How to Choose a Database" to be clearer!
Bro we need this kind of vlogs also
Interesting take on message brokers as databases...
Please make this kind of videos more often
Nice! good info to take note! As always superb content marko! From Philippines! (Amping = "take care")
Hi, amazing video. What graphics tablet are you using?
It was an interesting and informative video.
Hi Marko, love you videos, they are great!!
Anther thing, can you tell me please what is the name of your draw program that you used in this video?
Thanks!!
Thank you so much for making this video and explaining it in detail. I am a novice at using DBs and this helped clear some questions I had. Please make more videos like this on different subjects. I have used PrismaDB (SQL) in a React app that I have made for a URL shortener I wrote in TypeScript. I like the interface Prisma uses does noSQL offer an interface like this?
Great video
this is great...
now it makes sense that kafka would be used for a payment processing application
big stuff,.. also the background video would be perfect as a separated video to just chill
Keep posting like this
I have always had a bit of hard time in understanding the reasoning behind choosing a right database. I am like 3.5 years into software engineering profession and I recently started studying a book on this very topic as I want to be able to answer questions like why I chose a certain database. Your explanation made me understand that, been following you from start and love your videos as always. Looking forward to the next episode.
Hey thank you for such a nice comment! I'm glad the video was useful :) Good luck on your dev journey :)
@@withmarko Thank you :)
That's it. I'm getting a drawing tablet!
What model did you get?
Hahaha insane, tomorrow I have a meeting with my internship to choose a DB for my bachelor thesis hahahaha. I'll enjoy this one :p
Awesome, great coincidence 😃
Great explanation. The streaming dbs are used for notifications? What are the different use cases for them?
Thanks, yes notifications are one use case for sure, if there is any communication between 2 services where one of them is expected to be unavailable for some time, or not be able to process data as quickly as it’s arriving, it’s a good idea to have a streaming database in between
hello Marko! can you tell me the name of the stand desk you have under the monitor please?
Great video, what tablet did you get?
Hey thanks 🙏 I got the Wacom intuos 😃
I cant tell you how many people I have seen just by default go with NoSQL as its just "better" than SQL, and for some reason the popular notion is SQL is outdated.
Good, short video btw !!
Side note: I think the chapters need to be 00:00 format for the video to update the chapters on the video itself. The 0:00 still behave as links to those parts of the video, but you get the visual chunking on the play timeline if you do 00:30
Hey thanks, updated :)
@@withmarkoOH!! That wasn’t it. It didn’t chapter because you didn’t have a beginning. You need to include 00:00
whoo great video@Marko you really did explain it well !!!
Is there perhaps an app on the iPad that can do this too, where you can start a screen recording and the background is removed?
Now i'm using Graph Relational Database like EdgeDB foe my project
What is a drawing table you acquired? How it feels to use so far, would you suggest for someone else to use?
Hey Marko what drawing tablet do you use?
Great explanation! Thank you! 🌟
wow, so cool
Hi! What are the specs of your MacBook? 🙂
Oh yeaaaah🎉
Do your laptop gets warm?
Not clear how to choose to me... You can denormalize data in relational db. You can also persist a tree of objects in json in a clob field. You can do partionning and i guest sharding in relational database. So how to choose ? Are NoSql db really more performant than relational db in that case ?
Did u delete some video in ur channel, cus i remember there is a rainy day vlog which i really enjoy to watch has disappeared😢
Hmm i just noticed i used mongodb like a sql db with refs all over place lol. So usage of mongodb for ecommerce i would save actual user data in documents where they are always used together, keep track of that use cases and update all of them if user changed these data, correct?
Hey that's a good question! If you have a very high number of reads and you are always reading a few documents together, it makes sense to just bundle them up in a single document. But if you don't have very many reads, it's not worth it.
bro can you talk about internship offers ?
What's your view on using Golang as a backend?
It’s a great choice, I wish I knew that language better, but I really like the design philosophy of it
You know, just asking, but where do you work now??
He's working at kahoot
I'm Pretty Sure He Works At The Kahoot Office In Norway!
Yep that’s true 😃
What Tablet Is That?
Bro which mac are you using?
Hey this is an M1 Pro 16in
@@withmarko Thanks:)
I'm learning SQL, want to be a Data Analyst
Hey Marko !
Hey 😃
❤
How many hours of coding does your laptop lasts on battery?
Hey if I’m just coding, not running some crazy docker containers, then 10 hours easy
If anyone wants to get into the nitty gritty things of exchanging/storing/mutating data between systems, highly recommend the enterprise integration patterns book
Hey thanks for the recommendation 🙏
Normalisation does have the advantage of saving disk space but the question is, was normalisation designed with the main goal of saving disk space? I don't think so. I'd argue that the main design goal was avoiding data inconsistency due to data redundancy over space efficiency. So I personally wouldn't claim that "normalisation" was designed as a means to save disk space.
Hello Marko
hi
Sir if you earn 800k Kroners a year before taxes then what is your take home pay after taxes and deductions in Norway? Plz reply. Thanks a lot.
Hey please google “income tax in Norway” 😃
Depends on tax deductions. But generally around 45k nok/month
hi marko :)
Hello 😃
@@withmarko please more of this videos i learned so much 🥰
I thought Cassandra was a NoSQL database?
If I am asked, I always say SQL. I'm a SQL DBA damnit!
second
I guess I am the first.
fest
This explanation is far too simplified, even though I know it's difficult to do in 11 minutes.
SQL databases have many decades of optimization behind them and what they do cannot be done any faster!
If a system claims to be faster, it leaves out essential functions (see “ACID”).
The decision in favor of NoSQL should probably mainly made in the case of unstructured or weakly structured data.
You also have to be sure in advance that you won't need complex queries later on.
I fear that the decision in favor of NoSQL is mainly made because it is easier to use... which is the wrong reason!
By the way, the reason for normalization is not storage space, but speed and data integrity.
thankks for explaing
It’s very oversimplified of course haha, UA-cam is not university. The sentence “what they do cannot be done any faster”doesn’t carry much information. Don’t criticize and then hedge like that🙃 I totally agree I missed the point with data integrity, that’s a big one. Thanks for the comment, I appreciate it 🙏
Yeah, pretty basic information every developer should know
@@withmarko “what they do cannot be done any faster” carries the information that a database can't be faster without loosing essential features. If you don't need these features, because you have document-like data and only need primitive read requests, it's absolutely fine to choose a NoSQL Database, BUT you should be aware of what you are loosing. So, in a video that is comparing the two, you should at least mention the advantages of SQL Databases, what would cost only 2 mins more.
That said, I appreciate your work and already watched a lot of your videos and enjoyed them!
I think that explaining how SQL / NoSQL databases work is a bit insulting to your viewers :D
i am pesonaly not good with backend so it kinda helped me
Haha, didn’t mean to insult 😃 I know people in my audience are smart, but then again… I wanted to try the drawing tablet 🤓
@@withmarko I hope it serves you well