How have a fulltext and query search with couchdb?23.06.16

you can use couchdb-lucene

couchdb 1.6.1
os: debian  jessie
java: openjdk-8-jdk )
compiler: maven

1.
download the couchdb-lucene from 
https://github.com/rnewson/couchdb-lucene/blob/master/README.md
or
https://github.com/rnewson/couchdb-lucene/releases/tag/v1.1.0
(in this test only v1.1 was working)

once downloaded and unzipped enter into the folder and compile it with the simple command:
mvn

2.
after compiling you have a zip file under target, than unzip the this dist zip file into any location of your os

3.
set write permission to the folder indexes inside the unzipped file

4.
inside the folder start it with simple command of: bin/run
you will see like:
[Main] Accepting connections with SelectChannelConnector@localhost:5985

than the couchdb-lucene app is waiting on port 5985 for couchdb

5
for the couchdb,
adjust the default.ini or local.ini of your couchdb config file

os_process_timeout=60000

[httpd_global_handlers]
_fti = {couch_httpd_proxy, handle_proxy_req, <<"http://127.0.0.1:5985">>}

6.
restart couchdb 
/etc/init.d/couchdb

7
in your couchdb database create a search view like:

{
   "_id": "_design/search",
   "fulltext": {
       "by_code": {
           "index": "function(doc) { var ret=new Document(); ret.add(doc.av0_code); return ret }"
       },
       "by_desc": {
           "index": "function(doc) { var ret=new Document(); ret.add(doc.av0_description); return ret }"
       },
       "filter": {
           "index": "function(doc) { var ret=new Document(); ret.add(doc.av0_gauge,{'field':'gauge'});ret.add(doc.av0_length,{'field':'length'}); return ret }"
       }
   }
}

8.
test it with
http://localhost:5984/_fti
you should see:
{"couchdb-lucene":"Welcome","version":"1.1.0"}

9.
test a query like
http://localhost:5984/_fti/local/sl_style/_design/search/filter?q=gauge:%281.6%20||%202.0%29%20+%20length:8.0

10.
checkout the lucene queries and examples at 
https://dotcms.com/docs/latest/content-search-syntax

http://foaa.de/old-blog/2011/05/squeeze-couchdb-lucene/trackback/index.html#lucene

Anonymous

23.06.16

http://supervisord.org/

Anonymous

How have a fulltext and query search with couchdb?23.06.16

Information Epoch 1714892495