问HN：有没有简单的连接器可以连接MongoDB和Postgres？
我有一个Postgres模式，用于关联作者、帖子、评论、点赞、关注以及各种内容，这在关系查询中表现得非常出色。<p>特别是“文章”表，除了“正文”列之外，其他都很好，而在这列中，我突然需要存储一个大型的Markdown文件。<p>我想在MongoDB中创建一个“article_bodies”表，存储许多[article_id:article_body]的条目，我理解这正是MongoDB的用途。我认为这样可以提高Postgres的性能，同时让我在各处继续编写关系查询。<p>有没有快速简便的方法将我的Postgres“articles”表与MongoDB的“articles”表连接起来？我正在使用PostgREST来托管REST API，这会对我预期的性能产生影响吗？<p>我是自学的网页开发者，但似乎一切内容要么最适合使用关系数据库，要么最适合使用文档数据库，其中MongoDB和Postgres是最广泛使用的标准。有没有专门支持连接这两者的工具的项目或公司？我们是否终于可以停止构建新的数据库了？
查看原文
I have a postgres schema for relating authors, posts, comments, likes, follows, and all kinds of stuff that works great for relational queries.<p>The articles table in particular is great, with the exception of the "body" column, where all the sudden I'm hosting a large markdown file.<p>I want to have an "article_bodies" table in MongoDB that holds many [article_id:article_body] entries, which in my understanding is what MongoDB was made for. I'm thinking this will open higher performance from my postgres, while allowing me to keep writing relational queries everywhere.<p>Is there a fast and easy way to connect my pg "articles" table to a mongo "articles" table? I'm using PostgREST to host the rest API, will this have the performance impact I'm expecting?<p>I'm a self-taught webdev, but it seems like more or less everything is either best served by a relational db or a document db, with mongo and postgres being the most widely used standards. Are there any projects/companies dedicated to supporting tooling that links these two? Could we finally be done building new databases?