incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Newson <robert.new...@gmail.com>
Subject Re: CouchDB equivalent dynamic SQL
Date Fri, 30 Oct 2009 19:42:55 GMT
fwiw couchdb-lucene 0.5 will have better numeric support.

B.

On Fri, Oct 30, 2009 at 1:59 PM, Adam Kocoloski <kocolosk@apache.org> wrote:
> On Oct 30, 2009, at 1:36 PM, Duy Nguyen wrote:
>
>> Hi guys,
>> I have a troublesome sql query that needs to translate to couchDB
>> map/reduce
>> SELECT * FROM PRODUCTSWHERE [ PRICE ] AND [TYPE]'
>> Please note that Price and Type are dynamically generated depend on user
>> inputs. ( i.e TYPEcan be 100 < PRICE < 1000, or 1 < PRICE < 100, or 1000
<
>> PRICE < 10000. TYPE could be 'computer' , 'tv' etc..)
>> I can not do dynamically query on the fly with CouchDB. what is the best
>> way to solve this problem ?
>
> Hi Duy, it won't always be a perfect translation.  But CouchDB's compound
> view keys should be able to help you in this situation.  In your map,
> emit([doc.type, doc.price], null) and then query the view with
>
> ?startkey=["computer", 1000]&endkey=["computer", 10000]&include_docs=true
>
> or
>
> ?startkey=["tv", 100]&endkey=["tv", 1000]&include_docs=true
>
> Best, Adam
>
>

Mime
View raw message