comment on

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.

Fullpage Chat with the graph

View the source

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;
[download]

In reply to Chatterbox conversational clusters by diotalevi

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		`&`
	<		`<`
	>		`>`
	[		`[`
	]		`]`

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.


"be consistent"
	PerlMonks