What database to use to store a large amount of text?

Question

Java

Good day.
There is a need to store a huge number of different records in the database, each of which will contain several thousand characters (Russian) - the so-called stories, stories, no matter what you call it.
And so: what DB it is better to use for this purpose? Would a nosql database like mongo work, and if not, why not? And what is better than sql-database? What option would be ideal for this?
Thank you.

Answer 1

No difference. Though in files to store.
But if you need to look, then there is another question.
For full text search - SphinxSearch

Answer 2

Use elasticsearch

Answer 3

mongo will do, but many people have better postgre
FTS now, but there are confirmed tests for Postgre

Answer 4

(from comments on another answer)
"several thousand records" - well, let's take it. for example 9k
"a few <maybe even tens> thousand characters" - well, let's take, for example, 99k in
total, we barely reach 1TB. This is NOT "large (in the literal sense, in terms of its informational size) data." Honestly.
Since you didn't say what criteria the selection is going to be based on, how often new records will be added, and so on, I advise you to keep everything in simple files.