beer.db free open public domain beer, brewery n brewpubs data

Home | Data, Repos | News & Updates | Forum (Questions? Comments?) | Web Service / HTTP JSON API | Beer Maps | The Free World Beer Book

Welcome

What’s beer.db?

A free open public domain beer database & schema for use in any (programming) language (e.g. uses plain text data sets).

Schema Diagram

Datasets Examples

Breweries

“Classic” comma-separated values single-line record style

alaskan, Alaskan Brewing Co., 1986, AK, Juneau | AK 99801-9540 // 5429 Shaune Dr.
brooklyn, Brooklyn Brewery, 1987, NY, Brooklyn | NY 11249 // #1 Brewers Row // 79 N 11th St.
dixie, Dixie Brewing Co., 1907, LA, New Orleans | LA 70119 // 2401 Tulane Ave.

or

“Modern” comma-separated values multi-line record style

[alaskan]
  Alaskan Brewing Co., 1986
  5429 Shaune Dr. // Juneau, AK 99801-9540

[brooklyn]
  Brooklyn Brewery, 1987
  #1 Brewers Row // 79 N 11th St. // Brooklyn, NY 11249

[dixie]
  Dixie Brewing Co., 1907
  2401 Tulane Ave. // New Orleans, LA 70119

Beers

_________________________________
- Alaskan Brewing Co., Juneau

Alaskan Pale,  5.2%, golden_ale
Alaskan Amber, 5.3%, alt
Alaskan IPA|Alaskan India Pale Ale, 6.2%,  ipa|india_pale_ale
Alaskan Smoked Porter, 6.5%,   porter

_______________________
- Brooklyn Brewery

Brooklyn Lager,     5.2%, lager|american_amber_lager
Brooklyn Brown Ale, 5.6%,  brown_ale|american_brown_ale
Brooklyn East India Pale Ale,  6.9%,  ipa|india_pale_ale
Brooklyn Pilsner,  5.1%,   pilsner|golden_lager
Brooklyn Black Chocolate Stout,  10.0%,  imperial_stout
Brooklyn Dry Irish Stout, 4.7%,  dry_irish_stout
Brooklyn Oktoberfest, 5.5%,   maerzen|oktoberfest

___________________________________
- Dixie Brewing Co., New Orleans

Dixie|Dixie Lager, 4.6%, american_lager
Dixie Blackened Voodoo|Dixie Blackened Voodoo Lager,  5.0%,  munich_dunkel|dark_lager

Web Admin App

Try the beer.db Web Admin app running on Heroku prost.herokuapp.com.

Web Service / HTTP JSON API - GET /beer/guinness

Try the beer.db HTTP JSON API running on Heroku prost.herokuapp.com/api.

Example:

GET /beer/guinness

{
  "key":"guinness",
  "title":"Guinness",
  "synonyms": "Guinness Draught",
  "abv":"4.2",
  "srm":null,
  "og":null,
  "tags":["irish_dry_stout","dry_stout","stout"],
  "brewery":
  {
    "key": "guinness",
    "title": "St. James's Gate Brewery / Guinness Brewery"
  },
  "country":
  {
    "key":"ie",
    "title":"Irland"
  }
}

Command Line Tool - Build Your Own beer.db Copy

Use the beerdb command line tool to build your own beer.db copy from the plain text fixtures. Example:

Step 1: Get a copy of the world.db fixtures

$ git clone git://github.com/openmundi/world.db.git

Step 2: Get a copy of the Austrian beers ‘n’ breweries data set

$ git clone git://github.com/openbeer/at-austria.git

Step 3: Let’s build the beer.db

$ beerdb setup --include ./at-austria --worldinclude ./world.db

That’s it. See the beerdb command line tool project for more.

Talks - Slide Decks

• beer.db - Using Open Beer & Brewery Data in Ruby

Real World Usage

• beer.db.admin - beer.db Web Admin Tool in Ruby on Rails (version 3.2 and up).

Alternatives

• BreweryDB.com - beer and brewery data API by PintLabs Inc - (API use only - no database available for download; free demo; $ for use)
• Open Beer Database - free, public beer and brewery data API by Tristan Dunn (work-in-progress; API use only - no database available for download)
• Open Beer Database (openbeerdb.com) - free, public beer and brewery database (archive, no longer active)

License

The beer.db schema, data and scripts are dedicated to the public domain. Use it as you please with no restrictions whatsoever.

Questions? Comments?

Send them along to the Open Beer & Brewery Database Forum/Mailing List. Thanks!