MongoDB is a common example. A user with a profile, photos and settings is stored as a single document instead of in several tables. That makes it easy to keep building without first changing the whole database.
On the other hand, a SQL database is a better fit when the data is connected through many relations, as in a finance system. We choose what fits the data, not what is most fashionable.





