{"guid":"4bc8bbe5-cb04-5a2b-b441-a696be055948","title":"Fun with Foreign Data Wrappers (FDW) and PostgreSQL","subtitle":null,"slug":"bucharest-236-fun-with-foreign-data-wrappers-fdw-and-postgresql","link":"https://talks.2019.foss4g.org/bucharest/talk/TYUYZC/","description":"With Foreign Data Wrappers (FDW) you can access remote objects from SQL databases. This feature is part of the SQL/MED (SQL Management of External Data) specification that was added to the SQL standard.\n\nWith PostgreSQL you can make use of this great functionality. You can access different remote datasources via FDW  for example an ORACLE or MySQL database, JSON- or CSV-file, sources via ODBC and even twitter. \n\nThe list of FDW is very long: https://wiki.postgresql.org/wiki/Foreign_data_wrappers\n\nThere are also Geospatial Wrappers for GDAL/OGR, GeoJSON and OpenStreetMap. You can access your geospatial data for example geopackage or OGC WFS via FDW. That is easy and great fun. \n\nSome of the wrappers support only read others support read/write access.\n\nThe presentation will give an overview on the possibilities of Foreign Data Wrappers and show how to setup a connection to remote data using some examples with geospatial data.\n\nNone","original_language":"eng","persons":["Astrid Emde"],"tags":["bucharest","236","General"],"view_count":893,"promoted":false,"date":"2019-08-30T00:00:00.000+02:00","release_date":"2019-08-30T02:00:00.000+02:00","updated_at":"2026-03-19T14:00:10.364+01:00","length":1516,"duration":1516,"thumb_url":"https://static.media.ccc.de/media/conferences/foss4g2019/236-hd.jpg","poster_url":"https://static.media.ccc.de/media/conferences/foss4g2019/236-hd_preview.jpg","timeline_url":"https://static.media.ccc.de/media/conferences/foss4g2019/236-hd.timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/conferences/foss4g2019/236-hd.thumbnails.vtt","frontend_link":"https://media.ccc.de/v/bucharest-236-fun-with-foreign-data-wrappers-fdw-and-postgresql","url":"https://api.media.ccc.de/public/events/4bc8bbe5-cb04-5a2b-b441-a696be055948","conference_title":"FOSS4G 2019","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019","related":[{"event_id":7465,"event_guid":"d2b2bdd0-36fa-5ae1-aba0-a38960010e3b","weight":10},{"event_id":7466,"event_guid":"98c0417b-cdfd-57b3-9411-14f9f465f5b9","weight":13},{"event_id":7467,"event_guid":"df17d333-e410-5e1f-a31c-42805b52b53c","weight":19},{"event_id":7469,"event_guid":"c0174aef-c7a6-5d21-8dfe-e592c5a4eff3","weight":2},{"event_id":7484,"event_guid":"b4d6c8c6-688b-5273-aa8f-a2044128ac13","weight":2},{"event_id":7487,"event_guid":"6f1b8b15-b44a-592c-b3e9-96bd9e0fbce3","weight":10},{"event_id":7517,"event_guid":"ef1a3ce2-61bf-53e1-8f97-acb738c219f9","weight":2},{"event_id":7522,"event_guid":"74922ed0-86dd-5568-98fb-6fc812852441","weight":18},{"event_id":7526,"event_guid":"fd5614a8-535f-5069-8f69-3a9983d37830","weight":2},{"event_id":7533,"event_guid":"bff8e480-f2e6-5fb7-a945-fed5e6b06f77","weight":2},{"event_id":7534,"event_guid":"3fc26cc4-962e-5f27-a92b-c01e86d12100","weight":2},{"event_id":7548,"event_guid":"8ca1b4b6-ee0c-5102-ab95-a978cd3b4d8c","weight":2},{"event_id":7552,"event_guid":"4c2f4b81-1316-502d-870c-dc39567b782e","weight":16},{"event_id":7579,"event_guid":"0112454d-62b2-5132-8971-73c7fdb972d0","weight":10},{"event_id":7594,"event_guid":"9f3b41cc-dc93-55d8-a318-7b7740109b71","weight":2},{"event_id":7607,"event_guid":"d0794cae-d707-584c-8879-6c438a603486","weight":14},{"event_id":7608,"event_guid":"13e2ef4d-8375-580b-a797-c54a85faa0aa","weight":2},{"event_id":7624,"event_guid":"69079f64-448d-55b5-9cb3-7089547c370d","weight":2},{"event_id":7662,"event_guid":"a8fbf537-cbe1-5f17-aa73-97d64132f660","weight":5},{"event_id":7672,"event_guid":"1c58bd3e-15f6-51a3-af44-9d6a75f31556","weight":2},{"event_id":7692,"event_guid":"3c0ea464-ce0e-5676-a977-075148d7bbdd","weight":25},{"event_id":7695,"event_guid":"5df0ebe1-cfe2-54c4-a0c8-40e35a6de826","weight":14},{"event_id":7733,"event_guid":"0ba5c644-2353-5225-972e-6e3958f74f3e","weight":13},{"event_id":7756,"event_guid":"c4299de5-e39e-576d-93bb-7ae47fee42af","weight":10}],"recordings":[{"size":159,"length":1516,"mime_type":"video/mp4","language":"eng","filename":"bucharest-236-eng-Fun_with_Foreign_Data_Wrappers_FDW_and_PostgreSQL_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2019-08-30T14:33:31.668+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/h264-hd/bucharest-236-eng-Fun_with_Foreign_Data_Wrappers_FDW_and_PostgreSQL_hd.mp4","url":"https://api.media.ccc.de/public/recordings/39070","event_url":"https://api.media.ccc.de/public/events/4bc8bbe5-cb04-5a2b-b441-a696be055948","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"},{"size":23,"length":1516,"mime_type":"audio/mpeg","language":"eng","filename":"bucharest-236-eng-Fun_with_Foreign_Data_Wrappers_FDW_and_PostgreSQL_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2019-08-30T14:52:36.298+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/mp3/bucharest-236-eng-Fun_with_Foreign_Data_Wrappers_FDW_and_PostgreSQL_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/39107","event_url":"https://api.media.ccc.de/public/events/4bc8bbe5-cb04-5a2b-b441-a696be055948","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"},{"size":13,"length":1516,"mime_type":"audio/opus","language":"eng","filename":"bucharest-236-eng-Fun_with_Foreign_Data_Wrappers_FDW_and_PostgreSQL_opus.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2019-08-30T14:52:37.003+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/opus/bucharest-236-eng-Fun_with_Foreign_Data_Wrappers_FDW_and_PostgreSQL_opus.opus","url":"https://api.media.ccc.de/public/recordings/39108","event_url":"https://api.media.ccc.de/public/events/4bc8bbe5-cb04-5a2b-b441-a696be055948","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"},{"size":46,"length":1516,"mime_type":"video/mp4","language":"eng","filename":"bucharest-236-eng-Fun_with_Foreign_Data_Wrappers_FDW_and_PostgreSQL_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2019-08-30T14:53:42.575+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/h264-sd/bucharest-236-eng-Fun_with_Foreign_Data_Wrappers_FDW_and_PostgreSQL_sd.mp4","url":"https://api.media.ccc.de/public/recordings/39112","event_url":"https://api.media.ccc.de/public/events/4bc8bbe5-cb04-5a2b-b441-a696be055948","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"},{"size":65,"length":1516,"mime_type":"video/webm","language":"eng","filename":"bucharest-236-eng-Fun_with_Foreign_Data_Wrappers_FDW_and_PostgreSQL_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2019-08-30T14:56:59.550+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/webm-sd/bucharest-236-eng-Fun_with_Foreign_Data_Wrappers_FDW_and_PostgreSQL_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/39125","event_url":"https://api.media.ccc.de/public/events/4bc8bbe5-cb04-5a2b-b441-a696be055948","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"},{"size":188,"length":1516,"mime_type":"video/webm","language":"eng","filename":"bucharest-236-eng-Fun_with_Foreign_Data_Wrappers_FDW_and_PostgreSQL_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2019-08-30T15:07:59.266+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/webm-hd/bucharest-236-eng-Fun_with_Foreign_Data_Wrappers_FDW_and_PostgreSQL_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/39133","event_url":"https://api.media.ccc.de/public/events/4bc8bbe5-cb04-5a2b-b441-a696be055948","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"}]}