skysight-inc/HackerNews huggingface dataset:
The key thing that is important is that a recursive CTE allows for the retrieval of data from graph-like table schemas.

I'd sort of forgotten about this feature of SQL! But common table expressions and window functions actually keep the expressiveness of SQL and fill in gaps that just straight subselects, derived tables and joins alone can't always achieve.

Take for instance the rolling update he highlights. Before SQL Server got windowing functions (and boy, were Microsoft ever slow in implementing those in SQL Server!) the way to do a reasonable fast query (i.e. Not use cursors) was one a guy called Jeff Moden came up with in 2012:

http://www.sqlservercentral.com/articles/T-SQL/68467/

It relied on undocumented behaviour he observed in cluster indexes - so long as he could keep the order of rows returned by the database, he figured out a very fast method of doing a running total.

Obviously it was a hack and couldn't really be used, but it shows what folks can do when their favourite vendor doesn't supply critical features needed to process data in their favourite tool quickly :-)
The smoke detectors suck, but the thermostats are amazing.
Can you share more about the application you built? Genuinely curious about what kind of projects need this level of concurrency.
Here's to waiting for the "The Burning Smartwatch Memo"!

Jokes aside, I think Nokia has great potential in the wearables category.
We’re Giving Away 3B Lumens to Bitcoin Holders
And it's made with Ur/Web, which deserves to be used a lot more.
Also, you don't need root privileges to install it on the server side. You can just install it into your home directory, and run the client with --server=/home/you/bin/mosh-server. (It uses SSH for connection setup, and then communicates over UDP on a high-numbered port, so it doesn't need any privileged code.)
It cannot be 6.4 kilograms, because the launch mass of the average geosynchronous satellite is on the order of 5000 kg, e.g., https://en.wikipedia.org/wiki/NSS-7, https://en.wikipedia.org/wiki/Intelsat_901, http://www.ilslaunch.com/node/4289 (Inmarsat 5-F2).
They at least ought not to be granted one if they apply one since this exact thing has been done before by ODrive
It made me wonder if people are using their remote Dropbox space for archival or as a backup solution. The business plans appear to offer unlimited file recovery back to any point in time.
>When The Times introduced a paywall, the number of people looking at their digital service dropped by 98.7% (from 22m to around 300,000), yet the switch was a huge financial success.

But for how long? I'm fairly certain that once those 300,000 loyal readers kick the bucket that The Times' digital subscription service will too.

How is 22 million regular readers (who will keep coming back and telling their friends about your articles, because they're free) worth less than 300,000 paying subscribers (who for some reason absolutely have to read what's in The Times no matter the price, and would probably have a hard time encouraging others to be so vehement).

Not to mention the types of journalists you will attract with a readership of a very small city, vs the readership of the population of New York State.
Given the history of acquisitions, I'd say prepare for your devices to be EOL and possibly remote-bricked within a year.
LKML discussion: https://lkml.org/lkml/2016/4/23/135
Same here.
I have avoided Slack at work so far, but since colleagues are using Google Hangouts and Skype as well I end up using those. Usually the former, as I always have a Gmail window open and often forget to open Skype.
IIRC, this was a high performance scheme developed at Indiana University that was closed source for a long time.

Good on Cisco for open sourcing it.

I'm interested to hear what regular scheme programmers feel about this news.
Friend wrote this a long time ago when he was a young C++ coder. It's hosted on another friends' Github but the author is John Brooks, the author of Ricochet.

https://github.com/rburchell/fastdup

:-)
Latest commit 5fdc936 on Dec 18, 2015

Is this still an active project? 4 months is a long time to pass without a commit published.
Yes, but I suppose this is more the JVM than the language itself. The JVM is quite convincing though, hence Clojure, Scala, etc.
Yeah, absolutely. Being white is not an advantage everywhere.

There are some places where beig white is a distinct disadvantage. Like the examples you named. Or, try being a European male in ISIS-controlled territory! That'll get you killed pretty quick, right? No "white privilege" there. In Sunni-dominated regions, in fact, Sunni privilege is a thing. I mean, obviously, right? Sunnis in those regions have a lot of rights that Shia, Jews, Christians, and atheists don't.

So the good news for you here is that the concept of "white privilege" does not involve the notion that white people have magical force fields that render them immune to problems everywhere in the world.

In places like America where whites control nearly all of the wealth as well as the political establishment? For places like this, yeah, it's probably worth taking a look at things and asking ourselves if white people literally controlling almost everything in America might have some effect on equality in America.
Scientists accidentally make batteries that last a lifetime
Correct, nothing like this has ever happened before.
I've had great success with using JuiceSSH[0] for mosh on Android. Great for those times something important comes up and I'm away from my desk. Trying to connect without mosh on mobile networks is pretty terrible.

[0] https://juicessh.com/
It's about time! Although I'm curious---how did Cisco end up owning it?
The robust solution to this problem is not hardcoding the pipe buffer size and changing the size of pipe buffers within your program to match your hard coded value, but rather calling fgetconf to query the pipe buffer size for the pipe FD you are working with.
The US government can get into your home, do you refuse to live anywhere because of that?
So then, even among all the other "privileges" there are those for looking good, and bad, smelling bad, looking like someone that someone hates, having a weird voice, bad teeth, an accent, dressing inappropriately or strangely, weird hobbies, mental problems/physical/emotional abuse, anything at all by which anyone can judge....these are infinite and subjective, and dependent on context.

Who are you to judge someone, and tell them to "remember/check their privilege" without knowing all these intimate details of struggles throughout their life, all these factors, regardless that you seemingly know just one of these infinite characteristics?
James Bond and Pussy Galore - is this rape?

http://www.mumsnet.com/Talk/am_i_being_unreasonable/1570613-...
Wow that site is eye opening. I guess I'm not an early enough adopter to experience this stuff first hand. That would be truly infuriating if you depend on any of those products...
Indeed, though it is just the logical extension of the status quo: People tend to follow news sources whose overall tone/agenda they agree with (let it be online sources or good old newspapers).
I did some quick checks to investigate how size helps with deduplication.

Size is a fast initial differentiator because scanning for file size only needs to read metadata, but how good does it differentiate?

# all files
find ~ -type f | wc -l
1098045
# files with a unique size
find ~ -type f -printf '%s\n'|sort|uniq -c|grep ' 1 '|wc -l
48437
# most prevalent sizes (prevalence vs size)
find ~ -type f -printf '%s\n'|sort |uniq -c |sort -nr|head
36972 0
12707 24
9480 22
8036 39
5025 12
4804 26
3879 6
3232 76
2946 38
2855 20

In my home dir, less than 5% of files have a unique size.
That's a fair criticism. I don't have data on common modes of transit to games, unfortunately. I can assume that it's high for big cities but there is no way for me to know for sure. If I run across that data, I'll for sure revisit this.
Kept your dignity. I like it.
Which is indeed quite racist in itself.
Apple is expected to report that March quarter sales declined 10 percent year over year to around $52 billion
> People downvote when they disagree.

And of course they do, because the implementation encourages it. Downvoting has no consequence, it allows people to express disagreement with zero effort, and they even get a chance to hide posts they don't like. If I were designing a site to be an echo chamber, reddit-style voting is the killer feature I'd want to have.
> as the Romans said in the past, Nil nove sul sole

They didn't say that.
I don't understand how recognizing my privilege as a white male in America equates to discrimination.

Can you explain in detail?
>SSH waits for the server's reply before showing you your own typing. That can make for a lousy user interface. Mosh is different: it gives an instant response to typing, deleting, and line editing.

This seems asinine. If latency is an issue I want to know it, not be fooled into thinking my input is being interpreted correctly by 'predictions'. Does this mean when I hit 'jjjjjll' in vim, I'm going to see this underlined on-screen in mosh in high-latency situations?
Elixir doesn't get much attention. I'm keeping a list of links for languages that I'd eventually like to learn, which includes Elixir:

https://github.com/melling/ComputerLanguages/blob/master/eli...
A comparison of cancer detection approaches using plaintext medical data
It's a long time coming to end-user products, and it's extremely hard to give it the right semantics for all use-cases.

I first had a good look at caching distributed filesystems (and tried to build one) in my undergraduate thesis in 1999.
What's the alternative? I'm generally curious as to what would be considered more effective.
React Show HN: Animated This.setState
that's not an argument against what i'm saying, of course you could always dream up someone less privileged than any example i give.

am i saying racism isn't a thing? no. am i saying that we shouldn't tackle issues of discrimination and features of society that encourage people to fill certain gender roles? no.

all i'm saying is that demonising white males is wrong, and i don't believe in some sort of naive quota system or any other heavy handed intervention for many reasons.

if we want to encourage women into programming that's great start at the supply side, artificially increasing demand with quotas etc or moving further away from a merit based system in any way helps no one.

i have spoken to and know many talented bright females, and there is a general dis interest in STEM usually, especially programming. and if you bother to ask they don't talk about discouragement from entering a male dominated field, or bias or discrimination or lack of opportunity they talk about a general disinterest. could we market to them better? maybe, but there are clearly steps we should take and others we should not.

as for all the other problems with society which for some reason the tech world feels it has to rectify we're going about it entirely the wrong way. we should not discriminate on race positively or negatively if we want to help disadvantaged people let's do that by targeting the disadvantaged without taking race into account. racial profiling unneeded and we don't need to stigmatise anyone.
Is there a convenient way to run mosh-server on a box behind NAT a ProxyCommand?
For generated code or builds or something?
ShadyURL
A problem I foresee is Firefox's attempts to move away from XUL.[0] Firefox might just about manage that move, but who will do that work for Thunderbird? And once Firefox moves away from XUL, who will maintain XUL for Thunderbird's sake?

[0] Firefox is still XUL-based for now, but I think the writing's on the wall given the security issues with XUL and XPCOM, and Firefox's move away from XUL/XPCOM-based extensions.
n.

A special advantage, immunity, permission, right, or benefit granted to or enjoyed by an individual, class, or caste. See Synonyms at right.

n.

Such an advantage, immunity, or right held as a prerogative of status or rank, and exercised to the exclusion or detriment of others
Dealing with it can include working toward change. Screaming 'White Privilege' is just complaining without action.
>And yet did those organizations, which people rightly consider to be bad, actually do anything worse than the CIA has been doing in the last 70 years?

The average American is not personally affected by anything the CIA does. Can the same be said about the KGB?
It isn't an arbitrary wavelength. It's an entire absorption spectrum.

If the wavelength were the determining factor, green would be gender-neutral, and purple would be androgynous.

Not that this particular societal prejudice could ever be explained rationally, of course.~
Right, they're worth THREE billion.
No. Replacing that with a magic number wouldn't be good. Maybe it could be a constant instead, but this is most likely good practice.
5 prototyping techniques to improve the way you present your designs
> On a bad connection, outstanding predictions are underlined so you won't be misled.

Having used it, I found it worked very well and i never had a problem with predictions
Show HN: React – Animated shuffling of child components on change
Apply HN: Uggozi- Let your travel photos and blogs inspire more people to travel
Android app: https://play.google.com/store/apps/details?id=com.uggozi

The goal is to create a community where travellers and explorers can inspire dreamers to travel. There are so many great blogs written by travellers but most of them get buried in Google/Bing/<Your favorite search engine here> search. Likewise there are so many great travel photos taken by travellers but apart from just commenting and sharing there is not much that can be done with these photos on existing social networks.

Meet Uggozi- where anybody can:

- Submit a photo of a place along with max two links to blogs or articles on the internet that describe the place.

- Set any gorgeous photo of a place as wallpaper. Every wallpaper bears the name of the photographer and the place. We believe this will inspire people the moment they open their phones.

- Inspire friends and family by sending them an interactive picture postcard.

- Read any link and if you like the content of the article or the blog then show your appreciation by 'loving' it.

- See the top loved links to blogs and articles of a place in that place's feed.

Features that distinguishes us from the rest:

- We moderate the photos and the links submitted so that their subject is the place. It should somehow describe the place - it's culture, people or natural beauty. But we do not judge the quality of the photo or the content of the link subjectively as we believe in - "beauty lies in the eye of beholder"!

- To deliver the best experience, the app shows only the photos which will look good on your phone. So no more blurry photos!

- To make exploring fun we have a notion of 'Uggozi Explorer' which is bestowed on the person who posts the first popular photograph of a geographic location.

We believe that Uggozi can be a great place for travellers to promote their blogs and photos by reaching out to more people.

If you have any questions or feedback, we'd love to hear from you!
The old Opera browser was the best local client because you could open RSS links in the same app, as a new tab, in a real browser. There is no comparable local RSS reader that comes close. I've since switched to Inoreader.
Nokia certainly has a history as a design-oriented consumer brand. They were making elegant metallic phones already in 1998:

https://www.google.com/search?q=nokia+8810
Here come the bevy of calls for basic income..
I just want to say thanks for introducing me to ponysay. My terminal was dull until you all shared its magic with me.
I can't edit it now, but, instead of saying "Agile (sic) doesn't work well for service teams" I should've said "Choose your own flavor of Agile Methodology to suit your needs".
Only if your recent keystrokes have been getting echoed, and if you haven't done something that might disrupt echo.

> Predictions are done in epochs: when the user does something that might alter the echo behavior — like hit ESC or carriage return or an up- or down-arrow — Mosh goes back into making background predictions until a prediction from the new batch can be confirmed as correct.
Same article on a website that is not awful

http://www.tomdispatch.com/post/176132/tomgram%3A_rebecca_go...
Bottom line is: Singapore is not for everyone. If you're willing to give up some civil liberties for an efficiently-run nation where you can generally walk around without fear of getting stabbed or robbed, then it's the perfect place for you.
This is good news. The code is worth reading. It is as good as MIT Scheme, and less esoteric than Gambit.)
>> "I'd say prepare for your devices to be EOL and possibly remote-bricked within a year "

No way they would get away with that, especially as they're both European companies and consumer protections laws tend to be a lot better here than in the US (where if I remember correctly Nest pulled something like that recently).
>The fact that each company would have to redundantly set up their own.

I don't see the redundancy. Just because you have locks on your doors doesn't make my door locks redundant.

>The fact that the concept of private jurisdiction is currently incompatible with US Values.

That is true (depending on what you mean by "US Values"), but it tells us nothing of the efficiency of a theoretical system vs our current system.

>And finally, the fact that its a classic "Tragedy of the Commons" situation. Of course, you don't believe in that so what can I say? If one company's police force is effective, no other company will fund the police force.

While it would be hard to say exactly how a private police force would work because we can only work in hypotheticals and try to guess how the market might organize its efforts, I think it safe to say it would not work the way you're describing above. If you refuse to pay for police protection then you don't get it, just like any other private service. There is no commons. Some theorize that police protection (as well as fire, and possibly other services) would be included, or at least required, as part of insurance coverage.

>Now assuming each company's private police force gets their own jurisdiction, then all you gotta do to commit a theft is to leave the jurisdiction of police forces. Just like what criminals did before the FBI was invented in the 1920s. Committed a crime in New York? Move to Florida, then commit another crime.

Bounty hunters, for example, work across many jurisdictions. We also have cases in our current system of police where different jurisdictions work together, even across country boundaries. I don't see why the same thing couldn't happen with a private police force. Indeed, we see private businesses cooperating as a norm of their existence.

According to your objection, it sounds as if you find our current system of many jurisdictions at the planet level unsatisfactory. Do you favor a world-wide, singular government?

I suppose it's possible a thief could take a rocket ship to Mars, and ultimately it would be up to the individual doing the cost-benefit analysis on whether its worth it to pursue. In such a scenario are you in favor of a solar system-wide or intergalactic government?
Making fast scheme interpreters is something I always come back to, a timeless exercise that makes for a great way to decompress over a week (wow I'm a nerd). I'm excited to find some nuggets of micro-optimized gold!
10 strategies for bringing agricultural expertise to robotics startups
LMAO....you literally just said prior to this comment:

"We are not trying to ensure there is an "arbitrary number" of certain types of people working in our field."

You are a walking Poster Child for hypocrisy.
In a "24" like scenario, if you knew that torturing 100 people, all of whom you believe to be terrorists, was 50% likely to yield useful information would you do it?

For me personally, the effectiveness of torture is irrelevant. Maybe it is for you as well, I don't know from your comment. It's something we should not do, full stop.
Vast majority of developers would benefit from at least passing knowledge of algorithms and data structures.

For past few years I work (not full-time) on what is essentially a prototype of trivial line of business application: stock-keeping system. It is 3 layer and blahblah, with me implementing most of the server side. Amount of various hacks in the server to accommodate requirements of the "It is impossible to linearize a tree in C# without having local SQL database" kind is truly ridiculous (most of these involve few lines of generator-and-list-comprehensions-heavy python code on server).

Somehow there is whole large class of so called "developers", that can only directly transform input to output and anything that requires building some kind of data structure is impossible/unfeasible/whatever for them.
"Hello, world" on Android: https://github.com/apple/swift/blob/master/docs/Android.md
It's weird, I remember reading a very informative article about SAT from American Scientist when I was an undergrad:

http://sjcomp.com/files/compsci9703.html

I will have to reread it to see if it still makes sense.
I normally enjoyed the insight and comments of the thread more than the content of the article and don't comment that much.

But my personal opinion on this, only to share it and be heard possibly by the developers of homebrew, is that I honestly do not care about this. It's nice they are open about it, it's a hell of a tool and hey, if they want to track what I do to improve it, have my data.

I really don't see the opt-in/opt-out debate being so harsh on this. Because it's open source it should be opt-in? I really don't think so. Analytics are a valuable source of information for the developer and google provides a hell of a service for that. And you probably use several closed source tools that track you, sometimes without even telling you. Yes, you can really of external tools to block this, great for all of us those tools exists, you can use it for homebrew as well.

I wonder if all of the opt-in advocates don't use gmail for their email. I am pretty sure they do, and they are not worried about all of the tracking going on there? Or on other apps? Unless you really follow most if not all of stallman's computing principles[1], being furious about this, is, IMHO, disproportionate and a bit ungrateful.

So I am more than OK with opt-out. Nice that you wrote about it, nice that you provide a way to do it, and nice that you use your time to create such a great tool!

Kudos!

[1]: https://stallman.org/stallman-computing.html
You've more or less invented Hola Unblocker with a few limits
Did you forget about the violent responses to the peaceful Occupy Wall Street protests? Tightly controlled "Free Speech Zones"? That is what we have in the USA, coupled with propaganda ridden corporate news. I don't think that we are in a position to criticize other countries too much since we have our own problems.

I just got back from a business trip to Singapore, and considering how that area was devastated by the occupation during WW2, it is amazing how fast they have built a very good place to live.
What Uber did to cabbies, Driverless truck fleets will do to truck drivers
+ AI is coming and it's going to automate millions of jobs (lawyers, call center, ...)
1. Take a word that encapsulates the project in some way.

2. Translate it into other languages and find a cooler one. [1]

optional: Use wikitionary to verify the translation and possibly change the tense.

[1] http://translatr.varunmalhotra.xyz/