_a_a_a_

57 ms·

841.
by _a_a_a_ 3y ago
"it is not that surprising" Aw lord, there's always one isn't there.
842.
by _a_a_a_ 3y ago
Oh, that's very interesting about the functional dependencies. I'd certainly no idea about that. Interesting discussion, thanks!
843.
by _a_a_a_ 3y ago
> but if you want the highest paid employee per team or department That's straightforward, no? max(salary) over(partition by emp, dept order by salary desc) as top_emp ... where top_emp = 1 (You need to put the window
844.
by _a_a_a_ 3y ago
I use both in SQL regularly and without any problem, done so for decades. The problem is if you're actually implementing something then those rules you informally understand suddenly start to look less obvious when you try to write the
845.
by _a_a_a_ 3y ago
Very. Why?
846.
by _a_a_a_ 3y ago
I'm heading in the direction which is engines/tooling and I'm amazed at the number of corners of SQL that I have discovered that I don't know properly. You can use it fine for decades but when you need to know precisely
847.
by _a_a_a_ 3y ago
Name's new to me. https://en.wikipedia.org/wiki/Binary_logarithm
848.
by _a_a_a_ 3y ago
Yeah, sux to not have the SQL standard. Flipside, allegedly it is nearly undecipherable (on hearsay, not IME)
849.
by _a_a_a_ 3y ago
Firefox allows you to use / to start a conventional search. As a bonus, in Firefox if you hit the ' key (apostrophe) you get a search that looks only within hyperlinks and ignores all the un-clickable plain text. Give it a try, so
850.
by _a_a_a_ 3y ago
Strictly content. I'm looking to learn not be entertained so good explanations is all I'm after.
851.
by _a_a_a_ 3y ago
Perhaps it is. But if Indian YouTubers instead produced exceptional quality videos, I'd be as attracted to an Indian name popping up as I am discouraged by one now. I don't believe my discrimination is based on race, therefore isn
852.
by _a_a_a_ 3y ago
Do you work in advertising? Edit: seems not according to your profile, but it certainly does sound like it's written by an advertiser "connecting" people to products and carefully ignoring the fact that once a person has been
853.
by _a_a_a_ 3y ago
Well, there's also this https://en.wikipedia.org/wiki/1K_ZX_Chess 1K ZX Chess's code takes up only 672 bytes in memory,[2] but implements chess rules except for castling, promotion, and en passant, including
854.
by _a_a_a_ 3y ago
I'll certainly check out some of the channels here but my experience with Indian-originating tutorials on YouTube is that they are almost uniformly terrible. There are a few good ones but so rare that if I see an Indian name I'll
855.
by _a_a_a_ 3y ago
"Any sufficiently advanced technology is indistinguishable from lumps of metal and random chunks of rock" At least when it rains down on us as meteorites.
856.
by _a_a_a_ 3y ago
And no Wales for areas :(
857.
by _a_a_a_ 3y ago
Avi Loeb was the author of any number of crappy articles in Scientific American. Once I saw his name I started to skip over them. After a while Scientific American stopped publishing them. The only thing you really need to know about this g
858.
by _a_a_a_ 3y ago
The temperature might well matter :-) My minds eye has a picture of a goldfish lithobraking into a wall of solid ice.
859.
by _a_a_a_ 3y ago
Very interesting. Any idea how pure water could cause diarrhoea?
860.
by _a_a_a_ 3y ago
Maybe this could be made to make sense, after a fashion. Deuterated (D) water (heavy water) is apparently toxic if you get too much of it. I think the figure I heard was if it's over about 50% D2O in the D2O/H2O then it will kill
861.
by _a_a_a_ 3y ago
I thought Goldfish go to the top of tanks and 'gulp air' to get extra oxygen. Or so I assumed – does anyone know why they do it for sure?
862.
by _a_a_a_ 3y ago
The direct threading is what interests me. From a link provided above by @ghusbands https://eli.thegreenplace.net/2012/07/12/computed-goto-for-e... "...and the goto version is 25% faster than the switch
863.
by _a_a_a_ 3y ago
My interest is in compilers much more than interpreters, I haven't come across this threaded style before, my interest in languages and compilers is something I've barely used at work, and everything after university that I'v
864.
by _a_a_a_ 3y ago
> You can arbitrarily create models of earth life that didn't have a common ancestor I'm finding it very difficult to understand what you mean by "models of life". Actually I have no idea. What does this phrase even m
865.
by _a_a_a_ 3y ago
> It's trivial to apply my hypotheticals to models in which life didn't all descend from a common ancestor We don't have such a thing to our knowledge so it's not trivial. If you still feel it is, do the application y
866.
by _a_a_a_ 3y ago
> So you are questioning the effect of direct threading code? No, cos I said "the benchmarks speak for themselves". But I am trying to understand why it's better and under what circumstances.
867.
by _a_a_a_ 3y ago
Don't worry, I'm out of my depth and I know it, I shouldn't have put my oar in :)
868.
by _a_a_a_ 3y ago
This is my area of interest and I know a little about interpretation/compiling. I'm a little dubious about this (which I shouldn't be because the benchmarks speak for themselves). But a couple of doubts. 1. "it avoids an
869.
by _a_a_a_ 3y ago
Come on man, they literally say that, and acknowledge hardware may differ in behaviour, that difference too to be subsumed by the training/optimising.
870.
by _a_a_a_ 3y ago
"without using any assets" vs "relying on no external assets" but it's not my area so I may be misunderstanding.

More ›