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

What are you programming in? What's the final product going to be... an analysis, or a tool?

veen  ·  471 days ago  ·  link  ·  

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  ·  471 days ago  ·  link  ·  

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