TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

MongoDB 3.2: Now powered by Postgres

120 pointsby buffyodaover 9 years ago

10 comments

preinheimerover 9 years ago
tl;dr: There's a new "BI Connector" which will allow you to connect your business intelligence tools to MongoDB using the Postgres wire protocol (which many speak). This is somehow bad because Postgres is also popular, and maybe people will use Postgres now. Also: the author (who has a competing connector) knows the names of a lot of people at MongoDB.
评论 #10698121 未加载
评论 #10698114 未加载
评论 #10699762 未加载
parenthephobiaover 9 years ago
tl;dr 2.0:<p>1) MongoDB Inc have made a &quot;foreign data wrapper&quot; for PostgreSQL which enables MongoDB databases to be accessed from within PostgreSQL.<p>2) This makes data in MongoDB databases accessible to existing analytics software for SQL databases, which is often made by companies with lots of money.<p>3) The CTO of SlamData Inc, which makes analytics software for NoSQL databases, thinks that MongoDB Inc shouldn&#x27;t have done that.<p>tl;dr 3.0:<p>A company faces increased competition; isn&#x27;t happy about it.
评论 #10703484 未加载
onetwotreeover 9 years ago
Frankly, if I were tasked with integrating existing BI tools with MongoDB, I&#x27;d immediately start looking at ways to &quot;escape&quot; the anemic Mongo ecosystem to something a bit richer. A Postgres FDW seems like an excellent design.<p>Of course, I&#x27;m a bit of a Postgres partisan, and a Mongo refugee, but it still seems like a solid engineering decision and most of this guys arguments seem to hinge on &quot;BUT POSTGRES IS TEH ENEMY!&quot;.
评论 #10701703 未加载
评论 #10702609 未加载
评论 #10706828 未加载
ahacheteover 9 years ago
It&#x27;s nothing new that PostgreSQL is a great tool for doing analytics, even coming from MongoDB. I&#x27;m very happy that MongoDB took this route, it speaks a lot about their capabilities in the non-OLTP world.<p>Having said that, I very biasedly say that there&#x27;s a much better solution to this connector, which doesn&#x27;t flatten out the MongoDB data: it&#x27;s called ToroDB (<a href="https:&#x2F;&#x2F;github.com&#x2F;torodb&#x2F;torodb" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;torodb&#x2F;torodb</a>).<p>ToroDB, open source, speaks the MongoDB protocol, transforms documents to relational tables (without any kind of flattening, and without having to define any schema) and stores data in a RDBMS. More precisely, PostgreSQL.<p>Current development version (repl branch) speaks the replication protocol, and hence can replicate live from a MongoDB into PostgreSQL. No connector needed, no flattening, no FDWs, nothing else. Just add a new &quot;slave&quot; (ToroDB) to your replica set and you&#x27;re good to go.<p>It goes even further: if you want pure data warehousing, ToroDB will soon support GreenPlum. Some initial benchmarks (<a href="http:&#x2F;&#x2F;www.slideshare.net&#x2F;8kdata&#x2F;torodb-scaling-postgresql-like-mongodb" rel="nofollow">http:&#x2F;&#x2F;www.slideshare.net&#x2F;8kdata&#x2F;torodb-scaling-postgresql-l...</a>, slide #42) show 25x-75x improvement between doing aggregate queries in MongoDB and their equivalent queries in GreenPlum&#x27;s distributed SQL.<p>Now that MongoDB 3.2 ships with PostgreSQL &quot;included&quot;, feel free to try ToroDB. It&#x27;s always better the original :)<p>Note: I am a ToroDB developer.
评论 #10701691 未加载
CurtMonashover 9 years ago
Classic marketing pitch from a little company that wants to claim it&#x27;s much more significant than it is:<p>1. Claim a must-have set of requirements that ... 2. ... happen to match its product&#x27;s feature set ... 3. ... but not its competitors.&#x27;<p><a href="http:&#x2F;&#x2F;slamdata.com&#x2F;whitepapers&#x2F;characteristics-of-nosql-analytics-systems&#x2F;" rel="nofollow">http:&#x2F;&#x2F;slamdata.com&#x2F;whitepapers&#x2F;characteristics-of-nosql-ana...</a> is presumably the core of the argument.<p>I tend not to pay attention to such claims until the company rephrases them more honestly.<p>That said, a brief discussion of what is really happening is in <a href="http:&#x2F;&#x2F;www.dbms2.com&#x2F;2015&#x2F;09&#x2F;10&#x2F;mongodb-update&#x2F;" rel="nofollow">http:&#x2F;&#x2F;www.dbms2.com&#x2F;2015&#x2F;09&#x2F;10&#x2F;mongodb-update&#x2F;</a> Would more be better? Sure.
bro-stickover 9 years ago
The author tries to paint Mongo as an embarrassingly short-sighted, pseudo-enterprise company that can&#x27;t share its toys with others.<p>Mongo could refuse this by demonstrating collaboration efforts and solutions with a solution marketplace similar Atlasssian and VMware. On the partner side, cross-selling, cross promotions and collaborative sales&#x2F;product strategies can reduce conflict and wasted&#x2F;duplicated&#x2F;unaligned effort that can lead to sour partner experiences.
bricssover 9 years ago
Guru author should marry on Postgres)
anotherevanover 9 years ago
MongoDB: the snapchat of databases.
评论 #10707348 未加载
click170over 9 years ago
Is this posted anywhere besides LinkedIn? Would like to read but am not willing to give page views to LinkedIn.
评论 #10698022 未加载
评论 #10706925 未加载
alexkavonover 9 years ago
Looks like it&#x27;s time to switch databases. BLOAT. RIP Mongo.
评论 #10700390 未加载