Show filters Hide filters

Refine your search

Publication Year
1-1 out of 1 results
Change view
  • Sort by:
24:04 FOSS4G, Open Source Geospatial Foundation (OSGeo) English 2015

PostgreSQL, batteries included

This presentations presents some advanced features of PostgreSQL involving third party tools integrated directly into the database, and allowing for more features, especially for spatial data management. PostgreSQL is a very versatile RDBMS, and has a lot of core features. What is less known is that it can be used as a data platform, integrating external modules to further expand the capabilities of data management. First of all, some contrib PostgreSQL modules of interest are shown, useful for geocoding : pg trgm allows for trigram indexing and search, allowing string comparison with a tolerance to typo errors fuzzystrmatch also allows fuzzy string comparison directly inside the database using soundex algorithms FTS, aka Full Text Search, is a powerful text indexing and search mechanism right inside PostgreSQL Then, we show the Foreign Data Wrapper tools, which allow access to and from remote data. oracle fdw now supports Oracle Spatial and PostGIS natively, and let you exchange data in heterogeneous systems ogr fdw is a foreign data wrapper dealing with OGR data sources : access all these vector data files directly from your spatial database Foreign Data Wrapper really makes PostgreSQL a data platform, enabling easy import and export of data, migration plan, and transparent heterogeneous data systems. Last, we present some advanced data processing capabilities using PostgreSQL development languages. Pl/R lets you leverage the power of the R statistics framework to do advanced analysis of your spatial data Pl/Py put all Python modules at your disposal, with unlimited power for data processing, communication and interaction with external systems All these tools, usually less known than PostgreSQL and PostGIS bulk features, further improve the data platform, with high connectivity and interoperability, and almost unlimited features in terms of data processing. PostgreSQL, PostGIS, and -free- batteries included !
  • Published: 2015
  • Publisher: FOSS4G, Open Source Geospatial Foundation (OSGeo)
  • Language: English
out of 1 pages


   81 ms - page object
   15 ms - search
    0 ms - highlighting
    0 ms - highlighting/32121


AV-Portal 3.8.0 (dec2fe8b0ce2e718d55d6f23ab68f0b2424a1f3f)