I’ve been looking for a site that allows me to track not just what groceries I buy but do wacky analysis on the data like how much am I spending per carb calorie. Dumb, I know but I’m think I’m going to work on it.
I work all day with Magento and barely understand its EAV database model so I think I’ll try to design the database something like that.
I’ve been tracking Symfony on and off for a few years and might give that a try.
Some basic information I’ll need to store:
- Size Measurement? (oz, fl.oz, cups, …)
- Transaction ID
- Store ID
- List of items, how many, how much
- Item Count
- Maybe some other info