Offline support

[danielmewes]

We should think about offline support at some point. This was mentioned by @Rajan in rethinkdb/rethinkdb#5239 (comment) .

The idea is that it will make it a lot easier to build mobile applications on top of Fusion.

As a first simpler step, we could allow mirroring certain data to the client for read-only access.
In a second step, we could hook into our optimistic write infrastructure (that we still need to build, #42) to allow for syncing back writes once the user gets online again.

[dalanmiller]

Would this also require resumable changefeeds @danielmewes?

[danielmewes]

@dalanmiller That's a good question. I think this depends on how the API is going to look like, and how big we expect the offline data to be.

It might be acceptable to just stream a completely new set of results upon reconnection.
We could additionally generate a diff in the client library. The client would retrieve a complete new result set from the server, and then would compare it to what it currently has cached. Then it would emit events only for the changes.

[danielcompton]

Even if resumable change feeds were present, I think you'd still need to handle the failure case as the 'default', and if the change feed is able to be resumed choose that as a nicer way to reconnect. Resumable changefeeds still have a finite buffer after which they will need to close too, and there could be other reasons why resumable changefeeds don't resume (server restarts are the one that comes to mind).

[deontologician]

Related to #358

[COLABORATI]

yes, pouchdb like offline sync is absolutely needed in 2016 for any mobile app platform, please work on this so it can be done with rethinkdb, thanks!

[nevf]

Progressive Web Apps and offline first are gaining momentum. There is real need for fully fledged database capabilities in the Browser that can be used offline, with sync + conflict resolution back to the server when a connection is available again. This could be days or weeks later.

By fully fledged I mean all CRUD operations, so from the user's perspective the app has all the same functionality whether they are online or offline. The Browser database world is unfortunately constrained to IndexedDB, so we need to build on top of that.

My own use case is to enable Clibu the Knowledge Base Web App I'm developing to work offline. Right now it uses MongoDB on the server along with realtime websocket push of updates to the Browser, but it has no offline capabilities. The only option I can see at this point is to use something like Dexie.js along with it's Syncable module, but I can see that being a lot of work. An end-to-end solution such as RethinkDB + Horizon suggests itself to be far better.

I continue to be surprised that no one has yet come up with a modern NoSQL package that accomplishes what PouchDB and CouchDB do, clearly there is a now more of a need than ever.

[paulocoghi]

I continue to be surprised that no one has yet come up with a modern NoSQL package that accomplishes what PouchDB and CouchDB do, clearly there is a now more of a need than ever.

This is the point.

[franciscolourenco]

Hoodie

A generic backend with a client API for Offline First applications
https://github.com/hoodiehq/hoodie