In what cases should preference be given to storing information in files rather than in a database?

Question

Database

Or, in all cases, when it comes to non-program code, should the database be preferred?
Can there be any benefit in storing only indexes to files with information in the database? If yes, in what cases?

It is about text information.

Answer 1

Databases have a size limit, it's bad to shove any garbage in there.
A file is a file. It is as simple as 3 kopecks, it is backed up and restored as well.
In the base you are at least dancing with a tambourine. Well, you will lose in efficiency every 5 times.
Another question is that the file is always available to you, there is no overhead for extraction and so on, your server simply gives it away.
Your indexer just indexes it, you just delete it. And you don't have to SHIN if you know what I mean.

Answer 2

In what cases should preference be given to storing information in files?

When it comes to the configuration of the application, about a meager number of files and at the same time there are no relationships between entities. When there is no simultaneous change in the state of the contents of files by different processes.