a thoughtful web.
Good ideas and conversation. No ads, no tracking.   Login or Take a Tour!
comment by veen
veen  ·  404 days ago  ·  link  ·    ·  parent  ·  post: Pubski: October 20, 2021

These days most of my programming is in PostGIS, which is an extension on regular PostgreSQL to enable very powerful geo-functions. Sometimes I write more Python, and in the past year I've also combined the two, writing Python scripts that call the database and send some data back and forth to enjoy the best of both worlds.

Today I went back and forth between writing big, heavy queries in a PostgreSQL database, and writing lightweight dynamic queries in Retool. I'm using that for the first time to create an interactive dashboard for a well known client of ours. The other project will probably entail some large tables that show the result of the analysis and a map visualization as an output, which what my deliverables are in most projects.

mk  ·  404 days ago  ·  link  ·  

I have been writing Arc/PostGIS a bit. PostGIS feels pretty magical.