Are you over 18 and want to see adult content?
More Annotations

A complete backup of https://qredible.co.uk
Are you over 18 and want to see adult content?

A complete backup of https://goramblers.org
Are you over 18 and want to see adult content?

A complete backup of https://latamvtc.com
Are you over 18 and want to see adult content?

A complete backup of https://training.gov.au
Are you over 18 and want to see adult content?

A complete backup of https://iste-editions.fr
Are you over 18 and want to see adult content?

A complete backup of https://aspynovard.com
Are you over 18 and want to see adult content?

A complete backup of https://nosweatvegan.com
Are you over 18 and want to see adult content?

A complete backup of https://siseministeerium.ee
Are you over 18 and want to see adult content?

A complete backup of https://victoriaplum.com
Are you over 18 and want to see adult content?

A complete backup of https://featherdown.co.uk
Are you over 18 and want to see adult content?

A complete backup of https://quicklocks247.co.uk
Are you over 18 and want to see adult content?
Favourite Annotations

A complete backup of www.irpinianews.it/coronavirus-codogno-montefusco/
Are you over 18 and want to see adult content?
Text
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/Rfunctions:
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 credativInternational
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 hardwareMLS 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 PostgreSQLJOSEPH 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/Rfunctions:
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 credativInternational
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 hardwareMLS 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 credativInternational
DEEP THOUGHTS
Deep Thoughts Betting on Security Joe Conway joe@crunchydata.com mail@joeconway.com Crunchy Data January 31, 2020CHAPTER 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 InternationalUSING 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 materialWHERE'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 RDSSarah 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/Rfunctions:
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 credativInternational
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 hardwareMLS 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 PostgreSQLJOSEPH 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/Rfunctions:
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 credativInternational
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 hardwareMLS 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 credativInternational
DEEP THOUGHTS
Deep Thoughts Betting on Security Joe Conway joe@crunchydata.com mail@joeconway.com Crunchy Data January 31, 2020CHAPTER 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 InternationalUSING 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 materialWHERE'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 RDSSarah 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/Rfunctions:
SECCOMP YOUR POSTGRESQL SECCOMP your PostgreSQL Joe Conway joe@crunchydata.com mail@joeconway.com @josepheconway Crunchy Data 2020-0202DEEP 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 credativInternational
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 PostgreSQLJOSEPH 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/Rfunctions:
SECCOMP YOUR POSTGRESQL SECCOMP your PostgreSQL Joe Conway joe@crunchydata.com mail@joeconway.com @josepheconway Crunchy Data 2020-0202DEEP 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 credativInternational
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 credativInternational
DEEP THOUGHTS
Deep Thoughts Betting on Security Joe Conway joe@crunchydata.com mail@joeconway.com Crunchy Data January 31, 2020CHAPTER 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 InternationalUSING 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 materialWHERE'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 RDSSarah Conway
JOSEPH CONWAY
PGDay Southern California, SCALE10X, January 2012: PostgreSQL Functions By Example; LISA2012, December 2012: Options for PredictiveServer 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/Rfunctions:
SECCOMP YOUR POSTGRESQL SECCOMP your PostgreSQL Joe Conway joe@crunchydata.com mail@joeconway.com @josepheconway Crunchy Data 2020-0202DEEP 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 credativInternational
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 PostgreSQLJOSEPH CONWAY
PGDay Southern California, SCALE10X, January 2012: PostgreSQL Functions By Example; LISA2012, December 2012: Options for PredictiveServer 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/Rfunctions:
SECCOMP YOUR POSTGRESQL SECCOMP your PostgreSQL Joe Conway joe@crunchydata.com mail@joeconway.com @josepheconway Crunchy Data 2020-0202DEEP 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 credativInternational
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 credativInternational
DEEP THOUGHTS
Deep Thoughts Betting on Security Joe Conway joe@crunchydata.com mail@joeconway.com Crunchy Data January 31, 2020CHAPTER 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 InternationalUSING 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 materialWHERE'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 RDSSarah Conway
JOSEPH CONWAY
PGDay Southern California, SCALE10X, January 2012: PostgreSQL Functions By Example; LISA2012, December 2012: Options for PredictiveServer 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/Rfunctions:
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 hardwareMLS 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 PostgreSQLJOSEPH CONWAY
PGDay Southern California, SCALE10X, January 2012: PostgreSQL Functions By Example; LISA2012, December 2012: Options for PredictiveServer 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/Rfunctions:
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 hardwareMLS 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 PostgreSQLJOSEPH CONWAY
PGDay Southern California, SCALE10X, January 2012: PostgreSQL Functions By Example; LISA2012, December 2012: Options for PredictiveServer 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 credativInternational
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 2015WHERE'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, 2014JOSEPH 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 RDSSarah Conway
JOSEPH CONWAY
PGDay Southern California, SCALE10X, January 2012: PostgreSQL Functions By Example; LISA2012, December 2012: Options for PredictiveServer 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 FunctionsJOSEPH 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/Rfunctions:
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 hardwareMLS 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 PostgreSQLJOSEPH CONWAY
PGDay Southern California, SCALE10X, January 2012: PostgreSQL Functions By Example; LISA2012, December 2012: Options for PredictiveServer 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 FunctionsJOSEPH 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/Rfunctions:
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 hardwareMLS 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 PostgreSQLJOSEPH CONWAY
PGDay Southern California, SCALE10X, January 2012: PostgreSQL Functions By Example; LISA2012, December 2012: Options for PredictiveServer 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 credativInternational
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 InternationalWHERE'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 RDSSarah 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 FunctionsJOSEPH 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/Rfunctions:
SECCOMP YOUR POSTGRESQL SECCOMP your PostgreSQL Joe Conway joe@crunchydata.com mail@joeconway.com @josepheconway Crunchy Data 2020-0202DEEP 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 hardwareWHERE'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 2015JOSEPH 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 FunctionsJOSEPH 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/Rfunctions:
SECCOMP YOUR POSTGRESQL SECCOMP your PostgreSQL Joe Conway joe@crunchydata.com mail@joeconway.com @josepheconway Crunchy Data 2020-0202DEEP 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 hardwareWHERE'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 2015JOSEPH 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 credativInternational
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, 2004JOSEPH CONWAY
Created Date: 4/18/2009 5:14:03 PMMLS 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 RDSSarah Conway
JOSEPH CONWAY
* GitHub
ABOUT ME
If you want to view my professional biography, please visit myLinkedIn 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 withC
* 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 AdvancedAnalytics
* 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 AnalyticsSOURCE 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: SarahConway .
Toggle
Details
Copyright © 2023 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0