branko_d

25 ms·

271.
by branko_d 5y ago
This is insightful. In some sense, the only distinction a "pure" function has over "non-pure" is that it declares all its inputs/outputs (as function parameters and result). We say that a non-pure function has &quot
272.
Understanding LSM trees: What powers write-heavy databases (2020)(yetanotherdevblog.com)
149 points by branko_d 5y ago|45 comments
273.
by branko_d 5y ago
I found MobX working wonders for React UI responsiveness. You can cut-off large parts of rerendering more-less for free, without worrying you'll cut-off too much. I just wish MobX was statically typed, so I could know what has been obs
274.
by branko_d 5y ago
Ironically, Cobra Kai is on Netflix now. They bought it after YouTube stopped supporting it.
275.
by branko_d 5y ago
Assuming a non-clustered index on FOO (and no predicate pushdown by an optimizer smarter than MySQL's), the first query will scan the index on FOO and perform 150000 seeks into clustered index (only to discard 149985 of them): SELECT *
276.
by branko_d 5y ago
It still scans the index, but it doesn't fetch those rows that will be discarded. After it reaches the right page, it fetches the rows themselves. So it doesn't exactly avoid the wall, but it can push it considerably further awa
277.
by branko_d 5y ago
I think this article could have done a better job explaining the underlining data structures, which would have then given the readers much better intuition why this can actually work, and when . In a nutshell, a table can be: - Heap-base
278.
by branko_d 5y ago
One more thing: a heap can be easily packed contiguously in memory, while the tree nodes are typically dynamically allocated. This helps with allocation pressure, which is often the "hidden" cost people don't pay enough atten
279.
by branko_d 5y ago
I don't think you can have a "sliding window" of time just based on that. The next time you call the function, you need to count how many of the old calls are still "unexpired". This number (potentially) gets lower
280.
by branko_d 5y ago
> FK (which is just an index) Correction: foreign key is not an index. Many (most?) DBMSes allow a FK to exist without an index.
281.
by branko_d 5y ago
https://en.wikipedia.org/wiki/Survivorship_bias#In_the_milit...
282.
A domestic newspaper warns of the Russian space program’s “rapid collapse”(arstechnica.com)
4 points by branko_d 5y ago|0 comments
283.
by branko_d 5y ago
Excellent write up, thank you! It starts kind of slow, but then somehow morphs into effortlessly explaining advanced topics. I knew bits and pieces of this before, but I found information that was genuinely new to me, like this gem: ”Going
284.
by branko_d 5y ago
“If you wish to make an apple pie from scratch, you must first invent the universe” - Carl Sagan.
285.
by branko_d 5y ago
I think it's important to distinguish the authority of expertise from the authority of power.
286.
by branko_d 5y ago
I feel the same about Resharper. I stopped using it after many years simply because I could no longer bear the typing latency that is causes. I even bought a new laptop thinking the old hardware was to blame, only to discover the latency ha
287.
by branko_d 5y ago
Are you arguing that we should know which roots contain water and which parts of a horse are best for making bow strings? Circumstances change, skills evolve with the circumstances. Yes, there is a danger of sudden reversal of circumstances
288.
by branko_d 5y ago
> Imagine how difficult it would be to plug an elaborate 10-prong power plug into a socket with 10 holes... Imagine how difficult it would be to plug an elaborate 10-prong power plug into a socket with unknown number of holes. With stati
289.
by branko_d 5y ago
I have an uneasy feeling whenever I see a path parameter declared as string. Path is not a string - it's a sequence of path components and should be treated as such by our APIs. A path should be parsed once - on user input - and then u
290.
by branko_d 5y ago
Subzero temperatures don't seem to be that much of a problem, as the Finnish city of Oulu shows us: https://en.m.wikipedia.org/wiki/Oulu "Oulu is notable for its transportation network dedicated to non-motor
291.
A Data Sleuth Challenged a Powerful Covid Scientist. Then He Came After Her(buzzfeednews.com)
22 points by branko_d 5y ago|0 comments
292.
by branko_d 5y ago
> PLM managed through git I'm sorry but this is probably not a good idea. A typical PDM/PLM implements many things that don't exist or are not in the spirit of git, including but not limited to: - Per-object security, life
293.
by branko_d 5y ago
Or no battery charge at all! :)
294.
by branko_d 5y ago
> they value development speed I never understood that. For anything non-trivial, development speed is increased with types: you get auto-complete, safe refactorings, code navigation etc.
295.
by branko_d 5y ago
On the exception receiving side... The key, IMO, is to assume that every line of code can throw until proven otherwise, and then make sure you clean-up after yourself, using RAII in C++, `using` in C#, savepoints in SQL or whatever else mec
296.
by branko_d 5y ago
Windows 2000 was an excellent OS. Clean, frugal and and rock-solid. XP was bloated in comparison.
297.
by branko_d 5y ago
The best stats you've ever seen | Hans Rosling https://youtu.be/hVimVzgtD6w
298.
by branko_d 5y ago
Not so sure about aggregation, but what definitely takes forever is performance. To make a non-trivial SQL query scale to non-trivial amounts of data, you have to understand the physical data organization and how query optimizer is likely
299.
by branko_d 5y ago
> What is important is how the code is organized at high level. This was often forgotten about OOP as well, as Alan Kay himself reminds us... "The key in making great and growable systems is much more to design how its modules comm
300.
by branko_d 5y ago
> the "value" field is forced to be a character field It doesn't have to be. We use this (under SQL Server) for our simple "custom attributes" mechanism (some irrelevant details omitted): CREATE TABLE priva

More ›