Bitcoin IRC Graphs
Here are some graphs and SQL to show how to use the Bitcoin IRC data. These charts track the activity of three main developers of Bitcoin: Mike Hearn, Gregory Maxwell, and Gavin Andresen. These three developers were featured in a New York Times article about Bitcoin developers.
(1) Bitcoin Developers IRC Posts Over Time
SQL Code
SELECT `send_user` , YEAR( date_of_entry ) , MONTH( date_of_entry ) , COUNT( `type` )
FROM `bitcoindev_irc`
WHERE `send_user` = 'gavinandresen'
GROUP BY 1, 2 , 3;
(2)Bitcoin Developers IRC Posts by Total Percentage
SQL Code
SELECT YEAR( date_of_entry ) , MONTH( date_of_entry ) , COUNT( `type` )
FROM `bitcoindev_irc`
WHERE TYPE = 'message'
GROUP BY 1 , 2;
(3) Bitcoin IRC Log by Day of the Week
SQL Code
SELECT DAYOFWEEK( date_of_entry ) , COUNT( `type` )
FROM `bitcoindev_irc`
WHERE TYPE = 'message'
GROUP BY 1 ;
Attachment | Size |
---|---|
BitcoinDevelopersIRCPostsOverTime.png | 46.39 KB |
BitcoinDeveloperIRCPostsbyTobablPercentage.png | 66.61 KB |
BitcoinIRCLOGbyDayoftheWeek.png | 17.16 KB |
- gbatchelor's blog
- Log in to post comments