Good php search by sqlite database?

Question

PHP

There is a database (sqlite). And there are 25 thousand records. The name of the music and the text of the song for the telegram bot are stored. The bot itself is written in php. There search, type LIKE %%.

I looked at the logs there, people write the name of the music several times. Are there any normal search engines to work when there are minor errors in the query.

Answer 1

In such cases, IMHO, you should implement a phonetic search. Here is an article on Habré .
The dmstring function using the Daitch - Mokotoff Soundex phonetic algorithm will modify the search query into code. Examples from a post on Habré:

dmstring('Арнольд Шварцнеггер') == dmstring('Arnold Schwarzenegger') == 096830 479465
dmstring('Орнольд Шворцнегир') == dmstring('Arnold Schwarzenegger') == 096830 479465

Those. given that the requests are written differently, the phonetic code of both is the same. Here you will search for this code.

Answer 2

SQLite supports full text search.
Getting Started with SQLite Full-text Search

Answer 3

It is not recommended to implement full-text search on MySQL
. For this, ElasticSearch and the like are more suitable.
It is better to immediately study this technology, since then when there are a lot of records, the search will become slow.