There is a database in most if not all useful cases, but there could also be the actual files separately.

Using a database isn’t some kind of heavy-handed horrendous thing depending on the implementation (e.g., as long as it leaves your content files alone).