Databases exist for one reason: data you must not lose.
Best for:
Why? Strong structure + transactions.
Best for:
If accuracy matters (money, legal, reporting) → SQL
If speed and flexibility matter → NoSQL
Choosing a database is a product decision, not a trend.