Re:MongoDB gets support for multi-document ACID transactions
by furicane on Thursday February 15, 2018 @11:03AM
(#16385044)
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.
[ Parent
| on HN ]
Re:MongoDB gets support for multi-document ACID transactions
by pizza234 on Thursday February 15, 2018 @11:14AM
(#16385149)
> 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.
Re:MongoDB gets support for multi-document ACID transactions
by furicane on Thursday February 15, 2018 @11:28AM
(#16385261)
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.
Re:MongoDB gets support for multi-document ACID transactions
by scarface74 on Thursday February 15, 2018 @11:35AM
(#16385338)
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.
Re:MongoDB gets support for multi-document ACID transactions
by pizza234 on Wednesday February 21, 2018 @05:03PM
(#16433398)
When all you have is a hammer, everything looks like a nail.
Re:MongoDB gets support for multi-document ACID transactions
by neovive on Saturday February 17, 2018 @11:48AM
(#16401441)
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.