Hacker Newsnew | past | comments | ask | show | jobs | submit | pb060's commentslogin

Why do you consider Postgres + PostGIS out of fashion? What are people using for spatial data these days?

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 don’t have a formula, but in Italy for example it would be 24% of their profit.


I hear you, I can write BASIC in any language.


spaghetti gotoing everywhere and leaving space lines in between code if you might need to insert something later?



Not that I was expecting a global dataset, but title should be “USA Fall Foliage Map 2025“.


Maybe we'll get an "Autumn Foliage Map" for the rest of the world. England's looking quite beautiful this month.


That was my original title but I think mods changed it because it doesn’t reflect the website’s title.


To me it just looks like a world map rotated by 180 degrees. Not strange or disorienting.


And progressive lenses. There’s still a long way to go.


Incidentally, it’s also a demonstration that you shouldn’t use high contrast in typography. When you start the test you can clearly see the lines of text retained on your retina.


The same with MacBooks in dark mode, once you turn around you can see large horizontal lines separated at regular intervals that are maybe due to the refresh rate of the screen (or something else, if someone knows)


In my experience these are after exposures from lines of text. They get blurred together into indistinct lines because your eye focus moves between words, superimposing them.


Sometimes "crisp" quickly turns into "burned into your vision"


I don’t understand why you need the animation. If you point at the green background after staring the red one for a while, you can see a whole circle of the saturated color.


I agree, that you dont. As far as I can tell, the effect comes from superimposing an after-image on some other image.


You clearly demonstrated that you don't need the animation. However, it's a convenient way to keep you staring in the same place and not have to do anything else to cause the effect.


I had the same interpretation and in fact there's some truth in it. I recently did procreate and realized how primitive AI is compared to human beings and how long it might take for it to catch up.


The rate of learning for infants is rapid, but unlike LLMs. Every day there are very small steps that eventually add up. The size and quantity of each step is often not that impressive, but the number of tries from first random attempt at something to consistent behaviour is impressively low.


> Glad to see Echarts getting the recognition it deserves.

Why is it so rarely mentioned in chart libraries comparisons? Its not even listed on the Wikipedia page for JavaScript chart libraries. I discovered it by chance through Apache Superset.


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: