This site is about a previous instance of this event. For the current event, please see the updated site.

Schedule - PGConf.EU 2019

FDWs and their utilization in real world scenarios

Date: 2019-10-18
Time: 11:50–12:40
Room: Manzoni
Level: Intermediate

Have you ever had the need to write SQL queries to analyze data that would need to simultaneously query data from a flat file, MySQL,MongoDB, Oracle, Hadoop, a Python script and one or more different PostgreSQL nodes? It isn’t hard to imagine as modern day businesses tend to use specialized products and data stores for their special needs.

PostgreSQL’s FDW feature implements ISO Standard SQL-MED (SQL Management of External Data) which means that it enables PostgreSQL to manage and query data stored outside PostgreSQL. What it also means that PostgreSQL can talk to a host of other data sources including relational, noSQL and file based data sources.

This talk will cover the journey of PostgreSQL FDW feature in detail and focus how you can extend PostgreSQL to become the center of your data world in today’s dynamic data needs.

Slides

The following slides have been made available for this session:

Speaker

Boriss Mejias