Nice project! But how about make a bidirectional sync PostgreSQL with CouchDB by using replication protocol? (; -- ,,,^..^,,,
On Tue, Dec 16, 2014 at 1:43 PM, Mike <[email protected]> wrote: > 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. > > >
