[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 14: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 14:5327
    I once did that, using dBase III (err... can I mention it here ?) on my 
    home computer. Just a couple of fields :
    - Name of the band
    - Name of the record
    - Release year
    - Record size (LP, 12", 7")
    - Shop (where I bought it)
    I have kept it up-to-date for two years, but now I've given up.
    It got me clean listings of my record collection (now over 500 items,
    so that was useful) but I faced two problems :
    - I buy (and also sell) a lot, and I didn't always find the time to
      keep it up-to-date.
    - Lots of friends with my list asked me to lend them some, but I
      didn't always get them back, or got them completely ruined;
      for example, my copy of 'Spiral Scratch' by the Buzzcocks, something 
      really valuable to me, is now un-listenable due to enormous crackings.
      And I haven't been able to find another copy yet (fortunately I had
      taped it first).
    
    Well, that's why I stopped doing that, but I would not like to restrain
    your enthusiasm... Just be more careful than I was.
    
    Christophe.
    
    PS : Does anybody have the lyrics of 'Boredom' of the aforementioned
         Buzzcocks ?  I can't understand Howard Devoto's 'phras�' (maybe
         his accent ?) Thanks.
665.2GALVIA::STEPHENSNot me, baby - the mintsFri May 04 1990 19: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 CooperFri May 04 1990 22: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 09: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 18: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 10: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 16:510
665.8SHAPES::BROWNMRave On!Tue May 08 1990 14: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 15: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 15:143
    It was written by Andy Leslie (LESLIE::LESLIE).
    
    Keith
665.11EASE::CHISHOLMMarchand de PoissonsTue May 08 1990 15:354
    
    	Yup, and it's note 444.17 the dir/title in .-2 won't find it.
    
    	Doug