Postgres vs MySQL vs SQLite - a developer's guide

What relational database should you choose for your next app? I compare Postgres vs MySQL vs SQLite in detail so you can choose the right option for your next web application.

I also spend some time talking about non-relational stores like Mongo and Firebase, and why you SHOULD NOT use them except in very specific cases.

[GringoDotDev]

If you like this video, please consider liking / commenting / subscribing, it helps the channel a lot. Thank you!!

[nelisadludla]

Thank you for this video. It was very helpful. As a beginner, I was overwhelmed by the different databases out there. I now have a much better understanding of them.

[KingSemajCHI]

Useful but constructive criticism…maybe not chew gum on your next video 😂

[RT-mnpb]

Good discussion, especially the point about use what you know, what you already have, or can find expertise in. BUT, one important point is missing, that is, it's a limited perspective in an institutional environment. In the corporate or government world, the most used SQL DB's are: Oracle, MS SQL Server, or IBM DB2.

[adambechtold]

Great video! I especially appreciated the way you clearly distinguished between what was a cold hard fact (e.g. supported data types) and what was a professional opinion that others might disagree with (e.g. NoSQL will burn you enough to mostly disregard it and focus on relational DBs). That's such a helpful way to share your experience and earned wisdom without creating confusion.

[LeonC]

I was looking for videos on insights on how to choose a database and difference between the SQLs RDBMS and this was it. Great explanation, man

[alitaa]

this was in fact useful, and i kindly suggest that you compare sqlite options as well like libsql and sqlite3

[elcio-dalosto]

Really nice content, I learned a lot with this video! But man, just don't chew like that while recording, please(or edit that before you post). I lost my focus a lot of times because of that. Anyway, success to the channel, you got a new subscriber.

[aristideau]

SQlite's date type is very primitive and requires a heap of extra work when manipulation dates and time. And it does not support user defined functions so you cannot even write your own date handling functions to get over SQlite's lack of native date / time functions so thatalone would remove it from my DB short list.

[oliviarojas]

Thanks for vid! Very informative... If I may make a suggestion… there are parts around 5-10 mins where you are killing a piece of gum. . I almost change the vid during that time but ultimately glad I did not. . On a positive note I love hearing your keyboard . . Adobe audition offers some ai noise canceling software for production . . I have only seen videos of it but it seems powerful from this perspective . . Thanks again!!!

[TechArtRoom]

The biggest difference is the licensing models. If you distribute MySQL in a commercial product, you have to either make your entire project open source or purchase a a commercial license.

[erwandurand]

I found this video interesting at first and would have like to finish watching it but found chewing gum very off putting.

[yepyep]

00:46: *randomly taps on the table, while looking away and prerecorded words appear on the screen, to look professional*