BEGIN:VCALENDAR PRODID;X-RICAL-TZSOURCE=TZINFO:-//Calagator//EN CALSCALE:GREGORIAN X-WR-CALNAME:Calagator METHOD:PUBLISH VERSION:2.0 BEGIN:VTIMEZONE TZID;X-RICAL-TZSOURCE=TZINFO:America/Los_Angeles BEGIN:STANDARD DTSTART:20191103T020000 RDATE:20191103T020000 TZOFFSETFROM:-0700 TZOFFSETTO:-0800 TZNAME:PST END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20200206T164845Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20200220T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20200220T180000 DTSTAMP;VALUE=DATE-TIME:20200206T164845Z LAST-MODIFIED;VALUE=DATE-TIME:20200206T164845Z UID:http://calagator.org/events/1250476774 DESCRIPTION:Speakers: Gabrielle Roth &\; Michelle Franz \;\n \;\ nIn 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 te ll a couple of bad (Dad) jokes. \;\n \;\nWe’ll cover use (and mis- use) cases\, configuration of each\, and interesting quirks. Gabrielle w ill 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 h ave you) or different ones\, doesn’t really matter. One of them should h ave at least one table with data in it. \;\n \;\nAbout the speaker s: \;\n \;\nFrom embedded systems to UI to relational database pro gramming\, Michelle’s running an interesting path through the software w orld. Working with databases is her current episode\, with some programm ing\, some DBA\, some SysAdmin and a healthy dose of learning agile. She ’s very quickly come to appreciate and enjoy working with Postgres and h er work has allowed her to learn from some super talented database exper ts. \;\n \;\nGabrielle has been using Postgres since sometime in t he version 7s\, and thinks that the best part of using Open Source softw are is the culture of sharing knowledge. She’s a Senior Data Engineer at NS1 and co-founder and former co-lead of PDXPUG.\n\nTags: postgres\, po stgresql\, pdxpug\, dblink\, fdw\, sql\n\nImported from: http://calagato r.org/events/1250476774 URL:https://pdx.postgresql.us/ SUMMARY:PDXPUG February 2020 Meetup: DBlink and SQL/MED and FDW\, oh my! External Data Access tricks LOCATION:PSU Business Accelerator: 2828 SW Corbett Ave\, Portland OR 9720 1 US SEQUENCE:1 END:VEVENT END:VCALENDAR