PostgreSQL/PostGIS

PostgreSQL is a powerful and flexible open source database management system (DBMS), comparable to Oracle or MSSQL. With the PostGIS extension, geodata can be managed and analyzed. It is the optimal data warehouse solution in interaction with QGIS as desktop GIS and the GBD WebSuite as WebGIS for the implementation of small and large projects. A selection of the functionality includes:

  • Create, update and delete data
  • Simultaneous multi-user access
  • Management of metadata
  • User and rights management
  • Data backup and data integrity
  • PgAdmin4 tool for administration and development
  • Complex queries with subqueries (subselects)
  • Creation of (materialized) views, triggers and constraints
  • Expandable (e.g. functions, data types, operators)