Menu Home

Using PostgreSQL in R: A quick how-to

The combination of R plus SQL offers an attractive way to work with what we call medium-scale data: data that’s perhaps too large to gracefully work with in its entirety within your favorite desktop analysis tool (whether that be R or Excel), but too small to justify the overhead of […]

SQL Screwdriver

Note February 11, 2020: this articles is out of date, we suggest using the methods of Using PostgreSQL in R: A quick how-to instead. We discuss a “medium scale data” technique that we call “SQL Screwdriver.” Previously we discussed some of the issues of large scale data analytics. A lot […]