couch-to-postgres

couch-to-postgres copied to clipboard

Improved connection to PG with logging error.

jmorganh

works on workstation, not working on server

27

I worked through getting this to work on my desktop with PG and couch on our server. When I copy the folder( couch-to-Postgres) to my server (same server as pg...

jmorganh

we want to find some tools to publish postgresql table to redis or couchdb as a restful service

2

ericdai

I think the daemon may stop following a _changes feed but think all is ok if couch crashes and is restarted in between a watchdog check. Still testing and not...

sysadminmike

multi master replication

5

is it possible use couchdb replicator over the postgres database on couch-to-postgres?

gcarranza

http://www.craigkerstiens.com/2015/05/08/upsert-lands-in-postgres-9.5/ replace the 'select count' and insert or update stuff in update function to make just one request of an upsert to postgres for new/changes to docs - i am...

sysadminmike

daemon wakeup idea

1

When no changes for a while it can take a while before the daemon notices the next change Perhaps add a field in checkpoint_settings - when sending stuff to couch...

sysadminmike

SQL DELETE - document functionality

1

Do with bulk updates setting doc._deleted flag to true Should be straight forward to do once bulk function in place - as this can be then done with json_object_set_key(doc::json, '_deleted'::text,...

sysadminmike

example use sql

2

Do a wiki/readme page of example sql queries eg: SELECT DISTINCT doc->>'type' as doctype, count(doc->>'type') FROM mytable GROUP BY doctype ORDER BY doctype And any things which might bite like...

sysadminmike

attachments - issue to hold info on them

3

I dont think works with _attachments - or is ignoring them - as they are in couch and I think postgres is more use manipulating/generating reports/ad hoc queries on the...

sysadminmike