skysight-inc/HackerNews huggingface dataset:
Sure SQL can be awkward, but in your example the + operator is not the same as the SUM() function, so it's not surprising that they wouldn't work the same either. SUM() will probably cast the null into a 0 first in most databases while the + operator has no proper guidance on what to do with a null value.

Nullability is required to represent empty values and every database has ISNULL() and IFNULL/COALESCE() and both of those read fine to me but I can see why they're strange.

I'm not sure what you mean by abstraction though since CTEs, joins, window functions, table values, UDFs, views, and more can all be used to compose logic and the language does support parameters, cursors, if/else/case statements, ... what's missing here?
The Wall Street Drama Behind Remington’s AR-15
Completely agree. This is way better than the rich gobbling up finite natural resources. Art is virtually infinite since you can always create more. And it allows more people to actually be artists.
Advertising only works when you get exposed to it. The sheer maliciousness of the advertising industry succeeded in one thing as far as I'm concerned: I make sure we - as in my family and myself - get exposed to as little advertising as possible, and that we buy as little as possible of those things which are being advertised. How?

- we ditched television and broadcast radio

- we burn printed commercials without looking at them, the exception being the local supermarket's weekly handout

- we ditched our subscription to a printed newspaper and get our news from the 'net through a news reader

- ads are blocked on the router using a local name server with a blocklist, on the router through a net block firewall and on all devices using adblockers and dns blocking

- we buy second-hand as much as possible which a) gives us more for our money, b) leads to less waste, c) the proceeds generally go to some charity and c) provides an extra level of indirection between whatever is being advertised and what we buy

- we don't buy processed food whenever possible

- we don't "go shopping" without having a clear target, when we do go out to get something we generally have a list of things to get and tend to stick to this. Of course this is not a hard law, we sometimes buy things on the spur of the moment but we generally think twice or three times before buying

I probably forgot to mention quite a few things but it already reads as if we live in some kind of sect. We don't, not by a long stretch. We just don't like being used, that's all.
Automated QA Setup step by step
Capitalism 2.0, now performs 10 times faster.
I don‘t think anyone has actually stated this, so perhaps this won’t do as an answer, but I think in general the purpose is to counteract decades of bias and discrimination?
Anything and everything probably, it can be seen even in reviews. I was looking up some gloves and often the reviews are split 50/50 between great and complete garbage. I assume that the unlucky half got counterfeits. Recently I have bought some plastic plates to put under a flower pot. The dimensions were completely wrong: as in, the advertised plate was for a pot of 22 cm in diameter and this was even printed twice on the plate itself - it was not even 18cm large. This was on a product with over 4.5 star average.

I still buy stuff on amazon because returns are very simple, but I got into habit of immediately returning anything which is not good enough. I feel that most of the stuff one can buy there is garbage.
HD4000, Safari on High Sierra => 50fps windowed, 30fps @ 2560x1080

Output:

Using WebGL ver: 1
Warning: No color buffer floats. Water will look bad. Try Chrome >= 64.
AFAIK Firefox profiles should give you the same kind of privacy as running them under different user accounts.
Findx is now a private search engine in the Brave browser
Google has been accused of being too "white male" so this was an (illegal if true) attempt to balance what the company looks like.

I can also see it being a case of the CEO pounding their fist and saying, "Do something about X, which you're being explicitly measured on in your OKR" and then middle management choosing methods that are explicitly wrong.

I have no inside info on this case though.
By introducing new bias and discrimination? Well, what can go wrong?
Wow. That's not a feature I was aware of at all.

My only concern here is: does the extensions API used by this feature definitely cover all requests made by the browser. e.g. I don't see requests to geolocation services from the Navigator.geolocation API, Google Safe Browsing or CT auditing included in the list of example request types there.
Malware from Space
And calls it science.

Its my life’s work to persuade indie game developers, computer programmers and other ‘smart’ people, that they are wrong and that advertising works.

After reading the article I'm more convinced he is wrong. Which is quite weird, considering even if he would be right, he is doing a bad job.
Counteracting decades of bias and discrimination with bias and discrimination. What a great idea!
One command to update the language...wow...ok Iong for the day I can do that in C++.
> "Adam Smith...idealized independent people, usually farmers. Entrepreneurs, maybe 10 person tin factories"

Actually, Adam Smith constantly used independent farmers as examples of inefficiency, and the second paragraph the first chapter of "Wealth of Nations" mentions huge companies "destined to supply the great wants of the great body of the people".

Adam Smith is easier to read than are most discussions of his writing. If you want a sample, read the first three chapters of "Wealth of Nations" - only 20 pages. https://www.ibiblio.org/ml/libri/s/SmithA_WealthNations_p.pd...
Google: Class search results as journalism so we can dodge Right to Be Forgotten
Petoi: a Pi-Powered kitty cat
iOS, the Future of MacOS, Freedom, Security and Privacy in Hostile G Environment
Is this supposed to work at all on Chrome mobile?
Blockchain Engineer Wanted
Spoof, Jam, Destroy: Why We Need a Backup for GPS
Scaleway are horridly unreliable. I run a SaaS business, and hosted first with DigitalOcean which amounted to roughly one outage per month. I then tried hosting with Scaleway for a few months to cut costs.

On Scaleway, I averaged 53 outages every month. Average response times were slower. Longer outages meant I had to manually hard-restart the server, which corrupted all the database indexes. Scaleway also has a huge problem with machine availability. Last time I checked, everything was out of stock.

I'm hosting on AWS now, and it's about as reliable as DigitalOcean.

Outages are all tracked by Pingdom.
Can this be used for style transfer?

I'm looking for a solution to create a consistent personality for a chatbot, where the content all is created by different team members.
Well,I think the picture is still much more in favor of nuclear than you seem to suggest although I'd agree renewables have gotten a lot better, though less so on their environmental impact (just having solar panels on land kills natural wildlife and destroys habitats). But I think we'd both agree people should look at the data and research this, b/c whatever you think nuclear still has tons of potential, it has already solved most of the problems wind/solar have, and the public has a false perception of it as a "boogie man" which has and will just lead to bad choices and misaligned public policy.
> Allende not democratically elected

He wasn't, still, he got a 64,1% approval rate in 1972, which is much more than the actual president (Michelle Bachelet) on her whole second government.

> Main players were always Chilean

Not true, there is evidence that proves US intervention in both elections and government.
Minor point, but Sweden has a 50% Sales Tax? What's the source?

I see a VAT of 25%. https://en.wikipedia.org/wiki/Taxation_in_Sweden

This doesn't change your overall conclusion that not a lot goes back to the artist.
Yep, that one was taken by the dude that couldn't use @gmail, because you already had it ;)
Decades of bias and discrimination against white males? Government has been doing it for years.
Seconded, e.g. going to the signup page on my iPhone 5 just leads to a blank page. I suspect the same might be true for my iPad Air despite being on a current iOS release.

A slightly better onboarding experience would be worth a lot, even if the answer is "thine device is unsupported and no plan to support it exists."
> "white males and otherwise conservative people"

?
It’s kind of similar though in Europe. France, Italy, Germany and other European nations are very protectionist. Hell, entire EU is basically a protectionist conglomerate of nations so they can protect their economy against competition from emerging markets, Asia, South America etc. Chinese companies trying to have any meaningful presence in Europe also have to be in bed with local politicians and ruling class.
They limit themselves to only those solutions which have been vetted by the scientific process, and that could be readily implemented with currently available technology. In a way you're right that that's not an optimistic take, but in another way there's a lot of optimism there: they show that adding up the impacts of only that limited set of solutions could already achieve drawdown!
Isn't there a way to do this without discriminatory behavior, or are punitive measures a requirement? Specifically, punitive measures towards those that otherwise have not committed any offense other than simply being born the wrong race and/or gender.
Previously: https://news.ycombinator.com/item?id=16497551
> There is a huge amount of protectionism

Yes, like the 74% Steel tariff the EU imposes on China

Or how about solar panels from China which are hit with 65% tariffs unless they are sold at a minimum price (which is higher than average EU equivalents)?

The EU not being protectionist is a widely believed meme.
How to Implement Google AMP on WordPress Site or Blog?
SplitWhitespace is a convenience. Its underlying internal type is actually:

Filter<Split<'a, IsWhitespace>, IsNotEmpty>

The split[1] method is generic, and for example, one can indeed use a regex for it. (I wouldn't use it for CSV though, since it would almost certainly be wrong.)

[1] - https://doc.rust-lang.org/std/primitive.str.html#method.spli...
It's been shown that when a baby grips the finger of an adult, the adult tugs the baby's arm if they think the baby is male and hold their hand static if they think the baby is female.

I can't find the paper, though.
The real magical leap is how you take in 2B and produce nothing but a few patents.
Rust doesn't have manual memory management. It does have deterministic memory management as opposed to garbage collected language. Which means you can use it it in domains where garbage collected languages cannot be used - e.g. for a OS ...or for implementing a garbage collector.
I disagree. Frankly, for a lot of people and a lot of contexts, I don't think the halting problem is particularly important. You're using understanding of it as a shibboleth for exposure to common curricula about theoretical computation. But you can even know a lot about practical computation and not know anything about the halting problem. Curious: has your knowledge of the halting problem ever actually saved you time or effort in your work? If so, how?

Turing's work on the limitations of his machine are interesting, and I'm sure people with a deep understanding of them can advance the study of computation.

I think you're just being dismissive of skillsets which aren't your own. I think you're just bothered by the fact that AI and ML are being advanced more by people with more knowledge of linear algebra and statistics than computer science. And realize that it's the arrogant among them that will dismiss you as "just a technician."

Anyone who is looking down on either "scientists" or "technicians" should get over themselves.
Celebrate the Spring by Harvesting Free Ad Credits
What's more absurd is that the new victims are not the old beneficiaries. They discriminate before hiring against unrelated people.
It's a fair question, but if #MeToo has done anything it's been to highlight that a reasonably high percentage of men will misuse positions of authority for sexual reasons.

The answer is: some of our colleagues.
This is very true. I was involved in the NYC art market for about a decade. The smart artists either became professors or started over in a new career. Most of my art world friends are now programmers, lawyers, etc. A very small number of the people I knew actually made it, most of whom had a social or financial advantage to aid them. I knew exactly one artist who briefly made it on talent alone, and he was the art making equivalent of Lebron James.
To break endemic, systemic bias and discrimination, the majority group must choose to be biased and discriminatory against itself.

I can almost guarantee you it was a white male that had ultimate responsibility to make the decision to take action with regard to that demographic.
Nice picture. What else is there to show?
It is incredibly unlikely but you're right, especially when there might be poor UUID generators being used. We use 64-big ints for all ids which are resereved as batches from a global id service. Any datastore with atomic increments can serve this so I'm surprised it's not used more often.
I don't doubt that the technology works great. My concern is that the fully loaded lifecycle cost of spent nuclear fuel disposal/storage or reprocessing is not being taken into account when calculating dollars per megawatt-hour generated. This can be very costly and is frequently an economic externality of the cost to build and operate civilian nuclear power.
Sailsense Analytics (sailsense.io) | Brussels (BE) ONSITE | Full-time (38.5 ours/week)

Sailsense Analytics is an IoT company, whose vision is to simplify navigation and make leisure boating easier, cheaper, more convenient and ultimately more sharable. We create value for boat owners and other industry professionals (boat manufacturers, boat rental companies, …) by exploiting all the sources of information available on board.

We are looking for embedded and mobile software engineers, data scientists and an UX designer. More informations at https://www.linkedin.com/jobs/sailsense-analytics-jobs/
Facebook testing Messenger broadcasts
Java theoretically taking a lot of care not to use excessive memory. It loads classes on demand, it compiles bytecode only when this path is really hot. I don't really see why it's necessary to use 16MB RAM. Golang has GC and doesn't that much memory. Lua has an entire virtual machine and runtime and doesn't use that much memory either. It's not a valid argument. I still believe that current JVM developers just don't care that much about memory consumption which is a valid decision, but I don't like it anyway. Not everyone has 8+GB of RAM. I have 256 MB VPS which runs quite a few of network services and has half of memory free, but I don't think that I could afford Java if I want to run something there, even if my load is tiny.
Punishing the grandchildren for the wrongdoings of the grandparents.

I though we left that behind a 100 years or more ago?
> or are you going to pick the first brand that pops into your head?

The cheapest.

If I don't do research (read reviews or word of mouth) I often end up buying crap. Especially when emotions are tense. So I end up buying the cheapest, and reading a review (or indeed ask around) when I got more free time.

I wouldn't buy the brand which pops up in my mind, heck I got no clue which windshield brands exist.
On the bright side, it seems like some people here are finally waking up to the fact that China may soon be imposing it's will on the world. The Economist must be very influential.
No I haven't tested on any mobile platforms. It's targeted at desktop.
But it's not even sustainable for the big companies. Even with screwing over their please-don't-call-them-employees, they still need constant infusions of investor cash to stay afloat.
Norway tax on alcohol is around $63 per liter of pure ethanol. So your 5% 0.33 liter beer only has $1.05 tax.
Perhaps the people of the PRC value the stability that creates the conditions for their improving lives more than free speech and other individual rights. We, in the 'West', are in no moral position to say that their system is somehow wrong. Sure, we absolutely can and do judge; but we have lost the moral authority to say to the rest of the world that they ought to live by those judgments.
Because the masses are brand loyal. Such scandals pop dents in the overall brand loyalty, but they are temporary.
I don't have any stats on modern power consumption, but to be fair the P4 was an experiment in higher clock speeds that didn't pan out.

Future processors focused on increased parallelization and returned to less power-hungry clock speeds.
If it’s not technically cheating, it could be described as gamesmanship.

From Wikipedia https://en.m.wikipedia.org/wiki/Gamesmanship

“Gamesmanship is the use of dubious (although not technically illegal) methods to win or gain a serious advantage in a game or sport. It has been described as "Pushing the rules to the limit without getting caught, using whatever dubious methods possible to achieve the desired end".”
SamKnows is working with governments, ISPs, consumers and academics worldwide to build the definitive global internet performance measurement platform. With over 100,000 hardware measurement probes distributed across 35 countries, and even more mobile app installations, we provide an accurate analysis of end-to-end internet performance.

If you love big data, machine learning, and want to work in a fast-paced environment while contributing to the greater good, SamKnows could just be what you’re looking for.

We have an office right by the Tate Modern in London and are about to open two more offices in Sao Paulo and Philadelphia.

We are hiring for the following roles:

* iOS Developer

* Android Developer

* Senior Software Engineer (Machine Learning)

* Senior Software Engineer (PHP Backend)

* Senior Software Engineer (Data)

More details can be found here: https://www.samknows.com/company/careers

Contact us with any queries: careers@samknows.com
This guy. One of my favorite YouTube channels. Releases something like once a year but oh boy, worth the wait. Check it out if you're a nerd and like creative/useless stuff. ;)
This is great, but I wish it would get updated for 2018 as it is now 2 years old.
Well I think there are two counter points: Uber already has a running business, so it's relatively easy for them to go to a bank and say 'Here's how much a fleet of cars cost, here are the running costs, would you finance us $3Bn for it'. The answer is almost certainly yes, and if not then venture capital would probably fill the gap.

The second point is that there are two keys to making money out of this: Have self-driving cars, find customers to rent the self-driving cars. Uber is already established in the second part. So it might be true that another company buys the cars and tries to run the business, but uber has the established customer base.

In my opinion the future of self-driving cars inevitably ends up with one of the big players buying uber to allow them to monetize their fleet.
That's what I do too. Deny all third-party cookies, plus uBlock Origin with a sizable filter list and prefetching and link auditing blocked, video autoplay disabled gets me most of the security benefits with minimal setup and cognitive load. Privacy is not much better than running vanilla because although 3rd party cookies are blocked, most sites can still identify by device fingerprinting. That can only be blocked by not running Javascript, but that's personally too much of a hassle to handle and unbreak for practically every site out there.
I find it perplexing if Asian men are considered "white males and otherwise conservative people", these days.

Asian men (according to a quick Google search) are 28% of the entire world population, incidentally.
Why the Joy of Cooking is going after a Cornell researcher
> For example, his controversial statement about women being neurotic and too agreeable.

Neurosis is a clinical diagnosis, not a criticism as many laypeople misinterpret it. This is a fairly non controversial statement amongst physcologists, akin to saying women have wider hips than men.
One useful test of science if the property of falsifiability: what would it take to demonstrate this theory is incorrect?

Without that attempt to prove the theory false, I don't think it should be considered scientific.

So, for instance, expose someone to a lot of advertising and if they don't seek out the thing they are exposed to, then this theory (at least on this basic level) might be false.

Well, you might say, the claim is not that the person will definitely seek out the familiar but is more likely to do so.

Then propose an experiment to test this. Now we have started a scientific discussion.
It's hard to stay mad that long.

Back when they first starting running ads before movies, even before the 20 minutes of trailers, I was ready to rage quit. "I'm paying money to see ads?!"

The first ad was Mt. Dew and I silently vowed, "never to drink it again, you bastards!"

Now I'm down to 6 cans a day, so that's showing 'em.
Depth of Russian Politician's Cultivation of NRA Ties Revealed
Not that I agree with that, but drugs are illegal everywhere in the world and prisoners can be forced to work in many countries. In your opinion, that makes the US the least liberal and democratic country in the world?

How do you define liberal and democratic? Personally, I would include things like freedom of speech, the right to love who you will, and universal sufferage.

There are many countries that don't respect these freedoms.
> His manager, Allison Alogna, informed Wilberg and his colleagues that they were to “only accept” a certain rank of engineers (“Level 3”) if they were diverse.
thanks for that - i'll look into adding that information
That's up to them. I'm addressing the prospect of refusing medical intervention to people generally, especially to those who want it.
“We’re committing Twitter to increase the health and civility of conversation”
A Week Inside WeLive, the Utopian Apartment Complex That Disrupts City Living
The only thing you can really measure is motivation, merit and output. How much "harder/smarter" someone worked to achieve something seems incredibly vague, and in your instance it seems like you're just guessing? How does this get you "the best" in any objective way?
I found the post poorly written and wholly unscientific. Even if this is how ads work best (and I’m not disputing the correctness of the premise), there’s no science in the post proving it. It basically says “here’s this thing we know, so I say this applies in a similar manner to this unrelated subject”. I’d expect there to be an actual cited study that verified this is the case, but it’s just conjecture.

The biological example is itself weak. The lion advice is absolutely wrong and following it will likely get you killed[1]:

> The first thing to know about surviving a lion attack is to not run. It should not surprise you that a lion is way faster than you

But even if it were right, by the post’s logic the next time you saw a lion you’d stay in place and relax.

[1]: https://www.smithsonianmag.com/smart-news/how-to-survive-a-l...