Implement full-text search #50
Description
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