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.
