Hi Everyone,
We switch from Postgres to Couch for our main datasource about 5 years
ago. One of the main reasons was for master/master replication our data
suites the using a schema less model.
Ever since the switch I have always wanted to be able use sql to query
the data as opposed to writing add hoc scripts to put csv/xls reports
together. With all the json/jsonb stuff happening with postgres
recently I decided to scratched that itch last week with:
Node libary to stream CouchDB changes into PostgreSQL with a simple
client example.
https://github.com/sysadminmike/couch-to-postgres/
It is fairly simple to get going and start running SELECT queries on the
docs in your couchdb. It is also possible to use your couch views as
tables. It provides something similar Elastic Search river plugin but
for Postgres.
By adding a few some extra bits allows not only for SELECT queries on
the data but also UPDATE/INSERTS/(DELETES todo) on your couchdb docs
within Postgres.
Thanks for reading,
Mike.
