Postgresql Foreign Data Wrappers
Presented by:
Kevin Kempter
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
- Date:
- Duration:
- 50 min
- Room:
- Conference:
- PostgresConf US 2018
- Language:
- English
- Track:
- Operations and Administration
- Difficulty:
- Medium