7 ms·
Let me first say, I think all of the criticisms I am reading here are valid. That said, partitioning in PG still isn't great, and though it's better now than in
by lr4444lr 6y ago
Let me first say, I think all of the criticisms I am reading here are valid. That said, partitioning in PG still isn't great, and though it's better now than in say, v9.x, I'm not sure it's ever going to get where multinode NoSQL is without sacrificing core ACID that makes PG so great. I know it's not in keeping with the general HN dislike of Mongo, but if you have large scale data that has a stable partition key, data that you write and store authoritatively elsewhere like a relational DB, that you don't have to update with real time writes, but you need to do a lot of heavy reads of most of the fields, I think Mongo makes a lot of sense. To be clear, ALL of those things have to apply. And when you factor in ease of setup, adding new nodes, and training new devs that, doubt you will find a better solution.
- coding123 6y agoThere's still a rather large fanbase of Mongo on HN, it's just that we have to shut up most of the time.
- egeozcan 6y agoI don't think anybody will downvote you just for making a point in favor of MongoDB, as long as it's valid. If you are starting with things that are impossible to define (like the infamous phrase "internet scale") or are plain wrong, then you still don't have to shut up but maybe make sure you like your db of choice for the right reasons. There are people who love mysql because they use PHP and others who love Mongo because they use nodejs. It's understandable: Those stacks have a lot of users and it's easier to get support. Nevertheless, it's not strictly a strong starting point when people are just discussing databases. So, don't feel oppressed, just be clear with your reasoning.
- Izkata 6y ago> things that are impossible to define (like the infamous phrase "internet scale") I like to think of that as "personal blog with a couple visits a day". ;)
- deleted 6y ago[deleted]
- rpedela 6y agoI think Citus can be used effectively for that scenario now. https://www.citusdata.com/ https://www.citusdata.com/
- baby 6y agoI doubt the guardian needs to shard though.