MySQL vs MongoDB

[@when_life_gives_you_limes]

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

[@thegenxgamerguy6562]

So true!

[@iamworstgamer]

worst teacher he his.

[@אליעדלוי-ז6ו]

ok yoda@@iamworstgamer

[@kader1791]

LEWANDOWSKI what are you doing at IBM 💀

[@johnychinese]

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

[@saudmeethal644]

Probably creating the SkiDB that works smoothly with Snowflake

[@muhammaddanial3954]

It's just too good of a comment 😂😂

[@marcosgrillo7511]

"polish" his IT skills

[@davidmalko87]

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

[@ovuokeaghwotu2389]

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

[@chibuzoekwue]

For sure

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

[@daillengineer]

well, I suppose its an issue of right tool for the right job.for what I do, mongo is better than sql. I tried sql first and it just wasn't going to work. doesnt mean sql isnt good. just not the right tool for the job at hand.

[@Brawlstriker89]

@@daillengineernailed it I think. I think they each serve their own purposes. With their own strengths and weaknesses.

[@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]

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]

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]

Isn't mongodb supposed to be faster by design?

[@PeterB_California]

Great job as usual @martin!

[@buddhikabandara9256]

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

[@rajansonvane488]

Hi, i like your name.

[@buddhikabandara9256]

@@rajansonvane488 Thanks :D

[@johneric2720]

I love this tutorial, it was really fun, yet insightfull and had me subscribing immediately. Thank you so much GizNorm!

[@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 🙂

[@severtone263]

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

[@rogerkim7794]

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

[@WhyIsGhostInTheArena]

For some reason I was thinking that mysql and mongodb weren't both databases. I thought MongoDB was just a server. Will definitely learn both

[@cattrader-r]

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

[@fabienpineau1580]

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

[@TonksMoriarty]

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

[@aravindmuthu95]

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

[@rahulr9539]

It could be flipped.

[@IBMTechnology]

Search on "lightboard videos".

[@jinhunpark]

Nice video! But love your homebrew channel more ;)

[@QzBoy]

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

[@secretzpt176]

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.

[@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]

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]

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

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

[@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]

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

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

[@wayneyue1662]

I want to know How he write those words?

[@YuriG03042]

being really good at writing in reverse

[@rahulr9539]

@@YuriG03042 probably flipped video.

[@IBMTechnology]

Search on "lightboard videos".

[@wayneyue1662]

@@IBMTechnology Thanks!

[@RogerHolden]

Never heard JSON pronounced that way!!😃

[@robertananda1207]

wow, that was some quality video

[@RealRossini]

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

[@IBMTechnology]

See ibm.biz/write-backwards

[@dekim7979]

Table is equal to collection ^^

[@rajansonvane488]

Rows document

[@trollol_]

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

[@andrewmartinez8340]

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

[@DanielOpitz]

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

[@AtmaniChouaib]

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

[@gooo1762]

Thanks a lot!

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

[@mosespeter9711]

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

[@anikets4699]

He said 'relational database' afterwards

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

[@xenonozhid3383]

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

[@balakumaran1]

Eagerly waiting for GizNormDB..:)

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

[@thecloudterminal]

Great video. Thank you for sharing

[@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]

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

[@IreneTomphson]

cool video)

[@maruf7956]

For monolithic Projects mysql is unrivaled

[@orvovosk]

what is a newsql?

[@sabuein]

Thank you.

[@PhilippeBazinet]

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

[@CJ-ui4tg]

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

[@omoleregodwise5644]

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

[@oliviamoose80]

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

[@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]

Search on "lightboard videos".

[@petera.schneider2140]

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

[@itsel3250]

Giznorm DB 😂..Well explained

[@CoolestPossibleName]

still waiting for GizNormDB

[@wwavving]

good

[@anilbangera1]

Perfectly

[@QmGhq2T7CzQ]

He's writing in backwards!

[@kklowd]

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

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

[@afuyewale5648]

table for mysql while collection for mongodb

[@Guzguz28]

❤❤❤

[@mirvids5036]

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

[@olamikusholabi3247]

GIZNOrm DB...😂😂

[@LuisEduardoBraschi]

"Mongo" is a horrible ableist slur in Portuguese.

[@AeronWolfe]

This is why half of KZbin is just a money suck. Half way through the video, and already I know both mysql and mongodb are DATABASES. and are OPEN SOURCE!! Oooo.. oh... and they can both be used by the SAME LANGUAGES!!!! OH BOY!!! People watching this kinda topic probably already know all this man. Details. Architectural details. Please.... :(

[@pupplemupple]

GizNormDB time 😎

[@arathortizs28445]

i understood nothing serious.

[@manuelpires5368]

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

[@MrYass24]

This explanation is shallow, trivial and doesn't explain the true purpose of each of these databases, meaning when to use each one and how to use them both at the same time

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

[@yuriysemenikhin302]

This guy has NO IDEA what he is talking about 🥴

[@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)

[@yuriisych9018]

The worst comparison I have ever seen

[@yeromin_g]

I like video, but won't subscribe.

[@jonathanlampkin6645]

second

[@spondoolie6450]

If SQL is so much more secure than no SQL then why haven't I heard of MongoDB injections?

[@MrYass24]

There is MongoDB injection, you just live under a rock and didn't heard of it lol