Changes

[[Kyran Adams]] [[Work Logs]] [[Kyran Adams (Work Log)|(log page)]]

2018-01-18: Started work on running R functions from PostgreSQL queries following [https://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut01 this tutorial.] First installed R 3.4.3, then realized we needed R 3.3.0 for PL/R to work with PostgreSQL 9.5. Installed R 3.3.0. Link from tutorial for PL/R doesn't work, I used [http://www.joeconway.com/plr.html this instead.] To use R from pgAdmin III, follow the instructions in the tutorial: choose the database, click SQL, and run "CREATE EXTENSION plr;". This was run on databases tigertest and template1. You should be able to run the given examples. [https://www.joeconway.com/presentations/plr-DWDC-2015.05.pdf Another possibly useful presentation on PL/R.] Keep in mind, if the version of PostgreSQL is updated, both the R version and PL/R version will have to match it.