Results 1 to 12 of 12
  1. #1
    Join Date
    Jan 2008
    Posts
    2

    Building a Recipe Database

    My fiance is attending Culinary School in the fall. She and her family have tons of recipes. I'd like to try to build a database of the recipes. Then have it accesible through a simple..very simple web app on their home network..where you can search through recipies and add new ones. How hard would this be?..All I have right now is Access... any help woudl be appreciated

    Blake

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    it would not be hard at all -- try it

    feel free to come back and ask any questions you might have if you get stuck
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Depends on how complex you want to get.
    Simply storing the recipes is easy. Adding in functionality such as scaling ingredient quantity to make different numbers of servings, coding and translating our arcane system of English weights and measures, or trying to track calories per serving can make your application more complex.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    This is a simple online one that I use. The recipes are clearly stored as a sinlge textual record and then the person submitting it provides a name and some tags. Searches are on the name and the tags. As you can see, simple it is, accurate it ain't:
    http://fooddownunder.com/cgi-bin/search.cgi?q=hearts

    It doesn't help you technically but might give you an idea of just what sort of scope you want for this database.

  5. #5
    Join Date
    Aug 2003
    Location
    Toronto, Ontario, Canada
    Posts
    203
    Set up a database where you store the meal type, ingredients, cooking time, and whatever other factors are important as keys with the associated recipes.

    So then, if you want to find something that can be made in 1/2 hour, you can look up "Dinner" and ":30" (the two keys) and see all the "hits" (matching TXT files).
    When it rains, it pours.

  6. #6
    Join Date
    Jan 2008
    Posts
    2
    Well i dont plan on it being too complex at all. I'd just like it to store the recipe (name. ingrediants, directions, person who submitted it, and then tags to search by) then also be able to add one simply and a simple search. Im just nto sure where to start at all... in class we made faux video rental databases and library ones but nothing like this even though it seems way easier lol

  7. #7
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by emglespaul85
    in class we made faux video rental databases and library ones
    as you so aptly said, "lol"

    recipe databases seem to be very popular too

    in fact i worked on one last year -- site visitors enter ingredients they have on hand, the database suggests what you can prepare with them, visitors enter their favourite recipes, etc...

    but if you think the video store or library databases were hard, i have news for you, recipes is harder

    songs, tracks, albums, and artists is pretty much the toughest design that young web entrepreneurs tackle on their own before breaking down and bringing in the hired help
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  8. #8
    Join Date
    Nov 2011
    Location
    South Carolina
    Posts
    4

    Sample

    This is a sample database that I have used and am in the process of tailoring for my needs that may help you in your quest. You can set up a page from this to have someone edit online but I am not that advanced.

    Attached Files Attached Files

  9. #9
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by steeleace View Post
    ...that may help you in your quest.
    the original poster stopped waiting for a solution approximately four years ago
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  10. #10
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Rudy,
    Information provided long after the fact may still be relevant for people searching for answers.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  11. #11
    Join Date
    Jan 2012
    Posts
    3
    Quote Originally Posted by blindman View Post
    Rudy,
    Information provided long after the fact may still be relevant for people searching for answers.
    Like me :-) Every time I start a new diet I think about creating a recipe database to match it...

  12. #12
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Me too. I labor under the delusion that losing wait is simply a matter of properly organizing my caloric intake in normalized form.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •