We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Fun with Foreign Data Wrappers (FDW) and PostgreSQL

00:00
subtitles
off
playback rate
1
subtitles
off
English (auto-generated)
playback rate
0.25
0.5
0.75
1
1.25
1.5
1.75
2
quality
576p
422
 Cite
 Share
 Related Material
 Download Purchase
No logo availableFOSS4G
Logo of Open Source Geospatial Foundation (OSGeo)Open Source Geospatial Foundation (OSGeo)
 Emde, Astrid

Formal Metadata

Title
Fun with Foreign Data Wrappers (FDW) and PostgreSQL
Title of Series
Number of Parts
295
Author
Contributors
License
CC Attribution 3.0 Germany:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language

Content Metadata

Subject Area
Genre
Abstract
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. With 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. The list of FDW is very long: https://wiki.postgresql.org/wiki/Foreign_data_wrappers There 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. Some of the wrappers support only read others support read/write access. The 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.
Keywords
00:00
MappingMultiplication signMereologyRepetitionPerspective (visual)Projective planeInformationFamilyWrapper (data mining)Lecture/Conference
00:46
Musical ensembleSource codeDatabaseSource codeWrapper (data mining)Computer animationLecture/Conference
01:06
Wrapper (data mining)Musical ensembleWikiPresentation of a groupLocal ringMusical ensembleCasting (performing arts)RepetitionCartesian coordinate systemWeb 2.0DatabasePresentation of a groupWrapper (data mining)CodeGastropod shellSlide ruleMereologyComputer animation
01:49
Convex hullPresentation of a groupWrapper (data mining)DatabaseMultiplication signFunctional (mathematics)Extension (kinesiology)Computer animationXML
02:20
GeometryWrapper (data mining)Extension (kinesiology)DatabaseFunctional (mathematics)Extension (kinesiology)CASE <Informatik>Point (geometry)Multiplication signBitBuildingType theoryJSONXML
02:48
Wrapper (data mining)Link (knot theory)Menu (computing)Data managementStandard deviationDatabaseSalem, IllinoisData typeExtension (kinesiology)BitDatabaseSource code
03:26
Data managementStandard deviationDatabaseWikiWrapper (data mining)MassGeneric programmingRevision controlSource codeSinc functionWritingWikiStandard deviationRead-only memoryConnected spaceDifferent (Kate Ryan album)Right angleFunctional (mathematics)Physical systemMultiplication signXMLComputer animation
04:41
Arithmetic meanWrapper (data mining)DatabaseGeneric programmingMassEmulationMaxima and minimaProjective planeFunctional (mathematics)Connected spaceQuicksortLecture/Conference
05:17
Wrapper (data mining)Source codeDatabaseTwitterWikiComputer networkExtension (kinesiology)Projective planeComputer fileSource codeElectronic mailing listWikiDatabaseWrapper (data mining)XMLComputer animation
05:47
Computer networkExtension (kinesiology)Structural loadServer (computing)Table (information)Wrapper (data mining)DatabaseDifferent (Kate Ryan album)TwitterProjective planeRevision controlLocal ringStructural loadConnected spaceExtension (kinesiology)Process (computing)DatabaseComputer animation
06:13
Table (information)Extension (kinesiology)Structural loadServer (computing)Wrapper (data mining)DatabaseRepetitionComputer configurationLocal ringTexture mappingLimit (category theory)PolygonDistanceState of matterDomain nameNumbering schemeMacro (computer science)LoginMenu (computing)MaizeBinary fileEvent horizonQuery languageSummierbarkeitElectronic visual displayLemma (mathematics)User interfaceExtension (kinesiology)CASE <Informatik>Self-organizationTable (information)Computer configurationWrapper (data mining)Query languageSource codeConnected spaceDatabaseServer (computing)MappingLine (geometry)CuboidService (economics)RepetitionForm (programming)Grass (card game)Group actionFunctional (mathematics)Network topologyLimit setComputer animationXML
09:41
Table (information)1 (number)Utility softwareMountain passBitMappingTable (information)Computer fileDatabasePasswordComputer programmingVideo gamePlanningDifferent (Kate Ryan album)Extension (kinesiology)
10:01
Server (computing)Computer filePasswordWrapper (data mining)Electric currentExtension (kinesiology)Computer configurationComputer filePasswordDatabaseComputer programmingXMLUML
10:22
RootComputer fileForm (programming)Extension (kinesiology)Mereology
10:41
Server (computing)RootPasswordComputer configurationComputer fileTable (information)Wrapper (data mining)Extension (kinesiology)Computer fileTable (information)SoftwareOracleXMLLecture/Conference
11:00
Server (computing)Table (information)Extension (kinesiology)Structural loadWrapper (data mining)OracleDatabaseTexture mappingPasswordComputer configurationState observerIntegerDatabaseConnected spaceExtension (kinesiology)OracleOrder (biology)Computer animationJSON
11:30
Texture mappingServer (computing)Table (information)Computer configurationPasswordState observerOracleWrapper (data mining)Bounded variationIntegerExtension (kinesiology)Table (information)Computer configurationCASE <Informatik>BitMappingConnected spaceSheaf (mathematics)Different (Kate Ryan album)JSON
11:51
Wrapper (data mining)Table (information)Stack (abstract data type)DatabaseFile formatShape (magazine)Installation artInformationConnectionismSet (mathematics)Pauli exclusion principleServer (computing)Extension (kinesiology)Structural loadTable (information)Metropolitan area networkFile formatGoogolElectronic mailing listRamsey theoryDot productMassCombinational logicDatabaseMereologyPhysical systemVideo gameQuicksortRevision controlCompilation albumComputer fileWrapper (data mining)Level (video gaming)Open setGeometryShape (magazine)Vector spaceInformationComputer animation
13:53
Inflection pointPoint (geometry)State of matterFibonacci numberWrapper (data mining)Server (computing)Computer configurationFile formatSource codeTable (information)GeometryIntegerScale (map)RankingAnalytic continuationShape (magazine)UnicodeCodierung <Programmierung>Client (computing)InformationLine (geometry)MultiplicationPolygonFinitary relationVapor barrierAddress spaceCountingDigital filterPlanningReading (process)Drop (liquid)InformationWrapper (data mining)Connected spaceNatural numberComputer fileShape (magazine)Table (information)File formatServer (computing)Line (geometry)Codierung <Programmierung>CASE <Informatik>Computer configurationDatabaseStatement (computer science)Sheaf (mathematics)Greatest elementOracleSource codeBitLevel (video gaming)Scaling (geometry)Lie groupDirectory servicePoint (geometry)Parameter (computer programming)Computer animationSource code
17:18
CASE <Informatik>Connected spaceSource codeRemote procedure callFile formatComputer configurationRevision controlInformationAsynchronous Transfer ModeBlock (periodic table)
17:47
Sanitary sewerMessage passingMoving averageServer (computing)Configuration spaceClient (computing)Set (mathematics)Asynchronous Transfer ModeError messageMessage passingFlow separationLecture/Conference
18:09
Wrapper (data mining)Server (computing)Client (computing)Message passingSet (mathematics)Message passingRepetitionMixed realityWrapper (data mining)JSONXMLUMLLecture/Conference
18:37
Interface (computing)Line (geometry)Source codeElectronic mailing listMereologyDatabase transactionNatural numberComputer animationLecture/Conference
20:03
Source codeBitConnected spaceMathematicsNumbering schemeLecture/Conference
20:24
Numbering schemeConnected spaceSource codeoutputLecture/Conference
20:57
Wrapper (data mining)CodeLine (geometry)Connected spaceWindowType theoryComputer animationXML
21:27
Server (computing)Directory serviceLocal ringType theoryConnected spaceClient (computing)MappingScripting languageAuthenticationWindowLoginSolitary confinementOffice suiteMehrplatzsystemLecture/Conference
22:33
MathematicsCASE <Informatik>Computer virusService (economics)Software developerNumbering schemeLecture/Conference
23:07
Wrapper (data mining)Wrapper (data mining)CASE <Informatik>Identity managementGoodness of fitModule (mathematics)DatabaseAnalytic setImplementationAddress spaceTable (information)Regular graphSource codeNumberEndliche ModelltheorieMassPhysical lawService (economics)XMLComputer animationLecture/Conference
24:45
Staff (military)Single-precision floating-point formatDatabaseService (economics)Computer animation
Transcript: English(auto-generated)