How to Choose a Database (SQL vs. NoSQL)

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: [e-mail]
Instagram: @withmarko

[@sidorrobert]

Great stuff, +1 for next episode about vector, graph, object oriented etc. databases!

[@anashe5417]

uuuuh something about vectors or graphs would be nice

[@richardkraus5557]

yes please! make a video about graph databases

[@gborgesw]

Totally! Would love one about these!

[@danielgilleland8611]

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.

[@Andrew-wh7uy]

Nice explanation, Marko! Personally, I choose pretty simply: if I need joints I stick to SQL, if not, I choose NoSQL :)

[@withmarko]

Fair 👍

[@uriastriumph4780]

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.

[@withmarko]

Hey thanks for the comment! :) I would love to do another deep dive soon! :)

[@raptisj]

Definitely want a follow-up video. I really like the way you explan things and would enjoy watching a deep dive.

[@reecey1504]

Thanks Marko, I test the builds of SQL based scripts so it’s great to get an understanding of the design choices behind them.

[@latch909]

honestly super helpful high level summary for me! Love to see more of this style

[@xvekii3236]

That was awesome, Marko! I'd love to see more content about databases and their use cases for sure! Hvala i lijep pozdrav! :)

[@AugustoKalahary]

Mannn what a class you just gave. Great explanations!!

[@vengrinv]

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

[@withmarko]

Hey thanks, I really appreciate this comment 🙏

[@beatricecapelli7634]

Amazing video! I'd really love to see the second part with the other types of database. Really good format in my opinion!

[@1MelkaZ]

this was very informative, thank you marko. Keep em coming!

[@KarunJose-hb8ou]

A great explanation of different types of databases. Great work, Marko!!

[@withmarko]

Thanks!

[@kodfam]

This is a masterpiece, I have not seen different DB engines broken down in a simplest form like this. Great video ❤️

[@withmarko]

Hey thank! I'm glad you enjoyed the video :)

[@sl3mey]

Bro this video came perfect, i'm about to choose a databse

[@HABIBMUHD92]

Great explanation! Love this type of content.

[@vishaltambi1400]

whoo great video@Marko you really did explain it well !!!

[@Mo_ali2905]

Hey Man. I am living in Oslo, and I've been following you in your page since a year. Thanks for the valuable information 🙂.

[@WhiteRickRoss]

Awesome! Keep going with this format.

[@danielgilleland8611]

Nice overview! Gotta show my students this.

[@perlhacker]

awesome explaination, thanks for that, it made all the documentation that i have read more clear.

[@hapaise2924]

this was a very nice video, really enjoyed it

[@brunomaia6253]

Nice and simple explanation. TOP!

[@md.manzeralam6508]

Great video and explanation!

[@sugarod_]

loving the more technicals vids!

[@humaizuddinahmed2946]

Would definitely like to see more videos like this.

[@faizansaleem4423]

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.

[@withmarko]

Hey thank you for such a nice comment! I'm glad the video was useful :) Good luck on your dev journey :)

[@faizansaleem4423]

@@withmarko Thank you :)

[@datascience_azamat]

Great videos educational and entertaining!

[@lazarkap]

Great video, learned some new stuff 🙌

[@UserFH9698]

Wow, I learn something new and interesting today, thanks.

[@josem3363]

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.

[@withmarko]

Oh, thanks for the comment :) I changed it to "How to Choose a Database" to be clearer!

[@user-le2tz1wj6v]

this is really great video Thank you

[@maxreuv]

Interesting take on message brokers as databases...

[@TE_-.-]

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?

[@NihadBadalov]

Hi, amazing video. What graphics tablet are you using?

[@cody_codes_youtube]

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

[@withmarko]

Hey thanks, updated :)

[@cody_codes_youtube]

@@withmarkoOH!! That wasn’t it. It didn’t chapter because you didn’t have a beginning. You need to include 00:00

[@elav6899]

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!!

[@lyndontheman4093]

Nice! good info to take note! As always superb content marko! From Philippines! (Amping = "take care")

[@bryanwi09]

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?

[@Foodie-Techie]

It was an interesting and informative video.

[@ginger-viking]

Great video, thanks!

[@zoran.stojkovic]

super video Marko

[@Master-lo5df]

Amazing Video!

[@inakisanchez2552]

big stuff,.. also the background video would be perfect as a separated video to just chill

[@sathyanarayanan1654]

Bro we need this kind of vlogs also

[@code_with_rares]

That's it. I'm getting a drawing tablet! What model did you get?

[@parcidioandre914]

this is great... now it makes sense that kafka would be used for a payment processing application

[@govnewchewskees]

Please make this kind of videos more often

[@erickisee]

Great explanation. The streaming dbs are used for notifications? What are the different use cases for them?

[@withmarko]

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

[@abhinavghosh725]

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 !!

[@swarupmahata9717]

Very Helpful Video:)

[@ankbG]

What is a drawing table you acquired? How it feels to use so far, would you suggest for someone else to use?

[@LoranMaes]

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

[@withmarko]

Awesome, great coincidence 😃

[@JDMAnt]

Great video, what tablet did you get?

[@withmarko]

Hey thanks 🙏 I got the Wacom intuos 😃

[@simbolmina]

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?

[@withmarko]

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.

[@simpingsyndrome]

Now i'm using Graph Relational Database like EdgeDB foe my project

[@aymenbachiri-yh2hd]

Keep posting like this

[@j.h.a6254]

Hi! What are the specs of your MacBook? 🙂

[@muurimc]

Great video

[@uchmd9302]

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😢

[@ApurvoPal]

Do your laptop gets warm?

[@Simple_OG]

What's your view on using Golang as a backend?

[@withmarko]

It’s a great choice, I wish I knew that language better, but I really like the design philosophy of it

[@eytanbenittah]

What Tablet Is That?

[@ermarscaster4553]

bro can you talk about internship offers ?

[@jimprix179]

You know, just asking, but where do you work now??

[@Iker_Tech]

He's working at kahoot

[@Le0chkh4idze]

I'm Pretty Sure He Works At The Kahoot Office In Norway!

[@withmarko]

Yep that’s true 😃

[@hezypubgmobile]

Bro which mac are you using?

[@withmarko]

Hey this is an M1 Pro 16in

[@hezypubgmobile]

@@withmarko Thanks:)

[@justinkim7202]

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.

[@ChristopherState]

Great explanation! Thank you! 🌟

[@svmrat14]

Hey Marko !

[@withmarko]

Hey 😃

[@Gabriel-ue3jf]

How many hours of coding does your laptop lasts on battery?

[@withmarko]

Hey if I’m just coding, not running some crazy docker containers, then 10 hours easy

[@IgorBondarenko]

wow, so cool

[@jamesfraser1622]

I'm learning SQL, want to be a Data Analyst

[@AliImam-cs9ni]

Hello Marko

[@aaaaanh]

If anyone wants to get into the nitty gritty things of exchanging/storing/mutating data between systems, highly recommend the enterprise integration patterns book

[@withmarko]

Hey thanks for the recommendation 🙏

[@DontAsk12]

hi

[@webcoderph]

Oh yeaaaah🎉

[@gourabsarker9552]

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.

[@withmarko]

Hey please google “income tax in Norway” 😃

[@karliszemitis3356]

Depends on tax deductions. But generally around 45k nok/month

[@NodeWanted]

I thought Cassandra was a NoSQL database?

[@znydd]

❤

[@nikichashadow]

hi marko :)

[@withmarko]

Hello 😃

[@chedilahmer]

@@withmarko please more of this videos i learned so much 🥰

[@MarlonRibunal]

If I am asked, I always say SQL. I'm a SQL DBA damnit!

[@Elisei178]

second

[@rayansattarkhan6807]

I guess I am the first.

[@Elisei178]

fest

[@Apenschi]

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.

[@nikichashadow]

thankks for explaing

[@withmarko]

It’s very oversimplified of course haha, KZbin 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 🙏

[@Fran-kc2gu]

Yeah, pretty basic information every developer should know

[@Apenschi]

@@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!

[@TheLukasz222]

I think that explaining how SQL / NoSQL databases work is a bit insulting to your viewers :D

[@nikichashadow]

i am pesonaly not good with backend so it kinda helped me

[@withmarko]

Haha, didn’t mean to insult 😃 I know people in my audience are smart, but then again… I wanted to try the drawing tablet 🤓

[@nikichashadow]

@@withmarko I hope it serves you well