4 ms·

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 us

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.

pizza234 9y ago
> 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.
- furicane 9y ago
  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.
  - scarface74 9y ago
    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.
  - pizza234 9y ago
    When all you have is a hammer, everything looks like a nail.
neovive 9y ago
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.

pizza234 9y ago

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

furicane 9y ago
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.
- scarface74 9y ago
  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.
- pizza234 9y ago
  When all you have is a hammer, everything looks like a nail.

neovive 9y ago

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.