Avoiding the soft delete anti-pattern
Link: Avoiding the soft delete anti-pattern: "The main problem with soft deletion is that you’re systematically misleading the database. This is most obvious in the case of foreign key constraints."
I had never thought of this. It makes sense. Interesting.
Do You Use It? macOS Versioning Sees Low Awareness and Adoption - TidBITS
Link: Do You Use It? macOS Versioning Sees Low Awareness and Adoption - TidBITS: "The results of our poll asking how often you use macOS’s versioning feature show that nearly three-quarters of TidBITS readers either never use versioning or don’t even know what it is. But versioning could save you from losing work—it’s worth trying."
Versioning? Never knew about this!
Mastering SQL: Comprehensive Guide To Structured Query Language
Link: Mastering SQL: Comprehensive Guide To Structured Query Language: "Introduction In the previous blog article we've explored together a comprehensive guide..."
Pretty good collection of SQL basics, all in one place.
Slop is the new name for unwanted AI-generated content
Link: Slop is the new name for unwanted AI-generated content: "I saw this tweet yesterday from @deepfates, and I am very on board with this: Watching in real time as “slop” becomes a term of art. the way that “spam” …"
Watch a new term of art being created as we watch in real time.
bliki: Yagni
Link: bliki: Yagni: "Yagni ("You Aren't Gonna Need It") is the principle that we should not build presumptive features. It should not be used as a justification for neglecting internal quality."
Another longer article about YAGNI by the pretty-famous Martin Fowler.
» YAGNI – how to do things WHEN you actually need them to be done
Link: » YAGNI – how to do things WHEN you actually need them to be done: "YAGNI – how to do things WHEN you actually need them to be done"
Not everyone thinks YAGNI is a good principle. I happen to very much think it is. Of course rules can always be broken if you know what you're doing!
AI Superhuman?
Link: AI Superhuman?: "What does it mean for AI to be better than a human? And how can we tell?"
This article takes a stab at putting current and future AIs, capabilities into some context. They define some gradations of AGI and explain why some of them will be achieved sooner than others.
AI Isn’t Good Enough - by SK Ventures
Link: AI Isn’t Good Enough - by SK Ventures: "On a recent cross-country trip—I (Paul) drove from California to Illinois and back again. On the drive, I saw a sign I had never seen before: In a McDonald’s window it said $1,000 SIGNING BONUS. That was not a thing when I was a teenager doing minimum-wage jobs. No one paid you $1,000 signing bonuses to work for fast-food restaurants."
How LLMs Work, Explained Without Math
Link: How LLMs Work, Explained Without Math: "I'm sure you agree that it has become impossible to ignore Generative AI (GenAI), as we are constantly bombarded with mainstream news about Large Language Models (LLMs). Very likely you have tried…"
Excellent overview with code. Can't say for sure that it is a true/accurate explanation or just a clever oversimplified analogy.
How To Code A Mac Game - Best Learning Tutorials - GameDev Academy
Link: How To Code A Mac Game - Best Learning Tutorials - GameDev Academy: "If you've ever dreamt of developing your own Mac game but haven't been sure where to start, you're in the right place. In this article, we're going to"
Trying to make coding a simple game more approachable.