Patrick Galbraith (capttofu) wrote,
  • Location:
  • Mood:
  • Music:

I love Sphinx!

Ok, I'm quite Sphyched.

I built the Sphinx Storage Engine, and it appears it'll solve a lot of pain I've had with FT, and gives me integration without having to write a bunch of perl glop to glue results of index searches into subsequent queries.

mysql> SELECT url, content,items_text.title FROM feeds join items using (feed_id) join items_text using (item_id)join items_sph_idx using (item_id) WHERE query='Kowalchik'\G
*************************** 1. row ***************************
url: http://blogsearch.google.com/blogsearch_feeds?hl=en&q=Mike+Kowalchik&ie=utf-8&num=10&output=rss
content: [This is a comment on Blogs I'm enjoying of late from Mike Kowalchik.] Hi Jack, couple of quick things. We have lots of autodiscovery features in our code infrastructure, for example, if you put an HTML page url in the "address bar" in ...
title: Comment from Mike Kowalchik on Blogs I'm enjoying of late
*************************** 2. row ***************************
url: http://blogsearch.google.com/blogsearch_feeds?hl=en&q=Mike+Kowalchik&ie=utf-8&num=10&output=rss
content: Truly great ‘revolutionary’ computing startups are the ones that understand the ideas but more importantly the ‘bigger picture’. It’s the big picture thinking, understanding how the ideas fit into the context of the world as it exists ...
title: Mike Kowalchik sez…
2 rows in set (0.00 sec)

I love this. I can't wait to drop FT indexes..... I can't wait to type the statement and watch it run...!

BTW Sphinx guys: I have a patch for the autconf stuff to build the engine with 5.0.51b (if you don't have it already)
Tags: happiness, mysql, sphinx
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic
  • 1 comment