title: Searching with the pyramid framework
body: <p>I'm trying to implement a search function into my website, which is running on pyramid, and I was wondering what is the most efficient way of approaching this problem. I am currently looking into <a href="http://pieceofpy.com/blog/2011/08/05/hooking-up-whoosh-and-sqlalchemy-%28sawhoosh%29/" rel="nofollow">Whoosh</a> and <a href="http://wiki.pylonshq.com/display/pylonscookbook/MySQL+fulltext+search+in+SQLAlchemy+with+safe+query+parameters" rel="nofollow">MySQL full text searching with SqlAlchemy</a>.  I need a fast and simple implementation, and wondering which one would be the best choice.</p>