about me
I'm a 37'ish year old web application developer from South Portland, Maine. I love meeting fellow techies, drop me a line if you want to talk shop.
Categories
acts_as_fulltext_indexed and geokit
Posted on 07/01/2008 at 04:43 AM
I created a quick fork on github of the acts_as_fulltext_indexed plugin made by Chris Heald of antiarc.net.
Acts_as_fulltext_indexed addresses a limitation of MySQL’s INNODB table format (which supports transactions but not fulltext indices) by using MySQL’s MYISAM table format (which supports fulltext indices, but not transactions).
Acts_as_fulltext_indexed solves this issue by creating a MYISAM table just for fulltext indexed searching that is separate from your regular INNODB tables. A link back to your main model is created polymorphically, and your models have automatic hooks that create and update these indices on after_save.
My fork simply lets you pass in two additional finder options that Geokit requires, if you are also using Geokit. You would use it as such:
Model.search( params[:search_terms],
{
:origin => etc,
:within => etc,
:conditions => etc,
:order => etc,
:limit => etc
}
)
refer to the original read me here:
http://blog.antiarc.net/2007/05/01/introducing-acts_as_fulltext_indexed/
my fork is at:
http://github.com/CodeOfficer/acts_as_fulltext_indexed/tree/master
Leave a comment?
Please use Pastie or Gist if you need to write code in your comments.
Often times I will release code for free or go that extra distance to help others online. If my skills were useful to you, please consider a small donation. Thank you very much.
You Can Find Me
@ github.com
@ twitter.com
@ calendaraboutnothing
My Wishlists
My Other Sites
Foundation's Edge, RJones Family, We're Not.com (only for staging), Ailee Jones (same as rjones for now)
Friends of Mine
Aaron, Barnaby, Brian, Chris, Dirk, Frank, Four, Justin, Matt, Mike, Monty, Paul, Sean, Travis
IRC Hangouts
I can usually be found lounging on irc.freenode.net while I work, on the following channels: #fauna, #github, #hello-heroku, #jquery, #passenger, #ruby, #rubyonrails, #slicehost, #sproutcore, #textmate, #werenot.