Joe Conway
Sr SDM PostgreSQL Contributors Team at AWS
Joe Conway has been involved with the PostgreSQL community for more than 25 years, presently as a PostgreSQL Committer, Major Contributor, and Infrastructure Team member. He currently leads the PostgreSQL Contributors Team at Amazon Web Services, RDS Open Source Databases.
Upcoming presentations
No upcoming presentations...
Past presentations
- Installation
- initialization
- startup
- session managment
- Basic configuration
- postgresql.conf
- pg_hba.conf
- psql use/hints
- SQL syntax and quoting
- Data types
Collation Challenges
Sorting it Out
Background: "libc" is commonly used as a shorthand for the "standard C library", a library of standard functions that can be used by all C programs. glibc is the GNU C Library implementation, which is used on all major Linux distributions (e.g. AL, RHEL, Debian/Ubuntu, SuSE). The glibc library, libc.so, provides most of the foundational C routines such as open, read, write, malloc, printf, and ...
How Green Was My Valley
Advanced Spatial Analytics
Increasingly today, collected data includes a spatial component. PostgreSQL + PostGIS, combined with R via PL/R, provides an awesome tool-chain for advanced spatial analytics on such data! This presentation will introduce the audience to PL/R, discuss the pros and cons of this approach to spatial data analysis, then walk through examples of spatial analysis using PostgreSQL, PostGIS, and PL/R.
Intro to PostgreSQL
a jumpstart to up and running
A crash course to get you up and running with PostgreSQL. We will cover:
PostgreSQL 9.5 has a new feature called Row Level Security (RLS). Using RLS, a PostgreSQL extension called sepgsql (somewhat modified), and Security Enhanced Linux (SELinux) configured properly, it is possible to create a Multi-level Security database. This talk will describe how it can be done, including: Overview/Use-case Solution Components * RLS * SELinux * sepgsql Configuration and Setup *...
One of the key strengths of PostgreSQL is its extensability, and at the core of that are functions. In PostgreSQL functions can be used as an end in-and-of themselves, or they can be used to allow the creation of other custom SQL objects such as operators and aggregates. This presentation will enlighten the audience on the vast array of capabilities embodied in PostgreSQL functions, and illustr...
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 analytic...