There is a goal to do a "live search" on some database of audio recordings. Everything is written in the nodeJS + nginx combination. The project has just started to do, has not yet decided on the choice of database (SQL, nosql, memory).
The database can contain several (tens, hundreds) thousands of records. Each entry can have fields: "name, autor, genre, style", etc. And some other parameters - popularity, popularity among friends, popularity according to interests. At the moment, I am at a deadlock with the choice of a database, where to actually store data about records and the main thing is how to do a super-fast search on them. The condition that the base should not be built into the project will be located on a separate server.
Tell me your thoughts on this, please?