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.
You can also read this in written form on my substack: gringodotdev.substack.com/p/m...

Пікірлер: 34

  • @GringoDotDev
    @GringoDotDev9 ай бұрын

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

  • @nelisadludla2563
    @nelisadludla25639 ай бұрын

    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.

  • @GringoDotDev

    @GringoDotDev

    9 ай бұрын

    I'm really happy it was helpful!

  • @some5794
    @some57943 ай бұрын

    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

  • @GringoDotDev

    @GringoDotDev

    2 ай бұрын

    Thank you!!

  • @adambechtold6741
    @adambechtold67417 ай бұрын

    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.

  • @GringoDotDev

    @GringoDotDev

    7 ай бұрын

    Thanks so much, Adam! It's really nice to hear that it was helpful. I'm still really flattered that people listen to what I have to say!

  • @KingSemajCHI
    @KingSemajCHI8 ай бұрын

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

  • @GringoDotDev

    @GringoDotDev

    8 ай бұрын

    Hahaha duly noted!

  • @jofofouj

    @jofofouj

    8 ай бұрын

    +1 to this. Love the info and how it was presented. Don't like the chewing noises.

  • @GringoDotDev

    @GringoDotDev

    8 ай бұрын

    @@jofofouj thank you for the feedback!

  • @sarthakshah6761

    @sarthakshah6761

    2 ай бұрын

    +1 😂

  • @therealbfg123

    @therealbfg123

    2 ай бұрын

    Great video, couldn't finish because of the chewing with my headphones on.

  • @RT-mn2pb
    @RT-mn2pb22 күн бұрын

    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.

  • @GringoDotDev

    @GringoDotDev

    22 күн бұрын

    Yup, that's completely right!

  • @alitaa1154
    @alitaa11549 ай бұрын

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

  • @GringoDotDev

    @GringoDotDev

    9 ай бұрын

    thanks for the feedback, I will probably do a video on Turso at some point (worth checking it out)

  • @kvelez
    @kvelez13 күн бұрын

    Interesting.

  • @elcio-dalosto
    @elcio-dalosto5 ай бұрын

    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.

  • @GringoDotDev

    @GringoDotDev

    5 ай бұрын

    Thank you! Totally agree with you and thanks for the feedback

  • @oliviarojas7023
    @oliviarojas702311 ай бұрын

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

  • @GringoDotDev

    @GringoDotDev

    11 ай бұрын

    I really appreciate the feedback! I'll try to avoid chewing gum jajaja

  • @abellosimon
    @abellosimon8 ай бұрын

    Excellente video.

  • @GringoDotDev

    @GringoDotDev

    8 ай бұрын

    Gracias amigo! Si te interesa tengo planes de grabar esto de nuevo en español y pensamientos más actualizados

  • @some5794

    @some5794

    3 ай бұрын

    @@GringoDotDev Genial, en el mismo canal o tienes otro?

  • @TechArtRoom
    @TechArtRoom6 ай бұрын

    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.

  • @GringoDotDev

    @GringoDotDev

    6 ай бұрын

    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.

  • @TechArtRoom

    @TechArtRoom

    6 ай бұрын

    ​@@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.

  • @peterhamilton9387
    @peterhamilton938710 ай бұрын

    No mention at all of MS SQL Server?

  • @GringoDotDev

    @GringoDotDev

    10 ай бұрын

    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.

  • @peterhamilton9387

    @peterhamilton9387

    10 ай бұрын

    @@GringoDotDev No worries. I was just a little curious as to why no mention as it is very popular and very capable. Great video otherwise 👍

  • @yepyep3897
    @yepyep38978 ай бұрын

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

  • @GringoDotDev

    @GringoDotDev

    8 ай бұрын

    probably the best performance review I've ever received!!

  • @shixzie
    @shixzie19 күн бұрын

    stop eating/chewing while you record!

Келесі