passiomatic / coldsweat

Web RSS aggregator and reader compatible with the Fever API
MIT License
146 stars 21 forks source link

Implement full-text search #50

Open passiomatic opened 10 years ago

passiomatic commented 10 years ago

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