Joe Conway @josepheconway

Sr SDM PostgreSQL Contributors Team at AWS

About

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.

Joe Conway has presented the following presentations

    Joe Conway Collation Challenges at Seattle 2024
    Sorting it Out

    presented by Joe Conway

    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 ...

    more

    Thu 7 2024 Essentials
    Joe Conway How Green Was My Valley at PGConf US 2017 [PgConf.US]
    Advanced Spatial Analytics

    presented by Joe Conway


    video

    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.

    Fri 31 2017 Development
    Joe Conway Intro to PostgreSQL at PGConf US 2017 [PgConf.US]
    a jumpstart to up and running

    presented by Joe Conway


    video

    A crash course to get you up and running with PostgreSQL. We will cover:

    • Installation
      • initialization
      • startup
      • session managment
    • Basic configuration
      • postgresql.conf
      • pg_hba.conf
    • psql use/hints
    • SQL syntax and quoting
    • Data types

    Operations
    Joe Conway MLS PostgreSQL: Implementing Multi-level Security in PostgreSQL with RLS and SELinux at PGConf US 2016 [PgConf.US]

    presented by Joe Conway

    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 *...

    more

    Development
    Joe Conway Fun with Functions, by Example at PGConf US 2015 [PgConf.US]

    presented by Joe Conway

    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...

    more

    Developer
    Joe Conway Easy Statistical Analysis in PostgreSQL with PL/R at PGConf NYC 2014 [PgConf.US]

    presented by Joe Conway

    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...

    more

    Developer