skysight-inc/HackerNews huggingface dataset:
> And yet someone proficient in SQL will not necessarily be able to read a traditionally-written lambda calculus expression as the languages differ significantly (and not just because of tables), so I think this proves my point that there are different, and hopefully better, ways to express the interaction with the database. There is no reason why the protocol has to be exactly as SQL is. There are theoretically an infinite number of ways to communicate the same intent to a RDBMS.

First, lambda calculus isn't a language -- at least, not in the typical sense. It's a mathematical logic construct. It's more akin to geometry than to a programming language. Same applies to relational algebra.

And of course lambda calculus and relational algebra differ significantly... Their domains are completely disjoint. I was not comparing them in this way. I'll restate my premise:

If we consider SQL a mapping of relational algebra operators to SQL operators [0], then any other language which also maps to relational algebra will not be significantly different. Thus, complaining about SQL being a singularity is kinda like complaining that relational algebra, lambda calculus, or any other mathematical constructs are singularities.

> For instance, SQL does not do composability well. There is no fundamental reason why you should not be able to write query fragments, simplifying the way many queries are constructed and avoiding the huge mess that monolithic, hard to debug, queries often become. It is simply that SQL does not allow for it. A better API could improve on this significantly, without losing any features a relational database provides.

You can compose SQL with views. Non-materialized views act as pure SQL composition. Materialized views allow precalculation of subexpressions.

Most of the big databases also support common table expressions, which allow for decomposition within a single query.

https://en.wikipedia.org/wiki/Hierarchical_and_recursive_que...

> You don't have to throw all database theory out the window just to change the API away from one that was designed 40 years ago.

Of course not. The problem is that any new SQL would just be a new mapping for the same underlying relational algebra. "Welcome to the new SQL, same as the old SQL."

[0] It's not, because tables aren't relations. However, the operators are similar enough that parallels are easily drawn.
Sounds like the perfect unicorn startup (ie able to raise) would be deep-learning sales/marketing/engagement copy-writing and follow-up with some human supervision? Reducing CAC and sales staff.
This is the New York Times we are talking about, a company that got blindsided by the internet and social media. NYT is firing editors and renting out office space to stay solvent, it makes sense they would write this article

https://www.bloomberg.com/news/articles/2016-12-16/new-york-...
https://www.washingtonpost.com/news/morning-mix/wp/2017/06/3...
NPR's Planet Money had a great recent episode summarizing the whole situation. It includes an interview with one of the people whose complaint led to the EU's initial investigation: http://www.npr.org/sections/money/2017/08/04/541643346/episo...
Ah, right. And if ultrasound is actually much like regular sound, it may sound perfectly normal.
Saucs
Yeah, editing
In addition to the many nice examples others have mentioned, I would like to point to one book of which I am currently in the middle: Becky Chambers's "The long way to a small, angry planet". This book is delightfully conflict-free so far, and it's hard to think it's not intentional; indeed, one of the (non-human) characters even lampshades it during a gaming session by referencing the way that human games seem always to be built around conflict and competition.
The City of Houston, which votes Democrat, has actually done a reasonable job of upgrading its infrastructure over the years. For example all roads built/upgraded since the 90s are designed to act as drainage systems.

The problem is that Houston is a big city and its population has been rising very quickly, and the city government's efforts have been insufficient. And since the Texas state government is dominated by gotta-keep-government-small-and-taxes-low Republicans, Houston has received almost no assistance from the state in this regard. We are seeing the results of that today.
Because we all know Black is a terrible color to paint a bike shed.
You should use React.PureComponent whenever possible. And stateless functions always re-render. There's no chance of using "shouldComponentUpdate".

Using store state vs local state shouldn't matter much, as long as your components are pure and only pull what they need from the store.
Though his intent was to create employment reforms. "Iaimed for the public's heart, and ... hit it in the stomach".

http://articles.chicagotribune.com/2006-05-21/features/06052...
Why Men Don't Believe the Data in the Gender Gap in Science
There can be dozens of completely different reasons why that might be the case, without requiring inaudible frequencies to be involved.
I believe Intel stopped releasing the documentation required to make them around that timeframe.
Seeing as how Linux and Bash are 19 & 24 for the higher income nations and not included within the rest of the world list, would you also group sysadmin roles as a wealthier country function?

I have a limited understanding of the two in real-world application.
Oh please, nobody is going to hunt you down based on what approximate stage of life you are at.
>intonation and emphasis just right.

Yes. The emphasis carries a lot of information in addition to the simple text. I find it hard to do when reading aloud from a book I haven't myself read before. In fact I think it's one reason I tend to pick my personal childhood favourites to read.

Perhaps this is lazy. I wonder if other parents do the same?
Do they do that because they don't actually want to fill the job?
Only on HN would targeting 100 million devices for a preview be seen as small fry.
> Your display is likely only 720p, or 1080p, but a 4K video on youtube will still look a lot better, although technically it should have no visible difference.

Not at all, bitrate differences are audible.

> And just like you need 4K 4:2:0 mp4 video to get even close to the quality of uncompressed 1080p 4:4:4 video, you also need far higher sampling rate and depth of highly compressed audio to get a quality similar to 16bit/44.1kHz PCM.

…how so?
This is not yet something to fear at all. If Amazon is even available in your part of Europe it tends to not be that great. There are plenty of online stores in Europe though.
All good points! Indeed all that extra data makes the decode stage that much more difficult. Same happens with audio too, but high-res audio isn't nearly as bulky as video or nearly as resource-intensive to decode
Interesting article and I agree with most of it except

1 - Most employees are not as skilled as pro athletes.

2 - If you want to carry the athlete analogy further, then you would only give contracts to the employees who made you happy with the tryouts or "combine" etc. Note that this is essentially (I think, could be wrong) happening with the several-interview approach that's already going on, combined with a signing bonus with a minimum term to keep the bonus clause.

So the employer usually doesn't get the bonus back if they fire the employee (except for rare "cause" situations) and the employee doesn't get to keep the bonus if they quit early. It's not that dissimilar to the details I know of athletes (which isn't much).
I found yesql inadaquete for use with anything other than simple queries. Writing plain SQL is definitely nicer than an ORM, however, I find that manipulating SQL as data (honeysql) is far superior to .sql files with added magic (yesql).

As soon as I had to dynamically build queries (essential when moving beyond the complexity of "select this user record") I ran into issues with yesql's lack of power.

It also fits closer to one of the main principles of clojure, to be data-driven/data-first/just-use-data etc etc
It can be seen from the video (from the way they avoid it) that the "augmentation" is always superimposed on the "reality". I.e. someone can't walk in front of the virtual objects you put on the table.

Is that a limitation of ARKit too?

What would it take to make it "real 3D"?
Why Clean Eating Can't Save Your Soul
Wells Fargo hit with new class-action lawsuit over mortgage lock-in fees
Realist.

I encourage you to read the book The Waxman Report, to better understand how policy and legislation are forged. It's a lightweight, layperson intro. TLDR: It takes decades to research, build support, reach consensus. And then big changes apparently happen all at once.

People I know have been working on paid parental leave and domestic care legislation for EIGHTEEN YEARS. Last month, they were happy to report that their legislation was passed and signed.

Prior examples are marijuana legalization, marriage equality, background checks for gun purchases, education and healthcare for immigrant children. Etc.

--

What is privacy? What does it look like?

No one knows. There is no agreement. There is not even consensus on the questions, much less the answers. So imagining a technological solution (implementation) isn't even remotely possible.

This privacy policy stuff is wicked complicated. I've been working on voter privacy and protecting healthcare records since 2004. I'm still learning new things, causing me to revisit my positions.

And only now, some 12 years later, I've finally figured out what to ask for, a proposal on how to fix this mess.
> I always liked Brian Moriarty's definition of story: "a particular causally related sequence of events".

By this logic, it seems that a recipe is a story. (Maybe that's intentional!)

I'd almost view the definition of a story as more about the intention than about the content—rather like art, which can (arguably) be created simply by the act of presenting it as such (in the sense of "found art" (https://en.wikipedia.org/wiki/Found_object )). So too, surely, can one have a "found story".
Yup yup! ^
The German basic law (article 14) defines:

> (2) Eigentum verpflichtet. Sein Gebrauch soll zugleich dem Wohle der Allgemeinheit dienen.

> (2) Property entails obligations. Its use shall also serve the public good.

In Article 9, it also defines:

> (2) Vereinigungen, deren Zwecke oder deren Tätigkeit den Strafgesetzen zuwiderlaufen oder die sich gegen die verfassungsmäßige Ordnung oder gegen den Gedanken der Völkerverständigung richten, sind verboten.

> (2) Associations whose aims or activities contravene the criminal laws, or that are directed against the constitutional order or the concept of international understanding, shall be prohibited.

If you have the commented version, with comments from the creators and several former and current constitutional court judges, I recommend you read the relevant comments. They specifically discusses these part, and argue that the right to own property, start a group (Vereinigung, including Verein, Unternehmen, etc), own something as a group, etc solely exist to serve society.

This right has obligations, such as the obligation that if you do not need your property, but it can be used to serve society, you can lose the right to it (as has happened in Hamburg in Winter 2015/2016, when a company refused to rent a building to the government so they could use it as refugee accomodation, and, as a result, the building was seized from the company, and used as it anyway).

The comments and quoted constitutional court cases also discuss and outline the limitations, and other situations. For example, if property is seized, then the organization has to be given the market value in return.

I am not a lawyer, this is not legal advice.
Show HN: The Most Epic Thing You Will Ever Watch
You would think that, but if the advent of drones is anything to go by, it's going to simply make things worse.

When you have to put your own humans in a combat situation, you think twice before sending your men to their potential doom. With robots and unmanned vehicles, you can just keep throwing them at the problem, cost is the only concern.
Apple has no problem with bundling Safari with the OS because:

* Apple isn't close to being dominant as a platform.
* Allows the default browser to be changed.
* Hasn't demonstrated any evidence that they want to stop a competing browser.
* Hasn't actively took measures to coerce users to Safari.

Microsoft violated all of these.
Where in the article does it say he owned the car at the time of the disagreement over the GPS tracker?
Silicon Valley siphons our data like oil. The deepest drilling has just begun
Ever heard of drones? "murky water" is quite an understatement.
T. gondii also being the parasite that can cause toxoplasmosis in rare cases where the infected individual suffers an immune system issue (like HIV). This is the condition treated by Daraprim, aka the drug bought by Martin Shkreli's old company ('pharma bro').

I asked him once about the alleged behavioral changes associated with T. gondii and he said the research on that is bunk. Shrug...
It's not permanently affixed. It's removable.
Having lived in Houston, this isn't a measure of the flood but a measure of how terrible the infrastructure is. They have terrible flood management systems but are "rated" to handle everything but a "100" year flood... yet Houston gets 100 year floods every year- multiple ones- and has for 40 years.

It's a scam involving the ratings much like the mooody's ratings scam of the last decade IMNSHO
The article was arguing about 24bit/192kHz digital audio, not about what codecs do or don't do with it. If you need 24bit/192kHz with both inaudible frequencies and inaudible dynamic steps to make 16bit/48kHz music sound better at the same bitrate, then the parameters you've given to your codec suck.

Same for video. YouTube very likely allocates more bandwidth for 4k video than would be required for equivalent quality at lower resolutions, assuming that you are interested in higher overall quality (e.g. less artifacts) if you go through the trouble of 4k video. That's a conscious choice, not a technical necessity.
Google isn't prevented from having a product search, just from inserting those results before the regular web results.

Similarly, Google wouldn't have to remove images or videos, just not embed them directly on top of the web search results. Seems OK to me, and hardly pushing "European web search 15 years into the past."
I am reading the original Dragon Lance saga to my two daughters. Very enjoyable, but I'm not satisfied by my voicing of Raistlin.
Your sarcasm is not appreciated nor warranted. If you disagree with any of the specific cases I talked about, feel free to tell me why I'm wrong, but merely being sarcastic about it isn't helpful.
I think on the aggregate, parents bear a lot of responsibility for my generation being this way, but there are other factors at play as well, the following two being the most significant in my opinion:

- People (somewhat accurately) seeing elite college as the most surefire way to ensure membership in the high end of the earnings spectrum, and therefore organizing their kids' preteen/teenage lives around getting into college, molding kids' psyches into a process-driven, check-the-box orientation (i.e., do the following list of things to a specified standard and you will get into a great school and then everything will be OK)

- The role of social media / constantly sharing details of one's life with one's entire network, which, as the Wait but Why comic posted in this thread eloquently describes, is generally more unhealthy than healthy
He goes by the name Special Sauce. That's all I know.
If you'd like to see it in action, I made a CodePen to demonstrate antirez's pixel dissolve over a Castle Wolfenstein 3D scene: https://codepen.io/jones1618/pen/YxRVpo
Congratulations on your launch, however I wouldn't build any kind of business on Wordpress - the platform itself is just too crap to get any kind of enjoyable work out of it, not to mention the extreme competition from third-world countries keeping the prices down.
Diversity in Tech: Why It Hasn’t Happened and How to Change That
But Amazon is essentially a market place. Google is a search site.
Working with Google forms Offline
Wow, that was awesome!
People will disagree with you that this in any way games the free market. It's just not a useful argument to have, since it mostly revolves around definitions.
You chide others for buying into some western myths about north korea, then buy straight back into them yourself.

As a simple example, Wikipedia has a list of 122 merchant ships registered in North Korea[1]. Do you really think that these ships are crewed by counterfeiters, bomb-makers, and those with 'high criminal skills'?

[1]https://en.wikipedia.org/wiki/List_of_North_Korean_merchant_...
Sure, they are outdated. But if you sat a user down in front of a current Mac Mini and one using one of Intel's equivalent wattage and price point parts which shipped in volume in the past six months, would a user notice the difference? Short of benchmarking I doubt they would. The new parts just aren't compelling.
Note: Apple does not allow the default browser to be changed on iOS.
Which is why we have the Second Amendment in the US and it is our right as citizens to have our own death robots.

/seriousness
People don't usually inject it inside the blood/brain barrier...
Picking the Right Color for the Job with Gpick
> It can be seen from the video (from the way they avoid it) that the "augmentation" is always superimposed on the "reality".

I think you mean “inferred” rather than “seen”, if it is an assumption based on avoidance, and there are other explanations; while HoloLens is better equipped than phone-holder software AR to avoid this, the one time I did get to use one there were some glitches when the “augmentation” should be obscured y the “reality”. If ARCore handles that, in principle, but is currently annoyingly glitchy in practice on its current preview-quality state, you might reasonably avoid it in demos.
Scale, speed, and costs all matter.

The Jevons paradox notes that an increased efficiency of some process or system increases the total utilisation. In particular, it makes previously nonviable applications viable.

Postal junk mail, telemarketing calls, email spam, popover/popunder ads, malware, robocalls, fake news, chatbots, and more, are all responses of previously nonviable applications becoming viable.

The underlying limitation seems to be the scope of attention of attackers based on private / personal data, and/or of the systems in which they operate. The role of AI in extending that institutional bandwidth ... strikes me as rather frightening.

There've been previous discussion of similar topics which point to the prospect of, say, automated lawsuit filing, or debt collections (already a problem), or more. The prospect of some trained algo running over deep, rich data, seeking arbitrage opportunities, strikes me as undesireable.
My own Hitachi Travelstar 5K160 is now at
Power_On_Hours=81569 (9.3 years)
Load_Cycle_Count=16793410
It doesn't work very hard though.
That's not such a great reference...
Those will fail on first amendment grounds. I've been saying for years that you won't have privacy without a constitutional amendment/rewrite, but that's looking more and more likely every day.
Disabler that only responds to crypto-signed request encrypted with hardcoded per-device keys. Have fun.

"It can be hacked" really only because good security practice like the above would involve extra costs and the dealership / hardware manufacturer have little incentive to do so. But as a maxim, it doesn't really work: good security is possible.
The conclusion summarized the findings as a topical analysis, more to find the "fun facts" as they look to dive deeper into the data internally.

But I definitely believe there are too many factors within the data for a full understanding. Most likely a case of Correlation != Causation
Sorry then, my understanding was incorrect.

I'm not sure where to look for the precise definition of "fiduciary".

https://en.wikipedia.org/wiki/Fiduciary fiduciary: A fiduciary is a person who holds a legal or ethical relationship of trust with one or more other parties (person or group of persons).

http://dictionary.law.com/Default.aspx?selected=744 fiduciary: 1) n. from the Latin fiducia, meaning "trust," a person (or a business like a bank or stock brokerage) who has the power and obligation to act for another (often called the beneficiary) under circumstances which require total trust, good faith and honesty. 2) adj. defining a situation or relationship in which a person is acting as a fiduciary for another.

http://dictionary.law.com/Default.aspx?selected=745 fiduciary relationship: n. where one person places complete confidence in another in regard to a particular transaction or one's general affairs or business.

http://dictionary.law.com/Default.aspx?selected=599 duty of care: n. a requirement that a person act toward others and the public with the watchfulness, attention, caution and prudence that a reasonable person in the circumstances would use.
Codeflow, Visual coding for the modern cloud
Love the dig at Rothfuss in the end notes! Release the damned book, Patrick!
More specifically, Google Search is a search site. I'm sure the EU has no problem with Google Shopping, as long as it remains a separate product.
Not the same wifi, but since web.whatsapp is pulling the data from your phone, they recommend that your phone be connected to wifi.
This is actually an ongoing process, too.

The opinion of the EU is that Google should be forced to either allow the user to choose the provider of these widgets (maps, weather, etc), or to require Google to rank these widgets at the same position that they would show up in regular search.

For example, in a search for a product, Google returns first a Shopping widget, then the Amazon result (and in it, an amazon widget), then several competitors, and only then Google Shopping.

Google should rank the widgets of each provider the same way as search results, without any bias.
You don't. Your phone needs to be on the internet tho. Personally I like this setup, it's simple and just works. And no issue about missing some messages or duplicate notifications (which is sometimes the case with multi endpoint apps).
Is refactoring in Xcode using Swift still a horrible joke? It just seems odd that you would say Android Studio is not that much better than Xcode considering the horrible inadequacies of Xcode when it comes to Swift. Meanwhile, pretty much anything you can do with Android Studio, with respect to Java, you can also do in Kotlin.
Front-end JS for the oil-and-gas industry. Custom, industry-specific customer-facing web applications. Interesting work, but the business logic required by some companies is freakin' terrifying :)
No it doesn't. It could easily result in less social utility by promoting self-segregation and the concentration of funding into high achievement schools where the marginal utility of each additional dollar is substantially diminished at the outset.

The reason why kids from poor families do poorly in school is also the reason why those families are _least_ likely to be selective in their choice of schools. These are not independent phenomena.

So unless the only utility function that matters is freedom to choose your school, approaches like vouchers are unlikely to improve things and could easily not only perpetuate but exacerbate achievement gaps and derivative social issues, like crime.
I just post the summary from http://techmeme.com/river verbatim as a sort of TL;DR.