MySQL vs MongoDB
Vložit
- čas přidán 9. 11. 2022
- 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
I can tell this guy is a fun teacher, more of him please!
So true!
worst teacher he his.
ok yoda@@iamworstgamer
This couldn't have come at a better time. Thank you for this!
For sure
Great job as usual @martin!
LEWANDOWSKI what are you doing at IBM 💀
Well he's here to help us tap into new technologies
Probably creating the SkiDB that works smoothly with Snowflake
It's just too good of a comment 😂😂
"polish" his IT skills
He was said that if he gets job at IBM he wins Champions League 😂
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
Hi, i like your name.
@@rajansonvane488 Thanks :D
Nice video! But love your homebrew channel more ;)
these videos actually tempt me so hard to try and apply to IBM. Great video, thanks!
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
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...
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.
Isn't mongodb supposed to be faster by design?
Great presentation - thank you. A comparison with DB2 would be appreciated.
I'm a bit familiar with both db's but this is the first time that i learned where their names are coming from 🙂
I hope to see GizNormDB in the future. Good luck 🤞
wow, that was some quality video
Thanks a lot!
Hi Bro, excellent video, btw, what software/hardware you're using to record your handwriting on a transparent screen?
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.
Since becoming a GizNormDB developer, my life has changed significantly. 😂
Thank you.
What the method used to face the screen and write on the screen like IBM video?
Eagerly waiting for GizNormDB..:)
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.
What's the security part that you don't get with mongodb?
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.
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
Nice video, but the term "legacy" is just not correct in this context.
Never heard JSON pronounced that way!!😃
cool video)
Is this guy writing in reverse? Bruh , that's a skill I would like to learn
It could be flipped.
Search on "lightboard videos".
Wait. Is it the guy from the beer channel? I am so confused!
You can't convince me that MongoDB isn't named after Ming the Merciless' home planet Mongo in Flash Gordon.
Perfectly
this is like explaining what a car is by saying it is a thing that has a steering wheel, pedals, etc.
Table is equal to collection ^^
Rows document
How did you do that PEN writing mirroring thing? :D
See ibm.biz/write-backwards
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.
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
@@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.
@@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
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.
bad developers can create garbage tables in mysql too and do too many join queries. anyone can break rules they understand enough of
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.
with respect to content quality, this channel has too few subscribers
the joke at the end, thank you for the funny explanation
good
as a developer with a daughter, i now have to make my own db 😂
what is a newsql?
In the US Mongo means big full and simple
For monolithic Projects mysql is unrivaled
What do you mean by "LAGECY TABLE"? this doesn't sound right to me
He said 'relational database' afterwards
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.
I want to know How he write those words?
being really good at writing in reverse
@@YuriG03042 probably flipped video.
Search on "lightboard videos".
@@IBMTechnology Thanks!
Nice, informative vid, thanks.
It's JAY SON by the way, not JAI SON.
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.)
Search on "lightboard videos".
@@IBMTechnology Oh. Yes. That was obvious, in retrospect ;-). Nice.
Giznorm DB 😂..Well explained
I'm pronouncing JSON "jaison" from now on lol
If SQL is so much more secure than no SQL then why haven't I heard of MongoDB injections?
still waiting for GizNormDB
❤❤❤
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.
I'm here just for the reverse writing lessons
Search on "lightboard videos".
table for mysql while collection for mongodb
This video was pretty lacking. I guess I just expected more from a video titled "MySQL vs mongodb" British dude is cute tho
He's writing in backwards!
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 .
Are you saying MongoDB uses JavaScript to parse JSON documents?
GIZNOrm DB...😂😂
second
GizNormDB time 😎
Master Inventor? Advantage of MySql is security? Who comes up with such dummy things?
i understood nothing serious.
"Mongo" is a horrible ableist slur in Portuguese.
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! 🙂
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
I like video, but won't subscribe.
The worst comparison I have ever seen
This guy has NO IDEA what he is talking about 🥴
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)