AI is increasing my job security at the moment because the junior developers I work with use AI without discretion. On of them didn’t remember having worked on a feature they built with AI assistance in the recent past. To his credit he admitted he didn’t know how the code worked.
Agree with this. They are re-solving a problem that has been solved better by others before (with R-trees).
They may well be using some data storage where spatial indexing is not possible or standard. Geoparquet is a common one now - a great format in many ways but spatial indexing isnt there.
Postgres may be out of fashion but still an old fashioned postgis server is the simplest solution sometimes.
For use cases like this - long term geospatial people still use postgis as foundational - mainly for its speed at scale and spatial indexing.
For the wider tech world - I would say postgres suffers from being "old tech" and somewhat "monolithic". There have been a lot of trends against it (e.g. nosql, fleeing the monolith, data lakes). But also more practically for a lot of businesses geospatial is not their primary focus - they bring other tech stacks so something like postgis can seem like duplication if they already use another database, data storage format or data processing pipeline. Also some of the proliferation of other software and file formats have made some uses cases easier without postgis.
Really Id say the most common path ive seen for people who dont have an explicit geospatial background who are starting to implement it is to avoid postgis until it becomes absolutely clear that they need it.
But what would they use before bringing in postgis ? I'm curious about the alternatives. MongoDB for example doesn't seem to have a geospatial ecosystem, apart from basic 2d features. Clickhouse ?
I wouldn't say R-trees solve the problem better. Joining multiple spatial dataset indexed with r-trees is more complex as the nodes are dynamic and data dependent. Neighborhood search is also more complicated because parent nodes overlap.
Its a well researched area. My understanding is for most use cases and data like this R trees outperform as bounding box comparisons are fast to run and the bounding boxes tend to be well organised to chunk data efficiently. H3 is a looser area and you may find lots of your points are clustered in a few grids so you end up doing more expensive detailed intersection calculations. Of course it all depends a little on your data, use case and to some extent the parameters chosen for the spatial index. But I think safe to say now based on industry experience that r trees do a very good job 99.9% of the time.
You can of course also use h3 in postgis directly as well as r trees. Its helps significantly for heatmap creation and sometimes for neighbourhood searches.
The data you linked doesn't show that. If I were on my computer, I would download crude oil prices/US shale oil extraction data and look for correlations.
My intuition seeing this is that the lack of openness of Venezuelian economy made it impossible to recover from the crude oil price drop circa 2014, because of a lack of access to capital and new tech (and probably corruption). Also, if you want to nationalizes, you better have a plan like Norway had, and Venezuela didn't. If your goal is only profit, better let a private company take care of it, that's the thing they're good for.
From what I understand the root cause is racism and classism.
Venezuela was in a deep economic crisis for a very long time before Chavez was elected. The then ruling elite were pretty happy living in a bubble, extracting oil, selling to the west, embezzling the proceeds and ignoring most of the population.
The reason I say, the root cause is racism and classism, is because they totally underestimated the power of the people to overthrow their corrupt regime.
You clearly don't know anything about the history of the country. It was never about classism or racism, venezuelans are racially diverse with lots of mix between the original indigenous inhabitants, colonial europeans, african slaves and then the second wave of european immigrants after the WWII.
> The reason I say, the root cause is racism and classism, is because they totally underestimated the power of the people to overthrow their corrupt regime.
There was no 'regime', there was a democracy with corruption problems but that was still functional. Nor it was 'overthrown', a populist was elected due to disenchantment and the populist dismantle the state institutions and turn it into an oligarchy ran by his circle.
> There was no 'regime', there was a democracy with corruption problems
OK.
> but that was still functional
Clearly not, because Chavez was elected despite having attempted a coup d'etat previously.
Clearly not, because the coup d'etat against Chavez failed because the population was overwhelming supporting him.
> populist dismantle the state institutions and turn it into an oligarchy ran by his circle
Which was necessary because previously it was an oligarchy ran by an opposing circle, which lost favor with the people.
> It was never about classism or racism
It's classism, partly fueled by racism, which causes the ruling elite in Latin America to have such disdain for the rest of the population, that they believe they can take control of the country and govern it as if they were some kind of aristocracy, and completely ignore those beneath them, because they aren't of the right class, are not white enough, and don't have enough wealth, to be taken into consideration.
What was your prompt to get it to run the test suite and heal tests at every step? I didn’t see that mentioned in your write up. Also, any specific reason you went with Codex over Claude Code?
For me (original author of JustHTML), it was enough the put the instructions on how to run tests in the AGENTS.md. It knows enough about coding to run tests by itself.
Can skills completely replace MCPs? For example, can a skill be configured to launch my local Python program in its own venv. I don’t want Claude to spend time spinning up a runtime
Skills only work if you have a code environment up and running and available for a coding agent to execute commands in.
You can absolutely have a skill that tells the coding agent how to use Python with your preferred virtual environment mechanism.
I ended up solving that in a slightly different way - I have a Claude hook that spits attempts to run "python" or "python3" and returns an error saying "use uv run instead".
The biggest issue with Windows 11 for me is the noticeable performance lag in basic apps like Notepad and File Explorer. Simple tasks, like opening files or navigating folders, feel sluggish, and I can visibly see windows rendering in slow motion. I’ve heard this might be due to Windows 11’s UI elements being redrawn over lower level UI. I’m considering switching to Linux as my daily driver.
Last I checked DuckDB spatial didn’t support handling projections. It couldn’t load the CRS from a .prj file. This makes it useless for serious geospatial stuff.
reply