Addendum: String attributes are a feature of Sphinx 1.10-beta (see http://sphinxsearch.com/docs/manual-1.10.html#conf-sql-attr-string). Sadly, they don't have any function aside from storage and retrieval yet. I haven't checked whether this is planned for 1.10 final (or another future version) but you might want to check back on that.
- C. On Mar 22, 2011, at 12:24 PM, Clemens Kofler wrote: > Hi Nicholas, > > unfortunately, the CRC is a one-way function – there is no way to directly > convert it back to its original string. > > You can see a solution I'm using in https://gist.github.com/881075 (using > MySQL). A product has a brand name (e.g. Adidas) which is CRC'd so it can be > faceted. Note that I've not validated the code (I did cut some unnecessary > stuff) so you might need to adjust a thing or two. Also note that depending > on the size of the queried table (products in this case) this might be slow > as hell. You can, of course, let Postgres perform its wizardry which cached > views, indexed expressions (you could index the resulting CRC values) etc. > > Hope that helps, > - C. > > On Mar 22, 2011, at 12:12 PM, Nicholas Faiz wrote: > >> Hi, >> >> I'm trying to set up a lot of facets for a library catalogue. It's the >> typical faceted search scenario: search 'abc', see n related facets (perhaps >> one called discipline, with a value of 'histories" and 150 matches), the >> user then clicks on histories and expects to see those 150 records. >> >> I've been configuring my facets as attributes, too, with the hope that >> something like the following will work: >> >> Book.facets 'abc', :facet => [:discipline], :with => {:discipling => >> "histories"} >> >> With the attribute/facet discipline set as a string, though, inaccurate >> matching was the result (I'm using Postgres). >> >> After some reading I discovered the CRC type, and by converting the >> facets/attributes to CRCs. I can obtain accurate matches through rails >> console: >> >> Book.facets 'abc', :facet => [:discipline], :with => {:discipling => >> "histories".to_crc} >> >> But the browsing experience is lost as all of the facet names are integers; >> so under the facet discipline I have lists of numbers. >> >> I coded this far into it, thinking there'd be a way to convert from the CRC >> representation for histories to the string representation (it's a Ruby >> encoding, after all). >> >> What are people doing to solve this problem >> >> Cheers, >> Nicholas >> >> -- >> 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. > -- 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.
