[resolaibohp]

I agree with using sqldf, it is a wonderful tool in R. I am sure you are aware already, but for those who are not, sqldf does not support window functions with it being based on sqlite. Just wanted to point this out as the original article emphasizes them.

[ggrothendieck]

Actually the sqldf R package supports 4 backend databases (sqlite, h2, postgresql, mysql), not just sqlite, and postgresql does support window functions.