My next big project …

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:

Store Info:

  • Address
  • Rating?

Product Info:

  • Brand
  • Servings
  • Size?
  • Size Measurement? (oz, fl.oz, cups, …)
  • Fat
  • Carbs
  • Protein
  • Fiber

Transaction Info:

  • Transaction ID
  • Store ID
  • List of items, how many, how much
  • Item Count
  • Tax
  • Maybe some other info

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.