couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Metin Akat <>
Subject Re: Search for city by name, order by population
Date Mon, 12 Apr 2010 09:28:28 GMT
What you need is called couchdb-lucene. All the hacks that try to do
something similar, in my opinion require much more effort.

On Mon, Apr 12, 2010 at 12:20 PM, Sebastian Cohnen
<> wrote:
> you are right, this won't work in your case... but I'm not sure if this is easily solvable...
> On 12.04.2010, at 11:19, Magnus Ottosson wrote:
>> Are you sure about that?
>> Wouldn't [name, population] first order the cities by name and if
>> there are more than one city with the same name they would be order by
>> population?
>> Magnus
>> On Mon, Apr 12, 2010 at 10:59 AM, Nils Breunese <> wrote:
>>> If you use [name, population] as the key I believe you'll get what you need.
You could query the view like this: ?startkey=["name"]&endkey=["name",{}]
>>> Also check out the article on view collation on the wiki:
>>> Nils Breunese.
>>> ________________________________________
>>> Van: Magnus Ottosson []
>>> Verzonden: maandag 12 april 2010 10:25
>>> Aan:
>>> Onderwerp: Search for city by name, order by population
>>> Hi,
>>> I have a database with the names and population of cities (about 7
>>> million entities). Is it possible, with couchdb, to create a key that
>>> includes both cityname and population where I can search for a name
>>> and get the matching results ordered by the population?
>>> I tried to create a key like [population, name] and search like this
>>> ?startkey=[0, "name"]&endkey=[10000000, "name]&limit=10 but it does
>>> not work like the way I hoped.
>>> Any ideas?
>>> Magnus
>>> De informatie vervat in deze  e-mail en meegezonden bijlagen is uitsluitend
bedoeld voor gebruik door de geadresseerde en kan vertrouwelijke informatie bevatten. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is voorbehouden
aan geadresseerde. De VPRO staat niet in voor de juiste en volledige overbrenging van de inhoud
van een verzonden e-mail, noch voor tijdige ontvangst daarvan.

View raw message