I wrote a small tutorial (~9000 words in two parts) on how to design complicated queries so that they don't need DISTINCT and are basically correct by construction.
https://kb.databasedesignbook.com/posts/systematic-design-of...
- Having a typesetting quality and control like TeX does, including mathematical typesetting, although improvements could be made to that, too. (I think I would also like the syntax more like TeX has)
- You can include PostScript codes within the document which can run during the typesetting process (rather than only during output), therefore allowing it to affect decisions of page breaks, etc, as well as allowing PostScript to draw diagrams and control text rendering. (I had written a PostScript program to load PK fonts, so that would make it possible to use PK fonts from TeX as well.)
- Full support for non-Unicode text (without converting it internally to Unicode). (It is OK if it also supports Unicode as long as the code to support Unicode is avoided when not using it (in the entire document or in a part of it).)
https://xplanes.tumblr.com/post/30938386375/from-the-cover-o...
https://xplanes.tumblr.com/post/30941448265/from-nuclear-pow...
https://xplanes.tumblr.com/post/30944519719/from-nuclear-pow...
https://xplanes.tumblr.com/post/30947450568/from-nuclear-pow...
https://xplanes.tumblr.com/post/30952419021/from-nuclear-pow...
https://capitalgains.thediff.co/p/teachingfinance
“And it's hard for a teacher to end a class by telling students that they got an A+ in financial literacy and are now equipped to get ripped off in entirely new ways by an entirely different set of adversaries. But it's also impossible to create a repeatable standardized test that accurately simulates such an adversarial environment, because any time everyone gets the same correct answer, that answer would need to become wrong.”
Some good ones: - United States v. One Solid Gold Object in Form of a Rooster - United States v. 11 1/4 Dozen Packages of Articles Labeled in Part Mrs. Moffat's Shoo-Fly Powders for Drunkenness - South Dakota v. Fifteen Impounded Cats