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

Apr 08, 2009. Sphinx 0.9.9-rc2 is out

Sphinx 0.9.9 branch is officially feature-frozen and we are making 0.9.9-rc2 available. As those who've been following 0.9.x releases should be accustomed to, despite a modest rc1 to rc2 tag change it adds about 30 new features once again. (Wonder if we'll be able to break the spell in 1.x and be less greedy about the version increments.)

The ultimate new feature couple is MySQL binary protocol and SphinxQL query language. Meaning that searchd can now pretend it's mysqld. Meaning that you can use ye good olde mysql command-line client to connect to searchd and fire your queries using regular SELECT syntax! More details are available via that link above.

But wait, there's more. We added ODBC support both on Windows and Linux (through UnixODBC) so you now can connect directly to that Oracle or MS SQL database. We added a bunch of performance counters, IMO they look especially nice when viewed using SHOW STATUS via mysql client program. Strict order operator (aaa << bbb) and field-start and field-end keyword modifiers (^hello world$) were added to full-text query language. GROUP BY now supports aggregate functions (AVG, MAX, MIN, and SUM), accessible both through newly added SphinxQL interface and SetSelect() API call.

Other 20+ features are smaller and these 7 most major ones should be enough to encourage you to get and try it anyway. For the curious, 0.9.9-rc2 change log lists them all along with the bug fixes.

How safe is it to upgrade? Generally, both API and indexes are backwards compatible (for about 2 years now); early adopters roll out intermediate non-public releases on production systems on a rather regular basis; and we never publish releases with known major general issues. And 0.9.9-rc2 is no exception. Of course nobody (except Donald Knuth) can guarantee that his software is absolutely bug free. But what we can guarantee to our customers is that we'll priority fix all bugs that you can repeat. (The keyword here is "priority" as we're gradually fixing all the bugs reports we receive.) So if you're looking for safer production deployment of all the shiny new features, consider support packages. They perfectly cover 0.9.9-rc2.

What's next? We will be fixing issues discovered in rc2 for about 1-2 months from now on before announcing stable release - depending on your feedback. Do send us some! In the meantime, the work on real time updates is progressing, we'll be showing those at MySQL UC 2009. That said, next two planned releases are 0.9.9-release and 1.10.1-alpha, with the one which is the le... the bigger of two goods coming out first.

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

Comments

#1. *Origin | 2009-04-08 00:17:58, anonymous

Спасибо, ребят.

П.С. Чёрт, я только спать собрался.... :)

#2. Pete Spicer | 2009-04-08 02:36:57

Looking mighty fine there, I know this will solve a few problems I've seen in the forums in recent weeks. Can't wait for 0.9.9-release!

#3. rates | 2009-04-08 04:14:04, anonymous

It's time to use Sphinx!

#4. sp | 2009-04-08 08:25:26, anonymous

thank you! sphinx is the best!

#5. cysin | 2009-04-08 10:02:07

Great~~I am trying to make it support Chinese soon~

#6. Devis | 2009-04-08 10:02:21

Thank you shodan, great SphinxQL!

#7. Pavan | 2009-04-08 12:51:55, anonymous

Its Great! Sphinx and Shodan you rock!

#8. Jay Yukes | 2009-04-11 00:26:01, anonymous

built it and deployed to production! thanks for the good work!!

#9. ethaniel | 2009-04-19 09:46:50, anonymous

Это супер, но когда же мы наконец увидем live updates? 2 года ждем погоды :)

#10. David | 2009-05-09 16:38:56, anonymous

Connecting to searchd using the MySQL command-line client (server and client both on Windows) works great, but I can't connect to searchd using the MySQL .Net native client:

MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.Exception: Exception of type 'System.Exception' was thrown. at MySql.Data.MySqlClient.NativeDriver.Open() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlConnection.Open()

This is my connection string:
<add name="sphinx" connectionString="server=localhost; port=3307;pooling=false;" providerName="MySql.Data.MySqlClient"/>

I can't connect using the MySQL GUI Query Browser either. So, I conclude that there's more of the MySQL connection protocol that needs to be implemented before this is really useful.

#11. Joyce | 2009-05-18 15:05:05, anonymous

Eagerly awaiting the real time updating feature

#12. cysin | 2009-06-20 10:23:25

For those who need better Chinese support on sphinx, please visit http://code.google.com/p/sphinx-for-chinese

#13. Jake | 2009-10-30 02:49:40, anonymous

Chinese(zh_cn.utf8) support...I'm waiting for this ..

#14. Jonathan | 2009-10-31 05:05:41, anonymous

I have been dreaming of MySQL binary protocol and SphinxQL query language additions since I first heard of sphinx. That makes an incredible full-text database phenomenal! I will never go back...

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 (*)
8 - 5 = ?
 

Copyright © Sphinx Technologies Inc, 2009