Saturday, April 04
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.
Comments are disabled.
Post is locked.
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.
44kb generated in CPU 0.0445, elapsed 0.1109 seconds.
54 queries taking 0.1028 seconds, 347 records returned.
Powered by Minx 1.1.6c-pink.
54 queries taking 0.1028 seconds, 347 records returned.
Powered by Minx 1.1.6c-pink.