Re: Lucene database bindings

2005-09-19 Thread mark harwood
>>does it deal w/ aggregate functions and group by >> clauses? Yes, it is basically *all* the normal SQL functionality but with the added option to mix in scores from lucene queries to the criteria. >From the example code: select top 10 count(*) as numAds,pricePounds from ads where pricePounds

Re: Lucene database bindings

2005-09-18 Thread Ray Tsang
I must admit that I have not downloaded the source yet. But a quick question, does it deal w/ aggregate functions and group by clauses? Thanks! Ray, On 9/17/05, markharw00d <[EMAIL PROTECTED]> wrote: > >>Basically your lucene_query function will return a true/false in one > of the query predica

Re: Lucene database bindings

2005-09-17 Thread markharw00d
>>Basically your lucene_query function will return a true/false in one of the query predicates for each record. Almost, it returns a score - much more useful than just a boolean and the key difference between a search engine and a database (partial matching with relevance ranked scores). Thes

Re: Lucene database bindings

2005-09-17 Thread Mag Gam
Mark: VERY VERY good post! Please publish this doc and example. On 9/17/05, Chris Lu <[EMAIL PROTECTED]> wrote: > > On 9/17/05, markharw00d <[EMAIL PROTECTED]> wrote: > > Mag Gam wrote: > > > > >Does your example store the index in the derby db or somewhere else? I > was > > >thinking of index

Re: Lucene database bindings

2005-09-17 Thread Chris Lu
On 9/17/05, markharw00d <[EMAIL PROTECTED]> wrote: > Mag Gam wrote: > > >Does your example store the index in the derby db or somewhere else? I was > >thinking of indexing a table in a seperate column. > > > > > The software is not an org.apache.lucene.store.Directory implementation > ie an FSDire

Re: Lucene database bindings

2005-09-17 Thread markharw00d
Mag Gam wrote: Does your example store the index in the derby db or somewhere else? I was thinking of indexing a table in a seperate column. The software is not an org.apache.lucene.store.Directory implementation ie an FSDirectory alternative for persisting Lucene data in a relational table

Re: Lucene database bindings

2005-09-17 Thread Mag Gam
Does your example store the index in the derby db or somewhere else? I was thinking of indexing a table in a seperate column. On 9/16/05, markharw00d <[EMAIL PROTECTED]> wrote: > > I know there have been some posts discussing how to integrate Lucene > with Derby recently. > > I've added an ex

Re: Lucene database bindings

2005-09-17 Thread Mag Gam
Mark: Thanks for looking at this.I will try it out! On 9/16/05, markharw00d <[EMAIL PROTECTED]> wrote: > > I know there have been some posts discussing how to integrate Lucene > with Derby recently. > > I've added an example project that works with both HSQLDB and Derby > here: http://issues.a

Lucene database bindings

2005-09-16 Thread markharw00d
I know there have been some posts discussing how to integrate Lucene with Derby recently. I've added an example project that works with both HSQLDB and Derby here: http://issues.apache.org/jira/browse/LUCENE-434 The bindings allow you to use SQL that mixes database and Lucene functionality i