Ss Brewing Technologies Giveaway!

Home Brew Forums > Home Brewing Beer > Brewing Software > Open Beer Data Project
Reply
 
LinkBack Thread Tools
Old 05-17-2011, 07:15 PM   #1
mozicodo
Feedback Score: 0 reviews
 
mozicodo's Avatar
Recipes 
 
Join Date: Feb 2006
Location: Colorado Springs, CO, CO
Posts: 259
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 Open Beer Data Project @aptidude on identi.ca

Android Software: ZymTools Free ZymTools Full
mozicodo is offline
 
Reply With Quote Quick reply to this message
Old 05-17-2011, 09:03 PM   #2
turtle
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2010
Location: San Antonio, Texas
Posts: 489
Liked 5 Times on 5 Posts
Likes Given: 4

Default

how is this different from the HBT wiki?

__________________
turtle is offline
 
Reply With Quote Quick reply to this message
Old 05-17-2011, 09:11 PM   #3
mozicodo
Feedback Score: 0 reviews
 
mozicodo's Avatar
Recipes 
 
Join Date: Feb 2006
Location: Colorado Springs, CO, CO
Posts: 259
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 Open Beer Data Project @aptidude on identi.ca

Android Software: ZymTools Free ZymTools Full
mozicodo is offline
 
Reply With Quote Quick reply to this message
Old 05-17-2011, 10:20 PM   #4
turtle
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2010
Location: San Antonio, Texas
Posts: 489
Liked 5 Times on 5 Posts
Likes Given: 4

Default

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

__________________
turtle is offline
 
Reply With Quote Quick reply to this message
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,785
Liked 483 Times on 334 Posts
Likes Given: 2645

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 Quick reply to this message
Old 05-17-2011, 10:32 PM   #6
mozicodo
Feedback Score: 0 reviews
 
mozicodo's Avatar
Recipes 
 
Join Date: Feb 2006
Location: Colorado Springs, CO, CO
Posts: 259
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 Open Beer Data Project @aptidude on identi.ca

Android Software: ZymTools Free ZymTools Full
mozicodo is offline
 
Reply With Quote Quick reply to this message
Old 05-17-2011, 10:40 PM   #7
mozicodo
Feedback Score: 0 reviews
 
mozicodo's Avatar
Recipes 
 
Join Date: Feb 2006
Location: Colorado Springs, CO, CO
Posts: 259
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 Open Beer Data Project @aptidude on identi.ca

Android Software: ZymTools Free ZymTools Full
mozicodo is offline
 
Reply With Quote Quick reply to this message
Old 05-19-2011, 01:07 PM   #8
Bithead
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2010
Location: Southern, NJ
Posts: 755
Liked 35 Times on 29 Posts
Likes Given: 80

Default

Subscribed

__________________
Bithead is offline
 
Reply With Quote Quick reply to this message
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 Quick reply to this message
Old 05-19-2011, 03:24 PM   #10
mozicodo
Feedback Score: 0 reviews
 
mozicodo's Avatar
Recipes 
 
Join Date: Feb 2006
Location: Colorado Springs, CO, CO
Posts: 259
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 Open Beer Data Project @aptidude on identi.ca

Android Software: ZymTools Free ZymTools Full
mozicodo is offline
 
Reply With Quote Quick reply to this message
Reply



Quick Reply
Message:
Options
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 01: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-13-2009 11:11 PM