I have tried to search the forums for this one but can’t really find a good topic on it.
I am currently building a website that centers around a calendar and activity cards. When a user presses one of the cards, it should display in the calendar which days this activity was performed.
In order to store this information, I need a database in order to store:
- Login information, the users should be able to login to the page in order to keep track of their progress.
- Their activities, every time an activity is marked on a specific date on the calendar it should be saved in the database. A user can have many activities and perform it at different levels.
I am however completely lost on what database approach to choose for this. I know HTML, CSS and JS and the site I’m currently building on is hosted with node.js and express (I only know the basics of these two as this is my first time using them). My main concern is what database I should choose for this and why. I have a little knowledge about SQL (I’ve been using SQL Server a few times at work) but really want to choose what’s best for the project as well as something that I can use for future projects as well. SQL based? NoSQL? Firebase? There’s so much that my head is going dizzy just trying to find a good first step for this while also combining it with user authentication that I need for this.
Do anyone have some guidelines for me to start at? Some links to help me out? Some do’s and don’ts in this situation? I’m grateful for any advice I can get. Thanks for reading all the way through!