[thelist] PHP/MSQL question millions or thousands

Fred D Yocum fdy at mcc.org
Wed Feb 6 13:54:09 CST 2008

Wow, I am on digest mode, (probably not a good idea when asking a 
question) what a lot of good thought provoking replies! I did a recipe 
site once before (for the collection of recipes) and now remember how 
difficult to impose a structured order on recipes -- which can vary 
enormously depending on who is supplying it.

 http://www.nibblous.com Recipe and ingredients are held in one text 
field. What saves you from having carrotts or hum? How to index just the 
ingredients? Perhaps on processing you check each word against a table of 
ingredients and create a tag cluster held with the recipe record from the 
hits found. This also might save one from ingredient naming variations 
(Swede = Rutabaga, Zucchini= Marrow) 

> ...it is hard to think of an interface where creating a recipe would be 
refreshingly simple given such a database design, especially when I start 
thinking about how a qty, unit, preparation style, brand name, etc. would 
all be valid variations of the same ingredient.

Ta everyone,
Fred D

More information about the thelist mailing list