JSONSelect For CouchDB
CSS-like selectors for JSON, which can be used over couch views.
- It makes it easy to access data in complex JSON documents.
- It feels like CSS.
See jsonselect docs for more details on the query
Install
npm i couchdb-jsonselect -g
Add jsonselect to a couchdb database
couchdb-jsonselect http://localhost:5984/databasename
jsonselect from a view
Assume you have a view named ddoc/myview. To select only the .languagesSpoken from each doc, use the following url
http://localhost:5984/databasename/_design/jsonselect/_list/select/ddoc/myview?include_docs=true&select=.languagesSpoken
You can use all the query parameters for the view, eg
http://localhost:5984/databasename/_design/jsonselect/_list/select/ddoc/myview?include_docs=true&select=.languagesSpoken&start_key="a"&end_key="b"
Retrieve Only Part Of A Doc
Lets say you have a doc with id abc3092390
. To retrieve part of a doc, such as the .languagesSpoken property, use the following url
http://localhost:5984/databasename/_design/jsonselect/_show/select/abc3092390?select=.languagesSpoken
ldjson
We can also return ldjson from a view by adding the query parameter ?ldjson=true
eg
http://localhost:5984/databasename/_design/jsonselect/_list/select/ddoc/myview?include_docs=true&select=.languagesSpoken&ldjson=true