If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Building a Recipe Database

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-17-08, 01:30
emglespaul85 emglespaul85 is offline
Registered User
 
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
Reply With Quote
  #2 (permalink)  
Old 01-17-08, 07:58
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
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
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #3 (permalink)  
Old 01-17-08, 08:31
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
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"
Reply With Quote
  #4 (permalink)  
Old 01-17-08, 08:48
pootle flump pootle flump is offline
King of Understatement
 
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
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.
Reply With Quote
  #5 (permalink)  
Old 01-17-08, 10:51
rockingred rockingred is offline
Registered User
 
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.
Reply With Quote
  #6 (permalink)  
Old 01-17-08, 13:01
emglespaul85 emglespaul85 is offline
Registered User
 
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
Reply With Quote
  #7 (permalink)  
Old 01-17-08, 14:27
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
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
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #8 (permalink)  
Old 11-30-11, 05:25
steeleace steeleace is offline
Registered User
 
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
File Type: zip Recipe Collection.zip (125.4 KB, 35 views)
Reply With Quote
  #9 (permalink)  
Old 11-30-11, 06:39
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
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
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #10 (permalink)  
Old 11-30-11, 13:23
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
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"
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On