DAB: Search

[chrisvire]

The search feature uses the search_words table in the data.sqlite database. There are columns for when searching with or without accents. There is a column for locations which has the id from the entries table with a weight following the index. The search results should be sorted by weight.

Here is an example:

word	word_no_accents	locations
don't	don't	1330(20) 1644(20) 2743(20) 2753(20) 2810(50) 2967(20) 3089(50) 3140(20) 3149(20)

It should be done in a service worker so that it doesn't affect the performance of the display. There was significant work done for Scripture search. This DAB PWA should use the same type of techniques for good performance and responsiveness to the UI.

The Search UI has check boxes for "Match whole words" and "Match accents and tones". For the later, you should search the word column if checked and word_no_accents if not checked.

[chrisvire]