What DB to choose for storage of lines?

Question

Database

There are, let's say, 100 million lines of the form

Otherwise you are splitting on the regex ., which means "any character".

or

Note the double backslash needed to create a single backslash in the regex!

that is, these are ordinary strings, I plan to store in a varchar (255) column
which database is better to choose for a quick search? Is it beneficial in this case to use the sphinx in conjunction for full-text search?

Answer 1

for full-text - specialized Sphinx Search, etc., yes, it makes sense.
to search from the beginning of the string - any NoSQL, any SQL.
100 million is nonsense for modern DBMS.

Answer 2

elasticsearch

Answer 3

Sphinx is best
for search like LIKE '%keyword%' sharpened by clickhouse