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
