Using MySQL’s Full Text Search with Django

[elfs]

It drives me nuts that we in the Django community rely on Solr or Haystack to provide us with full-text search when MySQL provides a perfectly functional full-text search feature, at least at the table level and for modest projects. I understand that not every app runs on MySQL, but mine do, and I’m sure many of you are running exactly that, and

Comments

[wolfwings]

Sadly, most stuff just ignores MySQL's FULLTEXT for a different reason: It only works on MyISAM tables. :-/ InnoDB usage blocks it, and more and more stuff is running/focussing on InnoDB from what I've been seeing since it allows for row-level locking instead of shutting down an entire table to lock it to update it.

This same stuff could be applied to a Sphinx install pretty easilly though, since Sphinx runs a subset of the MySQL command-set for communication with front-end apps.

[en_ki]

Yeah, I like the part where I can have full-text search XOR referential integrity. "Herp a derp", as the kids say.