February 2020 Meetup: DBlink and SQL/MED and FDW, oh my! External Data Access tricks

2020 February 20 Meeting 6pm-8pm

Location:

PSU Business Accelerator
2828 SW Corbett Ave · Portland, OR
Parking is open after 5pm.

Speakers: Gabrielle Roth & Michelle Franz

In February, long-term PDXPUGers Michelle Franz & Gabrielle Roth return
to discuss DBLINK and FDW, two methods of accessing data that’s outside
your database. We’ll briefly mention SQL/MED on the way, and tell a
couple of bad (Dad) jokes.

We’ll cover use (and mis-use) cases, configuration of each, and
interesting quirks. Gabrielle will attempt a live demo of file_fdw and
postgres_fdw. You’re welcome to follow along if you’d like, just show up
with a couple of Pg databases: they can be on the same cluster (or
container or RDS instance or what have you) or different ones, doesn’t
really matter. One of them should have at least one table with data in
it.

About the speakers:

From embedded systems to UI to relational database programming,
Michelle’s running an interesting path through the software world.
Working with databases is her current episode, with some programming,
some DBA, some SysAdmin and a healthy dose of learning agile. She’s very
quickly come to appreciate and enjoy working with Postgres and her work
has allowed her to learn from some super talented database experts.

Gabrielle has been using Postgres since sometime in the version 7s, and
thinks that the best part of using Open Source software is the culture
of sharing knowledge. She’s a Senior Data Engineer at NS1 and co-founder
and former co-lead of PDXPUG.

--
Mark Wong
2ndQuadrant - PostgreSQL Solutions for the Enterprise
https://www.2ndQuadrant.com/