JOSEPH CONWAY

OSCON 2004: Flexible Data Acquisition and Analysis. OSCON 2005: Terabytes of Business Intelligence. PGCon 2007: Improving your View. PGDay San Jose 2009: PL/R Lightning Talk. Postgres Open, September 2011: PL/R - The Fast Path to Advanced Analytics. Postgres Open, September 2011: Migration to PostgreSQL - preparation and methodology.

JOSEPH CONWAY

Table of Contents 1. Change log 2. Documentation | | Source repo via github 3. Download PL/R source (plr-8.2.0.10) for PostgreSQL 8.2 4. Download PL/R source (plr-8.3.0.17) for PostgreSQL 8.3 and higher POSTGRESQL FUNCTIONS BY EXAMPLE Overview Function Basics By Example PostgreSQL Functions By Example Joe Conway joe.conway@credativ.com credativ Group January 20, 2012 Joe Conway SCALE10X-PGDay ADVANCED SQL AND FUNCTIONS Adv. SQL - Basics Adv. SQL - Window Functions, CTEs, LATERAL JSONB and SP-GIST Functions - Overview Function Basics Functions - By Example Advanced SQL and Functions POSTGRESQL SUPPORT FUNCTIONS Chapter 7. PostgreSQL Support Functions. The following commands are available to use in PostgreSQL queries to aid in the use of PL/R

functions:

SECCOMP YOUR POSTGRESQL SECCOMP your PostgreSQL Joe Conway joe@crunchydata.com mail@joeconway.com @josepheconway Crunchy Data 2020-0202 FUN WITH FUNCTIONS, BY EXAMPLE Functions - Overview Function Basics Functions - By Example Fun with Functions, by Example Joe Conway joe.conway@credativ.com credativ

International

PL/R THE FAST PATH TO ADVANCED ANALYTICS Overview Usage Features Advanced Summary Intro Pros/Cons Installation Pros Leverage people’s knowledge and skills statistics/math is a specialty Leverage hardware

MLS POSTGRESQL

1/61 Overview Solution Components Implementation Results MLS PostgreSQL Joe Conway joe.conway@crunchydata.com mail@joeconway.com Crunchy Data January 21, 2016 MIGRATION TO POSTGRESQL PREPARATION AND METHODOLOGY Overview Oracle to PostgreSQL Informix to PostgreSQL MySQL to PostgreSQL MSSQL to PostgreSQL Replication and/or High Availability Discussion Migration to PostgreSQL

JOSEPH CONWAY

OSCON 2004: Flexible Data Acquisition and Analysis. OSCON 2005: Terabytes of Business Intelligence. PGCon 2007: Improving your View. PGDay San Jose 2009: PL/R Lightning Talk. Postgres Open, September 2011: PL/R - The Fast Path to Advanced Analytics. Postgres Open, September 2011: Migration to PostgreSQL - preparation and methodology.

JOSEPH CONWAY

Table of Contents 1. Change log 2. Documentation | | Source repo via github 3. Download PL/R source (plr-8.2.0.10) for PostgreSQL 8.2 4. Download PL/R source (plr-8.3.0.17) for PostgreSQL 8.3 and higher POSTGRESQL FUNCTIONS BY EXAMPLE Overview Function Basics By Example PostgreSQL Functions By Example Joe Conway joe.conway@credativ.com credativ Group January 20, 2012 Joe Conway SCALE10X-PGDay ADVANCED SQL AND FUNCTIONS Adv. SQL - Basics Adv. SQL - Window Functions, CTEs, LATERAL JSONB and SP-GIST Functions - Overview Function Basics Functions - By Example Advanced SQL and Functions POSTGRESQL SUPPORT FUNCTIONS Chapter 7. PostgreSQL Support Functions. The following commands are available to use in PostgreSQL queries to aid in the use of PL/R

functions:

SECCOMP YOUR POSTGRESQL SECCOMP your PostgreSQL Joe Conway joe@crunchydata.com mail@joeconway.com @josepheconway Crunchy Data 2020-0202 FUN WITH FUNCTIONS, BY EXAMPLE Functions - Overview Function Basics Functions - By Example Fun with Functions, by Example Joe Conway joe.conway@credativ.com credativ

International

PL/R THE FAST PATH TO ADVANCED ANALYTICS Overview Usage Features Advanced Summary Intro Pros/Cons Installation Pros Leverage people’s knowledge and skills statistics/math is a specialty Leverage hardware

MLS POSTGRESQL

1/61 Overview Solution Components Implementation Results MLS PostgreSQL Joe Conway joe.conway@crunchydata.com mail@joeconway.com Crunchy Data January 21, 2016 MIGRATION TO POSTGRESQL PREPARATION AND METHODOLOGY Overview Oracle to PostgreSQL Informix to PostgreSQL MySQL to PostgreSQL MSSQL to PostgreSQL Replication and/or High Availability Discussion Migration to PostgreSQL FUN WITH FUNCTIONS, BY EXAMPLE Functions - Overview Function Basics Functions - By Example Fun with Functions, by Example Joe Conway joe.conway@credativ.com credativ

International

DEEP THOUGHTS

Deep Thoughts Betting on Security Joe Conway joe@crunchydata.com mail@joeconway.com Crunchy Data January 31, 2020

CHAPTER 1. OVERVIEW

Chapter 1. Overview. PL/R is a loadable procedural language that enables you to write PostgreSQL functions and triggers in the R programming language.PL/R offers most (if not all) of the capabilities a function writer has in the R language. FUN WITH FUNCTIONS, BY EXAMPLE Functions - Overview Function Basics Examples Appendix - More Examples Fun with Functions, by Example Joe Conway joe.conway@credativ.com credativ International

USING GLOBAL DATA

Chapter 5. Using Global Data. Sometimes it is useful to have some global status data that is held between two calls to a procedure or is shared between different procedures. HOW GREEN WAS MY VALLEY How Green Was My Valley Joe Conway joe.conway@crunchydata.com mail@joeconway.com Crunchy Data May 15, 2018 THE UPCOMING ROLE OF POSTGRESQL IN FLAT PANEL DISPLAY 11 Two Types of Silicon Transistors Amorphous Silicon • Used for majority of displays today. • Well suited for LCD TV. • Higher power requirement than p-Si. • Not able to support high speed needed for SOG. • Challenged to support OLED TV due to material

WHERE'S WALDO?

Overview Overview by Method Use Cases Questions Intro Agenda Methods Sample Data Agenda Summary of methods Overview by method Example use cases Joe Conway PGConf.EU 2015 FLEXIBLE DATA ACQUISITION AND ANALYSIS Flexible Data Acquisition and Analysis Joe Conway mail@joeconway.com O’Reilly Open Source Convention July 26–30, 2004 SECURING YOUR DATABASE IN AMAZON RDS Introduction User & Database Management Network Management Auditing & Monitoring Backups & Recovery End Securing Your Database in Amazon RDS

Sarah Conway

JOSEPH CONWAY

OSCON 2004: Flexible Data Acquisition and Analysis. OSCON 2005: Terabytes of Business Intelligence. PGCon 2007: Improving your View. PGDay San Jose 2009: PL/R Lightning Talk. Postgres Open, September 2011: PL/R - The Fast Path to Advanced Analytics. Postgres Open, September 2011: Migration to PostgreSQL - preparation and methodology.

JOSEPH CONWAY

Table of Contents 1. Change log 2. Documentation | | Source repo via github 3. Download PL/R source (plr-8.2.0.10) for PostgreSQL 8.2 4. Download PL/R source (plr-8.3.0.17) for PostgreSQL 8.3 and higher POSTGRESQL FUNCTIONS BY EXAMPLE Overview Function Basics By Example PostgreSQL Functions By Example Joe Conway joe.conway@credativ.com credativ Group January 20, 2012 Joe Conway SCALE10X-PGDay ADVANCED SQL AND FUNCTIONS Adv. SQL - Basics Adv. SQL - Window Functions, CTEs, LATERAL JSONB and SP-GIST Functions - Overview Function Basics Functions - By Example Advanced SQL and Functions POSTGRESQL SUPPORT FUNCTIONS Chapter 7. PostgreSQL Support Functions. The following commands are available to use in PostgreSQL queries to aid in the use of PL/R

functions:

SECCOMP YOUR POSTGRESQL SECCOMP your PostgreSQL Joe Conway joe@crunchydata.com mail@joeconway.com @josepheconway Crunchy Data 2020-0202 FUN WITH FUNCTIONS, BY EXAMPLE Functions - Overview Function Basics Functions - By Example Fun with Functions, by Example Joe Conway joe.conway@credativ.com credativ

International

PL/R THE FAST PATH TO ADVANCED ANALYTICS Overview Usage Features Advanced Summary Intro Pros/Cons Installation Pros Leverage people’s knowledge and skills statistics/math is a specialty Leverage hardware

MLS POSTGRESQL

1/61 Overview Solution Components Implementation Results MLS PostgreSQL Joe Conway joe.conway@crunchydata.com mail@joeconway.com Crunchy Data January 21, 2016 MIGRATION TO POSTGRESQL PREPARATION AND METHODOLOGY Overview Oracle to PostgreSQL Informix to PostgreSQL MySQL to PostgreSQL MSSQL to PostgreSQL Replication and/or High Availability Discussion Migration to PostgreSQL

JOSEPH CONWAY

OSCON 2004: Flexible Data Acquisition and Analysis. OSCON 2005: Terabytes of Business Intelligence. PGCon 2007: Improving your View. PGDay San Jose 2009: PL/R Lightning Talk. Postgres Open, September 2011: PL/R - The Fast Path to Advanced Analytics. Postgres Open, September 2011: Migration to PostgreSQL - preparation and methodology.

JOSEPH CONWAY

Table of Contents 1. Change log 2. Documentation | | Source repo via github 3. Download PL/R source (plr-8.2.0.10) for PostgreSQL 8.2 4. Download PL/R source (plr-8.3.0.17) for PostgreSQL 8.3 and higher POSTGRESQL FUNCTIONS BY EXAMPLE Overview Function Basics By Example PostgreSQL Functions By Example Joe Conway joe.conway@credativ.com credativ Group January 20, 2012 Joe Conway SCALE10X-PGDay ADVANCED SQL AND FUNCTIONS Adv. SQL - Basics Adv. SQL - Window Functions, CTEs, LATERAL JSONB and SP-GIST Functions - Overview Function Basics Functions - By Example Advanced SQL and Functions POSTGRESQL SUPPORT FUNCTIONS Chapter 7. PostgreSQL Support Functions. The following commands are available to use in PostgreSQL queries to aid in the use of PL/R

functions:

SECCOMP YOUR POSTGRESQL SECCOMP your PostgreSQL Joe Conway joe@crunchydata.com mail@joeconway.com @josepheconway Crunchy Data 2020-0202 FUN WITH FUNCTIONS, BY EXAMPLE Functions - Overview Function Basics Functions - By Example Fun with Functions, by Example Joe Conway joe.conway@credativ.com credativ

International

PL/R THE FAST PATH TO ADVANCED ANALYTICS Overview Usage Features Advanced Summary Intro Pros/Cons Installation Pros Leverage people’s knowledge and skills statistics/math is a specialty Leverage hardware

MLS POSTGRESQL

1/61 Overview Solution Components Implementation Results MLS PostgreSQL Joe Conway joe.conway@crunchydata.com mail@joeconway.com Crunchy Data January 21, 2016 MIGRATION TO POSTGRESQL PREPARATION AND METHODOLOGY Overview Oracle to PostgreSQL Informix to PostgreSQL MySQL to PostgreSQL MSSQL to PostgreSQL Replication and/or High Availability Discussion Migration to PostgreSQL FUN WITH FUNCTIONS, BY EXAMPLE Functions - Overview Function Basics Functions - By Example Fun with Functions, by Example Joe Conway joe.conway@credativ.com credativ

International

DEEP THOUGHTS

Deep Thoughts Betting on Security Joe Conway joe@crunchydata.com mail@joeconway.com Crunchy Data January 31, 2020

CHAPTER 1. OVERVIEW

Chapter 1. Overview. PL/R is a loadable procedural language that enables you to write PostgreSQL functions and triggers in the R programming language.PL/R offers most (if not all) of the capabilities a function writer has in the R language. FUN WITH FUNCTIONS, BY EXAMPLE Functions - Overview Function Basics Examples Appendix - More Examples Fun with Functions, by Example Joe Conway joe.conway@credativ.com credativ International

USING GLOBAL DATA

Chapter 5. Using Global Data. Sometimes it is useful to have some global status data that is held between two calls to a procedure or is shared between different procedures. HOW GREEN WAS MY VALLEY How Green Was My Valley Joe Conway joe.conway@crunchydata.com mail@joeconway.com Crunchy Data May 15, 2018 THE UPCOMING ROLE OF POSTGRESQL IN FLAT PANEL DISPLAY 11 Two Types of Silicon Transistors Amorphous Silicon • Used for majority of displays today. • Well suited for LCD TV. • Higher power requirement than p-Si. • Not able to support high speed needed for SOG. • Challenged to support OLED TV due to material

WHERE'S WALDO?

Overview Overview by Method Use Cases Questions Intro Agenda Methods Sample Data Agenda Summary of methods Overview by method Example use cases Joe Conway PGConf.EU 2015 FLEXIBLE DATA ACQUISITION AND ANALYSIS Flexible Data Acquisition and Analysis Joe Conway mail@joeconway.com O’Reilly Open Source Convention July 26–30, 2004 SECURING YOUR DATABASE IN AMAZON RDS Introduction User & Database Management Network Management Auditing & Monitoring Backups & Recovery End Securing Your Database in Amazon RDS

Sarah Conway

JOSEPH CONWAY

OSCON 2004: Flexible Data Acquisition and Analysis. OSCON 2005: Terabytes of Business Intelligence. PGCon 2007: Improving your View. PGDay San Jose 2009: PL/R Lightning Talk. Postgres Open, September 2011: PL/R - The Fast Path to Advanced Analytics. Postgres Open, September 2011: Migration to PostgreSQL - preparation and methodology.

JOSEPH CONWAY

Table of Contents 1. Change log 2. Documentation | | Source repo via github 3. Download PL/R source (plr-8.2.0.10) for PostgreSQL 8.2 4. Download PL/R source (plr-8.3.0.17) for PostgreSQL 8.3 and higher POSTGRESQL FUNCTIONS BY EXAMPLE Overview Function Basics By Example PostgreSQL Functions By Example Joe Conway joe.conway@credativ.com credativ Group January 20, 2012 Joe Conway SCALE10X-PGDay ADVANCED SQL AND FUNCTIONS Adv. SQL - Basics Adv. SQL - Window Functions, CTEs, LATERAL JSONB and SP-GIST Functions - Overview Function Basics Functions - By Example Advanced SQL and Functions POSTGRESQL SUPPORT FUNCTIONS Chapter 7. PostgreSQL Support Functions. The following commands are available to use in PostgreSQL queries to aid in the use of PL/R

functions:

SECCOMP YOUR POSTGRESQL SECCOMP your PostgreSQL Joe Conway joe@crunchydata.com mail@joeconway.com @josepheconway Crunchy Data 2020-0202

DEEP THOUGHTS

Deep Thoughts Betting on Security Joe Conway joe@crunchydata.com mail@joeconway.com Crunchy Data January 31, 2020 FUN WITH FUNCTIONS, BY EXAMPLE Functions - Overview Function Basics Functions - By Example Fun with Functions, by Example Joe Conway joe.conway@credativ.com credativ

International

PL/R THE FAST PATH TO ADVANCED ANALYTICS Overview Usage Features Advanced Summary Intro Pros/Cons Installation Pros Leverage people’s knowledge and skills statistics/math is a specialty Leverage hardware MIGRATION TO POSTGRESQL PREPARATION AND METHODOLOGY Overview Oracle to PostgreSQL Informix to PostgreSQL MySQL to PostgreSQL MSSQL to PostgreSQL Replication and/or High Availability Discussion Migration to PostgreSQL

JOSEPH CONWAY

OSCON 2004: Flexible Data Acquisition and Analysis. OSCON 2005: Terabytes of Business Intelligence. PGCon 2007: Improving your View. PGDay San Jose 2009: PL/R Lightning Talk. Postgres Open, September 2011: PL/R - The Fast Path to Advanced Analytics. Postgres Open, September 2011: Migration to PostgreSQL - preparation and methodology.

JOSEPH CONWAY

Table of Contents 1. Change log 2. Documentation | | Source repo via github 3. Download PL/R source (plr-8.2.0.10) for PostgreSQL 8.2 4. Download PL/R source (plr-8.3.0.17) for PostgreSQL 8.3 and higher POSTGRESQL FUNCTIONS BY EXAMPLE Overview Function Basics By Example PostgreSQL Functions By Example Joe Conway joe.conway@credativ.com credativ Group January 20, 2012 Joe Conway SCALE10X-PGDay ADVANCED SQL AND FUNCTIONS Adv. SQL - Basics Adv. SQL - Window Functions, CTEs, LATERAL JSONB and SP-GIST Functions - Overview Function Basics Functions - By Example Advanced SQL and Functions POSTGRESQL SUPPORT FUNCTIONS Chapter 7. PostgreSQL Support Functions. The following commands are available to use in PostgreSQL queries to aid in the use of PL/R

functions:

SECCOMP YOUR POSTGRESQL SECCOMP your PostgreSQL Joe Conway joe@crunchydata.com mail@joeconway.com @josepheconway Crunchy Data 2020-0202

DEEP THOUGHTS

Deep Thoughts Betting on Security Joe Conway joe@crunchydata.com mail@joeconway.com Crunchy Data January 31, 2020 FUN WITH FUNCTIONS, BY EXAMPLE Functions - Overview Function Basics Functions - By Example Fun with Functions, by Example Joe Conway joe.conway@credativ.com credativ

International

PL/R THE FAST PATH TO ADVANCED ANALYTICS Overview Usage Features Advanced Summary Intro Pros/Cons Installation Pros Leverage people’s knowledge and skills statistics/math is a specialty Leverage hardware MIGRATION TO POSTGRESQL PREPARATION AND METHODOLOGY Overview Oracle to PostgreSQL Informix to PostgreSQL MySQL to PostgreSQL MSSQL to PostgreSQL Replication and/or High Availability Discussion Migration to PostgreSQL FUN WITH FUNCTIONS, BY EXAMPLE Functions - Overview Function Basics Functions - By Example Fun with Functions, by Example Joe Conway joe.conway@credativ.com credativ

International

DEEP THOUGHTS

Deep Thoughts Betting on Security Joe Conway joe@crunchydata.com mail@joeconway.com Crunchy Data January 31, 2020

CHAPTER 1. OVERVIEW

Chapter 1. Overview. PL/R is a loadable procedural language that enables you to write PostgreSQL functions and triggers in the R programming language.PL/R offers most (if not all) of the capabilities a function writer has in the R language. FUN WITH FUNCTIONS, BY EXAMPLE Functions - Overview Function Basics Examples Appendix - More Examples Fun with Functions, by Example Joe Conway joe.conway@credativ.com credativ International

USING GLOBAL DATA

Chapter 5. Using Global Data. Sometimes it is useful to have some global status data that is held between two calls to a procedure or is shared between different procedures. HOW GREEN WAS MY VALLEY How Green Was My Valley Joe Conway joe.conway@crunchydata.com mail@joeconway.com Crunchy Data May 15, 2018 THE UPCOMING ROLE OF POSTGRESQL IN FLAT PANEL DISPLAY 11 Two Types of Silicon Transistors Amorphous Silicon • Used for majority of displays today. • Well suited for LCD TV. • Higher power requirement than p-Si. • Not able to support high speed needed for SOG. • Challenged to support OLED TV due to material

WHERE'S WALDO?

Overview Overview by Method Use Cases Questions Intro Agenda Methods Sample Data Agenda Summary of methods Overview by method Example use cases Joe Conway PGConf.EU 2015 FLEXIBLE DATA ACQUISITION AND ANALYSIS Flexible Data Acquisition and Analysis Joe Conway mail@joeconway.com O’Reilly Open Source Convention July 26–30, 2004 SECURING YOUR DATABASE IN AMAZON RDS Introduction User & Database Management Network Management Auditing & Monitoring Backups & Recovery End Securing Your Database in Amazon RDS

Sarah Conway

JOSEPH CONWAY

PGDay Southern California, SCALE10X, January 2012: PostgreSQL Functions By Example; LISA2012, December 2012: Options for Predictive

Server Analytics

JOSEPH CONWAY

Table of Contents 1. Change log 2. Documentation | | Source repo via github 3. Download PL/R source (plr-8.2.0.10) for PostgreSQL 8.2 4. Download PL/R source (plr-8.3.0.17) for PostgreSQL 8.3 and higher ADVANCED SQL AND FUNCTIONS Adv. SQL - Basics Adv. SQL - Window Functions, CTEs, LATERAL JSONB and SP-GIST Functions - Overview Function Basics Functions - By Example Advanced SQL and Functions POSTGRESQL FUNCTIONS BY EXAMPLE Overview Function Basics By Example PostgreSQL Functions By Example Joe Conway joe.conway@credativ.com credativ Group January 20, 2012 Joe Conway SCALE10X-PGDay POSTGRESQL SUPPORT FUNCTIONS Chapter 7. PostgreSQL Support Functions. The following commands are available to use in PostgreSQL queries to aid in the use of PL/R

functions:

SECCOMP YOUR POSTGRESQL SECCOMP your PostgreSQL Joe Conway joe@crunchydata.com mail@joeconway.com @josepheconway Crunchy Data 2020-0202

DEEP THOUGHTS

Deep Thoughts Betting on Security Joe Conway joe@crunchydata.com mail@joeconway.com Crunchy Data January 31, 2020 FUN WITH FUNCTIONS, BY EXAMPLE Functions - Overview Function Basics Functions - By Example Fun with Functions, by Example Joe Conway joe.conway@credativ.com credativ

International

PL/R THE FAST PATH TO ADVANCED ANALYTICS Overview Usage Features Advanced Summary Intro Pros/Cons Installation Pros Leverage people’s knowledge and skills statistics/math is a specialty Leverage hardware MIGRATION TO POSTGRESQL PREPARATION AND METHODOLOGY Overview Oracle to PostgreSQL Informix to PostgreSQL MySQL to PostgreSQL MSSQL to PostgreSQL Replication and/or High Availability Discussion Migration to PostgreSQL

JOSEPH CONWAY

PGDay Southern California, SCALE10X, January 2012: PostgreSQL Functions By Example; LISA2012, December 2012: Options for Predictive

Server Analytics

JOSEPH CONWAY

Table of Contents 1. Change log 2. Documentation | | Source repo via github 3. Download PL/R source (plr-8.2.0.10) for PostgreSQL 8.2 4. Download PL/R source (plr-8.3.0.17) for PostgreSQL 8.3 and higher ADVANCED SQL AND FUNCTIONS Adv. SQL - Basics Adv. SQL - Window Functions, CTEs, LATERAL JSONB and SP-GIST Functions - Overview Function Basics Functions - By Example Advanced SQL and Functions POSTGRESQL FUNCTIONS BY EXAMPLE Overview Function Basics By Example PostgreSQL Functions By Example Joe Conway joe.conway@credativ.com credativ Group January 20, 2012 Joe Conway SCALE10X-PGDay POSTGRESQL SUPPORT FUNCTIONS Chapter 7. PostgreSQL Support Functions. The following commands are available to use in PostgreSQL queries to aid in the use of PL/R

functions:

SECCOMP YOUR POSTGRESQL SECCOMP your PostgreSQL Joe Conway joe@crunchydata.com mail@joeconway.com @josepheconway Crunchy Data 2020-0202

DEEP THOUGHTS

Deep Thoughts Betting on Security Joe Conway joe@crunchydata.com mail@joeconway.com Crunchy Data January 31, 2020 FUN WITH FUNCTIONS, BY EXAMPLE Functions - Overview Function Basics Functions - By Example Fun with Functions, by Example Joe Conway joe.conway@credativ.com credativ

International

PL/R THE FAST PATH TO ADVANCED ANALYTICS Overview Usage Features Advanced Summary Intro Pros/Cons Installation Pros Leverage people’s knowledge and skills statistics/math is a specialty Leverage hardware MIGRATION TO POSTGRESQL PREPARATION AND METHODOLOGY Overview Oracle to PostgreSQL Informix to PostgreSQL MySQL to PostgreSQL MSSQL to PostgreSQL Replication and/or High Availability Discussion Migration to PostgreSQL FUN WITH FUNCTIONS, BY EXAMPLE Functions - Overview Function Basics Functions - By Example Fun with Functions, by Example Joe Conway joe.conway@credativ.com credativ

International

DEEP THOUGHTS

Deep Thoughts Betting on Security Joe Conway joe@crunchydata.com mail@joeconway.com Crunchy Data January 31, 2020

CHAPTER 1. OVERVIEW

Chapter 1. Overview. PL/R is a loadable procedural language that enables you to write PostgreSQL functions and triggers in the R programming language.PL/R offers most (if not all) of the capabilities a function writer has in the R language. FUN WITH FUNCTIONS, BY EXAMPLE Functions - Overview Function Basics Examples Appendix - More Examples Fun with Functions, by Example Joe Conway joe.conway@credativ.com credativ International

USING GLOBAL DATA

Chapter 5. Using Global Data. Sometimes it is useful to have some global status data that is held between two calls to a procedure or is shared between different procedures. HOW GREEN WAS MY VALLEY How Green Was My Valley Joe Conway joe.conway@crunchydata.com mail@joeconway.com Crunchy Data May 15, 2018 THE UPCOMING ROLE OF POSTGRESQL IN FLAT PANEL DISPLAY 11 Two Types of Silicon Transistors Amorphous Silicon • Used for majority of displays today. • Well suited for LCD TV. • Higher power requirement than p-Si. • Not able to support high speed needed for SOG. • Challenged to support OLED TV due to material

WHERE'S WALDO?

Overview Overview by Method Use Cases Questions Intro Agenda Methods Sample Data Agenda Summary of methods Overview by method Example use cases Joe Conway PGConf.EU 2015 FLEXIBLE DATA ACQUISITION AND ANALYSIS Flexible Data Acquisition and Analysis Joe Conway mail@joeconway.com O’Reilly Open Source Convention July 26–30, 2004 SECURING YOUR DATABASE IN AMAZON RDS Introduction User & Database Management Network Management Auditing & Monitoring Backups & Recovery End Securing Your Database in Amazon RDS

Sarah Conway

JOSEPH CONWAY

PGDay Southern California, SCALE10X, January 2012: PostgreSQL Functions By Example; LISA2012, December 2012: Options for Predictive

Server Analytics

JOSEPH CONWAY

Table of Contents 1. Change log 2. Documentation | | Source repo via github 3. Download PL/R source (plr-8.2.0.10) for PostgreSQL 8.2 4. Download PL/R source (plr ADVANCED SQL AND FUNCTIONS Adv. SQL - Basics Adv. SQL - Window Functions, CTEs, LATERAL JSONB and SP-GIST Functions - Overview Function Basics Functions - By Example Advanced SQL and Functions POSTGRESQL FUNCTIONS BY EXAMPLE Overview Function Basics By Example PostgreSQL Functions By Example Joe Conway joe.conway@credativ.com credativ Group January 20, 2012 Joe Conway SCALE10X-PGDay POSTGRESQL SUPPORT FUNCTIONS Chapter 7. PostgreSQL Support Functions. The following commands are available to use in PostgreSQL queries to aid in the use of PL/R

functions:

DEEP THOUGHTS

Deep Thoughts Betting on Security Joe Conway joe@crunchydata.com mail@joeconway.com Crunchy Data January 31, 2020 SECCOMP YOUR POSTGRESQL SECCOMP your PostgreSQL Joe Conway joe@crunchydata.com mail@joeconway.com @josepheconway Crunchy Data 2020-0202 PL/R THE FAST PATH TO ADVANCED ANALYTICS Overview Usage Features Advanced Summary Intro Pros/Cons Installation Pros Leverage people’s knowledge and skills statistics/math is a specialty Leverage hardware

MLS POSTGRESQL

1/61 Overview Solution Components Implementation Results MLS PostgreSQL Joe Conway joe.conway@crunchydata.com mail@joeconway.com Crunchy Data January 21, 2016 MIGRATION TO POSTGRESQL PREPARATION AND METHODOLOGY Overview Oracle to PostgreSQL Informix to PostgreSQL MySQL to PostgreSQL MSSQL to PostgreSQL Replication and/or High Availability Discussion Migration to PostgreSQL

JOSEPH CONWAY

PGDay Southern California, SCALE10X, January 2012: PostgreSQL Functions By Example; LISA2012, December 2012: Options for Predictive

Server Analytics

JOSEPH CONWAY

Table of Contents 1. Change log 2. Documentation | | Source repo via github 3. Download PL/R source (plr-8.2.0.10) for PostgreSQL 8.2 4. Download PL/R source (plr ADVANCED SQL AND FUNCTIONS Adv. SQL - Basics Adv. SQL - Window Functions, CTEs, LATERAL JSONB and SP-GIST Functions - Overview Function Basics Functions - By Example Advanced SQL and Functions POSTGRESQL FUNCTIONS BY EXAMPLE Overview Function Basics By Example PostgreSQL Functions By Example Joe Conway joe.conway@credativ.com credativ Group January 20, 2012 Joe Conway SCALE10X-PGDay POSTGRESQL SUPPORT FUNCTIONS Chapter 7. PostgreSQL Support Functions. The following commands are available to use in PostgreSQL queries to aid in the use of PL/R

functions:

DEEP THOUGHTS

Deep Thoughts Betting on Security Joe Conway joe@crunchydata.com mail@joeconway.com Crunchy Data January 31, 2020 SECCOMP YOUR POSTGRESQL SECCOMP your PostgreSQL Joe Conway joe@crunchydata.com mail@joeconway.com @josepheconway Crunchy Data 2020-0202 PL/R THE FAST PATH TO ADVANCED ANALYTICS Overview Usage Features Advanced Summary Intro Pros/Cons Installation Pros Leverage people’s knowledge and skills statistics/math is a specialty Leverage hardware

MLS POSTGRESQL

1/61 Overview Solution Components Implementation Results MLS PostgreSQL Joe Conway joe.conway@crunchydata.com mail@joeconway.com Crunchy Data January 21, 2016 MIGRATION TO POSTGRESQL PREPARATION AND METHODOLOGY Overview Oracle to PostgreSQL Informix to PostgreSQL MySQL to PostgreSQL MSSQL to PostgreSQL Replication and/or High Availability Discussion Migration to PostgreSQL

JOSEPH CONWAY

PGDay Southern California, SCALE10X, January 2012: PostgreSQL Functions By Example; LISA2012, December 2012: Options for Predictive

Server Analytics

DEEP THOUGHTS

Deep Thoughts Betting on Security Joe Conway joe@crunchydata.com mail@joeconway.com Crunchy Data January 31, 2020 FUN WITH FUNCTIONS, BY EXAMPLE Functions - Overview Function Basics Examples Appendix - More Examples Fun with Functions, by Example Joe Conway joe.conway@credativ.com credativ International FUN WITH FUNCTIONS, BY EXAMPLE Functions - Overview Function Basics Functions - By Example Fun with Functions, by Example Joe Conway joe.conway@credativ.com credativ

International

THE UPCOMING ROLE OF POSTGRESQL IN FLAT PANEL DISPLAY 11 Two Types of Silicon Transistors Amorphous Silicon • Used for majority of displays today. • Well suited for LCD TV. • Higher power requirement than p-Si. • Not able to support high speed needed for SOG. • Challenged to support OLED TV due to material FUNCTION LIBRARY QUESTIONS Overview Function Library Questions Shebang Joe Conway mail@joeconway.com June 19, 2015 Joe Conway PGCon 2015

WHERE'S WALDO?

Overview Overview by Method Use Cases Questions Intro Agenda Methods Sample Data Agenda Summary of methods Overview by method Example use cases Joe Conway PGConf.EU 2015 POSTGRES INTERFACE PERFORMANCE Overview Methodology Code Test Cases Results Postgres Interface Performance Joe Conway joe.conway@credativ.com mail@joeconway.com credativ USA September 18, 2014

JOSEPH CONWAY

Created Date: 4/18/2009 5:14:03 PM SECURING YOUR DATABASE IN AMAZON RDS Introduction User & Database Management Network Management Auditing & Monitoring Backups & Recovery End Securing Your Database in Amazon RDS

Sarah Conway

JOSEPH CONWAY

PGDay Southern California, SCALE10X, January 2012: PostgreSQL Functions By Example; LISA2012, December 2012: Options for Predictive

Server Analytics

POSTGRESQL FUNCTIONS BY EXAMPLE Overview Function Basics By Example PostgreSQL Functions By Example Joe Conway joe.conway@credativ.com credativ Group January 20, 2012 Joe Conway SCALE10X-PGDay ADVANCED SQL AND FUNCTIONS Adv. SQL - Basics Adv. SQL - Window Functions, CTEs, LATERAL JSONB and SP-GIST Functions - Overview Function Basics Functions - By Example Advanced SQL and Functions

JOSEPH CONWAY

Table of Contents 1. Change log 2. Documentation | | Source repo via github 3. Download PL/R source (plr-8.2.0.10) for PostgreSQL 8.2 4.

Download PL/R

SECCOMP YOUR POSTGRESQL SECCOMP your PostgreSQL Joe Conway joe@crunchydata.com mail@joeconway.com @josepheconway Crunchy Data 2020-0202 POSTGRESQL SUPPORT FUNCTIONS Chapter 7. PostgreSQL Support Functions. The following commands are available to use in PostgreSQL queries to aid in the use of PL/R

functions:

DEEP THOUGHTS

Deep Thoughts Betting on Security Joe Conway joe@crunchydata.com mail@joeconway.com Crunchy Data January 31, 2020 PL/R THE FAST PATH TO ADVANCED ANALYTICS Overview Usage Features Advanced Summary Intro Pros/Cons Installation Pros Leverage people’s knowledge and skills statistics/math is a specialty Leverage hardware

MLS POSTGRESQL

1/61 Overview Solution Components Implementation Results MLS PostgreSQL Joe Conway joe.conway@crunchydata.com mail@joeconway.com Crunchy Data January 21, 2016 MIGRATION TO POSTGRESQL PREPARATION AND METHODOLOGY Overview Oracle to PostgreSQL Informix to PostgreSQL MySQL to PostgreSQL MSSQL to PostgreSQL Replication and/or High Availability Discussion Migration to PostgreSQL

JOSEPH CONWAY

PGDay Southern California, SCALE10X, January 2012: PostgreSQL Functions By Example; LISA2012, December 2012: Options for Predictive

Server Analytics

POSTGRESQL FUNCTIONS BY EXAMPLE Overview Function Basics By Example PostgreSQL Functions By Example Joe Conway joe.conway@credativ.com credativ Group January 20, 2012 Joe Conway SCALE10X-PGDay ADVANCED SQL AND FUNCTIONS Adv. SQL - Basics Adv. SQL - Window Functions, CTEs, LATERAL JSONB and SP-GIST Functions - Overview Function Basics Functions - By Example Advanced SQL and Functions

JOSEPH CONWAY

Table of Contents 1. Change log 2. Documentation | | Source repo via github 3. Download PL/R source (plr-8.2.0.10) for PostgreSQL 8.2 4.

Download PL/R

SECCOMP YOUR POSTGRESQL SECCOMP your PostgreSQL Joe Conway joe@crunchydata.com mail@joeconway.com @josepheconway Crunchy Data 2020-0202 POSTGRESQL SUPPORT FUNCTIONS Chapter 7. PostgreSQL Support Functions. The following commands are available to use in PostgreSQL queries to aid in the use of PL/R

functions:

DEEP THOUGHTS

Deep Thoughts Betting on Security Joe Conway joe@crunchydata.com mail@joeconway.com Crunchy Data January 31, 2020 PL/R THE FAST PATH TO ADVANCED ANALYTICS Overview Usage Features Advanced Summary Intro Pros/Cons Installation Pros Leverage people’s knowledge and skills statistics/math is a specialty Leverage hardware

MLS POSTGRESQL

1/61 Overview Solution Components Implementation Results MLS PostgreSQL Joe Conway joe.conway@crunchydata.com mail@joeconway.com Crunchy Data January 21, 2016 MIGRATION TO POSTGRESQL PREPARATION AND METHODOLOGY Overview Oracle to PostgreSQL Informix to PostgreSQL MySQL to PostgreSQL MSSQL to PostgreSQL Replication and/or High Availability Discussion Migration to PostgreSQL

JOSEPH CONWAY

PGDay Southern California, SCALE10X, January 2012: PostgreSQL Functions By Example; LISA2012, December 2012: Options for Predictive

Server Analytics

DEEP THOUGHTS

Deep Thoughts Betting on Security Joe Conway joe@crunchydata.com mail@joeconway.com Crunchy Data January 31, 2020 FUN WITH FUNCTIONS, BY EXAMPLE Functions - Overview Function Basics Functions - By Example Fun with Functions, by Example Joe Conway joe.conway@credativ.com credativ

International

THE UPCOMING ROLE OF POSTGRESQL IN FLAT PANEL DISPLAY 11 Two Types of Silicon Transistors Amorphous Silicon • Used for majority of displays today. • Well suited for LCD TV. • Higher power requirement than p-Si. • Not able to support high speed needed for SOG. • Challenged to support OLED TV due to material FUN WITH FUNCTIONS, BY EXAMPLE Functions - Overview Function Basics Examples Appendix - More Examples Fun with Functions, by Example Joe Conway joe.conway@credativ.com credativ International

WHERE'S WALDO?

Overview Overview by Method Use Cases Questions Intro Agenda Methods Sample Data Agenda Summary of methods Overview by method Example use cases Joe Conway PGConf.EU 2015 SECURING YOUR DATABASE IN AMAZON RDS Introduction User & Database Management Network Management Auditing & Monitoring Backups & Recovery End Securing Your Database in Amazon RDS

Sarah Conway

JOSEPH CONWAY

Created Date: 4/18/2009 5:14:03 PM POSTGRES INTERFACE PERFORMANCE Overview Methodology Code Test Cases Results Postgres Interface Performance Joe Conway joe.conway@credativ.com mail@joeconway.com credativ USA September 18, 2014 POWER POSTGRESQL: EXTENDING THE DATABASE WITH C JOE CONWAY Power PostgreSQL: Extending the Database with C Joe Conway mail@joeconway.com O’Reilly Open Source Convention July 26–30,

2004

JOSEPH CONWAY

OSCON 2004: Flexible Data Acquisition and Analysis. OSCON 2005: Terabytes of Business Intelligence. PGCon 2007: Improving your View. PGDay San Jose 2009: PL/R Lightning Talk. Postgres Open, September 2011: PL/R - The Fast Path to Advanced Analytics. Postgres Open, September 2011: Migration to PostgreSQL - preparation and methodology. POSTGRESQL FUNCTIONS BY EXAMPLE Overview Function Basics By Example PostgreSQL Functions By Example Joe Conway joe.conway@credativ.com credativ Group January 20, 2012 Joe Conway SCALE10X-PGDay ADVANCED SQL AND FUNCTIONS Adv. SQL - Basics Adv. SQL - Window Functions, CTEs, LATERAL JSONB and SP-GIST Functions - Overview Function Basics Functions - By Example Advanced SQL and Functions

JOSEPH CONWAY

Change log: 8.3.0.8 to 8.3.0.9. - Make PL/R compile under MSVC to produce usable win32 binaries. - Updated copyright notices for 2010. - Remove obsolete info from README and point to web site instead. - Consolidate and reorder all header files in order to avoid namespace conflicts between postgres/R/Win32. POSTGRESQL SUPPORT FUNCTIONS Chapter 7. PostgreSQL Support Functions. The following commands are available to use in PostgreSQL queries to aid in the use of PL/R

functions:

SECCOMP YOUR POSTGRESQL SECCOMP your PostgreSQL Joe Conway joe@crunchydata.com mail@joeconway.com @josepheconway Crunchy Data 2020-0202

DEEP THOUGHTS

Deep Thoughts Betting on Security Joe Conway joe@crunchydata.com mail@joeconway.com Crunchy Data January 31, 2020 MIGRATION TO POSTGRESQL Overview Oracle to PostgreSQL Informix to PostgreSQL MySQL to PostgreSQL MSSQL to PostgreSQL Replication and/or High Availability Discussion Migration to PostgreSQL - preparation and PL/R THE FAST PATH TO ADVANCED ANALYTICS Overview Usage Features Advanced Summary Intro Pros/Cons Installation Pros Leverage people’s knowledge and skills statistics/math is a specialty Leverage hardware

WHERE'S WALDO?

Overview Overview by Method Use Cases Questions Intro Agenda Methods Sample Data Agenda Summary of methods Overview by method Example use cases Joe Conway PGConf.EU 2015

JOSEPH CONWAY

OSCON 2004: Flexible Data Acquisition and Analysis. OSCON 2005: Terabytes of Business Intelligence. PGCon 2007: Improving your View. PGDay San Jose 2009: PL/R Lightning Talk. Postgres Open, September 2011: PL/R - The Fast Path to Advanced Analytics. Postgres Open, September 2011: Migration to PostgreSQL - preparation and methodology. POSTGRESQL FUNCTIONS BY EXAMPLE Overview Function Basics By Example PostgreSQL Functions By Example Joe Conway joe.conway@credativ.com credativ Group January 20, 2012 Joe Conway SCALE10X-PGDay ADVANCED SQL AND FUNCTIONS Adv. SQL - Basics Adv. SQL - Window Functions, CTEs, LATERAL JSONB and SP-GIST Functions - Overview Function Basics Functions - By Example Advanced SQL and Functions

JOSEPH CONWAY

Change log: 8.3.0.8 to 8.3.0.9. - Make PL/R compile under MSVC to produce usable win32 binaries. - Updated copyright notices for 2010. - Remove obsolete info from README and point to web site instead. - Consolidate and reorder all header files in order to avoid namespace conflicts between postgres/R/Win32. POSTGRESQL SUPPORT FUNCTIONS Chapter 7. PostgreSQL Support Functions. The following commands are available to use in PostgreSQL queries to aid in the use of PL/R

functions:

SECCOMP YOUR POSTGRESQL SECCOMP your PostgreSQL Joe Conway joe@crunchydata.com mail@joeconway.com @josepheconway Crunchy Data 2020-0202

DEEP THOUGHTS

Deep Thoughts Betting on Security Joe Conway joe@crunchydata.com mail@joeconway.com Crunchy Data January 31, 2020 MIGRATION TO POSTGRESQL Overview Oracle to PostgreSQL Informix to PostgreSQL MySQL to PostgreSQL MSSQL to PostgreSQL Replication and/or High Availability Discussion Migration to PostgreSQL - preparation and PL/R THE FAST PATH TO ADVANCED ANALYTICS Overview Usage Features Advanced Summary Intro Pros/Cons Installation Pros Leverage people’s knowledge and skills statistics/math is a specialty Leverage hardware

WHERE'S WALDO?

Overview Overview by Method Use Cases Questions Intro Agenda Methods Sample Data Agenda Summary of methods Overview by method Example use cases Joe Conway PGConf.EU 2015

JOSEPH CONWAY

OSCON 2004: Flexible Data Acquisition and Analysis. OSCON 2005: Terabytes of Business Intelligence. PGCon 2007: Improving your View. PGDay San Jose 2009: PL/R Lightning Talk. Postgres Open, September 2011: PL/R - The Fast Path to Advanced Analytics. Postgres Open, September 2011: Migration to PostgreSQL - preparation and methodology. MIGRATION TO POSTGRESQL Overview Oracle to PostgreSQL Informix to PostgreSQL MySQL to PostgreSQL MSSQL to PostgreSQL Replication and/or High Availability Discussion Migration to PostgreSQL - preparation and FUN WITH FUNCTIONS, BY EXAMPLE Functions - Overview Function Basics Functions - By Example Fun with Functions, by Example Joe Conway joe.conway@credativ.com credativ

International

HOW GREEN WAS MY VALLEY How Green Was My Valley Joe Conway joe.conway@crunchydata.com mail@joeconway.com Crunchy Data May 15, 2018 OPTIONS FOR PREDICTIVE SERVER ANALYTICS credativ-logo Overview Test Method Details Running the Tests Predictive Analytics Options for Predictive Server Analytics Joe Conway and Je Hamann THE UPCOMING ROLE OF POSTGRESQL IN FLAT PANEL DISPLAY 11 Two Types of Silicon Transistors Amorphous Silicon • Used for majority of displays today. • Well suited for LCD TV. • Higher power requirement than p-Si. • Not able to support high speed needed for SOG. • Challenged to support OLED TV due to material FLEXIBLE DATA ACQUISITION AND ANALYSIS Flexible Data Acquisition and Analysis Joe Conway mail@joeconway.com O’Reilly Open Source Convention July 26–30, 2004

JOSEPH CONWAY

Created Date: 4/18/2009 5:14:03 PM

MLS POSTGRESQL

1/61 Overview Solution Components Implementation Results MLS PostgreSQL Joe Conway joe.conway@crunchydata.com mail@joeconway.com Crunchy Data January 21, 2016 SECURING YOUR DATABASE IN AMAZON RDS Introduction User & Database Management Network Management Auditing & Monitoring Backups & Recovery End Securing Your Database in Amazon RDS

Sarah Conway

JOSEPH CONWAY

* Twitter

* Facebook

* LinkedIn

* GitHub

ABOUT ME

If you want to view my professional biography, please visit my

LinkedIn profile .

Otherwise, see presentations, source code, PL/R notes ,

or PL/R Project .

PRESENTATIONS

* OSCON 2003: PostgreSQL-embedded Statistical Analysis with PL/R * OSCON 2004 tutorial: Power PostgreSQL: Extending the Database with

C

* OSCON 2004: Flexible Data Acquisition and Analysis * OSCON 2005: Terabytes of Business Intelligence * PGCon 2007: Improving your View * PGDay San Jose 2009: PL/R Lightning Talk * Postgres Open, September 2011: PL/R - The Fast Path to Advanced

Analytics

* Postgres Open, September 2011: Migration to PostgreSQL - preparation and methodology * PGWest, September 2011: PL/R - The Fast Path to Advanced Analytics * PGDay Southern California, SCALE10X, January 2012: PostgreSQL Functions By Example * LISA2012, December 2012: Options for Predictive Server Analytics * Postgres Open, September 2014: Adv. SQL + Functions * Postgres Open, September 2014: Postgres Interface Performance * SCALE13X, February 2015: Fun with Functions, by Example * PGConf.US, March 2015: Fun with Functions, by Example * DCPUG/Data Wranglers DC, May 2015: Easy Statistical Analysis in PostgreSQL with PL/R * PGCon, June 2015: Shebang: Scripting with Postgres * Postgres Open, September 2015: Easy Statistical Analysis in PostgreSQL with PL/R * PGConf.EU, Oct 2015: Where's Waldo: Text Search and Pattern Matching in PostgreSQL * PGConf.SV, Nov 2015: Where's Waldo: Text Search and Pattern Matching in PostgreSQL * Nordic PGDay 2017: How Green Was My Valley: Spatial Analytics Red Hat Defense in Depth 2017: Securing PostgreSQL -- Exploring the PostgreSQL STIG and Beyond * FOSS4G NA 2018: How Green Was My Valley: Spatial Analytics

SOURCE CODE

* LISA2012, December 2012: Options for Predictive Server Analytics -

SQL

* OSCON 2004 presentation: sourcecode * OSCON 2004 tutorial: sourcecode * str_validate for 7.3.X/7.4devel * Session Variables Example Functions for Postgres 8.1 * pg_controldata VIEW for PostgreSQL 9.0 (alpha4) * pg_config VIEW for PostgreSQL 9.0 (alpha4)

* GitHub

MENU

* About Me

* Presentations

* Source Code

* PL/R Project

GET IN TOUCH

* mail@joeconway.com

* Crunchy Data

� Untitled. All rights reserved. Image: Pexels . Original template: HTML5 UP . Modified by: Sarah

Conway .

Toggle