I come from a enterprise world where I led a mobile native complete offline application. The mobile app had SQLite database and we had a mobile middleware in between.
So our stack was client with offline database, mobile middleware, backend enterprise app server with RDBMS data base.
Now I am looking to develop an enterprise application where I will develop both the backend and client. I am looking to develop my backend in NoSQL database with node.js. Here I will use couchbase server
On the client side I want the same NoSQL Database as I have offline non connected scenario. Here I will use couchbase Lite.
On the mobile middleware to offer sync, user authentication, etc I wanted to use Sync Gateway. I went through your "Couchbase Mobile 101" training video. As there are no other videos are not available I have several questions:
1. My application is a complex enterprise which will have lot of offline data - are there any limits to the offline db size?
2. You are saying the use of user->role->channel and assign channel to documents. As you can imagine that in enterprise world there will be millions of documents that are created say example is HR documents, Sales videos, Sales visits the rule will not be by channel but distribution rules can be complex by zip code/accounts that user is allowed to see sales data for , etc. So does your Sync Gateway allows to write complex rules and store as procedures that can read during distribution.
3. How does the application will sync data first time? Does it download all the documents related to the user channel first time on the device? I understand that when the network is available you do the automatic sync from device to server - but in that case do you clean up the local database completely?
4. Is couchbase lite still in beta version? When is stable release planned to be out?