MySQL vs MongoDB

IBM Cloud Databases for MongoDB → ibm.biz/BdPP2P
IBM Cloud Databases for MySQL → ibm.biz/BdPP2y
Database management systems (DBMS) are software tools that allow users to store, extract, and query large sets of data. IBM’s Martin Keen explores the key differences between two of the most popular varieties - MySQL and MongoDB - and explains how each got its unusual name.
Get started for free on IBM Cloud → ibm.biz/sign-up-now
Subscribe to see more videos like this in the future → ibm.biz/subscribe-now
#mysql #mongodb #database

Пікірлер: 108

  • @when_life_gives_you_limes
    @when_life_gives_you_limes Жыл бұрын

    I can tell this guy is a fun teacher, more of him please!

  • @thegenxgamerguy6562

    @thegenxgamerguy6562

    Жыл бұрын

    So true!

  • @iamworstgamer

    @iamworstgamer

    11 ай бұрын

    worst teacher he his.

  • @user-me5rb3um1f

    @user-me5rb3um1f

    5 ай бұрын

    ok yoda@@iamworstgamer

  • @kader1791
    @kader1791 Жыл бұрын

    LEWANDOWSKI what are you doing at IBM 💀

  • @johnychinese

    @johnychinese

    Жыл бұрын

    Well he's here to help us tap into new technologies

  • @saudmeethal644

    @saudmeethal644

    Жыл бұрын

    Probably creating the SkiDB that works smoothly with Snowflake

  • @muhammaddanial3954

    @muhammaddanial3954

    Жыл бұрын

    It's just too good of a comment 😂😂

  • @marcosgrillo7511

    @marcosgrillo7511

    Жыл бұрын

    "polish" his IT skills

  • @davidmalko87

    @davidmalko87

    10 ай бұрын

    He was said that if he gets job at IBM he wins Champions League 😂

  • @ovuokeaghwotu2389
    @ovuokeaghwotu2389 Жыл бұрын

    This couldn't have come at a better time. Thank you for this!

  • @chibuzoekwue

    @chibuzoekwue

    Жыл бұрын

    For sure

  • @PeterB_California
    @PeterB_California Жыл бұрын

    Great job as usual @martin!

  • @Keenok
    @Keenok Жыл бұрын

    I have been using SQL for 30 years and mongo since it started. I fervently hate that I can't write a single query in mongo that will tell me what services a subscriber has purchased, since the subscriber table cannot be related directly within a query to the services table. I used to write single queries that could tell me every optical node in a circuit and spit it out in an easy to read manner. Now I would have to write a significant program in another language to manage what I did in 100 lines of human readable SQL. If I could write queries that correlate multiple collections at the command line, I would love mongo. Yeah, it is fast and flexible, but as the guy who has to figure out what went wrong at a telecom that has 5 9's uptime, I can't do it in mongo. In SQL I can.

  • @rogerkim7794
    @rogerkim7794 Жыл бұрын

    these videos actually tempt me so hard to try and apply to IBM. Great video, thanks!

  • @buddhikabandara9256
    @buddhikabandara9256 Жыл бұрын

    This guy is a good teacher. Good luck with the GizNormDB :D

  • @rajansonvane488

    @rajansonvane488

    Жыл бұрын

    Hi, i like your name.

  • @buddhikabandara9256

    @buddhikabandara9256

    Жыл бұрын

    @@rajansonvane488 Thanks :D

  • @KyleHarrisonRedacted
    @KyleHarrisonRedacted Жыл бұрын

    Made a blog platform that could run on MySQL and MongoDB by switching a flag, and pumped them full of facade data (couple authors, long and short posts, bunch of users, comments) I just wanted to see which one would run faster at the end of the day with a real world application. The results to me were that while they were fairly even with a little data at the beginning, Mongo really started falling behind with page load times as the data ballooned Now, bare in mind my test structured the Mongo data in a similar way to how I’d store in a relational table. I wanted to run the same test but with the idea that I’d be combining the documents but it required quite a bit of conditional refactoring, especially in the admin portions. And then MySQL introduced its own indexable json document column type. I just never bothered looking back to Mongo after that

  • @alandosman5002

    @alandosman5002

    Жыл бұрын

    I think that's where the neat part comes in with MongoDB, it is mostly created for horizontal scaling, so you can easily scale it I think your problem of having a lot of data will be fixed...

  • @kayloko1

    @kayloko1

    Жыл бұрын

    Hello , if you can give me your email please because i need advice about an approach to how i would implement a database of a project (laravel 10). the problem is that i need to store documents (diploma , bank statement , Personalis...) each of these document have its own set or fields , so logically it each one would have its own table if made with mySQL , but that means each for each new type of document my client will need to add he will need a developer , i want to make that possible for non-technical admins to do that. in the worst case where there is no solution to make that possible without a developer , what database technology would suit this project.

  • @aberba

    @aberba

    5 ай бұрын

    Isn't mongodb supposed to be faster by design?

  • @yavuzsert6765
    @yavuzsert6765 Жыл бұрын

    I'm a bit familiar with both db's but this is the first time that i learned where their names are coming from 🙂

  • @fabienpineau1580
    @fabienpineau15802 ай бұрын

    What the method used to face the screen and write on the screen like IBM video?

  • @xenonozhid3383
    @xenonozhid3383 Жыл бұрын

    Great presentation - thank you. A comparison with DB2 would be appreciated.

  • @nickelnc7296
    @nickelnc7296 Жыл бұрын

    I hope to see GizNormDB in the future. Good luck 🤞

  • @jinhunpark
    @jinhunpark Жыл бұрын

    Nice video! But love your homebrew channel more ;)

  • @QzBoy
    @QzBoy Жыл бұрын

    Hi Bro, excellent video, btw, what software/hardware you're using to record your handwriting on a transparent screen?

  • @secretzpt176

    @secretzpt176

    2 ай бұрын

    Very late reply, and also not 100% sure, but it looks like he records himself using a green screen separately, and he writes on a board that is being recorded.

  • @gooo1762
    @gooo17623 ай бұрын

    Thanks a lot!

  • @andrewmartinez8340
    @andrewmartinez8340 Жыл бұрын

    What's the security part that you don't get with mongodb?

  • @robertananda1207
    @robertananda1207 Жыл бұрын

    wow, that was some quality video

  • @sabuein
    @sabuein Жыл бұрын

    Thank you.

  • @severtone263
    @severtone263 Жыл бұрын

    Since becoming a GizNormDB developer, my life has changed significantly. 😂

  • @TonksMoriarty
    @TonksMoriarty4 ай бұрын

    You can't convince me that MongoDB isn't named after Ming the Merciless' home planet Mongo in Flash Gordon.

  • @DanielOpitz
    @DanielOpitz Жыл бұрын

    Nice video, but the term "legacy" is just not correct in this context.

  • @balakumaran1
    @balakumaran1 Жыл бұрын

    Eagerly waiting for GizNormDB..:)

  • @aravindmuthu95
    @aravindmuthu95 Жыл бұрын

    Is this guy writing in reverse? Bruh , that's a skill I would like to learn

  • @rahulr9539

    @rahulr9539

    Жыл бұрын

    It could be flipped.

  • @IBMTechnology

    @IBMTechnology

    Жыл бұрын

    Search on "lightboard videos".

  • @RogerHolden
    @RogerHolden Жыл бұрын

    Never heard JSON pronounced that way!!😃

  • @thomascollins7955
    @thomascollins7955 Жыл бұрын

    I was trying to explain the difference between relational and document databases to my partner. I was met with confused looks and more questions. Thankfully I found this video and I can get back to my evening.

  • @thecloudterminal
    @thecloudterminal Жыл бұрын

    Great video. Thank you for sharing

  • @pprocacci
    @pprocacci Жыл бұрын

    I'd love for you to do a postgres (legacy) vs a mongodb comparison. I say this not only because postgres can act in a document driven manner, it's also 7x faster in writes and 2x faster in reads than mongodb. Sometimes, even if the original design of a "legacy" system wasn't intended to be used in a certain way, those "legacy" systems have adapted to incorporate both. Postgres is one such system that can do what mongodb can do, but better. Postgres can also do time series related stuff better than the competition as well. Now I happen to work in finance, and we're using postgres for all the above ... a document store, a time series database, and even table driven data. It just works and there is no need to run 3 different systems for 3 different use cases.

  • @thebowshock7729

    @thebowshock7729

    Жыл бұрын

    You are contradicting yourself. You claim postgres to be faster and better than MongoDb, yet in your comment you claim your company is fully committed to using a traditional SQL solution, meaning you simply have no data or experience to support what you are saying. While Postgres can do a lot of things that Mongo can do, just like Mongo can be run as an RDB, Mongo will always outshine Postgres in what it was designed to simply be better at. Just like Mongodb would be inferior to any SQL if used in a relational db way

  • @RealRossini
    @RealRossini10 ай бұрын

    How did you do that PEN writing mirroring thing? :D

  • @IBMTechnology

    @IBMTechnology

    10 ай бұрын

    See ibm.biz/write-backwards

  • @user-mh9to3we2h
    @user-mh9to3we2h6 ай бұрын

    cool video)

  • @aaron5877
    @aaron5877 Жыл бұрын

    If you work with data, a Rigid Schema in MySQL is a good thing. Flexible in MongoDB translates in to developers being lazy and simply creating a pile of data no one understands.

  • @YuriG03042

    @YuriG03042

    Жыл бұрын

    bad developers can create garbage tables in mysql too and do too many join queries. anyone can break rules they understand enough of

  • @thegenxgamerguy6562

    @thegenxgamerguy6562

    Жыл бұрын

    Document based storage liberates us developers from having to discuss every minor idea with a board of unwilling, lazy and grumpy DBAs and their worthless opinions.

  • @orvovosk
    @orvovosk Жыл бұрын

    what is a newsql?

  • @EdJanuskis
    @EdJanuskis Жыл бұрын

    you cannot index MongoDB the way you can index mySQL. I am talking about more then 5 indexes or combo indexes. MongoDB is good for non transactional data and requires only 1 or 2 indexes on the collection. if you need more from your DB you will need MySQL.

  • @CoreyThompson73

    @CoreyThompson73

    Жыл бұрын

    You can pair Mongo with SOLR for index and searching...(In theory, you could just use SOLR as a document store DB) CouchDB is very similar to to Mongo, and includes Lucene search/indexing

  • @EdJanuskis

    @EdJanuskis

    Жыл бұрын

    @@CoreyThompson73 In content management it is big over head to have 2 different solutions. Traditional DB can do a lot more and faster then Mongo/Solar. Only down side is that adding additional columns is a bit hustle. Specially in corp environments. But on the other hand once you establish schema you do not need to change ever again. in my env we have 2 Opods and they are doing same thing what Mongo/solar (50 + hosts) doing and i can tell you performance is not there.

  • @thebowshock7729

    @thebowshock7729

    Жыл бұрын

    ​​​@@EdJanuskis MongoDB has no limits to indexes and they also have compound indexes, so not sure what you mean Reading how you claim that a traditional db can do more just goes to show you don't really know what you are talking about. Tasks describe tools, not the other way around. So there will be tasks where MongoDb will outperform others and there will be those where it will be outperformed by its competitors

  • @user-ip1wg4sg3w
    @user-ip1wg4sg3w2 ай бұрын

    Wait. Is it the guy from the beer channel? I am so confused!

  • @anilbangera1
    @anilbangera1 Жыл бұрын

    Perfectly

  • @trollol_
    @trollol_11 ай бұрын

    this is like explaining what a car is by saying it is a thing that has a steering wheel, pedals, etc.

  • @omoleregodwise5644
    @omoleregodwise5644 Жыл бұрын

    with respect to content quality, this channel has too few subscribers

  • @mosespeter9711
    @mosespeter9711 Жыл бұрын

    What do you mean by "LAGECY TABLE"? this doesn't sound right to me

  • @anikets4699

    @anikets4699

    Жыл бұрын

    He said 'relational database' afterwards

  • @ravishmahajan9314

    @ravishmahajan9314

    Жыл бұрын

    LAGACY means it's there very long time. Relational databases are there for around 5 decades I guess. But MongoDB is a new database storing data in documents instead of traditional table structure.

  • @dekim7979
    @dekim7979 Жыл бұрын

    Table is equal to collection ^^

  • @rajansonvane488

    @rajansonvane488

    Жыл бұрын

    Rows document

  • @wayneyue1662
    @wayneyue1662 Жыл бұрын

    I want to know How he write those words?

  • @YuriG03042

    @YuriG03042

    Жыл бұрын

    being really good at writing in reverse

  • @rahulr9539

    @rahulr9539

    Жыл бұрын

    @@YuriG03042 probably flipped video.

  • @IBMTechnology

    @IBMTechnology

    Жыл бұрын

    Search on "lightboard videos".

  • @wayneyue1662

    @wayneyue1662

    Жыл бұрын

    @@IBMTechnology Thanks!

  • @wwavving
    @wwavving11 ай бұрын

    good

  • @CJ-ui4tg
    @CJ-ui4tg Жыл бұрын

    as a developer with a daughter, i now have to make my own db 😂

  • @BobHooker
    @BobHooker Жыл бұрын

    In the US Mongo means big full and simple

  • @AtmaniChouaib
    @AtmaniChouaib5 ай бұрын

    the joke at the end, thank you for the funny explanation

  • @petera.schneider2140
    @petera.schneider2140 Жыл бұрын

    You do write mirror script with your left hand, don't you? (Which actually is much easier for right-handers than writing non-mirrored with the left hand.)

  • @IBMTechnology

    @IBMTechnology

    Жыл бұрын

    Search on "lightboard videos".

  • @petera.schneider2140

    @petera.schneider2140

    Жыл бұрын

    @@IBMTechnology Oh. Yes. That was obvious, in retrospect ;-). Nice.

  • @maruf7956
    @maruf7956 Жыл бұрын

    For monolithic Projects mysql is unrivaled

  • @Octal_Covers
    @Octal_Covers Жыл бұрын

    Hi, I develop an application that uses MongoDB, I've found that Mongo *can* be used for the same applications as SQL, given you structure your data properly, which you should be doing anyways if you're making a database intended for production. Initially for the application we used SQL, but it quickly devolved into code that's hard to maintain. Mongo using JSON for query allows you to easily define queries in code, instead of relying on code-in-code. I believe Mongo is the future of databases.

  • @CoolestPossibleName
    @CoolestPossibleName6 ай бұрын

    still waiting for GizNormDB

  • @oliviamoose80
    @oliviamoose805 ай бұрын

    I'm pronouncing JSON "jaison" from now on lol

  • @itsel3250
    @itsel32509 ай бұрын

    Giznorm DB 😂..Well explained

  • @Jeff-Lynn
    @Jeff-LynnАй бұрын

  • @mirvids5036
    @mirvids5036 Жыл бұрын

    Nice, informative vid, thanks. It's JAY SON by the way, not JAI SON.

  • @nerdikkoff8058
    @nerdikkoff8058 Жыл бұрын

    I'm here just for the reverse writing lessons

  • @IBMTechnology

    @IBMTechnology

    Жыл бұрын

    Search on "lightboard videos".

  • @afuyewale5648
    @afuyewale5648 Жыл бұрын

    table for mysql while collection for mongodb

  • @Guzguz28
    @Guzguz28 Жыл бұрын

    ❤❤❤

  • @QmGhq2T7CzQ
    @QmGhq2T7CzQ Жыл бұрын

    He's writing in backwards!

  • @kklowd
    @kklowd Жыл бұрын

    This video was pretty lacking. I guess I just expected more from a video titled "MySQL vs mongodb" British dude is cute tho

  • @itsaaron6423
    @itsaaron6423 Жыл бұрын

    I think mysql would be faster since its closer to the machine while json is an object hence parsing json as well as running javascript code inside MongoDB would make it slow but better performing when used in places where critical data and speed arent much required . The ease of MongoDB makes it easy and preferable for web development while MySQL too has common uses but MongoDB is right at home for developers since Json is easy to understand .

  • @coolfyb

    @coolfyb

    Жыл бұрын

    Are you saying MongoDB uses JavaScript to parse JSON documents?

  • @olamikusholabi3247
    @olamikusholabi32472 ай бұрын

    GIZNOrm DB...😂😂

  • @LuisEduardoBraschi
    @LuisEduardoBraschi Жыл бұрын

    "Mongo" is a horrible ableist slur in Portuguese.

  • @jonathanlampkin6645
    @jonathanlampkin6645 Жыл бұрын

    second

  • @inkooboo
    @inkooboo Жыл бұрын

    If this is not satire video, than it is really poor piece of information. This guy does not know the subject he talks about. SQL based databases are not legacy, it is just different way to structure your data. SQL vs NoSQL have different pros and cons. And both are heavily used by all major tech companies

  • @manuelpires5368
    @manuelpires5368 Жыл бұрын

    Master Inventor? Advantage of MySql is security? Who comes up with such dummy things?

  • @thegenxgamerguy6562
    @thegenxgamerguy6562 Жыл бұрын

    Come on, IBM, get back to PC business. With videos like this you show us that you're a company that could contribute a lot! 🙂

  • @pupplemupple
    @pupplemupple Жыл бұрын

    GizNormDB time 😎

  • @arathortizs28445
    @arathortizs284457 ай бұрын

    i understood nothing serious.

  • @yuriisych9018
    @yuriisych9018 Жыл бұрын

    The worst comparison I have ever seen

  • @yeromin_g
    @yeromin_g Жыл бұрын

    I like video, but won't subscribe.

  • @yuriysemenikhin302
    @yuriysemenikhin302 Жыл бұрын

    This guy has NO IDEA what he is talking about 🥴

  • @YuriG03042

    @YuriG03042

    Жыл бұрын

    says the guy implying the video is wrong while at the same time making 0 corrections 🤡 you have NO IDEA what you are talking about (see, i can make baseless arguments too)