|
free open-source SQL full-text search engine |
|
Sphinx
Community Services Misc
|
News entrySep 19, 2007. 0.9.8 dev news: server moved, geodistance feature addedLast week was especially hectic, with too much time being spent on emergent maintenance tasks. It all started with yet another round of server connectivity outages, which, combined with totally incompetent support, forced us to pull the plug and move everything to another hosting company. Then, as if according to Russian proverb that says “two relocations are equal to one fire”, the move went with its bumps too: most notably, it turned out that Plesk database migration tool drops auto-increment option on all table columns in all databases. Adding insult to injury, my desktop box had been hit by a worm which could not be fully cleaned by anti-virus software and I ended up reinstalling the system and software from scratch (system recovery did not work either). The outcome is however nice and sweet. The new box is more powerful, and we also expect better (more stable) connectivity. At least there were no outages at all yet – while as of time of this writing the old box is down again. The new box is in Europe so it also works somewhat faster for me over SSH; hopefully the difference for US Web visitors will be negligible. And, on the sly, Sphinx source repository had been at last converted from CVS to SVN; one more small step towards making it public at some point in future. The last but not least of the things falling in “maintenance” category; I've also created Feedburner-powered Sphinx RSS feed which syndicates this news page. Write it down in your moleskine. But the update would not be complete without a new snapshot. And it comes with a nice new feature again. Enter geodistance. Sphinx now supports float attributes, and is able to compute geographical distance between two points specified by latitude and longitude pairs (in radians). So you now can specify per-query “anchor point” (and attribute names to fetch per-entry latitude and longitude from), and then use “@geodist” virtual attribute both in the filters and in the sorting clause. In this case distance (in meters) from anchor point to each match will be computed, used for filtering and/or sorting, and returned as a virtual attribute too. There also had been several bugfixes, most notably in SphinxSE which should now at least compile with every other MySQL version from 5.0.22 to 5.1.21 (I tested quite a few). Almost feature freeze time... almost. Permalink // del.icio.us // digg // stumble Add commentName and Comment are required; other fields are optional. Email will never be displayed nor transferred nor used for anything else except getting back in touch. Register and then login to skip spambot check and filling your name every time. Sorry, no markup at all for now. |
| Copyright © Sphinx Technologies Inc, 2009 |
