Open Beer Data Project - Home Brew Forums
Home Brew Forums > Home Brewing Beer > Brewing Software > Open Beer Data Project

Reply
 
Thread Tools
Old 05-17-2011, 07:15 PM   #1
mozicodo
 
mozicodo's Avatar
Recipes 
 
Feb 2006
Colorado Springs, CO, CO
Posts: 257


I created the Open Beer Data Project which can be found at http://www.openbeerdata.org/. It is meant to be a repository for ingredient and other similar data in a central place which is not reliant on any single person.

All code involved is stored at http://code.google.com/p/openbeerdata/

All the ingredients data I currently have has been manhandled into the database so if you have other sources I can import from or know anyone at the manufacturers who could provide me with database dumps that would be great. Or if you're a fellow software developer who has much of this information and would like to contribute it to the greater good that would likewise be appreciated.

I currently am only exporting to CSV files and a Sqlite database but I'll be adding beerxml dumps shortly.
__________________
It may take a real man to brew a big beer, but it takes a big man to brew a real beer.

Xtreme Mashtun Build

 
Reply With Quote
Old 05-17-2011, 09:03 PM   #2
noggins
HBT_SUPPORTER.png
Recipes 
 
Sep 2010
San Antonio, Texas
Posts: 783
Liked 122 Times on 85 Posts


how is this different from the HBT wiki?

 
Reply With Quote
Old 05-17-2011, 09:11 PM   #3
mozicodo
 
mozicodo's Avatar
Recipes 
 
Feb 2006
Colorado Springs, CO, CO
Posts: 257

First, it's in a computer readable format.
Second, I've specified licensing for it.
__________________
It may take a real man to brew a big beer, but it takes a big man to brew a real beer.

Xtreme Mashtun Build

 
Reply With Quote
Old 05-17-2011, 10:20 PM   #4
noggins
HBT_SUPPORTER.png
Recipes 
 
Sep 2010
San Antonio, Texas
Posts: 783
Liked 122 Times on 85 Posts


Lots of good info in those files; is there a reason you chose csv over sql?

 
Reply With Quote
Old 05-17-2011, 10:30 PM   #5
brewmcq
HBT_LIFETIMESUPPORTER.png
 
brewmcq's Avatar
Recipes 
 
Apr 2011
Houlton, ME
Posts: 1,803
Liked 533 Times on 365 Posts


It's easy enough to pull CSV into SQL..
__________________
Brew McQ | Welcome to my Pub | Brew McQ on Facebook | Northern Maine Home Brewers on Facebook | Untappd

What do YOU want out of this hobby? It's your hobby. Do it the way YOU want to do it. Don't depend on the rest of us to tell you how to do it.

 
Reply With Quote
Old 05-17-2011, 10:32 PM   #6
mozicodo
 
mozicodo's Avatar
Recipes 
 
Feb 2006
Colorado Springs, CO, CO
Posts: 257

Portability
__________________
It may take a real man to brew a big beer, but it takes a big man to brew a real beer.

Xtreme Mashtun Build

 
Reply With Quote
Old 05-17-2011, 10:40 PM   #7
mozicodo
 
mozicodo's Avatar
Recipes 
 
Feb 2006
Colorado Springs, CO, CO
Posts: 257

... but I'll put ANSI SQL on my todo list.
__________________
It may take a real man to brew a big beer, but it takes a big man to brew a real beer.

Xtreme Mashtun Build

 
Reply With Quote
Old 05-19-2011, 01:07 PM   #8
Bithead
Recipes 
 
Apr 2010
Southern, NJ
Posts: 752
Liked 36 Times on 30 Posts


Subscribed

 
Reply With Quote
Old 05-19-2011, 01:23 PM   #9
stanley1271
Recipes 
 
Feb 2011
Tampa, FL
Posts: 333
Liked 1 Times on 1 Posts


Not really sure of a use for a spreadsheet of all the data. I myself prefer a searchable database, but I will certainly be keeping an eye on this project. It might just be out of the scope of my plans right now.

-Stanley
__________________
Swamp Land Brewing Blog

Quote:
Originally Posted by fujieagle View Post
I'm telling ya, she's nuttier than a squirrel turd.
Kegged:
  • AHS Anniversary Hefeweizen
  • American Devil IPA

 
Reply With Quote
Old 05-19-2011, 03:24 PM   #10
mozicodo
 
mozicodo's Avatar
Recipes 
 
Feb 2006
Colorado Springs, CO, CO
Posts: 257

Quote:
Originally Posted by stanley1271 View Post
Not really sure of a use for a spreadsheet of all the data. I myself prefer a searchable database, but I will certainly be keeping an eye on this project. It might just be out of the scope of my plans right now.
I'm just using the spreadsheets (csv files) as the basis to automate the export of the data. The goal is to take those spreadsheets and export them as:

1) SQLite database - already done
2) BeerXML
3) ANSI SQL statements for creation of pgsql, mysql, mssql, etc
4) JSON?
__________________
It may take a real man to brew a big beer, but it takes a big man to brew a real beer.

Xtreme Mashtun Build

 
Reply With Quote


Reply
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transferring Beersmith Data to a new computer? RLinNH Brewing Software 6 09-22-2012 05:50 PM
Strawberries - Beersmith Data Apoxbrew Brewing Software 2 03-13-2011 04:57 AM
Lost Beersmith Data jacksonbrown Brewing Software 2 11-01-2009 02:18 AM
Beer smith opens preview pane everytime I open it petep1980 Brewing Software 0 07-12-2009 04:59 PM
Having some beersmith issues, can't open recipe Coastarine Brewing Software 1 02-14-2009 12:11 AM


Forum Jump