April 26, 2024

How to represent weekly frequency in express/sql db

I am trying to build a habit tracker app like this one, https://tryconfetti.io, but I am struggling to figure out how to do the weekly frequency. For example, if I want to workout Monday, Wednesday, Thursday and Saturday, how do I store that in a database? If it was a range of days like Airbnb does it, for example Monday-Wednesday, I could do a starting_day and ending_day and use DateTime, but in this case it could be multiple dates and that’s why I am a bit lost.

To summarize, what I want is sort of a weekly dot chart where users can mark off the days they have completed the habit. Any help would be appreciated. Thanks in advanced!

Previous post How to Find Pure CBD Oil for Sale?
Next post CBD in the UK – Benefits, Legal Status, and Where to Buy