how many albums do you own?

Brideoffrankenstein · 12 Sep 2005, 20:31

This is not getting me any closer to my music database guys!

lazarus corporation · 12 Sep 2005, 20:32

Motz wrote:Is this "News for Geeks, Stuff that Matters"?

Methinx not

They use the word 'nerd' purely for alliteration

aims · 12 Sep 2005, 20:36

You know you're a Geek/Nerd when...

You have an argument over the boundary between the two

But I think we're stepping over the boundary between on-topic and decidedly not, so I'll concede on this one for the thread's sake

@BoF: If you have Microsoft Access (@Geeks: Yes, I'm aware that it doesn't scale, but a record collection is hardly enterprise sized) on your computer, then get hold of a "For Dummies" book (Not because you are one, because they're decent) and tailor the examples to suit your needs. That said, the task in question is probably doable with a spreadsheet unless you want to construct utterly bastard obnoxious queries...which you won't, because you're not a geek

lazarus corporation · 12 Sep 2005, 20:47

Motz wrote:@BoF: If you have Microsoft Access (@Geeks: Yes, I'm aware that it doesn't scale, but a record collection is hardly enterprise sized) on your computer, then get hold of a "For Dummies" book (Not because you are one, because they're decent) and tailor the examples to suit your needs. That said, the task in question is probably doable with a spreadsheet unless you want to construct utterly bastard obnoxious queries...which you won't, because you're not a geek

No copy of MS Access (well, I suppose I could lend a copy).

But, having promised to set something like this up for BoF, any suggestions as to alternatives to MS Access - some sort of Open Source DB which must have a good programmable GUI frontend similar to Access' forms?

aims · 12 Sep 2005, 20:50

OpenOffice.org Base seems decent enough (I was messing about in it before, trying to create my own music database but got bored). The only caveat is that you have to download the whole of OO.org to get hold of it =\

Baron Silas Greenback · 13 Sep 2005, 00:12

one white one - easy to file!

hallucienate · 13 Sep 2005, 09:37

OK Geeks: My music database started off life in Dbase3, running on a XT PC.

Since then it has been converted to Access (when I was learning it at Tech). It has five tables:
artists - Artist names
recordings - Recording details
catagory - Pop, Polka, etc
format - CD, LP, quadruple CD single
tracks - Tracklistings

I have also converted it to MySQL/PHP but never really bothered doing too much work on it.

It was several different count and search queries to make it useful.

13 Sep 2005, 10:23

I only have my Sisters boots listed. Anything else, I generally know whether I have it or not. (well, apart from the time I bought a second copy of Raw Power.)

boudicca · 13 Sep 2005, 10:29

God, this is a relief! I don't have a database or anything, just a plain word document with just a long long long list, which is constantly being added to...

boudicca · 13 Sep 2005, 10:30

God, this is a relief! I don't have a database or anything, just a plain word document with just a long long long list, which is constantly being added to...

emilystrange · 13 Sep 2005, 11:22

quick count.. about 200 ish on vinyl, it seems, and maybe about the same on cd though they are scattered a bit round the house..

uncatalogued.

smiscandlon · 13 Sep 2005, 18:58

boudicca wrote:God, this is a relief! I don't have a database or anything, just a plain word document with just a long long long list, which is constantly being added to...

boudicca also wrote:God, this is a relief! I don't have a database or anything, just a plain word document with just a long long long list, which is constantly being added to...

Is everything on your list twice?

13 Sep 2005, 20:13

vinyl is a-z by artist, within that its by release date. 12"s before the albums they came from.

CDs are up there any old how.

all uncatalogued.

Padstar · 13 Sep 2005, 20:43

Abot 700 CDs... if you include doots ive downloaded etc.

Paddy

TheBoyNextDoor · 15 Sep 2005, 15:47

Some of the albums I've bought during the years.. I always seem to find albums laying around that's not listed.. hehe...

http://www.skivsamling.nu/show.pl?order ... offset=all

Jaimie1980 · 15 Sep 2005, 16:32

Around 100 albums including compilations.

rian · 15 Sep 2005, 20:01

TheBoyNextDoor wrote:Some of the albums I've bought during the years.. I always seem to find albums laying around that's not listed.. hehe...

http://www.skivsamling.nu/show.pl?order ... offset=all

I see that you are also a fan of "And also the trees"
I love them. I have all their albums, but I couldn't find them in Sweden. Got some help from a German friend.

rian · 15 Sep 2005, 20:03

And " A Split Second". Hmm. I've heard about them, and think I've heard them too. Is it synth music?

Sounds very familiar.

rian · 15 Sep 2005, 20:05

TheBoyNextDoor wrote:Some of the albums I've bought during the years.. I always seem to find albums laying around that's not listed.. hehe...

http://www.skivsamling.nu/show.pl?order ... offset=all

Can't find any The Chameleons though, on your list.

It's a shame, really

TheBoyNextDoor · 15 Sep 2005, 21:18

rian wrote:
TheBoyNextDoor wrote:Some of the albums I've bought during the years.. I always seem to find albums laying around that's not listed.. hehe...

http://www.skivsamling.nu/show.pl?order ... offset=all
I see that you are also a fan of "And also the trees"
I love them. I have all their albums, but I couldn't find them in Sweden. Got some help from a German friend.

Wow. Not too many Swedish fans of that band really..

VarfÃ¶r skriver jag pÃ¥ engelska till dig?

A Split Second is a Belgian "EBM"-band.. they are so-so in my opinion.

Chameleons doh! Shame on me.. I like them so can't explain why I don't have any records..

TheBoyNextDoor · 15 Sep 2005, 21:24

Can't find any The Chameleons though, on your list.

It's a shame, really

FÃ¶rresten, ska du pÃ¥ the m*****n i Stockholm 3 oktober?

rian · 15 Sep 2005, 21:30

TheBoyNextDoor wrote:
Can't find any The Chameleons though, on your list.

It's a shame, really

FÃ¶rresten, ska du pÃ¥ the m*****n i Stockholm 3 oktober?

Ska pÃ¥ mycket annat i hÃ¶st, sÃ¥ The Mish villl nog inte bli en av dem. Sett dem fÃ¶rut, pÃ¥ Gino. 1994 eller 95, tror jag.

TheBoyNextDoor · 15 Sep 2005, 21:37

Ska pÃ¥ mycket annat i hÃ¶st, sÃ¥ The Mish villl nog inte bli en av dem. Sett dem fÃ¶rut, pÃ¥ Gino. 1994 eller 95, tror jag.

Andra konserter?
KÃ¤nns som att det kommer mÃ¥nga bra band till Sverige inom nÃ¤rmsta framtiden.. KJ, CoX, DM osv.

rian · 15 Sep 2005, 21:40

TheBoyNextDoor wrote:
Ska pÃ¥ mycket annat i hÃ¶st, sÃ¥ The Mish villl nog inte bli en av dem. Sett dem fÃ¶rut, pÃ¥ Gino. 1994 eller 95, tror jag.
Andra konserter?
KÃ¤nns som att det kommer mÃ¥nga bra band till Sverige inom nÃ¤rmsta framtiden.. KJ, CoX, DM osv.

Kaizers Orchestra, pÃ¥ Nalen i oktober. SuverÃ¤na live. Missa inte dom. Sett dom 3 gÃ¥nger, och det Ã¤r ace!

17 oktober tror jag.

boudicca · 15 Sep 2005, 23:11

smiscandlon wrote:
boudicca wrote:God, this is a relief! I don't have a database or anything, just a plain word document with just a long long long list, which is constantly being added to...

boudicca also wrote:God, this is a relief! I don't have a database or anything, just a plain word document with just a long long long list, which is constantly being added to...
Is everything on your list twice?

Whoops!

Why is everyone talking funny now...?