All the records you own

Message Bookmarked

Bookmark Removed

This thread is supposed to give an idea of the tastes of different ILM'ers. Maybe it can even contribute to answer the thread question Who On ILM Has The Best And Worst Music Taste 2002 .

So whoever has organised his/her records/cds etc. in a database please post a link to it. Here are my cds as of the beginning of this year. They cover about have of the music items in our household.

― alex in mainhattan (alex63), Monday, 25 November 2002 22:23 (twenty-three years ago)

~~have~~ should read half of course

― alex in mainhattan (alex63), Monday, 25 November 2002 22:24 (twenty-three years ago)

oh fuck.

― hstencil, Monday, 25 November 2002 22:25 (twenty-three years ago)

http://while1.org/~xm/albums.html

updating later on

― Jonathan Williams (ex machina), Monday, 25 November 2002 22:28 (twenty-three years ago)

At least this thread can answer the question who owns most music items at ILM and did organise it in a database or spreadsheet or word document or text file or whatever.

― alex in mainhattan (alex63), Monday, 25 November 2002 22:38 (twenty-three years ago)

(question two: why does anyone do this?)

― mark s (mark s), Monday, 25 November 2002 22:38 (twenty-three years ago)

I haven't done it yet, but I've been tempted to. Why? I guess it's the same sort of narcissism that leads me to keep a blog and post on ILM. Also - who knows - if I had the whole list in front of me, I might see a pattern.

― o. nate (onate), Monday, 25 November 2002 22:40 (twenty-three years ago)

to keep track of stuff. to be able to query on things like artist, release year etc. and not to forget for the insurance in case some insane bastard steals all your records...

― alex in mainhattan (alex63), Monday, 25 November 2002 22:42 (twenty-three years ago)

erm, is this a "guy thing"?

― geeta (geeta), Monday, 25 November 2002 22:47 (twenty-three years ago)

No, it's an OCD thing as far as I'm concerned.

― hstencil, Monday, 25 November 2002 22:50 (twenty-three years ago)

i did find a grocery barcode scanner once, and i wanted to scan everything i owned (not just music -- food items, comic books, little scraps of paper on the floor), for the purpose of creating some awe-inspiring godlike database of all my possessions, but i never got around to it. it wasn't really for tracking things, though, but just for the action of scanning things in. lasers!

― geeta (geeta), Monday, 25 November 2002 22:53 (twenty-three years ago)

if someone stole my records i would have like room for my books and stuff at last

― mark s (mark s), Monday, 25 November 2002 22:57 (twenty-three years ago)

I did it in one very long night about two weeks after one of my friends had all of his cds stolen (he had about 400). The idea then is that it's for insurance purposes. Whether or not it would really matter were we to have a fire or burglary, I dunno.

― scott pl. (scott pl.), Monday, 25 November 2002 22:59 (twenty-three years ago)

or a larder, that wd be top

― mark s (mark s), Monday, 25 November 2002 23:00 (twenty-three years ago)

i haven't updated my list in ages but it's posted somewhere.. can't be arsed posting it again

― electric sound of jim (electricsound), Monday, 25 November 2002 23:01 (twenty-three years ago)

If someone would steal my books, I would finally have space for my CD's!

― Siegbran (eofor), Monday, 25 November 2002 23:03 (twenty-three years ago)

it's win-win!!

siegbran's larder is full of reindeer

― mark s (mark s), Monday, 25 November 2002 23:07 (twenty-three years ago)

Alex has three Nine Inch Nails albums!

― sundar subramanian (sundar), Monday, 25 November 2002 23:08 (twenty-three years ago)

if someone stole all my books and records i'd have nothing to pile all this other stuff on top of

― jones (actual), Monday, 25 November 2002 23:13 (twenty-three years ago)

trent reznor owned 1992 or when was it?

― alex in mainhattan (alex63), Monday, 25 November 2002 23:17 (twenty-three years ago)

That's what AMG is for.

― o. nate (onate), Monday, 25 November 2002 23:18 (twenty-three years ago)

I made a list three years ago. I lost the original Access file, so if I wanted to update it I'd have to start again.

It was arranged by artist, album, year, and label.

Friends were shocked to learn that I owned no Beatles on CD.

― Jody Beth Rosen (Jody Beth Rosen), Monday, 25 November 2002 23:23 (twenty-three years ago)

I need to do this to stop me from buying/copying/downloading stuff I already have.

― Curt (cgould), Monday, 25 November 2002 23:24 (twenty-three years ago)

Reading's for pussies, Mark.

I think it's sensible for insurance purposes, for sure.

― Clarke B. (emily), Tuesday, 26 November 2002 00:46 (twenty-three years ago)

who said i read em? i don't listen to my records either

here is my database:
i eating
ii sleeping

― mark s (mark s), Tuesday, 26 November 2002 00:50 (twenty-three years ago)

where does buffy fit into that schematic?

― geeta (geeta), Tuesday, 26 November 2002 00:54 (twenty-three years ago)

and not to forget for the insurance in case some insane bastard steals all your records...
We're providing shopping lists for insane thieving bastards right here on this thread, in fact!

― Sean Carruthers (SeanC), Tuesday, 26 November 2002 00:55 (twenty-three years ago)

what kinds of crazed thieves break into houses and riffle thru crates to steal, like, rare art ensemble of chicago LPs? wouldn't they be eying yr stereo?

― geeta (geeta), Tuesday, 26 November 2002 01:44 (twenty-three years ago)

Cautionary tale, Geeta -- good friend of mine last year was robbed of a huge amount of vinyl and CDs that he had painstakingly built up over time. Sometimes they do concentrate on the software rather than the hardware.

I think it's sensible for insurance purposes, for sure.

I had my old database for that purpose, but like Jody, the original file got eaten somewhere along the line. Recreating it now would be ominous.

― Ned Raggett (Ned), Tuesday, 26 November 2002 02:19 (twenty-three years ago)

mark, after I stopped having a database I lost the ability to remember which releases I bought in a given year. including new releases. so they get uh lost to the ravages of time sometimes. even when I like them.

― Josh (Josh), Tuesday, 26 November 2002 03:24 (twenty-three years ago)

But Ned, can't you just walk into a store and say, "Everything, please", and duplicate your collection that way?

― Sean Carruthers (SeanC), Tuesday, 26 November 2002 03:29 (twenty-three years ago)

oh what a beautiful store that would be

― electric sound of jim (electricsound), Tuesday, 26 November 2002 03:33 (twenty-three years ago)

like Jody, the original file got eaten

I got eaten?

― Jody Beth Rosen (Jody Beth Rosen), Tuesday, 26 November 2002 03:36 (twenty-three years ago)

(insert Dan Perry...er, a Dan Perry comment...here)

oh what a beautiful store that would be

Yes, my friend.

― Ned Raggett (Ned), Tuesday, 26 November 2002 03:40 (twenty-three years ago)

I was recently having dinner at a friend's place and got to talking with his stepfather - found out that the guy is an ex dj and has over 40,000 old 45s. ! I asked him how he knows if he already had something when he sees it, because I lose track with only a few hundred, but he claims he can somehow almost always remember.

― Kim (Kim), Tuesday, 26 November 2002 04:19 (twenty-three years ago)

I haven't updated this in ages and ages (five years, at least), but I did create a database of my 7" singles:

http://www.cyclespersecond.com

Motivation was originally to help me pull records from my collection for my weekly radio show -- boxes of singles were on the tippy-top of some high bookcases, and hauling them down was a pain. But yeah, hstencil is OTM with the OCD thing, I'd imagine. It is kind of nutty.

― Jen (nstop), Tuesday, 26 November 2002 04:37 (twenty-three years ago)

this guy once sold me an art ensemble of chicago album and i found out later that it was "hot" (he'd stolen it off someone else i knew) -- v. embarrassing annoying and awkward

― george gosset (gegoss), Tuesday, 26 November 2002 04:40 (twenty-three years ago)

My little story sounds incomplete, but I don't know why.

― Kim (Kim), Tuesday, 26 November 2002 05:51 (twenty-three years ago)

i have a cd of rubber soul!!

― ron (ron), Tuesday, 26 November 2002 07:16 (twenty-three years ago)

i do have a list of records and cd's. but it is just written in a little book and is in no particular order. i may not have them all written down either

― ron (ron), Tuesday, 26 November 2002 07:17 (twenty-three years ago)

My database is in my head. If I can't remember if I have a particular CD, I know I am on the wrong track.

― nathalie (nathalie), Tuesday, 26 November 2002 08:33 (twenty-three years ago)

I did want to do a database for the insurance company but my father tells me that everything in the house is covered.

― Julio Desouza (jdesouza), Tuesday, 26 November 2002 10:14 (twenty-three years ago)

I don't know what CD's I have anymore. Must have close to 2000. I know at present I cannot find:

Bon Jovi - New Jersey
Elfpower - the fourth album, "the sun is forever"?

How my CD's are arranged: Elephant 6, indie pop, man or astroman?, Rock and metal, the beach boys, neil young (all in my new IKEA CD unit)

In old medicine cabinet above my bed: chaotically arranged various CDs stored in order of buying, and Dinosaur Jr, Lotion, Low, Smashing Pumpkins, Eric's Trip, the Carpenters, Abba.

On top of this unit I have about 40 7 inch singles.

Warbrobe: stuff I don't listen to and rock/metal tapes

Boxes on top of wardrobe: more stuff I don't listen to.

I'm almost tempted to make a database, but know I would get bored of the process after half an hour.

― jel -- (jel), Tuesday, 26 November 2002 10:30 (twenty-three years ago)

Sell them all alex!

― Dr. C (Dr. C), Tuesday, 26 November 2002 13:30 (twenty-three years ago)

How much would you give me, Dr. C? ;-)

― alex in mainhattan (alex63), Tuesday, 26 November 2002 14:14 (twenty-three years ago)

DJ Martian to thread.

― Marcello Carlin, Tuesday, 26 November 2002 14:16 (twenty-three years ago)

Actually looking at the first entries, I can understand you, Dr. C. There is quite a lot of rubbish in there. I probably only ever listen to one third of those cds.

― alex in mainhattan (alex63), Tuesday, 26 November 2002 14:20 (twenty-three years ago)

Pfennigs and pfennigs!

― Dr. C (Dr. C), Tuesday, 26 November 2002 14:20 (twenty-three years ago)

I only own 12 CDs so there's no need to catalogue them.

― alext (alext), Tuesday, 26 November 2002 14:43 (twenty-three years ago)

surely if you only own 12 you must be pretty daft, so maybe a list would still be prudent

― Josh (Josh), Tuesday, 26 November 2002 15:19 (twenty-three years ago)

do you practise being an arrogant cunt, josh, or does it just come naturally?

― Marcello Carlin, Tuesday, 26 November 2002 15:22 (twenty-three years ago)

Marcello, actually I have never constructed an all encompassing list of these are the CDs I own. My collection of CDs, Cassettes and Vinyl are presently arranged/stored in such a chaotic anti-ergonomic mess, that to even consider constructing such a list is a non-starter.

Anyway I would be more interested in constructing a mega list year-by-year of albums that I have not yet listened to.

― DJ Martian (djmartian), Tuesday, 26 November 2002 15:24 (twenty-three years ago)

o.nate - yes to the 'pattern' thing - & I wish I had kept a record of *when* I bought particular recordings - I'd like to see how the factual evidence lined up with distortions of memory and self-image.

― Snowy Mann (rdmanston), Tuesday, 26 November 2002 15:36 (twenty-three years ago)

marcello, is it natural mental deficiency or your periodic blinding fits of rage that render you unable to get obvious jokes?

― Josh (Josh), Tuesday, 26 November 2002 15:50 (twenty-three years ago)

you have just answered my question.

― Marcello Carlin, Tuesday, 26 November 2002 16:00 (twenty-three years ago)

ok I'm gonna go with the rage then unless you say otherwise

― Josh (Josh), Tuesday, 26 November 2002 16:02 (twenty-three years ago)

funnily enough there are days when i wish someone would break into my flat and steal my computer

― mark s, board moderator (mark s), Tuesday, 26 November 2002 16:04 (twenty-three years ago)

maybe if you look funny at marcello he'll bust it up with a brick or somethin

― Josh (Josh), Tuesday, 26 November 2002 16:06 (twenty-three years ago)

oh behave

― Marcello Carlin, Tuesday, 26 November 2002 16:12 (twenty-three years ago)

i feel like a green goddess

― mark s (mark s), Tuesday, 26 November 2002 16:16 (twenty-three years ago)

Can I say FITE?

― Roger Fascist (Roger Fascist), Tuesday, 26 November 2002 16:17 (twenty-three years ago)

"I need to do this to stop me from buying/copying/downloading stuff I already have.
-- Curt (curtisgould@attbi.com), November 25th, 2002."

what curt said. tho despite having a farily accurate list/database (not on the web) - I have actually rebought stuff by accident on a couple of occasions...

― g (graysonlane), Tuesday, 26 November 2002 16:27 (twenty-three years ago)

The fields I have in my music database (maybe helpful for people who want to start one):
- artist
- title
- release year
- medium (cd, lp, mc, maxi etc.)
- purchase date
- style (this turned out as quite useless)
- no. (if it's a double, triple etc. album)
- no. of tracks
- playing time
- mc cross-reference (if there are different artists on both sides of the mc I order them after the first artist in the alphabet, therefore the other one gets the reference of the first)
- lyric sheet (yes/no)
- top ten (yes/no if said album is in my personal top ten of release year)
- owner (my girl-friend or me)
- auto-number key (Access provides this automatically)

Additionally I have look-up tables for artists (including country/state and town), mediums and styles.

I think that is all. I haven't put a label field in the music table yet. But that is probably going to be added soon. Maybe the recording year is another interesting field to add. Maybe the price as well. Any other suggestions how to enlarge the database with useful info?

― alex in mainhattan (alex63), Tuesday, 26 November 2002 17:07 (twenty-three years ago)

alex in mainhattan -- as far as release year goes, might i also suggest:

Release label (diffeerent for re-issues)
Producer/Engineer
Condition
Outstanding features (markings, etc.)

― christoff (christoff), Tuesday, 26 November 2002 17:21 (twenty-three years ago)

Martin Skidmore to thread......
he said somewhere that his music database included 'location' - I am hoping this turns out to be a map reference, or some galactic co-ordinate system.

― Snowy Mann (rdmanston), Tuesday, 26 November 2002 17:50 (twenty-three years ago)

It's been a crappy day, so as a distraction I have compiled the P section of my CD collection!

The Pancakes – Flying in the blue sky on a frying pan
Palace Brothers – S/T
Palace Songs - Hope
Panda – S/T
Panda: Select: 10% by volume
Papas Fritas – S/T
Papas Fritas – Helioself
Papas Fritas – Buildings and grounds
Pavement – Slanted & enchanted
Pavement – Crooked rain, crooked rain
Pavement – Wowee Zowee
Pavement – Brigthen the corners
Pavement – Terror twilight
Phantom Surfers – The Great surf crash of ‘97
Philistines Jr – The Continuing struggle of
Philistines Jr – The Sinking of the SS Danehower
Philistines Jr – Analog vs. digital or we don’t get the respect we deserve in today’s scientific community
Piano Magic – Artists rifles
Pipes That You See, Pipes That You Don’t – Individualised shirts
Pip Proud – One of these days
Pixies – Doo little
Pixies – Bossa nova
Pixies – Trompe le monde
Poison – Open up and say…ahh!
Poison – Flesh and blood
Poison – Swallow this live
Poison – Greatest hits 1986 – 1996
Poison – Power to the people
Poison – Hollyweird
Polvo – Celebrate the new dark age
Polvo – Exploded drawing
Polvo – Shapes
Pop Defect – Don’t be hateful
Pop off Tuesday – S/T
Preston School of Industry – All this sounds gas

I'd probably get rid of a few of these, but I just never get round to it.

― jel -- (jel), Tuesday, 26 November 2002 20:01 (twenty-three years ago)

What, no Pussy Galore?

― hstencil, Tuesday, 26 November 2002 20:07 (twenty-three years ago)

get rid of Pip Proud. he makes Jandek sound like Robbie Williams.

― electric sound of jim (electricsound), Tuesday, 26 November 2002 22:30 (twenty-three years ago)

pip proud's about the only thing on that list that i like

― unknown or illegal user (doorag), Wednesday, 27 November 2002 03:15 (twenty-three years ago)

not a Palace fan then?

― electric sound of jim (electricsound), Wednesday, 27 November 2002 03:21 (twenty-three years ago)

Mine has:
artist/title/format (CD, 12", K7)/year/label/catalog no/genre (indeed quite useless)/length/number of tracks/tracklist/price/purchase date/source (ie, shop or person I got it from)/comments

― Siegbran (eofor), Wednesday, 27 November 2002 03:41 (twenty-three years ago)

jim - no.

― unknown or illegal user (doorag), Wednesday, 27 November 2002 03:42 (twenty-three years ago)

on that list Poison and the Philistines Jr are the only two I listen to often.

― jel -- (jel), Wednesday, 27 November 2002 09:48 (twenty-three years ago)

if you want to get rid of the phantom surfers or pip proud ones you know my name, look up the #

― unknown or illegal user (doorag), Wednesday, 27 November 2002 11:06 (twenty-three years ago)

yeah sure, I'll swap you the pip proud for a mixtape or something. Email me an address.

― jel -- (jel), Wednesday, 27 November 2002 11:35 (twenty-three years ago)

ok cool i will!

― unknown or illegal user (doorag), Wednesday, 27 November 2002 11:42 (twenty-three years ago)

jel doesnt own This Eclipse!

― gareth (gareth), Wednesday, 27 November 2002 11:44 (twenty-three years ago)

Has anyone posted their collection to
rateyourmusic.com yet?

― Lord Custos Omega (Lord Custos Omega), Wednesday, 27 November 2002 14:45 (twenty-three years ago)

how do you post your collection at rateyourmusic, custos?

― alex in mainhattan (alex63), Wednesday, 27 November 2002 20:41 (twenty-three years ago)

haha I don't even recognise those descriptions as databases! Mine has like 13 tables, with lord knows how many fields. It is ludicrously complicated, but very useful when people want lists of great songs about storms or country records of the '60s or something. The tracks table has over 55,000 entries now, and there are nearly 500 albums without track listings (mostly mixes). I can't post this anywhere on the web, I'm afraid, as I don't have a site. I print out 4pt lists of albums to carry with me to stop me buying things twice too often, but the main reason for its existence is that it makes me very happy.

― Martin Skidmore (Martin Skidmore), Saturday, 30 November 2002 01:06 (twenty-three years ago)

Tell us more about all the tables and their fields in your database, Martin! 55,000 entries in the tracks table, wow. How much time do you spend updating your database?

― alex in mainhattan (alex63), Saturday, 30 November 2002 07:50 (twenty-three years ago)

Major tables: records (meaning containers for tracks, whatever format, albums or singles or box sets are all 'records' here), tracks, acts. Then there are the tables to resolve many-to-many relationships (DB techie talk, sorry!), but the stuff you might not expect is the relationships allowing me to assign genre to acts, records or tracks; to record one act as part of another; to assign producers or musicians on records or tracks; to assign writers and themes (this is how I can find loads of things about boats really quickly!) to tracks, and record if they are a cover, who the originator was. Then I have loads of forms and queries for searching and summarising and so on (like one where for an artist it lists all the other act associations, plus any covers of them, anything they wrote or produced or played on, and so on), and for generating random compilations.

It took me about a day to build all the structures and forms and stuff (and I've added a few bits since), and months of loads of time entering the data. Now I enter new stuff as I get it, so I don't know how much time I spend. When I go on a spree (like the 15 Trojan box sets a while ago, or buying about 60 CDs in a week at an HMV sale) it does take a long time to enter it all, but it helps me learn what I have, and encourages me to study the small print and sleeve notes, so I don't regard it as a chore or burden.

― Martin Skidmore (Martin Skidmore), Saturday, 30 November 2002 12:39 (twenty-three years ago)

how do you post your collection at rateyourmusic, custos?
Eventually. My collection is currently undergoing extensive renovations and will be open for business sometime in the first quarter of 2003.

― Lord Custos Omega (Lord Custos Omega), Monday, 2 December 2002 15:31 (twenty-three years ago)

if you've nothing better to do, have at it. Forgive the no-frills formatting; this was only created for tracking purposes (and to while away the idle hours at work). but since that seems a little onanistic now, feel free to scan. and to contact me w/ recommendations for further exploration, trade inquiries, derision, whatever.

― gg (summerslastsound), Monday, 9 December 2002 15:24 (twenty-three years ago)

jel, do you have something against Look What the Cat Dragged In?

― sundar subramanian (sundar), Monday, 9 December 2002 15:53 (twenty-three years ago)

gg, what does the color coding mean in your list?

― Paul in Santa Cruz, Monday, 9 December 2002 16:57 (twenty-three years ago)

Paul,

white - cd
bright green - lp
light green - 7"
light blue - 10"/12".

― gg/ summerslastsound (summerslastsound), Monday, 9 December 2002 18:03 (twenty-three years ago)

no sundar! I just haven't found it at the right price yet!

(doorag, I'll send that pip Cd soon!)

― jel -- (jel), Monday, 9 December 2002 18:05 (twenty-three years ago)

Oh, I thought it was some kind of rating system...

― Paul in Santa Cruz, Monday, 9 December 2002 18:27 (twenty-three years ago)

You must be logged in to post. Please either login here, or if you are not registered, you may register here.