Full-text searching #155

New issue

Open

opened 2019-03-02 14:28:25 -05:00 by jking · 0 comments

jking commented

2019-03-02 14:28:25 -05:00

Owner

The following would be required to implement full-text searching in The Arsse:

An implementation for SQLite
An implementation for PostgreSQL
An implementation for MySQL
A means of disabling full-text indexing to conserve space or processing time
A basic LIKE-based fallback if the feature is disabled or unavailable for SQLite, already done

The implementations would need to handle not only querying, but also populating the index when articles are added, as well as cleaning it up properly (if necessary) when articles are deleted.

All databases should have an implementation before a release with full-text searching is made.

The following would be required to implement full-text searching in The Arsse: - An implementation for SQLite - An implementation for PostgreSQL - An implementation for MySQL - A means of disabling full-text indexing to conserve space or processing time - A basic `LIKE`-based fallback if the feature is disabled or unavailable for SQLite, already done The implementations would need to handle not only querying, but also populating the index when articles are added, as well as cleaning it up properly (if necessary) when articles are deleted. All databases should have an implementation before a release with full-text searching is made.