tag:blogger.com,1999:blog-5160001102716841899.post3785157294590784769..comments2020-10-23T23:29:25.280+03:00Comments on The Affinax Project: Live fuzzy search using n-grams in RailsSteve Ruttenberghttp://www.blogger.com/profile/09875544429370940477noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-5160001102716841899.post-806646078407901542009-12-17T01:20:23.868+02:002009-12-17T01:20:23.868+02:00Looks great Sandy! And great find regarding databa...Looks great Sandy! And great find regarding database query reduction using the detect method to sort the objects. I already tested it on an app in development and changed the sample code in the post accordingly. Awesome!Steve Ruttenberghttps://www.blogger.com/profile/09875544429370940477noreply@blogger.comtag:blogger.com,1999:blog-5160001102716841899.post-74221425704532510312009-12-16T20:39:15.301+02:002009-12-16T20:39:15.301+02:00Thanks for the great post Steve! I have a website ...Thanks for the great post Steve! I have a website listing music events where searching for odd band/artist names, venues and towns used to be a real problem (eg. is that 'Deadmaus' or 'Deadmau5' your looking for..?)<br /><br />Anyways, using trigrams works a treat even with over 200,000 rows. I also found <a href="http://railsforum.com/viewtopic.php?id=29574" rel="nofollow">with some help</a> that I could reduce the number of hits on the object table for each request down to 1 and still preserve the rank order.<br /><br />You can see it in action with the 'Browse artists, bands and events' and 'Find events near you' search boxes at <a href="http://www.gigcatcher.co.uk" rel="nofollow">http://www.gigcatcher.co.uk</a><br /><br />Cheers!Unknownhttps://www.blogger.com/profile/04522124294009569399noreply@blogger.comtag:blogger.com,1999:blog-5160001102716841899.post-84373183427431060392009-06-09T12:25:58.998+03:002009-06-09T12:25:58.998+03:00Check No Fuzz, a Rails-plugin for ActiveRecord ins...Check No Fuzz, a Rails-plugin for ActiveRecord inspired by this post (<br />http://github.com/Chrononaut/no_fuzz/tree/master).Babarhttps://www.blogger.com/profile/11721336014630563207noreply@blogger.comtag:blogger.com,1999:blog-5160001102716841899.post-45213070382590468632009-04-30T13:39:00.000+03:002009-04-30T13:39:00.000+03:00A bit late maybe, but I've created a plugin for th...A bit late maybe, but I've created a plugin for this with generators etc. Its available at GitHub: http://github.com/Chrononaut/no_fuzz/tree/master<br /><br />I'm sure you'll have ideas for improvement etc - I'll gladly add you to the repos if you want to add things.Bjørn Arild Mælandhttps://www.blogger.com/profile/18215577894638007872noreply@blogger.comtag:blogger.com,1999:blog-5160001102716841899.post-80306405157525864502008-11-09T22:10:00.000+02:002008-11-09T22:10:00.000+02:00Anyone want to help me turn this into a plugin wit...Anyone want to help me turn this into a plugin with proper generators to create the migration and possibly the autocomplete code?Steve Ruttenberghttps://www.blogger.com/profile/09875544429370940477noreply@blogger.comtag:blogger.com,1999:blog-5160001102716841899.post-5736972865754656632008-11-09T22:03:00.000+02:002008-11-09T22:03:00.000+02:00hboon: I've refactored and enhanced the autocomple...hboon: I've refactored and enhanced the autocomplete code a bit, and am now using jquery. For a current project I am testing with 54,000 trigram rows and it is blazing fast with one hit on the trigram table, and 10 hits on the object table per autocomplete ajax request. I'll test it with more data shortly.Steve Ruttenberghttps://www.blogger.com/profile/09875544429370940477noreply@blogger.comtag:blogger.com,1999:blog-5160001102716841899.post-41102890121331921812008-11-07T05:48:00.000+02:002008-11-07T05:48:00.000+02:00How many items did you manage to take this to? I'm...How many items did you manage to take this to? I'm digging around for a lightweight n-gram lookup library/tool. Sphinx seems lightweight and scalable enough, but it doesn't do n-gram unfortunately.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5160001102716841899.post-55621980391673250632007-12-25T17:53:00.000+02:002007-12-25T17:53:00.000+02:00Cool !! Thanks.Cool !! Thanks.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5160001102716841899.post-57230218460734400072007-12-25T10:36:00.000+02:002007-12-25T10:36:00.000+02:00Thanks. If you've made an autocomplete before - it...Thanks. If you've made an autocomplete before - it should be fairly simple to 'upgrade' it. Yes, it's implemented on our 'stealth' test site. What was your last question?Steve Ruttenberghttps://www.blogger.com/profile/09875544429370940477noreply@blogger.comtag:blogger.com,1999:blog-5160001102716841899.post-85191731983163220242007-12-25T00:04:00.000+02:002007-12-25T00:04:00.000+02:00Wow man,A really good post..I will try your method...Wow man,<BR/>A really good post..<BR/>I will try your method tomorrow..<BR/>Did you implemented this somewhere?<BR/>Where from the idea for Rails?Vitaly Gorodetskyhttps://www.blogger.com/profile/05452712103876830274noreply@blogger.com