Implement full-text search

[passiomatic]

Sometimes there's the need to quickly find out a feed or entries by looking up their title or content.

Possible implementation

Peewee has and extension to activate full-text search with SQLite but AFAIK none with MySQL. This poses the problem to implement the search mechanism across at least to SQLite and MySQL. Using Whoosh could be a viable solution.

Each time a entry is added to the database Whoosh database is updated too. An existing Coldsweat installation could be updated una tantum via a sweat subcommand.

Previous work

• https://pypi.python.org/pypi/Whoosh/
• Bottle Fever has a prototype implementation of full-text search within entries using whoosh.
• Peewee full-text search with SQLIte docs
• There is also some basic support for Peewee full-text search with MySQL