2024-06-11 –, Kesselhaus
Have you unlocked the geospatial powers of PostgreSQL?
This talk will show 3 neat features of how to use postgresql in effective ways to handle geospatial timeseries in a new domain. The data in subject is live marine traffic from the Norwegian territory.
Have you unlocked the powers of PostgreSQL yet?
This talk will show 3 neat features of how to use postgresql in a somewhat unusual way to handle geospatial timeseries in an unknown domain. The talk will give an introduction to how to use json-types in postgresql, the postgresql-extensions postgis to handle geospatial data and the postgresql-extension timescaledb to handle the never-ending stream of geospatial data.
The story of the talk is marine traffic in Norwegian waters with open data from the Norwegian Coastal Administration, presented in an application made by the autor.
Nils is a long time programmer with experience in database handling and streaming technologies. I have been working as a consultant for 14 years, helping clients to handle data in efficient ways.