Ask us Anything about PostGIS
My favorite part of the day, was the Ask Us Anything where we answered several questions on topics ranging
from upgrade frustrations, books, pgAdmin enhancements, GPUs, and speed improvements in PostGIS.
Most importantly I got to vent
about Sandro's extension patch
discussed here
and how it's languishing and how we need
to do something about this demand for a pile of upgrade scripts thrust upon us by the PostgreSQL core in order for the extensions community to easily grow.
On the pgAdmin front, someone complained about the Geometry Viewer
getting scrambled at times requiring it to be closed and reopened.
To my pleasant surprise, the Geometry viewer issue was fixed just a week after the day in pgAdmin 8.
pgRouting
One of my other favorite talks of the day was Vicky Vergara, the queen of pgRouting talk on
pgRouting Practical Example
which was the best talk I've ever seen her give. Even more miraculous, because she was so sick when I talked to her earlier that I feared she'd be out of commission for a while.
I really marveled at the work she described with the UN challenge and how pgRouting can be used to improve the lives of the most vulnerable people in our community.
Paul did a great job of proding her about non-GIS uses for pgRouting, to which she detailed all the flow functions in pgRouting after all pgRouting is a bag of graph algorithms
you can use in PostgreSQL.
All this reminded me, how we really need to get out the second edition of pgRouting: A practical Guide.
So much has changed since we wrote the first edition,
that I'm so embarrassed how dated it is and pretty useless for current pgRouting. That's my New Year's resolution, get the second edition out in 2024.
