Also Also Wikout

Aaaand - if I use Xapian - which I shall - the Minx database need not support full-text indexing.  So for instance PostgreSQL, which I rejected because its full-text indexing is hideous, becomes viable again.

Actually, PostgreSQL's full-text indexing is no more arduous or inelegant to implement than Xapian's, and perhaps nearly as flexible.  The difference is that Xapian lives off to one side of your database, doing search-y stuff and nothing else, and doesn't clog up your tables or your SQL.  The PostgreSQL full-text search, by working exactly the same way, turns the virtue of integration into a vice.  The pre-computed search terms field that you need for the full-text index is present in both, but in Xapian it's out of the way and doesn't bother you.

And that really does matter.

Posted by: Pixy Misa at 12:55 AM | No Comments | Add Comment | Trackbacks (Suck)
Post contains 136 words, total size 1 kb.