[Xapian-discuss] Postgres connection

[James Aylett]

On Wed, Feb 21, 2007 at 10:49:05AM +0000, Olly Betts wrote:

> > Presumably what most people want here is something that automatically
> > prod a Xapian application to index/re-index/remove a document (where
> > the data comes out of a number of rows in a number of tables, but is
> > indexed in some fairly straightforward way).
> 
> Stating it at a slightly more abstract level, I think most people just
> want to be able to specify which fields should be "indexed as free text"
> and then have the Xapian index automatically kept in step when changes
> are made to the SQL database.  So it's as easy to use as any built in
> free text search facility is, but faster and better scaling.

That just needs row-level triggers, which postgresql has. Wouldn't be
too difficult.

> > However depending on the application, and how your architecture works,
> > you may be better off putting it inside your ORM layer [2].
> 
> This is harder for us to offer "plug and play" type support for, though
> it's easier to just write the code for yourself.

Absolutely. My point is more that we can probably supply something for
very, very basic use (which is a good idea), but that most people will
quickly move beyond that and need to write it themselves. And it's not
that difficult to do so if you have a decent architecture.

J

-- 
/--------------------------------------------------------------------------\
  James Aylett                                                  xapian.org
  james at tartarus.org                               uncertaintydivision.org