81–82 of 82 posts
Earlier quoted context omitted.
The real trick is recognizing when "disposable" code has quietly become infrastructure
Law of disposable infrastructure: The more temporary a fix is intended to be, the more likely it is to become load-bearing permanent infrastructure
(in today's context: especially if you upload temporary Thing to GitHub & co)
There's a 'joke' that goes around occasionally that has some truth to it: "Excel is the world's most popular programming language." Occasionally it's 'Excel macros' or 'VBA' instead of just Excel.[1] The core truth of it is that a massive amount, possibly most , of the world's software is not a carefully hand-crafted application in that lives in Github written by expert software developers. It's a heap of Excel funct…
I cannot overstate just how much I love working on stuff in Excel and Google Sheets. It's the most popular programming language because it's incredibly intuitive to people at all levels of programming experience (especially the "none" level), it offers instant feedback, and in many cases, the results are trivially verifiable. It does have its flaws, that you've pointed out - there's no good way to write tests, I'm no…
Have even gotten better with add-on like AppScript and the rest.
Even got a new tool called RowSink that helps me dump data easily into my sheets. So I'm kinda a maxed out Google sheets overlord right now.