Weekly tweet digest for 2010-09-26
- PostgreSQL 9.0 released today! http://www.postgresql.org/docs/9.0/static/release-9-0.html d/l: http://bit.ly/IRbjJ #
- Interview with me! "Mirror, Mirror On The Wall, Which Is The Best Open Source DB Of Them All?" http://bit.ly/9X9xqo #postgresql #
- Ok, who's a member? (Beard club) http://flic.kr/p/8CUMH3 #
- Resisting seen-it urge in response to headline touting 3rd-party functionality addon to mysql that postgres has had for years. #
twittering on 2010-09-22
- Ok, who's a member? (Beard club) http://flic.kr/p/8CUMH3 #
PostgreSQL 9.0: contributions!
New releases are opportunities for reflection!
As PostgreSQL grows, I would like to know how many people are contributing at any time. This is difficult to measure, given how many people contribute in ways not visible to the internet – advocating for PostgreSQL at work, sharing information about PostgreSQL offline in any way, or developing code related to PostgreSQL that isn’t shared directly back.
PostgreSQL developers have a habit of mentioning the people involved in the development of features in the commit logs. This includes people who discuss topics on the mailing list, who report bugs, provide test cases or send in patches. I spent a bit of time digging through the commit logs and pulling out unique names that are mentioned. This is a lossy process, as the log files are long, names are not always easy to spot, and I only spent 6 hours going through it.
I’ve made it through the 9.0 (16163 lines of logs) and 8.4 logs (21257 lines of logs) so far.
Here’s some basic information about them:
- 8.4 logs mention about 230 unique people (11 committers)
- 9.0 logs mention about 275 unique people (16 committers)
- 8.4 development contained 2293 commits with commits per author broken down below (click for a bigger version):
- 9.0 development contained 1703 commits, and the commits per author broken down below (click for a bigger version):
I’m working on graphs about number of lines inserted or deleted by each author, but need more time to work out the information presentation. Some interesting trends emerge about what the role of each committer is – particularly that there are a couple people who seem to be “gardeners” of the code – removing a lot of lines, sometimes more than they are adding. With a project as old as ours (first commit in 1996!), this maintenance work is critical.
I also did some grepping for key words in the commit messages:
word | times mentioned in 8.3 |
times mentioned in 8.4 |
times mentioned in 9.0 |
---|---|---|---|
review | 24 | 14 | 49 |
cute | 29 | 26 | 25 |
tom lane | 904 | 901 | 635 |
gripe | 37 | 48 | 26 |
hot standby | 0 | 5 | 48 |
replication | 18 | 4 | 52 |
You’re welcome to explore our git repo at git.postgresql.org. Thanks to all the folks who worked on the git migration over the past few months, and finally made our transition from CVS to git complete last night!
twittering on 2010-09-21
- PostgreSQL 9.0 released today! http://www.postgresql.org/docs/9.0/static/release-9-0.html d/l: http://bit.ly/IRbjJ #
- Interview with me! "Mirror, Mirror On The Wall, Which Is The Best Open Source DB Of Them All?" http://bit.ly/9X9xqo #postgresql #
twittering on 2010-09-21
- PostgreSQL 9.0 released today! http://www.postgresql.org/docs/9.0/static/release-9-0.html d/l: http://bit.ly/IRbjJ #
- Interview with me! "Mirror, Mirror On The Wall, Which Is The Best Open Source DB Of Them All?" http://bit.ly/9X9xqo #postgresql #
PostgreSQL 9.0 media coverage roundup
As you probably noticed, we released PostgreSQL 9.0 today!
There were quite a few stories, and here’s what I’ve got so far:
- Mirror, Mirror On The Wall, Which Is The BestOpen Source DB Of Them All? (includes audio interview with me and Robin from EDB)
- Oracle MySQL rival PostgreSQL updated
- PostgreSQL database garners new attention
- PostgreSQL 9.0 brings replication and more
- PostgreSQL 9.0 Adds Replication Technology to Open-Source Database
- Slashdot mention! Yay we made it to the front of slashdot!
- PostgreSQL 9.0 mit eingebauter Replikation In German! There were a few in Spanish too, I think.
- Hacker News post (Thread includes some stuff about mysql v postgresql, using postgis and why use streaming replication over log shipping)
- LWN: release thread
- Dutch article from Computerworld.nl Thanks Frank for the link to the Dutch article!
Weekly tweet digest for 2010-09-19
- home sweet home. #
- enjoying coffee from my kiwifoo mug, waiting for the bus. have an idea! #
- alright, who's going to @nopoconi tonight? 🙂 #
- oh awesome! @igniteGov has appeared… #
- OH: Not gnuTwitter? (:D) #
- feeling a bit overwhelmed. but also, full of win. status: http://flic.kr/p/8AhuGT #
- current status: http://en.wikipedia.org/wiki/File:Corna_01_(RaBoe).jpg #
- woo postgresql 9.0 release will be translated into 11 languages! #
- getting ready for @pdxpug #
- watching @eknuth show layers from http://oregonexplorer.info/imagery/ inside of Quantum GIS 🙂 #
- Now, @eknuth demoing ogrinfo on the commandline (from gdal.org) @pdxpug #
- OH: "ESRI throws very expensive parties and produces expensive tools that governments buy." #realtalk @pdxpug #
- Current status: http://hungoverowls.tumblr.com/photo/1280/1098971655/1/tumblr_l8jxh49fSA1qclcx7 #
- Feeling slightly guilty for having cream in my coffee while volunteering at #vegfest but flier sez we're all on a continuum #
- The rain's not going to stop, is it? #hrmph #
twittering on 2010-09-19
twittering on 2010-09-17
- current status: http://en.wikipedia.org/wiki/File:Corna_01_(RaBoe).jpg #
- woo postgresql 9.0 release will be translated into 11 languages! #
- getting ready for @pdxpug #
- watching @eknuth show layers from http://oregonexplorer.info/imagery/ inside of Quantum GIS 🙂 #
- Now, @eknuth demoing ogrinfo on the commandline (from gdal.org) @pdxpug #
- OH: "ESRI throws very expensive parties and produces expensive tools that governments buy." #realtalk @pdxpug #
- Current status: http://hungoverowls.tumblr.com/photo/1280/1098971655/1/tumblr_l8jxh49fSA1qclcx7 #