Refactor Plans + Workouts #102

New Issue

brandon.presley · 2022-10-28T22:56:45Z

brandon.presley commented

2022-10-28 22:56:45 +00:00

Plans and workouts currently store values as comma delimited strings.
This makes it hard to have StartPlan query the daily count of workouts, without losing the order in which the plan was made.
There are also some other consequences of doing it in this way, like data inconsistency when updating plans.

Plans and workouts currently store values as comma delimited strings. This makes it hard to have `StartPlan` query the daily count of workouts, without losing the order in which the plan was made. There are also some other consequences of doing it in this way, like data inconsistency when updating plans.

brandon.presley commented

2022-10-28 22:57:23 +00:00

We should try instead using join tables and having a many to many relationship for Plans -> Sets

brandon.presley referenced this issue from a commit

2022-10-29 03:39:43 +00:00

Add days, plansDays, days tables

brandon.presley commented

2022-10-29 23:08:49 +00:00

Not sure this ended up saving us anything on performance so I'll close this for now.

brandon.presley closed this issue

2022-10-29 23:08:49 +00:00

Sign in to join this conversation.