I've been a happy NodeBB user for a couple years now, and a big lover of both its design and its performance. However, for a previous project of mine I've had major issues with this platform related to its use of NoSQL databases and the lack of an easy way to integrated it with another CSM / account database. As of today, this issue has become so annoying (for us and for our users!) that we will have to drop NodeBB altogether if we don't find a solution - so here I am asking you a hand!
The situation is simple. I have a PostGreSQL user database that is external to NodeBB. Registration and account management is done through a different website. I want NodeBB to use info from that database for username, passwords and email addresses. Two ways that could work:
Make NodeBB directly pick data from the PostGreSQL database for user accounts. From what I've read, I guess that' a no-go?
Disable registration in NodeBB, then replicate selected data from a SQL database into Redis/MongoDB. Perhaps that's doable, and I'd like to know if any of you has any experience with it and NodeBB.
Thank you all!