StatusNet number countings
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.

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 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
-
Thanks for the hint







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
(URL)
31-10-’11 20:41