Hi
We have a number of client couchdbs which we query as one.
I initially wrote: https://github.com/sysadminmike/couch-to-postgres
To help get ad hoc reports from our couch data using postgres.
The above utility will stream changes for each couchdb into its own
postgres table which can then be queried and collated together using
standard sql UNION.
Mike.
On 04/03/2016 11:54, Matthew Buckett wrote:
We're using CouchDB as a store for a mobile app that is collecting
some user entered data. Each user has their own database in CouchDB
and we're wanting todo some general reporting on the entered data. Our
current plan is:
- replicate all the users data into a central database, each users DB
has a replication function to add it to the one central DB.
- create some views on the central DB which enable the reporting.
- Create some HTML/JS reporting pages which access the central DB.
- Has anyone else done some reporting against CouchDB?
- Did you use continuous replication or just batch replication?
- Should we just export all the data and import it into a general
reporting tool?
Thanks.
