CouchDB

Apr 22, 2015 - I installed the following:

* elasticsearch 1.5.1
* plugin elasticsearch-river-couchdb 2.5.0

NodeJS and ElasticSearch
http://daemon.co.za/2012/05/elasticsearch-5-minutes/
https://github.com/AdrianRossouw/elasticsearch-example

http://daemon.co.za/2012/05/replacing-couchdb-views-with-elasticsearch/

http://www.ripariandata.com/blog/time-to-relax-installing-couchdb-and-elasticsearch

http://www.elasticsearch.cn/guide/reference/river/couchdb.html

https://github.com/elastic/elasticsearch-river-couchdb/


* https://www.digitalocean.com/community/tutorials/how-to-set-up-couchdb-with-elasticsearch-on-an-ubuntu-13-10-vps
** http://stackoverflow.com/questions/27273998/why-elasticsearch-wont-run-on-ubuntu-14-04


code.sudo -u elasticsearch /usr/share/elasticsearch/bin/elasticsearch -d -p /var/run/elasticsearch.pid --default.config=/etc/elasticsearch/elasticsearch.yml --default.path.home=/usr/share/elasticsearch --default.path.logs=/var/log/elasticsearch --default.path.data=/var/lib/elasticsearch --default.path.work=/tmp/elasticsearch --default.path.conf=/etc/elasticsearch
code..

_"added a line into /etc/init.d/elasticsearch to print out the above command:"_


code.# Start Daemon
log_daemon_msg "sudo -u $ES_USER $DAEMON $DAEMON_OPTS"    # <-- Add this line
start-stop-daemon --start -b --user "$ES_USER" -c "$ES_USER" --pidfile "$PID_FILE" --exec $DAEMON -- $DAEMON_OPTS
log_end_msg $?
code..


* http://couchdb.apache.org
* http://wiki.apache.org/couchdb/HTTP_view_API

* http://www.sendung.de/2011-11-11/what-i-learned-about-couchdb/

Searching

* http://lethain.com/full-text-search-in-couchdb-using-couchdb/
* http://www.techfreak.net/2013/11/14/a-couchdb-view-example.html
* http://stackoverflow.com/questions/5285787/full-text-search-in-couchdb
* http://sitr.us/2009/06/30/database-queries-the-couchdb-way.html
* http://blog.mattwoodward.com/2011/05/string-matching-in-couchdb-views.html
* http://wiki.apache.org/couchdb/Full_text_search?action=show&amp;redirect=FullTextSearch
* http://www.elasticsearch.org/
* https://github.com/rnewson/couchdb-lucene
* https://github.com/elasticsearch/elasticsearch-river-couchdb


* http://www.ncbi.nlm.nih.gov/pmc/articles/PMC3383915/

* http://stackoverflow.com/questions/4298937/couchdb-views-remove-duplicates-and-order-by-time
* http://stackoverflow.com/questions/5571459/couchdb-view-query-with-multiple-key-values



h2. Book

* http://guide.couchdb.org
** http://guide.couchdb.org/editions/1/en/index.html

* http://guide.couchdb.org/draft/documents.html
* *Pagination*
** http://guide.couchdb.org/draft/recipes.html


http://guide.couchdb.org/draft/tour.html
https://pythonhosted.org/CouchDB/mapping.html
http://stackoverflow.com/questions/4773069/sorting-dates-in-couchdb-views


For easier searching, it's best to install Lucene

* https://github.com/rnewson/couchdb-lucene
* http://www.slideshare.net/martin.rehfeld/couchdblucene
* http://www.spaceinvade.rs/2014/07/23/CouchDB-Lucene-integration/
* http://lucene.apache.org/core/2_9_4/queryparsersyntax.html


couch.js
https://github.com/halorgium/couchdb/blob/2c5f780d8284be5e2cb39f7f61acc5ef8d6fb50d/share/www/script/couch.js



Installed CouchDB on Oct 10, 2014.

@apt-get install couchdb@

It installed version 1.0.1.

Version 1.6.1 is available.

https://github.com/rnewson/couchdb-lucene

hr.

https://launchpad.net/~couchdb/+archive/ubuntu/stable

bc. # install the ppa-finding tool
# for 12.04 release
sudo apt-get install python-software-properties -y

bc. # for 14.04 release
sudo apt-get install software-properties-common -y

bc. # add the ppa
sudo add-apt-repository ppa:couchdb/stable -y

bc. # update cached list of packages
sudo apt-get update -y

bc. # remove any existing couchdb binaries
sudo apt-get remove couchdb couchdb-bin couchdb-common -yf

bc. # see my shiny goodness - note the version number displayed and ensure its what you expect
sudo apt-get -f install
sudo apt-get install -V couchdb

bc. # manage via upstart
sudo stop couchdb
  couchdb stop/waiting

bc. # update /etc/couchdb/local.ini with 'bind_address=0.0.0.0' as needed
sudo start couchdb
  couchdb start/running, process 17422

bc. # check version
couchdb -V
    couchdb - Apache CouchDB 1.6.1

Good. Up to date. Oct 10, 2014


old post:
http://blog.woobling.org/2009/05/why-i-dont-use-couchdb.html


h2. Perl

http://search.cpan.org/dist/CouchDB-Client/lib/CouchDB/Client.pm

The above main module is outdated or oldish, 2009.

http://cpanratings.perl.org/dist/CouchDB-Client

bq. _"Generally, when I have a choice I prefer AnyEvent::CouchDB."_

http://search.cpan.org/~beppu/AnyEvent-CouchDB- 1.31/lib/AnyEvent/CouchDB.pm - (2011)

@perl -MCPAN -e 'install CouchDB::Client'@

Installed above Perl module on Oct 10, 2014. It took under one minute to install, unlike the nearly 10 minutes to complete the install of the MongoDB Perl client module.


h3. Jan 2015

* DB::CouchDB 
** http://search.cpan.org/~zaphar/DB-CouchDB-Schema-0.3.04_remove_blib/lib/DB/CouchDB.pm

* Store::CouchDB
** http://search.cpan.org/~norbu/Store-CouchDB-3.8/lib/Store/CouchDB.pm
** https://github.com/norbu09/Store-CouchDB
** https://metacpan.org/pod/Store::CouchDB
*** installed on Jan 13, 2015
*** had to manually download and install Types::Serialiser too. this module is used by Store::CouchDB




h2. Commands

http://wiki.apache.org/couchdb/Complete_HTTP_API_Reference

CouchDB is API, HTTP, REST, JSON, and JavaScript driven.

in the file @/etc/couchdb/local.ini@ set and uncomment the lines:
@port=5984@
@bind_address=127.0.0.1@

http://en.wikipedia.org/wiki/CouchDB

h3. Accessing server information

curl http://127.0.0.1:5984/

Reponse:
@{"couchdb":"Welcome","uuid":"2c6d440df9b206a8592c4f5db6f4e38a","version":"1.6.1","vendor":{"name":"Ubuntu","version":"12.04"}}@


h3. Creating a database

Creating a database named wiki

curl -X PUT http://127.0.0.1:5984/wiki

Response:
@{"ok": true}@


br. Attempting to create a second database named wiki

curl -X PUT http://127.0.0.1:5984/wiki

Response:
@{"error":"file_exists", "reason":"The database could not be created, the file already exists."}@


h3. Get database info

Retrieve information about the wiki database &#9;

curl http://127.0.0.1:5984/wiki

@{"db_name":"wiki","doc_count":0,"doc_del_count":0,"update_seq":0,"purge_seq":0,"compact_running":false,"disk_size":79,"data_size":0,"instance_start_time":"1412965274017838","disk_format_version":6,"committed_update_seq":0}@


h3. Create a document

Create a document, asking CouchDB to supply a document id

curl -X POST -H "Content-Type: application/json" --data @'{ "text" : "Wikipedia on CouchDB", "rating": 5 }'@ http://127.0.0.1:5984/wiki

Response
@{"ok":true,"id":"eadaefc9769de77b098009cfae000ef6","rev":"1-80fd6f7aeb55c83c8999b4613843af5d"}@


h3. Retrieve a document

curl http://127.0.0.1:5984/wiki/eadaefc9769de77b098009cfae000ef6

Response
@{"_id":"eadaefc9769de77b098009cfae000ef6","_rev":"1-80fd6f7aeb55c83c8999b4613843af5d","text":"Wikipedia on CouchDB","rating":5}@


h3. Update document

http://wiki.apache.org/couchdb/HTTP_Document_API#PUT

curl -X PUT -H "Content-Type: application/json" --data @'{ "text" : "Wikipedia on CouchDB", "rating": 0, "_rev":"1-80fd6f7aeb55c83c8999b4613843af5d"}'@  http://127.0.0.1:5984/wiki/eadaefc9769de77b098009cfae000ef6

Response
@{"ok":true,"id":"eadaefc9769de77b098009cfae000ef6","rev":"2-5ba469fb0677c7293baab0403c478fd2"}@


h2. Etc.

*[X]* http://guide.couchdb.org/draft/cookbook.html

*[X]* http://guide.couchdb.org/draft/views.html

http://stackoverflow.com/questions/2923063/searching-by-key-in-apache-couchdb

http://sitr.us/2009/06/30/database-queries-the-couchdb-way.html



h2. Apr 22, 2015

code.curl -X PUT '127.0.0.1:9200/_river/scaupdvlp1/_meta' -d '{ "type" : "couchdb", "couchdb" : { "host" : "localhost", "port" : 5984, "db" : "scaupdvlp1", "filter" : null }, "index" : { "index" : "scaupdvlp1", "type" : "scaupdvlp1", "bulk_size" : "100", "bulk_timeout" : "10ms" } }'
code..

returned

code.{"_index":"_river","_type":"scaupdvlp1","_id":"_meta","_version":1,"created":true}
code..


 #database - #nosql - #json