Tags

webcam vindaloo version vegan unix unicef trojan todo thinkpad textmate testing tagging syntax svn subversion sphinx spaces solaris sitemap sinatra sheet security search schema_info SchemaInfo ruby rinari relationships refresh rdiff-backup ramaze railsconf08 railsconf07 rails protools production power placeboeffect pink floyd PIC perl overheat outbreak osx os x NYHS NYC netbeans nanophotonics mysql music MPEG-4 model migration microvolunteer macbook mac log linux less leopard keynote JAX javascript java imunizator highlighting Handbrake haml hacks google geocoding genghistron gem gaming gabrielle's funny functional fun friends food fixes fixed firefox FF3 ferret fantasy' emacs DV donate datarecovery database D&D converter conference computing cheat capistrano business bribes

The Decider said on Tue Dec 04 15:18:10 +0000 2007 | permalink
Tagged: search sphinx ferret

Site wide search using mysql

I’m working on a site wide search using only mysql and not ferret or sphinx. I’m not ready to lift the veil but the big picture is:

  • There is a search model and table where with a full text index
  • Each model wishing to participate in searching responds to a callback function to create an index in the search table.
  • Each model has a view that displays their results.

Anyone interested? So far the speed is very impressive and you don’t need to launch any additional daemons like sphinx and ferret require.

Back to work.