[Xapian-discuss] databases stored in MySQL

[Olly Betts]

On Thu, Jun 08, 2006 at 10:11:06AM -0400, tata 668 wrote:
> I'd like to know if it's possible to store Xapian's databases inside MySQL?
> Instead of having Xapian to store its databases on the filesystem, can it 
> save them inside MySQL?

Well, it's *possible*, but you'd need to rewrite the low level "read
block" and "write block" calls to store the blocks in MySQL.  People
have talked about doing it with Postgres but I don't know of anybody
who actually has.

Or you could write a new backend which stored information in SQL tables
but none of the high performance search systems use SQL as a backend
(and the full text search features which come with SQL implentations
don't seem to scale particularly well) so I'm not sure it's a good plan.

> I'd like that because it would be easier to make a backup of all my data in 
> one step.

I don't think trying to shoehorn everything into SQL is the right
approach for that.

Cheers,
    Olly