02 August 2017

Farther on Down the Road

The end of the Yellow Brick Road is running R inside the RDBMS. PL/R for Postgres was the first I worked with. The commercial databases offer similar support, but at Big Bucks. Alas. Today we find a new odbc package for R which makes a half-step farther down the Road.
But the real power comes in being able to use high-level functions from the dplyr package and have the data processing run in the database, instead of in the local R session.

If nothing else, this package admits that RDBMS semantics (aka, joins and such) belong there, not in R. Come on guys!! If you can figure out a bastard language like R, SQL is a piece of cake.

No comments: