title: Mobile app using PouchDB-CouchDB and MySQL
body: <p>I'm developing a mobile app wrapped in Cordova that runs alongside our web-based application, based on PHP &amp; MySQL. The mobile app uses local-storage &amp; gets data via a layer of services that have been written to exchange data between the mobile app &amp; the MySQL database. The mobile app only uses a subset of data stored in the main MySQL DB.</p>
  
  <p>I am looking to replace my mobile-app local-storage solution with pouch DB &amp; see that it requires CouchDB ... which got me thinking of a potential configuration / solution that I would like to find out whether would be advisable and feasible ...</p>
  
  <p>Would it be feasible to set up a CouchDB database that runs as a mediator/slave between the main MySQL database &amp; the mobile app's PouchDB? The mobile service layer would use this database (as well as the main MySQL DB if necessary) &amp; data updates between the main-SQL &amp; couch-DB are pushed periodically via cron. The CouchDB would only store a subset of data from the MySQL DB that is relevant for the mobile app.</p>
  
  <p>Does this solution sound like overkill / a good idea? Is there a better way of approaching the setup described above?  I do like the idea of pouchdb-CouchDB ... but don't want to rewrite my entire web-app to use couch-DB, while an additional level of abstraction providing a subset of mobile-specific data seems useful.</p>
  
  <p>Thanks 
  Trace</p>