November 23, 2024
How to represent weekly frequency in express/sql db

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!

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