jstrickshire

I appreciate you calling that out, I will get that done.

Yeah, I can do that. Will get to it tomorrow!

I have a passion project 4x4anarchy.com that operates with a Python-MariaDB system for querying map data by latitude and longitude, transforming it into GeoJSON for map display. The website deals with sizable tables, approximately 1 GB in size. I've made extensive optimizations, relying on well-structured indexes, caching mechanisms, and query optimization to enhance performance.

Given these circumstances, how might the incorporation of Julia and some geospatial DB (PostGIS) contribute to further optimizing geospatial data retrieval and presentation, especially when dealing with large datasets and intricate geospatial operations?

I believe that stress does cause a tremendous amount of damage to the brain. I'm glad to see others share the same ideas. It may not be proven whether damage is permanent or not. But it's not something that can be left alone.