Hmmm, I love OSM, consume their data in my small cycling project and regularly contribute smaller fixes.
But I also shy away from anything more complex than fixing attributes and meta data of existing objects. Especially editing relations, ways and nodes - is this possible with MapComplete? I loaded the Cyclofix map, but I can't even select cycle paths or roads, just edit POIs.
I never understood the issues PG had with hints. Running a non-trivial DB with a non-trivial schema and scale is, well, non-trivial at all. At some point the DB stops being a black box and starts being a tool that you have to know inside and out to avoid performance issues.
>The optimizer is usually smarter than you think.
Except for when it isn't, and moves heavy calculation inside a nested loop inside a nested loop to avoid an index scan. Nothing is perfect.
Well, I am in the situation you are so afraid of. Chemo, radiation and other treatments suck big time, let alone the effects of the cancer itself.
BUT ... this is not a binary situation, where suddenly life becomes unbearable. There's so much worth living for. And not just the obvious big things in life (kids, family, friends), but also many many small things. Man, that first cup of cappuchino once the effects of chemo wear off alone is almost worth all the puking beforehand :) Or having a nice piece of cheese. Seeing my small herb garden grow. Etc. etc.
The trick is to live a peaceful, content life. Be grateful for what you have. Enjoy your short time on earth.
Totally agree, the current state of the German grid is not ideal. But I have the naive gut feeling that storage prices will also come down and we will see a similar non-political quiet revolution here as well. I.e. people and companies will simply install more and more storage because it is economically viable, not because of ideology. We'll see.
We have a similar approach here in Germany. Anyone has the right to install a small solar system on their balcony or similar and feed up to 800W into their local grid. You just mount it and plug it into your house/apartment grid. Technically you have to get it registered, too.
The sky is not falling, buildings are not crumbling and the grid is not burning.
It's not revolutionary either, but slowly picking up traction. You see more and more installations here in Berlin. On the country side where people have their own house and enough space it's a total no-brainer to set up one of those mini solar systems.
The typical systems you can buy off the shelf (800-1000W panels + inverter) amortize after a few years already, and are getting cheaper every year. I have the feeling the main limitation in the city is having a nice balcony with good mounting points.
Really nice project. Thank you for contributing to the OSM community.
>Editing geometries is out of scope for this project.
Out of curiosity, may I ask why?
It's not that I have this use case regularly, cycling-related it mainly comes up dealing with tracks through forests and fields.