[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference marvin::uk_music

Title:The UK Music Conference
Notice:Welcome (back) to UK_MUSIC on node MARVIN.
Moderator:RDGENG::CROOK
Created:Mon Mar 28 1988
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:1381
Total number of notes:39269

665.0. "Catalogue Software" by JOBBIE::PATTISON (A rolling stone gets the worm) Fri May 04 1990 17:27

    I'm thinking of designing a database (using SQL) for cataloguing my
    record collection, and some sort of simple user interface (in my spare
    time, naturally). Up to now I've just been using plain text files and
    "SORT" etc.
    
    I'd be interested in any suggestions as how to structure the database,
    i.e. what information to keep in it, what sort of relations and so on. 
    
    I'd also be interested to know if anyone has done this sort of thing
    before. 
    
    Dave
T.RTitleUserPersonal
Name
DateLines
665.1PRSIS7::BERNARDGone fishingFri May 04 1990 17:5327
665.2GALVIA::STEPHENSNot me, baby - the mintsFri May 04 1990 22:575
Howard Devoto? I though Pete Shelly sang all the Buzzcocks songs? (and maybe
I'm totally off the beaten track, but I thought Howard Devoto was in
Television, or some group like that?) Can someone set me straight?

--patrick--
665.3I Believe In...SWAM2::BERZER_VIThat's Special Agent CooperSat May 05 1990 01:519
    Pete Shelley does sing most of the Buzzcocks tracks.
    Howard Devoto was in Magazine and is now on his own,
    with a very good backing band.  
    
    Buzzcocks were talking about "reuniting" while they were
    on their retro-tour.  (During the interview I heard, it
    sounded like they just needed a record company.)
    
    -VAB
665.4WELMTS::GREENBSat May 05 1990 12:3110
    Howard Devoto was singer with the 'Cocks in their early days, and
    appears on the legendary 'Spiral Scratch' ep, which contains the
    classic seminal punk anthem 'boredom', as well as three other fine
    examples of the genre.
    
    Will these superlatives never cease?
    
    Bob
    
    BTW, Television's main man was Tom Verlaine.
665.5GALVIA::STEPHENSNot me, baby - the mintsSun May 06 1990 21:513
Did Howard Devoto record a song called "The Rainy Season"?

--Patrick--
665.6Multiple users?CLADA::MEAGHERThese are the hands of a tired manMon May 07 1990 13:4217
Hi Dave,

	I haven't done this (yet) but I have been toying with the idea. 
Knowing absolutely nothing about SQL or RDB could I recommend that you include
the following fields, in addition to the standard ones (ie Artist, Album, Media
type, songs, etc):

	- Owner's name

	- Borrower's name
	
You could then get friends to put their records in also, so that if you wanted
to check out a particular artist you could simply pull by Artist Name & show
Artist-Album-Media-Owner. 

Let me know how you get on,
-Brian.
665.7Yes, Howeird did "Rainy Season"...EdHPSRAD::ARTHUR50,000,000 Elvis fans can't be wrong!Mon May 07 1990 19:510
665.8SHAPES::BROWNMRave On!Tue May 08 1990 17:5514
    Good note.
    
    I have all my stuff on a WPS document, as text.  I have fields Artist,
    Title, Comments, Country of release, format (ie. 3"CD, 12"PS LTD - PS
    being picture sleeve, and LTD meaning limited edition).  Then I have
    all the tracks and mixes listed underneath each song.  If I was to set
    up a database I would also include the catalogue number of each record
    and the length of each mix.  I have thought about doing this myself
    using Datatrieve of Focus, but I'd rather do it on my own computer
    (which I don't have), so the idea's on hold.  I also have a list of
    records I want.
    
    
    matty
665.9EASE::CHISHOLMMarchand de PoissonsTue May 08 1990 18:138
    
    	I remember a DCL catalogue, called RECORDING.COM, someone
    	put into the UKCSSE::COMMAND_PROCEDURES conference some time
    	ago, it didn't have as many fields as you're looking for, but
    	did produce useful reports. A DIR/TITLE=RECORD might find it.
    
    
    	Doug.
665.10BURYST::EDMUNDS$ no !fm2r, no commentTue May 08 1990 18:143
    It was written by Andy Leslie (LESLIE::LESLIE).
    
    Keith
665.11EASE::CHISHOLMMarchand de PoissonsTue May 08 1990 18:354
    
    	Yup, and it's note 444.17 the dir/title in .-2 won't find it.
    
    	Doug