Since the Sphinx 0.9.9 release now seems to support MS SQL I spent a weekend trying to figure out how to write an MS SQL adapter for TS. I didn't quite get to the end, but I think I managed to figure out the hardest part, which was the GROUP_CONCAT function.
This function does not exist in MS SQL, and it's not easy to implement in T-SQL either (I spent quite a lot of time surfing through many different proposed solutions). It CAN be implemented in T-SQL, but not in a way that is compatible with the way TS expects the method to be called. So in the end I implemented it as a .NET C# library for SQL Server. It's quite easy to install it, and once you've done that it gives you both GROUP_CONCAT (as dbo.GroupConcat), and a CRC32 function (dbo.Crc32). But I need some help to get the final bits polished. I'm not quite sure how to integrate the code into TS. Is there someone interested in helping with the final bits? I put the code here: http://multivac.dyndns.org/thinking-sphinx/ Both the Ruby adapter code, the DLL, and the Visual Studio project is included. A README with installation instructions is also there. Please ask questions here, or e-mail me and I will try and help as much as I can..it's like...90% done. Just need someone who knows a bit of the TS architecture and we have some Sphinx goodness for MS SQL. Casper -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
