Home Brew Forums > Home Brewing Beer > Brewing Software > Open Beer Data Project
Reply
 
Thread Tools
Old 05-17-2011, 07:15 PM   #1
mozicodo
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
mozicodo's Avatar
Recipes 
 
Join Date: Feb 2006
Location: Colorado Springs, CO, CO
Posts: 262
Default Open Beer Data Project

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
mozicodo is offline
 
Reply With Quote
Old 05-17-2011, 09:03 PM   #2
noggins
Registered User
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2010
Location: San Antonio, Texas
Posts: 665
Liked 60 Times on 40 Posts
Likes Given: 61

Default

how is this different from the HBT wiki?


noggins is offline
 
Reply With Quote
Old 05-17-2011, 09:11 PM   #3
mozicodo
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
mozicodo's Avatar
Recipes 
 
Join Date: Feb 2006
Location: Colorado Springs, CO, CO
Posts: 262
Default

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
mozicodo is offline
 
Reply With Quote
Old 05-17-2011, 10:20 PM   #4
noggins
Registered User
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2010
Location: San Antonio, Texas
Posts: 665
Liked 60 Times on 40 Posts
Likes Given: 61

Default

Lots of good info in those files; is there a reason you chose csv over sql?
noggins is offline
 
Reply With Quote
Old 05-17-2011, 10:30 PM   #5
brewmcq
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
brewmcq's Avatar
Recipes 
 
Join Date: Apr 2011
Location: Houlton, ME
Posts: 1,865
Liked 530 Times on 364 Posts
Likes Given: 2853

Default

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.
brewmcq is offline
 
Reply With Quote
Old 05-17-2011, 10:32 PM   #6
mozicodo
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
mozicodo's Avatar
Recipes 
 
Join Date: Feb 2006
Location: Colorado Springs, CO, CO
Posts: 262
Default

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
mozicodo is offline
 
Reply With Quote
Old 05-17-2011, 10:40 PM   #7
mozicodo
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
mozicodo's Avatar
Recipes 
 
Join Date: Feb 2006
Location: Colorado Springs, CO, CO
Posts: 262
Default

... 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
mozicodo is offline
 
Reply With Quote
Old 05-19-2011, 01:07 PM   #8
Bithead
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2010
Location: Southern, NJ
Posts: 760
Liked 36 Times on 30 Posts
Likes Given: 84

Default

Subscribed
Bithead is offline
 
Reply With Quote
Old 05-19-2011, 01:23 PM   #9
stanley1271
Feedback Score: 0 reviews
Recipes 
 
Join Date: Feb 2011
Location: Tampa, FL
Posts: 333
Liked 1 Times on 1 Posts

Default

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
stanley1271 is offline
 
Reply With Quote
Old 05-19-2011, 03:24 PM   #10
mozicodo
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
mozicodo's Avatar
Recipes 
 
Join Date: Feb 2006
Location: Colorado Springs, CO, CO
Posts: 262
Default

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
mozicodo is offline
 
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

Newest Threads

LATEST SPONSOR DEALS