Hacker News new | past | comments | ask | show | jobs | submit login

Never invent the wheel if you haven't done your research yet.

Colleagues of mine successfully employed CouchDB in a situation where devices were offline for an x amount of time (running on tablets in airplanes), once they had internet again they would reliably start syncing data with the main database again. This was a number of years ago though, I haven't heard anything about CouchDB since.




It works perfectly with intermittent connectivity, restarts, etc. That will not be a problem.

I'm not sure about thousands of nodes syncing to a single replica though. That may be a bit over the top.


Who says you need to feed it directly to the replica. Logical replication provides infrastructure for decoding changes, and you may fetch it any way you want / how often you want / feed it wherever you want (file, another database, ...).

It would be trivial to write something that connects to a bunch of machines regularly, fetches the decoded increment and feed it somewhere (say, to a single database over a shared connection).

See test_decoding / pg_recvlogical for examples.




Join us for AI Startup School this June 16-17 in San Francisco!

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: