Which embeddable database is better than sqlite?

Question

Database

I'm still tormented by the question of which database to use for the project. sqlite is rather weak for 10,000 records with text and tag search. Mysql mongose ​​postgresql is a lot for theoretically one user. Even on with the docker eats a lot.
You just need a lightning fast search. Delays of more than a second will already be noticeable.
What other databases can be used, light ones that will start on the node.

Answer 1

Yes, there are no special ones, SQlite and, it seems, Firebird can be built-in-portable without a fierce background.
In my opinion, you either have an incorrect statement of the problem, or an incorrect organization of the data, or stupid mother laziness to make the data convenient for quick search.
In addition, there are really, really special solutions for fast full-text search in texts, it is unlikely that there are lightweight embedded solutions among them, ElasticSearch is the same.

Answer 2

With search in the text and tags is in sense full-text search?
Try manticore. https://manticoresearch.com/
But it is unlikely to be embedded. But certainly it will be easier than elastic.

Answer 3

Mysql did not please? The nineties are long gone.

Answer 4

Alternatively https://github.com/typicode/lowdb
But there is a caveat)

If you have large JavaScript objects (~10-100MB) you may hit some performance issues. This is because whenever you call db.write, the whole db.data is serialized and written to storage.