[Xapian-discuss] databases stored in MySQL
olly at survex.com
Thu Jun 8 15:38:56 BST 2006
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.
More information about the Xapian-discuss