I'm a frontend developer by trade. I have a new brand personal project that I set up with Create React App. It's running React version 18, and it's written with React hooks (duh). I'm using Base Web as the component library, although I'm not married to it. I'm using Redux for the UI state management.
Now that the UI / UX is starting to take shape, I'm getting more ambitious. I'm ready to grow this from a toy / portfolio piece into a real app. I need a database. I need to have user accounts. I'd like to do some realtime stuff with web sockets, too. I'm pretty rusty at database stuff. My most recent experience was with MongoDB. I used to use MySQL back in the day, so I know SQL basics, though I'm quite rusty. I don't have a strong opinion about SQL vs NoSQL. The nature of the app is a personal organizer with to-dos, calendars, reminders, etc. (Just so you have an idea of the kind of data I'll be working with).
I'm trying to decide on what DB to use and what Node.js framework to use. Express is familiar to me, but it seems a bit dated. I'd ideally like a solution that is "batteries included," as opposed to picking out the various pieces of the backend stack and wiring them up by hand. I'm currently researching HAPI. Given what I've described, can anyone recommend a good stack? Thank you so much!