the numbers are old, but still apply to some extent.
2004-01-17 01705, 2004
djce
I see. Artists with no albums, group by track count.
2004-01-17 01730, 2004
yalaforge
yup. I already identified about 5000 of them that are duplicates
2004-01-17 01746, 2004
yalaforge
the follow the pattern '{artist we have} + some other string'
2004-01-17 01721, 2004
djce
good idea.
2004-01-17 01734, 2004
yalaforge
and then there are wendell's reports, so we should get rid of many of them
2004-01-17 01753, 2004
djce
as of a week ago:
2004-01-17 01755, 2004
djce
FROM artist, track
2004-01-17 01756, 2004
djce
WHERE NOT EXISTS (
2004-01-17 01758, 2004
djce
SELECT * FROM album WHERE artist.id = album.artist
2004-01-17 01700, 2004
djce
) AND artist.id = track.artist
2004-01-17 01702, 2004
djce
GROUP BY artist.id
2004-01-17 01704, 2004
djce
ORDER BY COUNT(track.id)
2004-01-17 01706, 2004
djce
)
2004-01-17 01710, 2004
djce
AS tracks_by_artist
2004-01-17 01713, 2004
djce
GROUP BY numtracks
2004-01-17 01714, 2004
djce
ORDER BY COUNT(artistid) DESC;
2004-01-17 01716, 2004
djce
doh
2004-01-17 01718, 2004
djce
try again
2004-01-17 01720, 2004
djce
numtracks | count
2004-01-17 01722, 2004
djce
-----------+-------
2004-01-17 01724, 2004
djce
1 | 29235
2004-01-17 01728, 2004
djce
2 | 6071
2004-01-17 01730, 2004
djce
3 | 2108
2004-01-17 01732, 2004
djce
4 | 1134
2004-01-17 01734, 2004
djce
(damn X clipboards. grrrr.)
2004-01-17 01753, 2004
yalaforge
it gets worse
2004-01-17 01703, 2004
yalaforge
the whole VA submission process is BAD. really BAD.
2004-01-17 01720, 2004
yalaforge
I've seen submissions from good moderators that had mistakes in the artist fields
2004-01-17 01737, 2004
yalaforge
I think I can write a function that checks a proposed artist's name and makes suggestions to improve it
2004-01-17 01709, 2004
yalaforge
many people submit stuff like 'artist feat. artist' or 'x + y', 'x and y' etc.
2004-01-17 01712, 2004
djce
that sounds good...
2004-01-17 01754, 2004
yalaforge
ok, I'll add it to my TODO for the next release
2004-01-17 01741, 2004
yalaforge
heh. my university was rated as "germany's best in computer science" :-)
2004-01-17 01718, 2004
yalaforge
according to cdrecord, my burner "Does return CD ISRC information"
2004-01-17 01727, 2004
djce
interesting...
2004-01-17 01746, 2004
yalaforge
damn. ioctl_list(4) is outdated.
2004-01-17 01753, 2004
yalaforge hates to read kernel sources
2004-01-17 01730, 2004
rj_ joined the channel
2004-01-17 01737, 2004
yalaforge
ok, I can read the "Universal Product Code" from a CD-Audio using a ioctl()
2004-01-17 01748, 2004
djce
brb..
2004-01-17 01749, 2004
djce has quit
2004-01-17 01714, 2004
djce joined the channel
2004-01-17 01755, 2004
yalaforge
tried two discs. one had the UPC, the other didn't. and apparently, not all drives support to read the UPC :-(
2004-01-17 01728, 2004
yalaforge
the ISRC can be written using a CD burner but there's no way to read it
2004-01-17 01752, 2004
yalaforge is away: I'm busy
2004-01-17 01754, 2004
djce has quit
2004-01-17 01739, 2004
orogor joined the channel
2004-01-17 01717, 2004
djce joined the channel
2004-01-17 01727, 2004
djce has nice small fonts in mozilla at last
2004-01-17 01740, 2004
yalaforge
cool.
2004-01-17 01754, 2004
djce
maybe now I can start to catch up on mb-users. 55 unread. eek!
2004-01-17 01715, 2004
yalaforge
nothing relevant, IMHO. just chat
2004-01-17 01723, 2004
djce
ok, should be quick then.
2004-01-17 01725, 2004
djce reads
2004-01-17 01739, 2004
djce
oh, I got another X for you. maybe you can help.
2004-01-17 01747, 2004
djce
s/X/Q/ (question). duh.
2004-01-17 01751, 2004
djce
what am I like?
2004-01-17 01751, 2004
yalaforge hopes so
2004-01-17 01700, 2004
djce
anyway, the question is this:
2004-01-17 01715, 2004
djce
how can I use the X server when I'm su'd to another user?
2004-01-17 01729, 2004
djce
e.g. login in as me; start X; su - anotheruser ; gvim
2004-01-17 01745, 2004
yalaforge
you mean, you can't start the program because you don't have the permissions?
2004-01-17 01749, 2004
djce
which used to work on Red Hat, but now says "can't open display".
2004-01-17 01721, 2004
djce
I can't remember if on RH I had to customise anything to make that work, or if it was like that by default.
2004-01-17 01722, 2004
yalaforge
I have this problem, too. it has something to do with authentication. xhost comes to mind.
2004-01-17 01728, 2004
yalaforge
wait a few minutes, I'll have a look at it
2004-01-17 01743, 2004
djce reads man xhost too
2004-01-17 01720, 2004
yalaforge
xauth is relevant, too
2004-01-17 01724, 2004
orogor_ joined the channel
2004-01-17 01714, 2004
yalaforge
djce: ok, I think I know how it works
2004-01-17 01731, 2004
djce
cool. beats the hell out of me.
2004-01-17 01747, 2004
yalaforge
in the account that started the X server: xauth extract - $DISPLAY > /tmp/cookie
2004-01-17 01711, 2004
yalaforge
in the other account you su-ed to: xauth merge /tmp/cookie
2004-01-17 01736, 2004
yalaforge
and also set DISPLAY identically on both accounts
2004-01-17 01753, 2004
djce
yay!
2004-01-17 01757, 2004
djce
You da man!
2004-01-17 01715, 2004
yalaforge
I don't know if the cookie expires after the server is restarted. you have to try that
2004-01-17 01725, 2004
yalaforge
but I don't think so
2004-01-17 01734, 2004
djce
ok, we'll see.. Thanks.
2004-01-17 01738, 2004
yalaforge
np
2004-01-17 01738, 2004
yalaforge is away: lunch
2004-01-17 01755, 2004
orogor has quit
2004-01-17 01702, 2004
orogor_
orogor_ is now known as orogor
2004-01-17 01741, 2004
orogor has quit
2004-01-17 01753, 2004
yalaforge is back (gone 00:43:12)
2004-01-17 01728, 2004
melange
djce: 'xhost +localhost'
2004-01-17 01739, 2004
melange
djce: that should fix your X problem
2004-01-17 01700, 2004
melange
well, that's the easy way, anyway
2004-01-17 01701, 2004
melange
:)
2004-01-17 01741, 2004
yalaforge
melange: but allows anyone on localhost to access the X server
2004-01-17 01752, 2004
melange
how worried about that are you?
2004-01-17 01714, 2004
yalaforge
my box is used by several people
2004-01-17 01728, 2004
melange
ok, well you need to be more restrictive then
2004-01-17 01750, 2004
melange
if you're the only one on the box, or if you trust the others who access it, then xhost +localhost is fine
2004-01-17 01713, 2004
yalaforge
yup. and set $DISPLAY
2004-01-17 01737, 2004
melange
that probably depends on if you "su -" or not
2004-01-17 01745, 2004
melange
I tend to drop the "-" most of the time
2004-01-17 01720, 2004
yalaforge
I use it. my personal user has a strict umask
2004-01-17 01711, 2004
djce is away: at work
2004-01-17 01721, 2004
djce
melange: thanks for the tip, btw
2004-01-17 01746, 2004
melange
np
2004-01-17 01722, 2004
djce is back (gone 00:30:11)
2004-01-17 01739, 2004
djce
Hey, not bad. I allocated myself 30 minutes for that work. That was pretty close!
2004-01-17 01749, 2004
yalaforge
:-)
2004-01-17 01722, 2004
melange
no no no, you're supposed to over-allocate, that way you can get it in and say "it's a miracle!"
2004-01-17 01735, 2004
melange
(ref:
2004-01-17 01741, 2004
melange
(ref: Scotty from Star Trek)
2004-01-17 01749, 2004
yalaforge
lol
2004-01-17 01753, 2004
djce
well I did think I might round up a bit... say, in 30-minute chunks? Do you think rounding from 30:11 to 60:00 is too much? ;-)
2004-01-17 01726, 2004
melange
It's a miracle!
2004-01-17 01729, 2004
melange
;)
2004-01-17 01751, 2004
melange
it means you've got 29:49 to surf the web until your next task
2004-01-17 01753, 2004
melange
:)
2004-01-17 01712, 2004
yalaforge likes melange's way to think :-)
2004-01-17 01722, 2004
djce wonders whether to read the remaining 25 mb-users posts about mixes, classical etc.
2004-01-17 01737, 2004
yalaforge skipped them
2004-01-17 01756, 2004
melange
it starts to waffle on a bit, but I think there's some general agreement now
2004-01-17 01700, 2004
yalaforge
I reduced the artist count instead
2004-01-17 01728, 2004
melange
yalaforge: ?
2004-01-17 01735, 2004
yalaforge
yes?
2004-01-17 01748, 2004
melange
"I reduced the artist count instead" - I don't understand
2004-01-17 01704, 2004
yalaforge
we have tons of duplicated artists
2004-01-17 01723, 2004
yalaforge
I submit merges or 'change artist' mods
2004-01-17 01747, 2004
yalaforge
ca. 25000-30000 of our artists are dupes, I guess
2004-01-17 01710, 2004
melange
ok .. I'm still trying to work out how this relates to the MB thread
2004-01-17 01714, 2004
melange
:)
2004-01-17 01735, 2004
yalaforge
it's a more useful way of spending 30 minutes :-)
2004-01-17 01743, 2004
djce
I see :-)
2004-01-17 01744, 2004
melange
aaaaaaaaahhhhh
2004-01-17 01707, 2004
yalaforge wonders what you two were thinking
2004-01-17 01708, 2004
melange
*ding*
2004-01-17 01733, 2004
melange
well, I think it was just the timing
2004-01-17 01717, 2004
melange
I made my comment about waffling and agreements, and you said you just reduced the artist count (as if, reducing the artist count was a better way to deal with classical and mix naming)
2004-01-17 01734, 2004
yalaforge
oh :-)
2004-01-17 01747, 2004
melange
which, of course, didn't make a lot of sense :)
2004-01-17 01758, 2004
melange
aaaaaaanyway
2004-01-17 01713, 2004
yalaforge
yup. time to do some voting
2004-01-17 01753, 2004
melange
yeah .. I've fallen off the top five. I've been slack the last week, only a few votes each day.
2004-01-17 01746, 2004
yalaforge
same here. but some on the top voters list seem to like the 'abstain' button
2004-01-17 01701, 2004
melange
abstain's don't count on the top five though, right?
2004-01-17 01716, 2004
yalaforge
don't know
2004-01-17 01730, 2004
djce
melange: I think you're right.
2004-01-17 01740, 2004
melange
do artists with no albums get removed automatically?
