Comment by furicane | Hacker News Reader

Comment by furicane | Hacker News Reader

Parent Full thread

I've been using MySQL 5.7 since its release in production. I used to store JSON data in a blob, but when they released JSON support - I just couldn't wait to use it. It's working really, really good. JSON support solves a ton of problems we used to have, and we used EAV model to tackle those problems (I won't get into details, the discussion will go the other way). I deal with a few hundred MySQL deployments ranging from 1GB dataset size to several terabytes, with multimaster and MySQL cluster setup to in-app handled sharding. There are several notable pieces of software that never caused any problems in our use scenario, and MySQL is one of them. The other is nginx. Can't really remember the third. I often wondered why anyone would use MongoDB or similar, but I always keep forgetting that developers are usually inexperienced hipsters who are looking for magic unicorn to solve their lack of knowledge / experience.

> I often wondered why anyone would use MongoDB or similar, but I always keep forgetting that developers are usually inexperienced hipsters

You can do a basic google search, and you will find out use cases where document-based data storages are advantageous compare to relational ones.

So what you're saying that if I find something on google, it's undoubtedly true and I should blindly believe it? For every one of those use cases, I can provide a counter-argument. And there are many more who can do the same.

I used RDMSs for 15 years before ever using Mongo. I fell in love with Mongo from the first time I used it with a pre-existing system. The beauty of just being able to insert and retrieve my whole C# object graph with one statement was a thing of beauty.

I'm a Domain Driven Design true believer. The thought of just being able to store my entire domain model without the machinations of the object relational impedance mismatches was glorious.

I use C# so my document collections are strongly typed C# objects and thanks to the Mongo C# Linq provider, my queries are also strongly typed.

When all you have is a hammer, everything looks like a nail.

Thanks for the advice and vote of confidence in MySQL JSON support. I don't anticipate reaching that kind of scale, but it's great to hear about large, successful, production deployments. These days I try to stick with a very stable back-end stack and innovate more on the front-end.

Reply on news.ycombinator.com