RPostgreSQL goes back to a topic suggestion I had made for the Google Summer of Code 2008, and specifically for the R Project participation that year. And Sameer Kumar Prayaga (whom I then mentored for the project) did a fine job that summer putting together a working framework of package connecting R and the excellent PostgreSQL database system. Unfortunately, Sameer vanished once the summer was up; I heard he got himself a job a another db company.
Fast-forward a few years. A caretaker group had maintained the package in the meantime, but without really writing any new code. But thanks to the tireless efforts of Tomoaki Nishiyama, who not only wrote a lot of new code addressing some of issues logged at the Google Code project page, but also stepped forward and became the new lead maintainer, things are much, much better now.
The first 0.2-0 release a few weeks ago already addressed a rather large number of issues,
bringing the feature set much closer to what one would expect from a feature-complete
package. But one big thorn remained: builds on Windows still required a
local PostgreSQL library installation as well as local compilation. And as we
can tell from the mailing list(s), this is a little daunting for many
potential users. But what did release 0.2-1 bring: a complete set of libpq
sources so that builds on Windows no longer require presence of local
PostgreSQL sources! We tested this using Uwe Ligges’ excellent
win-builder service for R, and
after I reminded Uwe on the weekend to no longer blacklist build attempts of
now have Windows binaries for direct installation. Just call
install.packages(), and you’re good to go — much nicer!
Tomoaki achieved this pretty much single-handedly, and for that reason he greatly deserves some extra praise as an unsung Open Source hero!