sysadminmike

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...

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...

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...

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,...

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...

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...

add _add + friends feed to api

1

_add _enable _disable _remove All need to accept json as get/post request and keep it couchy _feeds_status - list all feeds - current /_status does this - add more info...

web interface to add/remove enable/disable reset initial_since checkpoint restart stream etc

we have postgres or couch to dump some statistics about the feeds to eg inserts/updates/deletes a sec / min / hr should be pretty easy to pump to couch and...

Old way: http_post(url VARCHAR, params VARCHAR, data VARCHAR, contenttype VARCHAR DEFAULT NULL) is no good any more