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.
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.
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.
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.
I’ve learned more about SQLite since recording this video. I agree with you. Alter table statements are also a huge problem. Probably time to do an update.
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.
Sure, but I don’t think it’s a super important distinction in practice. In cases where you use MySQL as your database for a web app, you won’t be distributing the binary and the licensing provision won’t apply. And in cases where you would distribute a binary (eg embedded environments) SQLite is almost always the go to option anyway, for reasons unrelated to licensing.
@@GringoDotDev General consumer B2C websites - yes. B2B has numerous cases where they want an on-premise enterprise installs. ( eg. medical, large corps, finance, enterprise software) such as examples are Jira or Salesforce. In such cases, commercial license of MySQL would be required if its used. That''s often why other DBs are chosen in these cases because they have a more lenient distribution model.
Sadly I’m not very familiar with it except as a consumer of its data warehousing. From what I hear from the DBAs I used to work with it’s fast enough for just about everything and very stable, but without personal experience at scale it’s hard for me to say when I would choose it e.g. instead of MySQL.
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.
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!!!