Thanks for the insight @aixnr! We still recommend redis as the default storage engine, especially for small forums, as it was what NodeBB was originally built against. MongoDB is supported just as well as Redis, so there is no fear of it ever being deprecated or considered a second-class citizen when it comes to support.
As for those stats you were asking about:
139.08MB memory used in Redis
@damien123 No additions needed, NodeBB loads the same whether you navigate to it "cold" (that is, directly via url), or locally via SPA interface. You can see that by viewing the page's source. It's indexable/crawlable.
If you're migrating, I'd encourage you to set up redirects so your links to existing topics/categories are not lost, but otherwise, you should be good to go.
Not really sure what all the hype about mongodb/redis lately is, if you can use well tested sql databases.
MongoDB is well tested too. But beyond being super stable, it is screaming fast - far faster than any relational database, it has amazing sharding properties, it speaks native JSON, it is getting a massive amount of active development, it is considered the native database for Node.js on which NodeBB is built and it scales like crazy.
Now the big one.... when using Node... those "well tested sql databases" are not well tested. MongoDB is far more stable and tested than any of them and, in fact, lack of highly reliable drivers is a major issue for relational (what you call SQL) databases.
So there are very, very good reasons to use NoSQL, especially MongoDB specifically. Speed, stability, battle tested, native, etc. I'm not actually clear on any upside to using a relational database here. Relationships are nice, but would they add any value at all in an online community infrastructure?
Also, I should note, some online communities that we have dealt with have scaling issues specifically because they eschewed this advice and went with those "well tested" relational databases. Once they grew and got busy they were unable to keep pace and they bogged down and had to throw crazy amounts of money at keeping respectable performance when MongoDB or other similar datastore could have been faster for cheaper.