Anything or more and less

a blog by Tobias Diekershoff

StatusNet number countings

Two comments

identi.ca was down today, for me it was the morning till the afternoon. Such things happen and they are not nice, not for the users and not for @evan and his team. Nobody to blame except those who blame the team but don’t setup their own StatusNet nodes, which is not that complicated. In fact it is rather easy…

For federated StatusNet user, those of us Laconicats (c.r. identicats) running their own servers or microblogging on federated nodes, that means it gets awfully quiet in the timeline. This time it hit my nerve and I just wanted to have some numbers.

So here they are. My node, since its last crash after the MySQL breakdown in April—so half a year. Nothing said about how active these accounts are, pure number counting here.

Profile URL count seen on diekershoff.homeunix.net

These numbers are profiles seen by my StatusNet node. Seen as once or still followed, once answered or once posted to a group I’m member of/was. That is 3440 profiles from identi.ca, 58 profiles from microblogs from the status.net cloud and 140 profiles from other sources (mostly StatusNet but also some Friendika instances). So when the StatusNet cloud is offline, and identi.ca beeing the biggest part of the SN cloud IIRC, that means that 95% of all profiles my node ever saw are gone.

I would not mind some more federated contacts ;-)

And for those who are interested, here are the MySQL queries I used (I’m open for other queries)

select nickname,profileurl from profile where not profileurl like "%status.net%" and not profileurl like "%identi.ca%" and profileurl not like "%twitter%";
select nickname,profileurl from profile where profileurl like "%status.net%";
select nickname,profileurl from profile where profileurl like "%identi%";

I’m sure there are better queries, maybe even a count (I’m sure it is) but they did their job and I liked to see the names flying by in the terminal :-)

two comments

  1. Hello,
    If you want to avoid twitter profile, and take into account only ostatus profile, you’d better to perform your requests against ostatus_profile table :)

    JB

    JB

    (URL)

    31-10-’11 20:41

  1. Thanks for the hint :-)

    Tobias

    Tobias

    31-10-’11 21:03

Leave a Reply

(optional field)
(optional field)
I like spammers, cause most can't think. Please think abit about this little qustion and write the answert (all lowercase) into that box...

Comment moderation is enabled on this site. This means that your comment will not be visible until it has been approved by an editor.

Remember personal info?
Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.
Special Thanks to email Marketing specialists!