Thats sounds hard!
I think postgres are working on a _changes feed type thing
But with this you can use your couchdb views in joins in postgres - so
have both world of map/reduce plus sql.
Mike.
Alexander Shorin wrote:
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.
