Blog
PostgreSQL SSL Setup in Docker-postgis
There are many ways to get a running PostgreSQL database on your host machine. Our preferred method of setting up the the database is using Docker and Kartoza provides a PostGIS Docker image
QGIS Road to Nerdvana Episode 18: Introduction to PostgreSQL and PostGIS
This is a walk-through showing how PostgreSQL and PostGIS can be used as a geospatial data store and then the data in that store be consumed and created by geopandas.
QGIS Road to Nerdvana Episode 7: Logging Postgres Calls
In this episode, Tim Sutton will show you how to enable PostgreSQL logging and what underlying queries are generated by QGIS or any other PostgreSQL client.
Using NOTIFY to Automatically Refresh Layers in QGIS
One of the most brilliant but little-known features of QGIS is the ability to trigger layer refreshes and events in response to notifications from PostgreSQL.
Adding Elevation to a Line from a DEM in PostGIS and Maintaining Accurate Measures
This is the second in a three part series on the behind-the-scenes GIS work that can go into planning a complex event, in this case the Cape Town Marathon.
