MySQL vs MongoDB 

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

LEWANDOWSKI what are you doing at IBM 💀

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.

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

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

Great job as usual @martin!

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

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

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

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

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

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

Nice video! But love your homebrew channel more ;)

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

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.

Table is equal to collection ^^

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

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

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

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

I want to know How he write those words?

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

wow, that was some quality video

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

good

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.)

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

what is a newsql?

Giznorm DB 😂..Well explained

still waiting for GizNormDB

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

Great video. Thank you for sharing

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

Perfectly

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 .

table for mysql while collection for mongodb

He's writing in backwards!

GIZNOrm DB...😂😂

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

❤❤❤

"Mongo" is a horrible ableist slur in Portuguese.

GizNormDB time 😎

This guy has NO IDEA what he is talking about 🥴

i understood nothing serious.

second

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

I like video, but won't subscribe.

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

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

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

Never heard JSON pronounced that way!!😃

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

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.

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.

For monolithic Projects mysql is unrivaled

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

Eagerly waiting for GizNormDB..:)

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

Thanks a lot!

cool video)

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

Thank you.

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

The worst comparison I have ever seen

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.

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

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.

In the US Mongo means big full and simple