_dain_

10 ms·

121.
by _dain_ 2y ago
>who was in charge of “digital infrastructure” in previous governments germany's digital infrastructure is a global laughing stock, this doesn't bode well.
122.
by _dain_ 2y ago
It's not just for "elite" devs. For my second real job I did not feel I was an "extremely strong candidate", just a mildly above-average one. I crushed the coding portion of the interview, but that balanced against
123.
by _dain_ 2y ago
Yes, run power to wind turbines to use them as giant fans
124.
by _dain_ 2y ago
Don't do this stupid party trick with `global`. You may as well argue that unit tests are pointless because you could cheat by making the implementations return just the hardcoded values from the test cases.
125.
by _dain_ 2y ago
>I already had that information. I understand my own coding style. Good for you, but you're not the only person working on the codebase, surely. >My function bodies are generally only a few lines, but my reasoning here is base
126.
by _dain_ 2y ago
There's a difference between intellectually "knowing" that you can parse SQL, and actually going out and trying it and finding that it's practical to do in a test suite. I found the article valuable.
127.
by _dain_ 2y ago
So don't do this then? The type system does not have to be sound to be useful; Typescript proves this.
128.
by _dain_ 2y ago
>The point is that I gain no information from it No, you do gain information from it: that the function takes an Iterable[Ducklike]. Moreover, now you can tell this just from the signature , rather than needing to discover it yourse
129.
by _dain_ 2y ago
This is totally not how I used typed Python. I eschew classes almost entirely, save for immutable dataclasses. I don't use inheritance at all. Most of the code is freestanding pure functions.
130.
by _dain_ 2y ago
>I'm concerned with what capabilities the input offers, not the name given to one particular implementation of that set of capabilities. If I have to think about it in any more detail than "`ducks` is an iterable of Ducklike&q
131.
by _dain_ 2y ago
>What? That's not what security means. Sure, you traded convenience for security. Your Google/Microsoft/FB/etc accounts are used to sign in or access information about other extremely important things in your life,
132.
by _dain_ 2y ago
>you are roaming and do not have access to texts I truly despise this. It effectively disenfranchises people for living outside of areas with good mobile coverage. Banks or utility payments or parking meters(!) or whatever should not b
133.
by _dain_ 2y ago
KeepassXC is FOSS, runs locally, is actively maintained, and is multi-platform. https://keepassxc.org/ I've used it for years with no complaints, it's wonderful.
134.
by _dain_ 2y ago
>Now, my Github access depends on the second factor, which I have chosen to be Microsoft Authenticator running on my phone. I genuinely do not know what will happen if my phone breaks down, so I downloaded TOTP codes from Github and eve
135.
by _dain_ 2y ago
happens sometimes. some people deliberately smash windows and bus stops to keep their rents down. or shoot guns in the air.
136.
by _dain_ 2y ago
There's an opposite incentive to keep the value of the improvements high (i.e. the house itself and any rental income that might come from it). Degrading the value of the land is hard to do without degrading the value of the improvemen
137.
by _dain_ 2y ago
>Yeah. Humans are crafty though. I don't think it would take conspiratorial coordination in order for this to turn into somewhat of an arms race. I'm imagining homeowners associations shifting prices from land value to HOA due
138.
by _dain_ 2y ago
The land value would be determined by surveyors based on the characteristics of the plot itself, the values of the plots around it, and the values of similar kinds of plots elsewhere. So if you tried such a stunt it'd be pretty obvious
139.
by _dain_ 2y ago
A simple average of total value / total amount of land is crazily misleading. LVT isn't about charging a flat rate per acre, it's supposed to scale with the unimproved value, hence the name. Land value per acre has a tremendo
140.
by _dain_ 2y ago
>Additionally, I am making a concerted effort to notice more new details during routine tasks, like commuting or shopping. I can't count how many times I've discovered something new and interesting on my work commutes. Actuall
141.
by _dain_ 2y ago
government, money, local geology.
142.
by _dain_ 2y ago
god I wish I could live in tunnels. like a hobbit. these sloths had it all figured out ...
143.
by _dain_ 2y ago
>That's not a solution at all, and there's nothing clever about it. It is a solution, and I'm not motivated by trying to be "clever". It just makes writing and reading the query easier for me. >You've
144.
by _dain_ 2y ago
The first element is modified less often than the last element. Often it's just an "id" column or something. Comma-first is a net win.
145.
by _dain_ 2y ago
I'm curious why you think so? I agree totally with the parent comment; when I iterate on a SQL query the most common place to make changes is near the end of the SELECT block, adding and removing and refining column expressions. I do t
146.
by _dain_ 2y ago
You can use ANY_VALUE to get an arbitrary value from a GROUP BY. There's also FIRST_VALUE for a window function (though that requires you specify an order).
147.
by _dain_ 2y ago
https://borretti.me/article/composable-sql >Imagine a programming language without functions. You can only write code that operates on concrete values, i.e. variables or literals. So instead of writing a function a
148.
by _dain_ 2y ago
WHERE and HAVING (and QUALIFY) are redundant. The PRQL language unifies them into a single "filter" construct: SQL: SELECT country, MAX(salary) AS max_salary FROM employees WHERE start_date > DATE '2021-01-01
149.
by _dain_ 2y ago
>How you index into them is unrelated to performance. Not true. If you store u32 indices, that can impose less memory/cache pressure than 64-bit pointers. Also indices are trivially serializable, which cannot be said for pointers.
150.
by _dain_ 2y ago
You hit the nail on the head. It's from that era of anti-nuclear hysteria and overpopulation doomers. Collapse stories are an expression of vanity. "Après moi, le déluge."

More ›