For me, it's Play + Vue (shameless plug: https://github.com/GIVESocialMovement/sbt-vuefy).
The real time sink is not development. It's ops. Configuring server, making sure it's secure and online at all time, rotating logs, backing up database regularly, no-downtime deployment.
I'm using SQL because it's more flexible than a NoSQL solution. You don't need to plan in advance how to model your data. Just add a new index, and it works decently enough. I can also modify data without building a specialized admin UI.