https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42744
Bug ID: 42744
Summary: Add Database backend for patron search (denormalized
table)
Initiative type: ---
Sponsorship ---
status:
Product: Koha
Version: Main
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Patrons
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
CC: [email protected], [email protected]
Depends on: 42508
Adds a zero-dependency Database backend for patron search using a denormalized
table (patron_search_index) with MariaDB FULLTEXT indexes.
Uses the field-group model: one row per patron per field group, enabling
targeted search and weighted relevance. The same search interface as the ES
backend, selected via the factory classes.
Components:
- patron_search_index table (field-group model)
- Koha::SearchEngine::Database::Indexer::Patrons
- Koha::SearchEngine::Database::Search::Patrons
- Koha::SearchEngine::Search::Patrons (factory)
- Koha::SearchEngine::Indexer::Patrons (factory)
- patron_search_index.pl CLI tool with --backend switch
- Integration tests
starts_with uses LIKE on borrowers columns directly (fast with indexes).
contains uses FULLTEXT BOOLEAN MODE on the index table.
Facet filters and library scoping via standard SQL.
This provides a patron search solution for installations that cannot deploy
Elasticsearch.
Depends on bug 42508.
Referenced Bugs:
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42508
[Bug 42508] Add Elasticsearch patron search feature
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
