free open-source SQL full-text search engine

Need a hand?
+1-888-333-1345

Sphinx

Community

Services

Misc

 Subscribe in a reader

Tracked by ClickAider

News entry

Jan 28, 2008. 0.9.8 dev news: more features, and MySQL UC

Jan 28, 2008 - 0.9.8 dev news:

Thanks to everyone who sponsored the development, this update delivers quite a few nice new features again.

  • added sorting by arbitrary expressions in run time (eg. "@weight+log(price)*2.5"; currently supports abs, ceil, floor, sin, cos, ln, log2, log10, exp, sqrt, min, max, pow, if);
  • added group-by on MVA support, and SetArrayResult() to PHP API;
  • added ordinal sorting with fixed RAM requirements;
  • added field sets syntax (ie. "@(field1,field2) hello @!(field3,field4) world"), and @@relaxed option to query language;
  • added libxml2 support (experimental; must be manually enabled in source for now);
  • added ignore_chars option (to fully ignore in-word characters such as soft hyphenation);
  • added wordcount ranker (SPH_RANK_WORDCOUNT);
  • added workaround for full 32-bit values vs. php 5.2.2+ vs. x64 platform;
  • added iconv support to xmlpipe2.

As usual, there was a number of fixes as well. Two most important ones are that wordforms now reuse charset_table and other index settings (they did not); and that Sphinx compiles on BSD-style systems out of the box again (hotfix for r1065 was available on the forum). It also looks for expat in /usr/local/ now, so xmlpipe2 support is likely to appear on one's BSD box, too.

I also started unifying and updating the documentation towards the release tag. There's no more semi-official documentation embedded in PHP API source; there's “API reference” section in the official HTML one instead. Volunteer English editors out there, anyone?

And now for something completely different, this year we'll be giving a talk on Sphinx at MySQL UC 2008. I'll also be showcasing Sphinx in DotOrg pavilion again, and the request for Sphinx BoF has been filed, too. UC visitors, you now know what and where to attend.

Our participation in MySQL UC also makes a good occasion for on-site visits to the US locations: being at the same continent simplifies the process a bit, you know. If you're interested in an on-site consulting job, please let me know in advance, before the flight tickets are bought (changing the dates on the flights from Russia to USA and back is, well, not totally impossible but definitely.. challenging).

Permalink // del.icio.us // digg // stumble

Add comment

Name 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.

Name (*)
Email
Website
Comment (*)
9 + 8 = ?
 

Copyright © Sphinx Technologies Inc, 2009