There's an interesting trend in microservices where there isn't necessarily a single choice. To scale, you may have a SQL database for a subsection of your application, and a NoSQL database for another subsection. To me, this gets very complex, but there's merit to it. One of the benefits is scalability on a fairly massive scale.