Working on recipe DB, need help. - Page 2 - Home Brew Forums
Register Now For Free!

Home Brew Forums > Home Brewing Beer > Recipes/Ingredients > Working on recipe DB, need help.

Thread Tools
Old 05-08-2006, 12:34 PM   #11
Jul 2005
Poo-Poo Land
Posts: 6,748
Liked 42 Times on 29 Posts

I would start out basic and work my way towards the more specific:

The first root should be (partial) Extract, All Grain
The second root of the tree would be Ale, Lager.
Then you'd get into the various types of ales and lagers
Then the individual recipes for each type. Or is this what you're thinking? Are you going to list Belgian's under a seperate tree or just put them into the Ale mix?

Are you going to code in ingredients or make them just text fields? By coding them in and assigning a primary key, you could easily create a function that would allow the user to enter in the ingredients they have and have the DB recommend a beer to brew. While it's time consuming, I'm sure a few of us here (myself included) would be willing to help enter information on hops, yeast and grains.

What language are you writing this in and what type of DB are you using? I'd be more than happy to lend a hand coding if it's PHP. I've written a few large DB projects for web using PHP and MySQL, but I'm also good with just about any SQL based DB and I can pick up on any JS or ActionScript needed.
Past Winners: Caramel Cream Ale #1, Hoegaarden Clone, Boom-Boom Vanilla Ale, Lazy Monk Abbey Style, Amarillo Cream Ale. (AG),

Buy a shirt now!!! Please! Did I help you? Buya shirt!
Cool Shirts.

Reply With Quote
Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
Working on Smoked Maple Brown Ale Recipe...Any Thoughts??? shagington Recipes/Ingredients 11 10-27-2009 01:39 AM
Working on a recipe xalu Recipes/Ingredients 5 08-01-2009 01:25 PM
Working on a recipe: Terrapin Rye Pale Ale clone Myrdhyn Recipes/Ingredients 4 03-25-2009 10:00 PM

Forum Jump