The last hour's chatterbox is graphed to clump around who was talking to whom. Sort of. This doesn't take into account message content so if you say someone's name, that doesn't hint that you are talking to them. You get points by speaking recently and within proximity to when someone else spoke.
Incidentally, I'm bringing these links up in PMD because while the code is visible I'm not presenting complete packages so people can run this stuff on their own. In that sense its more just an introduction to another view to perlmonks.
Appended: I added the PL/R code so people could see that too. The full source code for everything is at http://grenekatz.org/downloads/chatterbox//sql/perlmonks.sql.
CREATE FUNCTION r_median(double precision[]) RETURNS double precision AS ' median(arg1) ' LANGUAGE plr; CREATE AGGREGATE median ( BASETYPE = double precision, SFUNC = plr_array_accum, STYPE = double precision[], FINALFUNC = r_median ); CREATE FUNCTION invisible_speakers() RETURNS SETOF text AS ' SELECT username FROM (SELECT userid FROM chatter AS c, ( SELECT MAX( inserted ) AS s FROM other_users ) as s, ( SELECT MAX( inserted ) AS f FROM current_other_users ) AS + f WHERE c.inserted BETWEEN s.s AND f.f EXCEPT SELECT userid FROM current_other_users) AS i JOIN users USING (userid); ' LANGUAGE sql STABLE;
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Chatterbox conversational clusters
by jZed (Prior) on Apr 03, 2004 at 01:49 UTC | |
Re: Chatterbox conversational clusters
by kappa (Chaplain) on Apr 03, 2004 at 08:27 UTC | |
Re: Chatterbox conversational clusters
by hossman (Prior) on Apr 05, 2004 at 07:44 UTC | |
Re: Chatterbox conversational clusters
by pasky (Initiate) on Apr 04, 2004 at 00:31 UTC | |
by diotalevi (Canon) on Apr 04, 2004 at 03:48 UTC | |
Re: Chatterbox conversational clusters
by allolex (Curate) on Apr 08, 2004 at 06:30 UTC | |
by diotalevi (Canon) on May 04, 2004 at 01:37 UTC |
Back to
Perl Monks Discussion