> why everyone seems to have moved away from 1 big SQL database
Hacker News is probably not representative of the whole tech ecosystem. I think a majority of applications still uses one big SQL database.
I recently released an open-source framework [1] that is entirely based on Data-Oriented Design. I have received a lot of comments from people for whom it was the right design. Having all your data in the same place makes so many things easier!