A free open public domain beer database & schema for use in any (programming) language (e.g. uses plain text fixtures/data sets)
Build yourself a copy of the beer.db
from the plain text fixtures
in three steps.
Step 1: Get a copy of the world.db
fixtures
$ git clone git://github.com/geraldb/world.db.git
Step 2: Get a copy of the beer.db
fixtures
$ git clone git://github.com/geraldb/beer.db.git
Step 3: Let's build the beer.db
$ beerdb setup --include ./beer.db --worldinclude ./world.db
That's it.
Try the beer.db
Web Admin demo running
on Heroku prost.herokuapp.com
.
The beer.db
includes the following tables:
- beers
- breweries
- tags
- taggings (join table)
To build your own beer.db
copy
use the beerdb
command line tool.
See the beerdb
command line tool project
for more.
The beerdb
command line tool
lets you import beer and brewery data in plain text. Example:
alaskan, Alaskan Brewing Co., 1986, AK, city:juneau, Juneau | AK 99801-9540 // 5429 Shaune Dr.
brooklyn, Brooklyn Brewery, 1987, NY, city:newyork, Brooklyn | NY 11249 // #1 Brewers Row // 79 N 11th St.
dixie, Dixie Brewing Co., 1907, LA, city:neworleans, New Orleans | LA 70119 // 2401 Tulane Ave.
Alaskan Pale, 5.2%, by:alaskan, golden_ale
Alaskan Amber, 5.3%, by:alaskan, alt
Alaskan IPA|Alaskan India Pale Ale, 6.2%, by:alaskan, ipa|india_pale_ale
Alaskan Smoked Porter, 6.5%, by:alaskan, porter
Brooklyn Lager, 5.2%, by:brooklyn, lager|american_amber_lager
Brooklyn Brown Ale, 5.6%, by:brooklyn, brown_ale|american_brown_ale
Brooklyn East India Pale Ale, 6.9%, by:brooklyn, ipa|india_pale_ale
Brooklyn Pilsner, 5.1%, by:brooklyn, pilsner|golden_lager
Brooklyn Black Chocolate Stout, 10.0%, by:brooklyn, imperial_stout
Brooklyn Dry Irish Stout, 4.7%, by:brooklyn, dry_irish_stout
Brooklyn Oktoberfest, 5.5%, by:brooklyn, maerzen|oktoberfest
Dixie|Dixie Lager, 4.6%, by:dixie, american_lager
Dixie Blackened Voodoo|Dixie Blackened Voodoo Lager, 5.0%, by:dixie, munich_dunkel|dark_lager
- prost -
beer.db
Web Admin Tool in Ruby on Rails (version 3.2 and up).
- BreweryDB.com - beer and brewery data and api by PintLabs Inc.
- Open Beer Database - free, public beer and brewery database and API
The beer.db
schema, data and scripts are dedicated to the public domain.
Use it as you please with no restrictions whatsoever.