OliverJones
Joined 12 years ago
Joined 12 years ago
It has to be said, the order of columns in correctly designed multicolumn BTREE indexes is governed by the shape of the queries the indexes support.
So don't arbitarily reorder columns in your indexes to handle alignment.
There's the science of Karl Popper, where no statement can be considered scientific unless it is possible to devise an experiment to disprove it. And there's the science of education, where we memorize and regurgitate stuff.
Those two are stunningly different from each other. Yet, it's not possible to get to the mysterious work of actually doing Popper-level science without memorizing what went before. The critiques of this paper still ring true half a century on. I wish more students of science from primary school on up would pester their teachers and each other with the question, "how do you know?"
Here are some notes about my experience, offered to anybody who might be able to use them. https://www.plumislandmedia.net/reference/sqlite3-in-php-som...
I wish it worked with glass :-) :-)
I sometimes sweep up broken glass from bike lanes in my community. I need gloves, a broom, a dustpan, and a trash bag. Not as efficient. Needs a car, not a bike.
Read about what not to do: _The Ultimate Question_ by Fred Reichheld. This book is about the notorious Net Promoter Score. (Would you recommend HN to a friend? Would you? Would you?) Reading it will give you insight into how bonehead MBAs with Cs in their marketing classes can convince leadership they've come up with a good way to measure customer satisfaction. (Net Promoter Score works fine for competitive businesses selling commodity products -- rental cars to individuals for example -- but not for many places where it is now used.)
And, one wishes that a university class on scientific ethics asked students to read this article with a critical eye and figure out what they can learn from it.
Myths about human-health topics spread faster than truth sometimes. cf. stomach ulcers and "stress" vs. pylobacter. It's hard to stop that. But it's easier to stop if we're aware of the myths.
Germany seems to have similar sorts of federal / state / municipal government issues and other bureaucratic constraints as the US. And, this article makes it clear it has the same sorts of opportunities for improvement.
Maybe it's time to establish Programmieren für Deutschland as a parallel org to Code for America.