[Xapian-discuss] databases stored in MySQL

tata 668 tata668 at gmail.com
Thu Jun 8 15:44:05 BST 2006


Thanks for the quick reply!

I guess I'll stick with it as it is!

JL



----- Original Message ----- 
From: "Olly Betts" <olly at survex.com>
To: "tata 668" <tata668 at gmail.com>
Cc: <xapian-discuss at lists.xapian.org>
Sent: Thursday, June 08, 2006 10:38 AM
Subject: Re: [Xapian-discuss] databases stored in MySQL


> 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 




More information about the Xapian-discuss mailing list