Hi, What do you mean by "third party"? I have to build a search engine (something like fieldA='value1' AND fieldB='valueB' AND ...), and I already use CouchDB. Must I switch back to a more traditional approach with SQL?
regards, Cédric de Saint Martin. On 29 janv. 2010, at 19:23, Alex P wrote: > Agreed. (almost) any time you need a string contains, you'll want lucene. > Range queries are fairly straightforward with standard views (look at > startkey and endkey) but if you need 'and' conditions (or any compound > queries at query-time) you have to go third party. > > On Jan 29, 2010, at 2:16 PM, David Coallier <[email protected]> wrote: > >> On 29 January 2010 11:36, Дмитрий Курилов <[email protected]> wrote: >>> Hi folks, >>> >>> I have a database that contains docs like this one: >>> { >>> 'type': 'order', >>> 'customer_name': 'John F. Smit', >>> 'order_date': '2009-12-18', >>> 'manager_id': 'some id', >>> 'partner_order': 'ZX-M-777218883', >>> 'other_fields': 'There are other fields in document' >>> } >>> >>> I need all documents that match conditions received from web-form (so >>> conditions are unknown). For example: >>> * customer_name string CONTAINS 'Smit' >>> * order_date date BETWEEN '2009-12-01' and '2009-12-31' >>> * manager_id string IS 'manager-21' >>> * partner_order CONTAINS '77232' >>> >> >> >> I would recommend/consider looking at couchdb-lucene >> (http://github.com/rnewson/couchdb-lucene) >> >> -- >> Slan, >> David >
