Recent content on Joseph Conway
I’m a long-time PostgreSQL community member and contributor. I authored PL/R , the PostgreSQL procedural language for R, and have spent most of my career working on the database from the inside out. I currently work at AWS . The most up-to-date professional summary is on my LinkedIn profile . Elsewhere Code on GitHub Past and current talks under Presentations Notes and downloads for PL/R…
After many years on a hand-edited HTML5UP template, joeconway.com is reborn as a Hugo site.
User documentation, how-tos, and tips for PL/R. The primary source repository is on GitHub . Important notes when using PL/R Define R_HOME so that $R_HOME/bin is in your $PATH . Ensure all R library DLLs and any other dependent shared libraries are also in your $PATH . A particularly good walkthrough, especially for Windows users, lives at BostonGIS . Examples A graphing example using files PL/R…
Using PostgreSQL Row-Level Security and partitioning as an alternative to traditional history tables.
Co-presented with Michael Meskes.
Co-presented with Stephen Frost. Covers advanced SQL features (window functions, CTEs, LATERAL), JSONB, SP-GiST, and PostgreSQL function fundamentals with examples.
Co-presented with Jeff Hamann (Forest Informatics). Methodology and tooling for predictive analytics on server time-series data with PostgreSQL and PL/R.
Co-presented with Michael Meskes. Walks through migrations from Oracle, Informix, MySQL, and MSSQL into PostgreSQL.