NoSQL is a meaningless term, and SQL is a query language. The actual database types are relational, key-value/wide-column, document store, graph, search, OLAP/column-oriented, etc.

Any of them will work as long as you can durably store your data. Relational databases have always implemented ACID and SQL which makes them easy to work with, and they can support almost any data model with decades of updates and tooling which is why they are the default choice unless you specifically have other needs. Newer relational databases can also scale horizontally by applying the same sharding techniques as the other database types, so even that issue is no longer relevant.

PostgreSQL all the way down. I know I'm in the minority here.

I doubt you're the minority TBH.

Probably OneTick.