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 ! |