Using R In The Database: Easy Statistical Analysis in PostgreSQL with PL/R

What You'll Learn

PL/R is a PostgreSQL extension that allows the use of R from within PostgreSQL for advanced analytics in a simple, efficient, and controlled manner. It has been available and actively maintained since January 2003. PL/R works with all supported versions of PostgreSQL, and all recent versions of R. It is used by thousands of people worldwide.

Recent trends in big data favor bringing the analytics closer to the data – meanwhile PL/R has been quietly providing this service for over 10 years! This presentation will introduce the audience to PL/R, discuss the pros and cons of this approach to data analysis, take you through basic usage, and finally illustrate its power with a few advanced examples.

Our Speaker

Joe Conway is an innovative leader with broad experience in a wide array of disciplines and extensive international business exposure. He has been involved with PostgreSQL as a contributor since 2001. He is also the author and maintainer of a PostgreSQL procedural language handler for the R language, PL/R. Joe currently manages credativ USA, which specializes in open source software with a comprehensive range of services, including consulting, architectural and technical advice, software development, training, and personalized support.

Agenda

6:30 - Food and beverages

7:00 - Intro and announcements

7:15 - Talk

8:30 - Head to Tonic for drinks