Yesterday I was browsing Reddit and I stumbled across this, a video about NoSQL fanboys. I had honestly never had heard of NoSQL or MongoDB before, but it piqued my curiosity. So I researched into these fascinating and semi-new concepts. (Educate yourself here)
As a web developer who is working in a huge MySQL database handling tonnes and tonnes of outright unstructured data, I instantly saw the magic in this document-oriented concept. I love relational databases, and where ever data can be structured, I will do it. Alas, in life we all know that however hard we try, abstraction can lead to distraction from the actual work at hand.
I’m probably going to download MongoDB in the very near future for PHP5 (Sadly I’m stuck with this).
I’m thinking that I may use this, instead of MySQL or XML for storing things such as profile data that simply varies too much from one place, and person to another. I’m personally sick of seeing tables with 50 columns and databases with 100 tables just to cover every single little exception thrown at it when alternatives such as MongoDB exist.
I’ve also heard MongoDB is faster than MySQL, but I honestly haven’t had my hands on it to test.
Anyone had experience with MongoDB or NoSQL solutions? I’m really looking for downsides.