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
I can tell this guy is a fun teacher, more of him please!
@thegenxgamerguy6562
Жыл бұрын
So true!
@iamworstgamer
11 ай бұрын
worst teacher he his.
@user-me5rb3um1f
5 ай бұрын
ok yoda@@iamworstgamer
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
10 ай бұрын
He was said that if he gets job at IBM he wins Champions League 😂
This couldn't have come at a better time. Thank you for this!
@chibuzoekwue
Жыл бұрын
For sure
Great job as usual @martin!
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.
these videos actually tempt me so hard to try and apply to IBM. Great video, thanks!
This guy is a good teacher. Good luck with the GizNormDB :D
@rajansonvane488
Жыл бұрын
Hi, i like your name.
@buddhikabandara9256
Жыл бұрын
@@rajansonvane488 Thanks :D
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
5 ай бұрын
Isn't mongodb supposed to be faster by design?
I'm a bit familiar with both db's but this is the first time that i learned where their names are coming from 🙂
What the method used to face the screen and write on the screen like IBM video?
Great presentation - thank you. A comparison with DB2 would be appreciated.
I hope to see GizNormDB in the future. Good luck 🤞
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?
@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.
Thanks a lot!
What's the security part that you don't get with mongodb?
wow, that was some quality video
Thank you.
Since becoming a GizNormDB developer, my life has changed significantly. 😂
You can't convince me that MongoDB isn't named after Ming the Merciless' home planet Mongo in Flash Gordon.
Nice video, but the term "legacy" is just not correct in this context.
Eagerly waiting for GizNormDB..:)
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".
Never heard JSON pronounced that way!!😃
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.
Great video. Thank you for sharing
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
How did you do that PEN writing mirroring thing? :D
@IBMTechnology
10 ай бұрын
See ibm.biz/write-backwards
cool video)
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.
what is a newsql?
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
Wait. Is it the guy from the beer channel? I am so confused!
Perfectly
this is like explaining what a car is by saying it is a thing that has a steering wheel, pedals, etc.
with respect to content quality, this channel has too few subscribers
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.
Table is equal to collection ^^
@rajansonvane488
Жыл бұрын
Rows document
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!
good
as a developer with a daughter, i now have to make my own db 😂
In the US Mongo means big full and simple
the joke at the end, thank you for the funny explanation
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.
For monolithic Projects mysql is unrivaled
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.
still waiting for GizNormDB
I'm pronouncing JSON "jaison" from now on lol
Giznorm DB 😂..Well explained
Nice, informative vid, thanks. It's JAY SON by the way, not JAI SON.
I'm here just for the reverse writing lessons
@IBMTechnology
Жыл бұрын
Search on "lightboard videos".
table for mysql while collection for mongodb
❤❤❤
He's writing in backwards!
This video was pretty lacking. I guess I just expected more from a video titled "MySQL vs mongodb" British dude is cute tho
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
Жыл бұрын
Are you saying MongoDB uses JavaScript to parse JSON documents?
GIZNOrm DB...😂😂
"Mongo" is a horrible ableist slur in Portuguese.
second
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
Master Inventor? Advantage of MySql is security? Who comes up with such dummy things?
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! 🙂
GizNormDB time 😎
i understood nothing serious.
The worst comparison I have ever seen
I like video, but won't subscribe.
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)