TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Ask HN: Need help choosing a database for a local-remote multi master sync

6 点作者 bg0将近 7 年前
Hi all,<p>I’m on a mission to find a the right database for a big project I’ve been working on for a while. As of right now, I’m on a CouchDB (Cloudant) NoSQL database in the cloud while using PouchDB on Asyncstorage using a library in React Native. It&#x27;s a bit buggy for me right now.<p>I was wondering if anyone has done something like my below use case and could give me some guidance on what I should choose. My biggest issue is wrapping my head around how to do these multi-master type syncing requirements I have. Any help or guidance would be greatly appreciated.<p>My use case is as follows:<p>Master Database — This is in the cloud. And is the complete repository where all documents are stored.<p>Local intranet(s) — We install a local database on a linux machine on worksites. They periodically have access to the internet, which is how they will grab and send data from the mater database; but for the most part, they will be offline but will be connected to a local wifi network that devices can access. It should be noted that I only grab specific documents from the cloud. Time based and maybe like 50 other documents that are based on type. And then obviously any documents that are added to the database, we push to the master manually when we have internet.<p>Device(s) — During an online set up with the master database or via the local intranet, there are about 50 documents that are necessary to run this application that we need to grab. This is where all the documents are created. Depending on worksite, we want to make live queries to the master database or live queries with the local intranet. Whenever a document is created, we want to push this to either one of those so all devices can share the same information. Whether it be device-&gt;local intranet-&gt;cloud or device-&gt;cloud, the documents that are created need to get off the device and to the master. Once they are on the local intranet, we are goodie, or once they are on the cloud.<p>I should note that we never update a document atm to avoid conflicts and to keep an audit trial.

1 comment

ddorian43将近 7 年前
Try <a href="https:&#x2F;&#x2F;www.2ndquadrant.com&#x2F;en&#x2F;resources&#x2F;postgres-bdr-2ndquadrant&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.2ndquadrant.com&#x2F;en&#x2F;resources&#x2F;postgres-bdr-2ndqua...</a>
评论 #17173299 未加载