You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by karl wettin <ka...@snigel.dnsalias.net> on 2004/04/27 11:13:47 UTC
transparent RDBMS layer?
I'm considering writing a transparent RDBMS layer for Lucene using
triggers from the RDBMS (or maybe just patch something like HSQLDB).
Something like this:
CREATE TABLE myTable
(
PK int,
sometext VARCHAR(3000) luceneindex,
someFK int
);
Did anyone else consider this?
--
kalle
---------------------------------------------------------------------
To unsubscribe, e-mail: lucene-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: lucene-dev-help@jakarta.apache.org
Re: transparent RDBMS layer?
Posted by karl wettin <ka...@snigel.dnsalias.net>.
On Sun, 16 May 2004 17:12:09 +0200
karl wettin <ka...@snigel.dnsalias.net> wrote:
>
> Forgot the attachments!
I guess the list don't accept attachments, sorry about that.
<http://snigel.dnsalias.net/snigelwiki/Synchronizing_20HSQLDB_20with_20Lucene>
--
kalle
---------------------------------------------------------------------
To unsubscribe, e-mail: lucene-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: lucene-dev-help@jakarta.apache.org
Re: transparent RDBMS layer?
Posted by karl wettin <ka...@snigel.dnsalias.net>.
Forgot the attachments!
On Sun, 16 May 2004 17:04:47 +0200
karl wettin <ka...@snigel.dnsalias.net> wrote:
> On Tue, 27 Apr 2004 11:13:47 +0200
> karl wettin <ka...@snigel.dnsalias.net> wrote:
>
> >
> > I'm considering writing a transparent RDBMS layer for Lucene using
> > triggers from the RDBMS (or maybe just patch something like HSQLDB).
> >
> >
> > Something like this:
> >
> > CREATE TABLE myTable
> > (
> > PK int,
> > sometext VARCHAR(3000) luceneindex,
> > someFK int
> > );
> >
> >
> > Did anyone else consider this?
>
> Off topic, or just not interesting?
>
> I did how ever created such functionallity using HSQLDB-triggers.
>
> The code is a bit ugly and should be represented as a (HSQLDB trigger
> name) bounded controller class to save the JVM from threads and ensure
> synchronized calls to Lucene.
>
>
> --
>
> kalle
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: lucene-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: lucene-dev-help@jakarta.apache.org
>
>
--
kalle
Re: transparent RDBMS layer?
Posted by karl wettin <ka...@snigel.dnsalias.net>.
On Tue, 27 Apr 2004 11:13:47 +0200
karl wettin <ka...@snigel.dnsalias.net> wrote:
>
> I'm considering writing a transparent RDBMS layer for Lucene using
> triggers from the RDBMS (or maybe just patch something like HSQLDB).
>
> Something like this:
>
> CREATE TABLE myTable
> (
> PK int,
> sometext VARCHAR(3000) luceneindex,
> someFK int
> );
>
>
> Did anyone else consider this?
Off topic, or just not interesting?
I did how ever created such functionallity using HSQLDB-triggers.
The code is a bit ugly and should rather be represented in a late
bounded controller class called from (as in present code) multiple
triggers in HSQLDB to save the JVM from threads and synchronized
calls to Lucene.
--
kalle
---------------------------------------------------------------------
To unsubscribe, e-mail: lucene-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: lucene-dev-help@jakarta.apache.org