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.

how is this different from the HBT wiki?

First, it's in a computer readable format.
Second, I've specified licensing for it.

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

It's easy enough to pull CSV into SQL..

Portability

... but I'll put ANSI SQL on my todo list.

Subscribed

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

stanley1271 said:

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.

Click to expand...

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?