[Xapian-discuss] query

Richard Boulton richard at lemurconsulting.com
Wed Jan 10 10:51:27 GMT 2007


शालिनी (Shalini) wrote:
> Hello All,
>              i m new to xapian .I want to ask that i have database in
> mysql.I want to search in it .Is there any provision with the help of which
> we can do searching over MySQL database or else we can shift the 
> database of
> MySQL into Xapian databasa.
> Shalini

See the "dbi2omega" perl script in the omega application, which will 
dump a mysql table to a format suitable for indexing with Xapian (using 
the scriptindex tool, also in the omega application).  You may need to 
modify this script a little if you have a more complex database than 
that (or possibly create a database view containing the data you want to 
index).

If you need closer integration, you might want to set up triggers to 
cause immediate updates - this is perfectly feasible, but there's 
nothing already written in the Xapian distribution to do this sort of thing.

-- 
Richard



More information about the Xapian-discuss mailing list