This isn't something that TS supports natively just yet - although I'm working on it for TS 3.0 (current edge branch in the git repo).
Riddle does have some helper classes and methods to construct SphinxQL queries, and to connection to Sphinx via the mysql41 protocol, so if you're keen on persisting with this, I'd suggest reading through the code (see Riddle::Query). That said, why not just use MySQL or PostgreSQL instead of SQLite3? -- Pat On 14/01/2012, at 10:19 AM, wrgill999 wrote: > I have Sphinx installed. I'm running Rails with sqlite3. I've utilized > xmlpipe2 for indexing. > The results I get running ThinkingSphinx.search_for_ids seems very > random, and there doesn't seem to be much control to change them. > > If I use mysql to query form the command line (after adding a listener > to the config file for :mysql41), I have much more control and the > results are ordered by weight. > > So my question is how I can query Sphinx using MySQL from within Rails > when I'm using the sqlite3 db adapter for my app data...? > > Thanks! > > -- > 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. > -- 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.
