Ah, I saw it about a month or two ago when moving Simpy to PostgreSQL
8.0.3. I think I saw mentions of Java inside PostgreSQL in a
development version (8.1.*).
Otis
--
http://simpy.com
--- Dan Armbrust <[EMAIL PROTECTED]> wrote:
> Otis Gospodnetic wrote:
>
> >You may also want to consider Pos
Dave Kor [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 28, 2005 10:44 AM
To: java-user@lucene.apache.org; Andrew Boyd
Subject: Re: Lucene vs Derby (vs MySQL) for spatial indexing
Quoting Andrew Boyd <[EMAIL PROTECTED]>:
> I did a small demonstration application using lucene
Otis Gospodnetic wrote:
You may also want to consider PostgreSQL for a few reasons:
3) it seems that the new
versions let you embed Java directly into the database (perhaps
something like Oracle's Java-embedding thing).
Really? I realize this is off topic, but could you point me to some
d
Quoting Andrew Boyd <[EMAIL PROTECTED]>:
> I did a small demonstration application using lucene's range query and it
> worked fine.
> I didn't use a DB at all
>
>
> "Mosul_Iraq.html", "E043.13535"
> "Mosul_Iraq.html", "N36.33608"
>
> Having the directional (E, W, N, S) worked out well
>
> Andrew
--Original Message-
From: Barry Carter <[EMAIL PROTECTED]>
Sent: Jul 27, 2005 8:42 PM
To: java-user@lucene.apache.org
Subject: Lucene vs Derby (vs MySQL) for spatial indexing
Does Lucene optimize range queries that use Sort and/or limit the number
of hits?
My situation: I have a listing
MySQL has spatial extensions now too.
Your queries lack any free-text criteria so are probably best handled by
a database, not Lucene..
>>In case anyone's interested, I'm writing a zoomable/pannable world map
Save yourself some time. Just use the Google maps API. :-)
__
Barry,
You may also want to consider PostgreSQL for a few reasons: 1) it's
historically known to work well for geo-spatial data, 2) has
GIS/geo-spatial data types and such, and 3) it seems that the new
versions let you embed Java directly into the database (perhaps
something like Oracle's Java-emb
Does Lucene optimize range queries that use Sort and/or limit the number
of hits?
My situation: I have a listing of 2 million cities, with the name,
latitude, longitude, and population of each city. I want to efficiently
find the 50 most populous cities between (for example) latitudes 35.2 and
41
