branko_d

38 ms·

391.
by branko_d 7y ago
According to Wikipedia ( https://en.wikipedia.org/wiki/Penicillin#Discovery ): "The effects of penicillium mould were finally isolated in 1928 by Scottish scientist Alexander Fleming"
392.
by branko_d 7y ago
Yes, performance is a feature. You have to plan and architecture for it, and you can't just tack it on after the fact by profiling a few hot codepaths (though you should do that too). Performance can be different from "scalability
393.
by branko_d 7y ago
Just beware that C# is not exactly "Unicode" either. C# char is a UTF-16 code unit, not a Unicode code point. Most code points "fit" into just one UTF-16 code unit, but not all. For example: 𝐀 ("Mathematical Bold Ca
394.
by branko_d 7y ago
I'm not even German, but I know this... Kurzgesagt – In a Nutshell Awesome YouTube channel, BTW. ;)
395.
by branko_d 7y ago
Yup, aligning the B-Tree nodes to database pages (which are themselves aligned to physical disk blocks) is the key. No pun intended ;)
396.
by branko_d 7y ago
What bugs me is the too-strong coupling between the language and the run-time environment. (Non-)nullable references are a perfect example. They could have been supported on the old .NET Framework, but MS chose to only officially support th
397.
by branko_d 7y ago
I have exactly the same experience.
398.
by branko_d 7y ago
If they really push it to 1000 km/h, that will be faster than jetliners (with typical cruising speeds around 800-850 km/h).
399.
Writing Well-Behaved Triggers (2012)(dave.brittens.org)
1 points by branko_d 7y ago|0 comments
400.
by branko_d 7y ago
Some joins may be completely eliminated if the fields coming from them are omitted from the SELECT list. This happens when the DBMS can prove (through FOREIGN KEYS) that the joined row always exists, without having to ever physically retrie
401.
by branko_d 7y ago
Few random observations from my experience: - The docs and the code should live at different abstraction levels. Docs add most value when they explain things which are not readily expressible in code. - Docs are often written first, as a me
402.
by branko_d 7y ago
(Slightly) more accurate analogy... The vampire is feeding cookies to the developer, and sucking blood out the company that hosts the developer's code on the vampire's cloud. Not such a bad deal for us developers, IMO.
403.
by branko_d 7y ago
This is not just about the code, but also about the feature this code implements. A feature implemented through "indebted" code tends to be buggier and less performant. There are exceptions, of course, but by-and-large this has be
404.
by branko_d 7y ago
> much more space is wasted on column (field) alignment in records Hmmm... I don't think there is much alignment going on within the data pages. Efficiently packing data is a matter of avoiding excessive I/O and I can't im
405.
by branko_d 7y ago
> if you decide to use slugs for URLs I agree that using slugs alone is probably not a good idea (simply because they are not stable). They are there to make the URLs friendlier to search engines, but are strictly redundant (and therefor
406.
by branko_d 7y ago
Sequential integer IDs have some advantages over GUIDs at the database level. Integers are smaller (and cache friendlier!), while sequential values generally improve the fill factor of B-Trees (the DBMS can special-case the insertions that
407.
by branko_d 7y ago
Just use GUIDs instead. And if you want to keep using integer IDs internally, put the GUIDs into an alternate key.
408.
by branko_d 7y ago
My two main gripes with SQL are: - Lack of interoperability with other languages. - General ugliness of server-side SQL (stored procedures and functions). -------- The first one isn't really solved by ORM tools, AFAICT. You can't
409.
by branko_d 8y ago
I don't know about Japan, but I can confirm that in Kazakhstan doctors actively encourage sick people to wear surgical masks, specifically to prevent them from infecting others. Disclaimer: I'm not Kazakh myself, but my wife is.
410.
by branko_d 8y ago
FYI: Resharper can render XML comments (place the cursor on the symbol of interest and hit CTRL+SHIFT+F1). This includes the entire comment, not just the <summary> section.
411.
by branko_d 8y ago
Another good example of "compiler as a service" is the Roslyn compiler for C# (and also written in C#). What is interesting is that Roslyn was a complete rewrite compared to the original C# compiler (which was written in C++ and c
412.
by branko_d 8y ago
Key point: "The primary reason the utilization is so low is efficient code."
413.
by branko_d 8y ago
BTW, alcoholic drinks are requred to be radioactive by US law. https://youtu.be/1N1ydPJGGj4
414.
by branko_d 8y ago
I used it, and I would disagree that it was "complex" to use. No more than non-transacted Win32 file APIs anyway. We did a nice P/Invoke wrapper around native Win32 functions in C#, exposing FileStream and such, that the rest
415.
by branko_d 8y ago
NTFS has transactions... https://msdn.microsoft.com/en-us/library/windows/desktop/aa3... ...but sadly, they seem to be on the path of being deprecated by Microsoft... https://msdn.microsoft.co
416.
by branko_d 8y ago
Makes me glad I ordered prenatal genetic test for my daughter from Roche (Harmony) and not BGI (Nifty).
417.
by branko_d 8y ago
It strikes me that Windows is full of idiosyncrasies and historical artifacts (largely to keep it compatible with existing applications), yet is very successful and widely used - like English! I guess keeping compatibility over long periods
418.
by branko_d 9y ago
BlueprintJS is missing. Also, material-ui, react-md, Prime React, and quite a few others...
419.
by branko_d 9y ago
Recursive CTEs are breadth-first, which may not always be what you need.
420.
by branko_d 9y ago
Now, if they could downsize it and kill mosquitoes in mid-air (while keeping other insects alive), I'd definitely buy that! (Sorry, just a residual reaction to a mosquito-ridden vacation last summer.)

More ›