Conference Schedule - PGConf.EU 2019
FDWs and their utilization in real world scenarios
Time: 11:50 - 12:40
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.