Working on recipe DB, need help.

Homebrew Talk - Beer, Wine, Mead, & Cider Brewing Discussion Forum

Help Support Homebrew Talk - Beer, Wine, Mead, & Cider Brewing Discussion Forum:

This site may earn a commission from merchant affiliate links, including eBay, Amazon, and others.

TxBrew

Administrator
Staff member
Admin
Joined
Feb 10, 2004
Messages
9,308
Reaction score
2,113
I need to create a list of beer styles for everyone to put recipes under.

Should I do like brewing style; all grain, extract, etc.

Or should I do by type? Ale, lager, etc
 
TxBrew said:
I need to create a list of beer styles for everyone to put recipes under.

Should I do like brewing style; all grain, extract, etc.

Or should I do by type? Ale, lager, etc

I'd run it by type. I know that when I'm thinking about what to make next, I go to what kind of taste or style I'm looking for, and then search for a recipe based on the style.

I look forward to seeing (and using!) the finished product. :mug:
 
I was thinking type as well.

Everyone please list the types you would like listed so I don't miss any.
 
They have Ale, Lager, Hybrid/Mixed for their types.
 
Looks good to me, anyone disagree?

1. LIGHT LAGER
2. PILSNER
3. EUROPEAN AMBER LAGER
4. DARK LAGER
5. BOCK
6. LIGHT HYBRID BEER
7. AMBER HYBRID BEER
8. ENGLISH PALE ALE
9. SCOTTISH AND IRISH ALE
10. AMERICAN ALE
11. ENGLISH BROWN ALE 12. PORTER
13. STOUT
14. INDIA PALE ALE (IPA)
15. GERMAN WHEAT AND RYE BEER
16. BELGIAN AND FRENCH ALE
17. SOUR ALE
18. BELGIAN STRONG ALE
19. STRONG ALE
20. FRUIT BEER
21. SPICE / HERB / VEGETABLE BEER
22. SMOKE-FLAVORED AND WOOD-AGED BEER
23. SPECIALTY BEER
 
This sounds great, though as a newbie, I would like to know which recipes are extract right off the bat so I know not to mess with the all-grains, at least not yet... soon though....
 
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.
 

Latest posts

Back
Top