[Xapian-discuss] best practices - combining sql database and xapian, size of database?

[Olly Betts]

On Fri, Apr 16, 2010 at 11:18:00AM +0200, Per Jessen wrote:
> - each of my documents come with a set of attributes. These are easily
> stored and indexed in a sql database, but I'm not quite sure how I
> would combine a sql database lookup with a xapian query?  AFAICT,
> xapian also has mechanism for associating attributes with a document,
> might that be the right approach?

If you use Xapian 1.1.x (or shortly 1.2.x) another option is to dynamically
combine the results of an SQL query and a Xapian query by subclassing
Xapian::PostingSource:

http://trac.xapian.org/browser/trunk/xapian-core/docs/postingsource.rst

Cheers,
    Olly