Xapian discuss - Jan 2007 - Xapian Search Index Continuous Update

I am new to Xapian.  I have currently looking into Xapian and Lucene.
I have a database in mysql and have a table forum.
Can xapian be configured to update continuously, and provide up to date result? 
Also, could the result made be sorted by time?

Thank You,
Joe

 
---------------------------------
 Get your own web address.
 Have a HUGE year through Yahoo! Small Business.

You can certainly make your own script in pretty much any language to 
accomplish this with Xapian. I have done something similar in php.
Or you can use Omega, but not sure how much coding that entails, I never 
dealt with it myself.

Xapian is an excellent engine, by far the best I have tried myself.

Alec

joe smith wrote:
> I am new to Xapian.  I have currently looking into Xapian and Lucene.
> I have a database in mysql and have a table forum.
> Can xapian be configured to update continuously, and provide up to date
result?  Also, could the result made be sorted by time?
>
> Thank You,
> Joe
>
>  
> ---------------------------------
>  Get your own web address.
>  Have a HUGE year through Yahoo! Small Business.
> _______________________________________________
> Xapian-discuss mailing list
> Xapian-discuss@lists.xapian.org
> http://lists.xapian.org/mailman/listinfo/xapian-discuss
>
>

On Tue, Jan 16, 2007 at 05:42:57PM -0800, joe smith
wrote:
> I have a database in mysql and have a table forum.
> Can xapian be configured to update continuously, and provide up to
> date result?
Yes.

I think you'll either need some sort of update hook called by mysql when
a change if committed (I don't know enough about mysql to know if it
provides this or not), or to add a call to the process which updates the
mysql database, or to just poll the mysql database for changes
frequently.  I'd imagine the same options apply to anything which isn't
actually built into mysql.
> Also, could the result made be sorted by time?
Yes, you just need to store the time associated with each document in
a document "value", then you can choose to sort on that value.

Alternatively, if documents are added in ascending time order, the
raw ordering of the documents can be used.  This often works well
for an archive of news stories, for example.

Cheers,
    Olly