Presented by:

Kevink bio pic

Kevin Kempter

ProPAAS

Kevin is the founder and Chief Data Architect for ProPAAS (Professional PostgreSQL As A Service), a PostgreSQL Managed Services Company.

He has worked in IT since 1990 and has been working with databases since 1995. In the mid 1990's Kevin worked for Informix, serving as a Principal Consultant in the Informix Data Warehouse Group. Additionally he has experience with many RDBMS platforms, including Oracle, DB2, MySQL and SQL Server.

Kevin has experience in many database driven environments and industries including Telco, Finance, Science (NASA) and eCommerce. As a Database / Data Architect he has developed deep expertise in Database Administration, Database Development and Data Warehouse / Big Data Architectures.

Kevin has been specializing in PostgreSQL since 2004 and today manages the ProPAAS Team, leads platform conversions, and delivers ProPAAS public training.

No video of the event yet, sorry!

A presentation of Foreign Data Wrappers to include technical deployment details, usage, and use cases (including a vehicle for platform conversions)

Outline:

  • Overview

  • Creating the extension / installation

  • Creating a foreign server

  • User mapping

  • Import foreign schema

  • FDW Joins

  • FDW as a materialized view

  • FDW triggers

  • FDW and transactions

  • Detecting changes in a remote table

  • Platform conversion via Foreign Data Wrappers

  • Sampling of Extensions & available FDW's

    • Oracle
    • MySQL
    • www
    • S3
    • Redis
    • CouchDB
    • Docker
    • Facebook

Date:
Duration:
50 min
Room:
Conference:
PostgresConf US 2018
Language:
English
Track:
Operations and Administration
Difficulty:
Medium