But everyone involved wants MB to be able to do this.
2004-02-05 03647, 2004
djce
Then... we'll see?
2004-02-05 03654, 2004
ruaok
If MB can't then the CCCP is some serious issues.
2004-02-05 03604, 2004
djce
Presumably the branch can't go live if the answer is No.
2004-02-05 03614, 2004
ruaok
And they know that if we won't be allowed to do this, then MB will need to find another hosting solution.
2004-02-05 03629, 2004
ruaok
So, I think the answer will be yes.
2004-02-05 03640, 2004
djce
OK. Let's not merge until we know for sure.
2004-02-05 03602, 2004
ruaok
Well, I was hoping to release it, but have a switch that disables the amazon features, but still lets the amazon asin/coverart urls be exposed via the web service.
2004-02-05 03618, 2004
ruaok
But that seems pointless. So, lets hold off for now.
2004-02-05 03634, 2004
ruaok
But, I should post something about it so people can test it.
2004-02-05 03642, 2004
ruaok
I would like to release on the 15th.
2004-02-05 03642, 2004
djce
Sounds good..
2004-02-05 03653, 2004
djce
assuming a yes just before?
2004-02-05 03602, 2004
djce
or in semi-crippled mode?
2004-02-05 03650, 2004
ruaok
We release regardless. If the answer is no, we'll cripple it.
2004-02-05 03659, 2004
ruaok
And start looking for a new hosting provider. :-(
2004-02-05 03611, 2004
ruaok
But I think that is not likely to happen.
2004-02-05 03609, 2004
ruaok
so, did we ever come to a conclusion on the 'serious weirdness mail' from whicken?
2004-02-05 03629, 2004
ruaok
And when do we load the album release dates from whicken? I was planning on doing that for the release, but if the release is a ways off still we might want to do that before then...
2004-02-05 03617, 2004
djce digs out the mail
2004-02-05 03652, 2004
djce
I think we came to a conclusion.
2004-02-05 03604, 2004
djce
Namely that there are still bugs relating to leading/trailing whitespace,
2004-02-05 03613, 2004
djce
and still data in the DB with that problem,
2004-02-05 03621, 2004
djce
so from time to time such errors will show up.
2004-02-05 03632, 2004
djce
Not sure about the search index problem though;
2004-02-05 03649, 2004
djce
certainly if the index is broke (for a given artist), then it won't "just fix itself"
2004-02-05 03655, 2004
djce
not unless the artist name changes.
2004-02-05 03626, 2004
ruaok
so, maybe enter an RFE for yalaforge for a tailing whitespace cleanup?
2004-02-05 03644, 2004
djce
So what Wendell calls "serious weirdness" I might call "unfortunate bugs resulting in inconsistent data views".
2004-02-05 03653, 2004
djce
yes, but it's not just a cleanup.
2004-02-05 03607, 2004
djce
First, the server will have to stop accepting the bad data.
2004-02-05 03609, 2004
ruaok
input validation as well.
2004-02-05 03644, 2004
djce
Maybe something to seek out and repair index errors.
2004-02-05 03649, 2004
djce
i.e. artistwords et al
2004-02-05 03613, 2004
sward_3 has quit
2004-02-05 03656, 2004
Knio-school
Knio-school is now known as Knio
2004-02-05 03618, 2004
ruaok
djce: got a favor to ask you...
2004-02-05 03607, 2004
djce
shoot
2004-02-05 03627, 2004
ruaok
can you whip up two queries for us?
2004-02-05 03641, 2004
ruaok
First, what coverage of artist subscriptions do we have?
2004-02-05 03600, 2004
ruaok
how many artists are subbed? and which artists are subbed more than others?
2004-02-05 03613, 2004
ruaok
And how many albums have release types?
2004-02-05 03619, 2004
djce
ok, give me a few minutes
2004-02-05 03623, 2004
ruaok
super!
2004-02-05 03633, 2004
djce
types? as live, single, album, remix?
2004-02-05 03638, 2004
ruaok
yes
2004-02-05 03640, 2004
djce
ok
2004-02-05 03620, 2004
djce
ok, second one first.
2004-02-05 03636, 2004
djce
this isn't the simplest way, but it illustrates the point.
2004-02-05 03644, 2004
djce
create or replace view album_attrs as select id, name, artist, gid, attributes[1] as modpending, attributes[2] as x, attributes[3] as y from album;
2004-02-05 03652, 2004
djce
select x,y,count(*) from album_attrs group by x,y order by 1,2;
2004-02-05 03641, 2004
djce
as you'll see from the results it's a bit untidy... sometimes we have (type), sometimes (status), sometimes (type,status) or sometimes (status,type).
2004-02-05 03650, 2004
djce
and sometimes neither.
2004-02-05 03611, 2004
djce
you can then count "albums" by, for example: select count(*) from album_attrs where 1 in (x,y);
2004-02-05 03622, 2004
djce
or "where 2 in"... for singles,etc.
2004-02-05 03657, 2004
ruaok
sorry, I'm back.
2004-02-05 03607, 2004
djce
ok
2004-02-05 03614, 2004
djce
ok, here's a better SQL query:
2004-02-05 03625, 2004
djce
do the "create or replace view" above first...
2004-02-05 03626, 2004
djce
then:
2004-02-05 03634, 2004
djce
create or replace view album_attrs_2 as select *, case when x between 0 and 99 then x when y between 0 and 99 then y end as reltype, case when x between 100 and 199 then x when y between 100 and 199 then y end as relstatus from album_attrs ;
2004-02-05 03641, 2004
djce
then you can:
2004-02-05 03646, 2004
djce
select reltype, count(*) from album_attrs_2 group by reltype order by 2 desc;
2004-02-05 03651, 2004
djce
select relstatus, count(*) from album_attrs_2 group by relstatus order by 2 desc;
2004-02-05 03621, 2004
ruaok
nice!
2004-02-05 03633, 2004
ruaok
so I'm seeing that more than half of the albums have a release type.
2004-02-05 03636, 2004
ruaok
Am I reading that right?
2004-02-05 03654, 2004
djce
I think so.
2004-02-05 03601, 2004
djce
nulls = no data, so that seems right
2004-02-05 03614, 2004
ruaok
and most of the releases have a status. not nad.
2004-02-05 03617, 2004
ruaok
bad, that is.
2004-02-05 03626, 2004
djce
ok, on to subscriptions.
2004-02-05 03631, 2004
djce
on bender:
2004-02-05 03638, 2004
djce
select a.id, a.name, t.t from artist a, (select artist, count(*) as t from moderator_subscribe_artist group by artist) as t where a.id=t.artist order by 3 desc;
2004-02-05 03641, 2004
djce
(top subbed artists)
2004-02-05 03650, 2004
djce
(well all in fact; but most-subbed first).
2004-02-05 03638, 2004
ruaok
meager. :-(
2004-02-05 03646, 2004
ruaok
NIN is a the top. Go figger.
2004-02-05 03601, 2004
djce
in histogram form:
2004-02-05 03606, 2004
djce
select t as subscribers, count(*) as num from (select artist, count(*) as t from moderator_subscribe_artist group by artist) as t group by t order by 1;
2004-02-05 03632, 2004
djce
(this shows that 6666 artists have one subscriber, 1 artist has 11 etc)
2004-02-05 03658, 2004
ruaok
woah.
2004-02-05 03601, 2004
ruaok
1 | 1386
2004-02-05 03602, 2004
ruaok
5 | 10
2004-02-05 03603, 2004
ruaok
6 | 8
2004-02-05 03605, 2004
ruaok
7 | 5
2004-02-05 03607, 2004
ruaok
that's on test.
2004-02-05 03610, 2004
djce
then the same on the other axis, by moderator:
2004-02-05 03612, 2004
djce
select t as artists, count(*) as num from (select moderator, count(*) as t from moderator_subscribe_artist group by moderator) as t group by t order by 1;
