How to make a database search with the output of results as you enter a query?

I

ilnovikov2020-12-30 09:36:55

Database

ilnovikov, 2020-12-30 09:36:55

I have a small database of 20 products. I want to write keywords for each and make a search page for these products based on the keywords. At the same time, these products do not and will not have pages on the site, only names and properties in the database. They need to be put on cards.
It would be nice if product cards are displayed as you enter a request, as on https://www.artlebedev.ru/search/
What are the ready-made solutions for such a task?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

M

mayton2019, 2020-01-02
@mayton2019

The database is not suitable in such cases. She is not able to index "by keywords". And LIKE expressions usually give bad execution plans because the target is in the middle of the line. The classic base index does not work in such cases. You can try an offline product index using Apache Lucene. But this will require some effort to prepare and update such an index. Roughly speaking, it must be constantly synchronized with new products.