RDF or XML Drink dataset

[ptah]

I would like to inquire about obtaining a drink dataset (database) with the drink ingredients are separate entities (not just all in one field). This is so I can build a Point of Sales system for my father’s bar.

[Binks]

I'm curious - what does having a database of all the recipes here have to do with a point of sale system?

I assume that you want to somehow... print out a random recipe that includes the beverage someone just purchased?

... display a list of beverages they could make?

With some finagling you could probably manage to use cURL and some scripting to pull off some of that stuff (though you'd need a live internet connection).

Maybe I'm just unclear about what a Point of Sales system is - I'm thinking of the till that someone's final bills are put through (perhaps that's a narrow view of the system).

Being frank, I wonder how useful the database would be - the whole thing seems inconsistent at a lot of points (sometimes it's just "vodka", sometimes its a particular brand - as one example). Also, I wouldn't be surprised if lurking in those 15300+ recipes there are duplicates and extremely similar recipes. Combine even just those two factors, and I think that you would have a database that would cause no end of trouble for a machine.

The task of trying to decide what recipes are similar enough to be consolidated, and ensuring consistent naming conventions in all that data must be nearly impossible.

[ptah]

A point of sales system is thoes touch screen systems that the bar tender punches in what items were orderd.

Well i'm building the point of sales system that will also track inventory. The only way i can track inventory with mixed drinks or cocktales is if i know the ingrediance. Insted of having the bar tends punch in the ingredience i wish to have have the drink by name already in the system. Sorry for the bad spelling. If i know the maximum would be 15 shots for a 1L bottle and i know how many shots were used in the drinks sold that night i can asume that it should come out to about 12 shots per bottle(wrong orders , or spiled drinks).

The bar tends can then look up the drink by name, After filtering out extreemly uncommon drink. The interface also has the top 80 drinks sold on the first page as the system loads. Duplicate drink won't be a problem becasue if the name is different then the bar tender might know it under eather on of the names. The machine is a 2Ghz pentium with a 80Gig HD and 256Mb of RAm running windows XP light. It should not a a problem for the machine to handle 153000 Kb of data.

[ptah]

If you'd like to take a look at a prototype you can download it here. It doesn't require an installation it will just run anywhere.

http://www.stmartin.cc/bin.zip (http://www.stmartin.cc/bin.zip)

To create a mixed drink you will need to :

Tap the Mixed Drink button twice (Turns red)
Then select an alcohol(s) ,
Then click the soft drink button and select the mixer(s),
Then cash drink to create the drink.

It's just a prototype, It does not do everything yet