You just write "spent two years raising my youngest kid [building tree houses and whatnot]". If you keep a bit up with tech, why would anyone think twice about that? They wouldn't where I live.
Some years ago we ported some code from querying out the data and tallying in Python (how many are in each bucket) to using SQL to do that. It didn't speed up the execution. I was surprised by that, but I guess the Postgres interpreter is roughly the same speed as Python, which when you think about it perhaps isn't that surprising.
But Python is truly general purpose while the core query stuff in SQL is really specialized (we were not using stored procedures). So if Pypy can get 5x speedup, it seems to me that it should be possible to get the same kind of speed up in Postgres. I guess it needs funding and someone as smart as the Pypy people.
Not sure, but I solved a similar problem many years ago, and ended up concluding it was silly to send all the data to the client when the client didn't have the visual resolution to show it anyway. So I sampled it adaptively client-side by precomputing and storing multiple zoom-levels. That way the client-side chart app would get the points and you could zoom in, but you'd only ever retrieve about 1000-2000 points at the time.
I once had to deal with many million data points for an application. I ended up mip-mapping them client-side.
But regarding sampling, if it's a line chart, you can sample adaptively by checking whether the next point makes a meaningfully visible difference measured in pixels compared to its neighbours. When you tune it correctly, you can drop most points without the difference being noticeable.
I didn't find any else doing that at the time, and some people seemed to have trouble accepting it as a viable solution, but if you think about it, it doesn't actually make sense to plot say 1 million points in a line chart 1000 pixels wide. On average that would make 1000 points per pixel.
Yes. DJGPP and Allegro was a great help, and a big step up from the old Borland Turbo Pascal I started out with. I remember trying to rotate an image pixel by pixel in Pascal. Allegro simply had a function to do it. And yes, the mailing list was great - Shawn Hargreaves and the couple of people in the inner circle (I seem to remember someone called George) were simply awesome, helpful people.
I eventually installed Red Hat, started at university and lost most of my free time to study projects.
Some years ago I bought a little pamphlet with a few mental exercises by Rudolf Steiner, known for the Waldorf school system.
One of them was about building a habit. You find a small meaningless thing to do, it must have no purpose at all, and then you do it once every day for as long as it takes to become a habit, probably a month or two. E.g. you could fill a glass with water and throw it out.
I did the exercise (I would kneel for a few seconds when taking a bath) for a couple of months, and I think it worked for me. I've recently used the same tactic to build a useful habit.
Now building a new habit is not necessarily the same as changing an old habit.
I also found out that kneeling changed my perspective. I could think about a situation with some level of tension, kneel, and then my perspective on the same situation would be more humble and appreciative. YMMV.
Greenland can become independent if they wish. There would be some things to work out, but the legal framework has been in place since the 1970es. And they seem to be working towards the goal.
The reason it hasn't happened yet is that they'd either have to increase tax income greatly, or reduce public spending greatly with financial support from Denmark. As I gather, infrastructure up there is really expensive.
Yeah, the only dumb thing about the digital mail is that they're not just using email with an official registry.
They could have started some kind of certification thing for email providers and even funded a couple of certified email providers much more effectively than the digital post monstrosity.
That would have been awesome and forward looking, and perhaps even helped ordinary people get better security for their personal emails.
One thing to watch out for with immutability is that if you're dealing with personal information about people, immutability is probably illegal. You must be able to forget information, and not just simulate you've forgotten it.
I don't how universal this is at the moment, but I think it's likely to be more universal in the future.
The UK used to have very high subsidies for offshore wind for some reason. The last I've heard, subsidies for new plants are much lower today.
As for being cost effective, onshore wind is probably the cheapest option, and I think it's hoped that offshore will come close to that once more of the learning curve has been traversed. Perhaps fossil gas from the North sea is still cheaper for now, if you ignore the external cost.
I think solar power is even cheaper, but doesn't deliver much in the winter so far up north.
Backup: Batteries are cost effective for short term shortages. For long term shortages, you'd fire up thermal plants, either biomass or biogas (fossil gas for now).
It doesn't make sense to back up wind with nuclear. Nuclear has a high capital cost and relatively low running costs, so you don't save much from being standby but you still need to pay back the loans.