Wine Database

Question

Post reply

Wine Database

wildh

SSCarpal Tunnel

Points: 4370
More actions
May 10, 2005 at 7:31 am

#88871

I want to start a little databse of what wines I've drunk, when I drank them, where they came from and how I rated them ect., that kind of thing. I was wondering if anyone had done this kind of thing already and would be knind enough to script it out.
Thanks for looking.
Howard Wild UK

Viewing 15 posts - 1 through 15 (of 24 total)

You must be logged in to reply to this topic. Login to reply

sushila SSC-Dedicated Points: 35293 More actions · Answer 1

I would have one table that would be a "master" table - would have wineID, Region, Name, color, Year

The other table would have wineID (foreign key), datedrank, rating

Is this what you were looking for ?!

**ASCII stupid question, get a stupid ANSI !!!**

fperkins Ten Centuries Points: 1029 More actions · Answer 2

Perhaps searching for something in the freeware listings would be beneficial.

I think this one uses Access as the db, but there may be others available with SS backsides.

http://downloads.vnunet.com/download/eating+drinking/wine+library/_13001.html

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

Hm, I would rather drink another good one, than think about a schema for this just for fun.

Anyway I think most wine guides like Hugh Johnson's are available on CD. And most include some kind of freeware app that let's you do this.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Mike Metcalf SSCrazy Eights Points: 8763 More actions · Answer 4

I'd have to agree with Frank, why waste valuable drinking time looking to design a DB to track the wines you like/have drunk

wildh SSCarpal Tunnel Points: 4370 More actions · Answer 5

I drink, get drunk, fall unconcious, wake up, recover, forget whether I liked the wine the previous night or not, cannot impress chicks with knowledge of good wines, have slightly less chance of feeding the pony.

Options available

- Go for chicks who prefer cider and black (no need to impress).

- Don't bother trying to remember what wines I've had, or if I liked them.

- Spend a little time to track my wine consumption and pretend to be a boffin infront of the lovely young ladie I've only met once before, and be able to say - would you like to come back to my place and help me pop my cork.

I prefer option 3 at the moment.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 6

Heyhey, you mix up something here. Wine is nothing to drink like beer or other alcoholica.

But from your given alternatives, I would also opt for #3 (of course, without the "young lady". I'm married )

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Mike Metcalf SSCrazy Eights Points: 8763 More actions · Answer 7

At least you're doing it for the right reasons, to get drunk and impress the ladies

Although comming from the North East of England I tend to find that most of them prefer pints to wine (real classy ladies)

sushila SSC-Dedicated Points: 35293 More actions · Answer 8

Getting drunk impresses the ladies ?!?! Certainly never seen that pick-up line before - a guy falling senseless at my feet...ahh - maybe that's what it is - you don't see that he's drunk - only knocked out by your beauty...<:-)

**ASCII stupid question, get a stupid ANSI !!!**

Mike Metcalf SSCrazy Eights Points: 8763 More actions · Answer 9

Obviously the getting drunk and impressing the ladies were refering to 2 entirely seperate parts of the evening (or if some of the sorry states i've seen people in are to be belived seperate parts of the same decade)

Frank Kalis SSC Guru Points: 111183 More actions · Answer 10

You're a lady?

Äh women, female...What word do I use in this context?

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

sushila SSC-Dedicated Points: 35293 More actions · Answer 11

Frank - no one has ever accused me of being a lady yet...

However, I am "classy" in that I can down a couple of pints and still stay on my feet.

Talking of "downing" - don't knock the German wines...your beers may be good but I'd swear by the Rieslings anyday...

**ASCII stupid question, get a stupid ANSI !!!**

wildh SSCarpal Tunnel Points: 4370 More actions · Answer 12

Blue Nun anyone.

Does sushila need a guy? a chick who can down several pints and knows how to fine tune a SQL server has got to be in high demand.

Mike Metcalf SSCrazy Eights Points: 8763 More actions · Answer 13

Mike Metcalf

SSCrazy Eights

Points: 8763

May 11, 2005 at 6:27 am

#558027

Must not comment.........

Frank Kalis SSC Guru Points: 111183 More actions · Answer 14

That was neither an accusation nor meant offending.

I was just implying from your comment a guy falling senseless at my feet within the context. HAve I missed the answer or is your gender a secret?

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]