Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
Svip
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
43 ms
·
481.
▲
by
Svip
7y ago
Also quite expensive, since the Danish government provides a lacklustre funding for filming, according to Danish film makers. Even Danish productions often goes to places like the Czech Republic to film, because financial advantages are mu
482.
▲
by
Svip
7y ago
Someone may be able to correct me on this, or fill in the details, but part of China's larger Belt and Road Initiative, which is presented as investments into smaller countries, is to ensure non-aligned countries (in a manner of speaki
483.
▲
by
Svip
7y ago
Diplomacy wouldn't really work if you couldn't be candid. And if you knew everything you said in diplomatic conversations would be public, you'd be less candid. Or you'd only work with those, who would provide you with
484.
▲
by
Svip
7y ago
There is not currently a Free Trade Agreement between China and the Faroese Islands. But the Faroese Islands and Greenland have been hoping for a free trade agreement with China each, outside of one Denmark proper may have with China throu
485.
▲
by
Svip
7y ago
It's kind of a shame that it doesn't include the US territories, since it does say 'the United States', and not just 'the states of the United States' as the headline. Also, can we get (2012) added to the end o
486.
▲
Why Your Holiday Travel Is Awful
(politico.com)
3 points
by
Svip
7y ago
|
0 comments
487.
▲
by
Svip
7y ago
Did ICANN ever become a UN agency, or is it still technically under the jurisdiction of the USA? Or really neither, and nothing will probably happen?
488.
▲
by
Svip
7y ago
Except, that's potentially super slow if the optimiser does not realise what to do. In its default state, it will make two table look ups for each row in table a. So that's 1+N*2 look ups compared to 3 look ups in my example. F
489.
▲
by
Svip
7y ago
No, not that complex. Just that I want to be able to specify which of my joined tables I am counting on in a null-safe way, in case the joining table could have null values in all its columns.
490.
▲
by
Svip
7y ago
It would, I realised after I read the replies, that I should have used the two joined table scenario as per my reply to your sibling.
491.
▲
by
Svip
7y ago
If you write a lot of SQL, writing it in lowercase is OK. That's what I do anyway. If I insert simple prepared statements into code, I usually write keywords with uppercase, but larger code blocks, I write in lowercase. I also tend
492.
▲
by
Svip
7y ago
You're right, it's a bad example, imagine if I joining two tables: SELECT a.id, COUNT(b.*), COUNT(c.*) FROM a JOIN b ON b.a_id = a.id JOIN c ON c.a_id = a.id GROUP BY a.id I want to know how many occurrences a_id ha
493.
▲
by
Svip
7y ago
While counting columns will not include NULL columns, how about counting joined tables? SELECT a.id, COUNT(b.*) FROM a JOIN b ON b.a_id = a.id GROUP BY a.id is not permitted in Postgres. Sure, I could just use COUNT(b.a_id) since tha
494.
▲
Tech’s Woke CEO [Marc Benioff] Takes the Stage
(politico.com)
1 points
by
Svip
7y ago
|
0 comments
495.
▲
by
Svip
7y ago
As far as I can gather, all the islands of the Hudson Bay are considered part of Nunavut (even those in James Bay), but I don't think all the water belongs to Nunavut.
496.
▲
by
Svip
7y ago
Land area for Nunavut appear to be 1,877,787 km², which would still make it larger than the areas it is compared to in the article, but still far smaller than Greenland, which is right next to it.
497.
▲
by
Svip
7y ago
Isn't Greenland larger? It sends two mandates to the Danish Parliament.
498.
▲
by
Svip
7y ago
Because it makes the Conquistadors' conquests of the New World seem more appetising? Because it downplays the indiscriminate conquering of the Americas? Spain commemorates the day Columbus discovered America as its national day, as it
499.
▲
by
Svip
7y ago
But I am not sure this statement can be forgiven.
500.
▲
by
Svip
7y ago
> I'd sooner criticize a parser for mangling numbers above 2^53 (also allowed by the spec) The spec has something specifically to say about this[0]: > Note that when such software is used, numbers that are integers and are in the
501.
▲
by
Svip
7y ago
It's funny, the spec they references[0] makes no mention of parsers or nesting. But RFC 8259[1] clearly does. Moreover, I notice they were both published in December 2017. Why two specs for the same standard? [0] http://w
502.
▲
by
Svip
7y ago
Just speculating here, but it could also be plausible that one of Sholes' investors was a biographer, who wanted that kind of symbol on the typewriter. But given the success of the typewriter, by the second version, Sholes abandoned i
503.
▲
by
Svip
7y ago
And what if the connection is down?
504.
▲
by
Svip
7y ago
I think the title is a reference to the two previous articles that inspired it. Like the old 'X considered harmful' format.
505.
▲
by
Svip
7y ago
Of course I was trying to keep the comment brief, but "we" in this case is humanity. And the "choice" in this scenario is not automating every job, as the article suggests. If we automate 99% of jobs, it would still
506.
▲
by
Svip
7y ago
I hate the usage of the word 'inevitable' like this. Nothing is inevitable. There are some events that are going to be hard to prevent, like say the Earth being swallowed by the Sun (unless we could move the Earth out of harm&
507.
▲
by
Svip
7y ago
It really helps that in neither Denmark nor the Netherlands, helmets are mandatory. Unlike in say Sweden, where casual biking is having a hard time taking off. But it kind of bothers me that Danes and Dutchmen seem to be rather disinterest
508.
▲
Microsoft Employees Call to End GitHub ICE Contract
(bloomberg.com)
1 points
by
Svip
7y ago
|
0 comments
509.
▲
by
Svip
7y ago
Back when CRT televisions were the only option, Bang & Olufsen really made televisions of that era look great. But with flatscreens, everyone can make a television look great, so they've lost their edge. My point being, I don'
510.
▲
by
Svip
7y ago
I also noticed that he writes dates in the `%d %M` format (e.g. 25 July), which suggests that he is probably an intelligence officer. (I think they said he was an CIA operative?)
More ›