News for hackers. Stuff that matters.
Re:MongoDB shares jump more than 30% in $192M IPO by bad_user on Thursday October 19, 2017 @04:44PM (#15511383)
In general NoSQL solutions are optimized for certain use-cases at the detriment of others. If you're looking for a general purpose database, then RDBMSs like PostgreSQL are your best bet.

So that said, when comparing NoSQL solutions, ending up with an apples versus oranges comparison is almost inevitable.

Re:MongoDB shares jump more than 30% in $192M IPO by qaq on Thursday October 19, 2017 @04:59PM (#15511506)
The funny thing is PG will outperform most NoSQL solutions as NoSQL store for vast majority of use cases.
Re:MongoDB shares jump more than 30% in $192M IPO by bad_user on Thursday October 19, 2017 @05:38PM (#15511757)
Well, I for one think PostgreSQL is overrated.

The number one reason for why people want NoSQL is horizontal scaling and for that PostgreSQL is terrible, with all available solutions being hacks that don't work.

Re:MongoDB shares jump more than 30% in $192M IPO by hiram112 on Thursday October 19, 2017 @07:05PM (#15512299)
I don't disagree with you for teams who know which technology is right and which isn't, for their specific use cases.

But more common than not, inexperienced devs are using Mongo and similar to store relational data, simply because they were sold the 'MEAN' stack and didn't realize that, while it's easy to get a quick prototype running, a year or two later you eventually need things like transactions and joins, and NoSQL is absolutely the wrong technology most of the time.

Re:MongoDB shares jump more than 30% in $192M IPO by kod on Thursday October 19, 2017 @06:49PM (#15512209)
Citus works just fine.
Re:MongoDB shares jump more than 30% in $192M IPO by qaq on Thursday October 19, 2017 @06:57PM (#15512253)
what % of people have workload beyond something that PG on i3.16xlarge can handle?
Re:MongoDB shares jump more than 30% in $192M IPO by gaius on Friday October 20, 2017 @02:46AM (#15513938)
I always think this when people talk about scaling. You can buy off the shelf now boxes with 48 or 96 cores, 1-2T of RAM, internal bays for 10s of T of SSD or connect it to an AFA and get 100s of T. This is not even an exotic custom build system, just a commodity, and has been for years. Running a recent version of a conventional database on a box like this goes a very, very long way, with very little hassle because you don't even need to think about "sharding", and you can always add a hotstandby for offloading reads, or for redundancy in another DC, or whatever. Systems like this can quite happily bottleneck on the network before the database starts breaking a sweat.

Remember, sharding isn't scaling the database. Sharding is admitting your database can't scale so you're offloading the problem to another layer.

Re:MongoDB shares jump more than 30% in $192M IPO by qaq on Friday October 20, 2017 @08:22AM (#15515171)
You can have 224 cores and 12TB RAM in a commodity Supermicro box.
Re:MongoDB shares jump more than 30% in $192M IPO by gaius on Friday October 20, 2017 @05:20PM (#15519181)
Indeed. You would need one helluva Postgres workload to overload that. Not one in a million people genuinely have that requirement.
Re:MongoDB shares jump more than 30% in $192M IPO by KallDrexx on Thursday October 19, 2017 @08:54PM (#15512800)
It's also about locality of your data. Having a global infrastructure means 150-200ms minimum latency per query if you have a system in India or Singapore with a database server in a US data center region. That adds up quick.
Re:MongoDB shares jump more than 30% in $192M IPO by qaq on Thursday October 19, 2017 @09:41PM (#15512977)
That is orthogonal concern to what is being discussed if you run geo distributed Mongo cluster you will either have slow queries or will compromise on data integrity.
Re:MongoDB shares jump more than 30% in $192M IPO by KallDrexx on Friday October 20, 2017 @09:19AM (#15515503)
It's not orthogonal because it is harder to have master-master cross data center setups in relational databases even in scenarios where eventual consistency is acceptable (such as a use case for a piece of our infrastructure we have).

Sure MongoDB may not be the best fit for it but my point is more that these are scenarios where horizontal scaling is an important consideration makes more sense for some nosql solutions than for sql solutions. It's not just about single box performance.

Re:MongoDB shares jump more than 30% in $192M IPO by hendzen on Thursday October 19, 2017 @07:39PM (#15512466)
people who don't want to get woken up if Amazon decides to terminate said i3.16xlarge...
Re:MongoDB shares jump more than 30% in $192M IPO by qaq on Thursday October 19, 2017 @08:05PM (#15512595)
Not a fan of AWS or cloud in general but accepted that this the direction the world is going for now. The AWS instance type was purely for illustration purposes.
Re:MongoDB shares jump more than 30% in $192M IPO by jlarocco on Thursday October 19, 2017 @07:51PM (#15512528)
Missed the point completely...
Re:MongoDB shares jump more than 30% in $192M IPO by acdha on Thursday October 19, 2017 @08:20PM (#15512661)
I think you should reconsider that dismissal: everyone needs n > 1 instances for reliability while increasingly few tasks require more {CPU,RAM,IOPs} than a single server can provide. That means that a growing percentage of problems will require clustering for reliability more than performance, and that favors the easiest to manage since in most cases every option will be fast enough.
Re:MongoDB shares jump more than 30% in $192M IPO by gnaritas on Thursday October 19, 2017 @09:28PM (#15512944)
Horizontal scaling is often just as much about redundancy as it is scaling; no one server solution is a valid answer to a production application.
Re:MongoDB shares jump more than 30% in $192M IPO by qaq on Friday October 20, 2017 @06:41AM (#15514766)
People tend to copycat what Google and the like are doing without giving much thought to the fact that in many cases the solutions they adapt are simply due to the fact that they don't have an alternative and not because it's "better".
Re:MongoDB shares jump more than 30% in $192M IPO by fermuch on Thursday October 19, 2017 @05:46PM (#15511806)
I second this. Mongo clusters are easy to manage, and the aggregation pipeline or MapReduce engines do wonders on a sharded cluster with tons of data. That's the selling point of mongo for me.
Re:MongoDB shares jump more than 30% in $192M IPO by ComputerGuru on Thursday October 19, 2017 @08:09PM (#15512616)
It doesn't matter how easy to is to scale if it doesn't do it right. You can win all the internet points when it comes to speed and ease-of-use but it doesn't matter if it comes at the cost of data integrity.
Re:MongoDB shares jump more than 30% in $192M IPO by Diederich on Thursday October 19, 2017 @08:30PM (#15512701)
> It doesn't matter how easy to is to scale if it doesn't do it right.

I would refer you to an earlier comment:

> In general NoSQL solutions are optimized for certain use-cases at the detriment of others

Your definition of 'right' is absolutely not the only definition of 'right'.

More to the point: there are a lot of problem spaces where the data integrity provided by MongoDB are more than sufficient.

Re:MongoDB shares jump more than 30% in $192M IPO by ComputerGuru on Thursday October 19, 2017 @08:48PM (#15512775)
Sorry, I meant "correct" and not "right," as the former is objective and the latter can be (though often isn't) subjective. MongoDB is not correct; in fact, it is provably incorrect. If your needs to don't require correctness, then by all means.
Re:MongoDB shares jump more than 30% in $192M IPO by orf on Thursday October 19, 2017 @08:40PM (#15512735)
> with tons of data

Define tons of data. I'll bet a beer that what you say can fit on a single postgres instance and even be small enough to run fine on a cheapish developer laptop.

Re:MongoDB shares jump more than 30% in $192M IPO by nicholassmith on Thursday October 19, 2017 @06:06PM (#15511938)
That's interesting to me as I've been looking at Mongo aggregations for a solution to a problem but couldn't find any research on the performance of them.
Re:MongoDB shares jump more than 30% in $192M IPO by pishpash on Thursday October 19, 2017 @05:23PM (#15511670)
NoSQL is optimized for no solutions. You do all the optimizations yourself. Only then are you allowed to speak of "optimized for certain use cases at the detriment of others."