about me

I'm a 34'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 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.searchparams[: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?

Name:

Email:

Location:

URL:

Remember my personal information

Notify me of follow-up comments?

Submit the word you see below:


RailsConf 2008 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.

recommend me!

Search

You Can Find Me

@ github.com
@ twitter.com

My Wishlists

@ Amazon.com

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, Fred, 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.