skysight-inc/HackerNews huggingface dataset:
At least in my experience, things being slow is almost always due to a table scan rather than using an index.

Just the estimates (ie not actually running the query) should give clues as to which table it scans, and the predicates gives hints as to which index would have helped.

Not always easy fix though, sometimes what you're asking for just isn't possible to index in a nice way. Just the other day me and a colleague was trying to optimize a query, and we couldn't get it to use the index simply because the selectivity was too low. The most selective part of the where clause was a non-trivial and highly dynamic "exists" sub-query... We ended up using a few materialized views with manual refresh but still the query took 2-3 seconds (down from 10-15).
I'm not saying unions won't work...I'm saying they weren't involved in this case. This case doesn't look particularly repeatable WITHOUT unions.
If two companies of comparable size want to agree to arbitrate any disputes in a contact, that should be allowed. It saves massive amounts of time and money.

The problem is the disparity between the parties involved when it's a company and an individual.

Forced arbitration also bans class action lawsuits, which weakens individuals even further.
> "happens to be owned by Google" disclaimers on open source projects

Not sure I've seen this before, do you have examples?
good for you. i respect your conviction, and think you are doing a principled thing.
https://news.ycombinator.com/item?id=6349349 - Theranos discussion from 2013. Fun read.
Doesn't California law protect people from employers stealing code you write on your own time?

I recently turned down an offer in CA despite thinking I read something along those lines taking it as a sign of toxic culture. Another place had such a policy but gladly agreed to drop it.
That's how you wind up with zero sympathy from a potential jury.
We ALL need to be against 24/7/365 “on call”. I did it for 10 years. It not only sucks, but I’m confident hurt my overall productivity. If it’s not important enough to hire a backup or two, it’s simply not important.
Non facetious question, did they make their money doing what they're suggesting (passive investing), or do they have the knowledge that for most people passive is the best answer?

I guess I answered myself (the second)
> the right to surveillance on personal property

Wait, what? I don't think I've seen that before, what does this mean exactly?
It is addictive like any other sort of gambling/speculation.
From what I understand, Amazon actually has trouble recruiting and retaining enough warehouse workers (especially during peak seasons). This is evident by them having a starting wage ($15/hr) that is more than double the minimum wage in many parts of the country
What about latency?
I don't think a few seconds (or even minutes) are acceptable for Instant Messaging...

https://askleo.com/long-email-delivery-take/
I thought that SCOTUS already ruled that the federal arbitration act gives states little power in this?
Expanding Use of Silicon in Batteries, by Preventing Electrodes from Expanding
Out of curiosity, what is the minimum age you'd expect someone to be able to learn to design a simple CPU?
Discrimination would be saying “I’m making you work this weekend because it’s a religious holiday for you”. Saying “I don’t care about your religion and personal circumstances, I demand you work or ill fire you” isn’t discriminating, it’s just shitty.
Whatever your thoughts about arbitration there is no denying that it's the quicker and cheaper method, what this unfortunate development accomplishes is enlarging the pool of well to do clients and plaintiffs for the lawyers to exploit.

In a related note: organized labor almost killed the US car industry, when economical foreign cars got popular, domestic car companies couldn't quickly make the necessary adjustments to compete with the foreign product largely because of the inertia of union agreements.

Labor unions are adversarial to change and innovation and especially in this era there is no place for them and hopefully automation will eradicate them completely, it's disheartening that many HN commenters would support such antiquated and inefficient agreements.
That's a great start. Now if only everyone else would do the same.
We'll make money through affiliate marketing and premium features. We're strictly a technology company and don't touch or handle any money.
Haha so true. I found coding my own, albeit stupid, trading strategies quite fun back in the day...sortta similar kind of fun building a borked poker bot.

Think it's the combination of money, a bit of math and some cool algos that make it so fun
Companies shouldn't be allowed to have you sign away your constitutional rights like this.
More like trading options
> Are you buying a house that's $1 million dollars? Are you paying $80,000 in taxes? Are you paying $2400 a month for daycare bills? Are you paying thousands for health care insurance? Are you paying $250 for car registration? Or another $1000+ for car insurance or transportation?

That's not the right logic here. Are you saying that if they do those things in the Phillipines, then they should get a similar salary? I don't think it would be very difficult to get someone to raise the price of a house they're selling to $1 million dollars. One can then say they're buying that house and to give them a salary that allows them to do that. That would be extremely silly.

What you pay someone should only depend on what you get in return, and not on what their expenses of living are. Those are totally irrelevant. You can use an estimate on their expenses of living to know how low you can offer to pay them and still keep them happy, but it's not a justification, only an indicator of a low price they would be happy with.

On your second paragraph, that might be true, but GP's comment is made on the assumption of being equally experienced, equally as good. What justifies being paid much less, then? The real justification is that they can't be equal because, at the same price, it's always going to be more beneficial for a company in country A to hire an employee in country A over one in country B. This because it's inconvenient to have to deal with stuff like different timezones, language barriers, cultural barriers, taxes and other legal stuff, difficulty in physically meeting, etc. These things define the upper bound that a company is willing to pay before preferring to instead hire local for someone of the same skill.

As to the real price that these employment contracts should go for, it should be somewhere between this upper bound and the lower bound of the salary that a employee candidate can be reasonably sure to be able to obtain from their local job market. If the real price is too close to this lower bound, it may be because as a group they're not valuing themselves enough to push for higher salaries, or maybe they're being offered something else that they value that the local job market doesn't offer like remote work.
Oh? You may be entirely right, if that's the case, this fact completely eluded me and I'll take the correction.
People who fail to read and educate themselves will listen to snake oils salesman pitches and trade stocks like a junkie on heroin. I spent years learning industries, learning how to read quarterly report, to identify signs of fraud, and pay attention to the news every single day.

Like anything you do you have to be committed and determined to be successful. It's not a dark secret that there are no short cuts in life. This article assumes we are all much dumber than I prefer to believe we are. We being people who have money to trade stocks and suffer from big losses.

I learned how to trade stocks by reading books about value investing and accounting practices. Very simple stuff that like anything worth learning takes a bit of time and effort. I don't get the upvotes on this article.
Hey, wanted to say that I really appreciate the feedback and we're releasing this program exactly to address it. This is Ilya, one of the co-founders of Segment.

Re: how the program works on the backend — For new startups (<2 years, <$5M raised), the Startup Program provides $25k of annual credit (and $50k credit if you're applying thru an accelerator) on the team plan which makes "Segment Free" for 99% of the thousands of startups that use Segment. You can apply for it for multiple years, and after you graduate, we'll provide graduated discounts off our standard plans (50% in year 1). This is designed to be affordable for the entire time that a startup is getting off the ground.

Re: value over time — we see companies of 2+ years of age use an average of 7 source types (web, mobile, crm, stripe, ..) and 8 destination types (google analytics, event analytics tool, data warehouse, email marketing tool, A/B testing tool, ..) accounting for 56 point to point integrations. Each source <> destination connection takes an average of 24 hours to do initial API integration and more beyond to maintain, so hours can add up. (https://segment.com/academy/choosing-stack/how-stacks-evolve...)

We're also buffering data behind the scenes with Centrifuge when partner APIs have a downtime event to get your data deliverability as high as possible :) (https://segment.com/blog/introducing-centrifuge/)

Either way — this feedback is super helpful, and if you'd like to chat more I'm ilya@ segment.com. Thanks!
I loved 'Stoner', but wished I could also have read the story from the perspective of Stoner's wife (Edith). We see her as she appeared to Stoner, and it would be easy to write her off with adjectives like uptight, frigid, damaged, belligerent; but from the outside it would probably have been easy to write Stoner off as an inattentive, unfaithful husband pouring his life into profoundly unimportant work and going through an undignified mid-life crisis -- or something similarly reductionist and dehumanising. I bet Edith's inner life was at least as vivid as his, and whether or not her behaviour could be rationalised, her pain was certainly just as real as his. That's part of the genius of the book, though -- Williams shows us enough, and paints even the somewhat neglected characters richly enough, to stimulate these thoughts.

Anyway, this is an interesting interview, but (fortunately for everyone concerned) it gives the impression that Stoner and Edith were not modeled as closely on John and Nancy Williams as I might have guessed. So the title is a bit misleading.
I remember buying a childrens-print magazine, as a kid in the 80s, that had a bit more expensive special issue, but each sold copy was supposedly used to buy a couple of m² of the rainforest.

They marketed it in an "own a piece of the rainforest" way and kid me was super stoked about the idea of owning a piece of rainforest, imagining how I would be living there.

I think it might have been Yps [0], but I'm not 100% certain.

[0] https://en.wikipedia.org/wiki/Yps_(comics)
Yes, it is.

You're correct that any employee who decided to not answer their phone for a period might attract the same displeasure, but we have laws in the US that protect people who are observing religious holidays and he was, in fact, observing one. I guess Yelp could argue that his observation was unreasonably extreme, but that seems unlikely to pass muster.
Nike (NKE) Stock Drops After Duke Basketball Star's Shoe Splits
Are there certain fields where people are implicitly required to be "on call"? As a software dev (in an oncall rotation) even when I'm not on call I still am expected to check in on things and be available during non-business hours.

Same with the IT folk in my company.

However, does the CFO have this same requirement? Couldn't there be some financial-related mishap in the middle of the night? HR? What if an employee, say, assaults some other employee off-site in the middle of the night? Sales guys? ie, one of their customers is irate off-hours. The president?

I've never bothered to ask.
Trump Administration to End Program Providing Work Permits to H4 Spouse Visa
Hamilton's argument was that the treaty was with the old French government, not the new revolutionary government.
That's fascinating. I had no idea about the 'classes' thing.

I wonder if there's an alternate track for someone already established in another field. Could an established software developer somehow transition to getting a "big bucks" management position? Or does it all flow through that class system, and if you didn't enter at the bottom, you're not able to get to the top?
I'm pretty sure most parents could learn basic soldering in an hour or two.
ASK HN: My Friend Wrote His First IT Article, Thoughts
Not having forced arbitration doesn't mean you can't agree to arbitration voluntarily.
the current choking of the courts (with most proceedings and exact reasonings out of view of the public) has zero effect on the bigotedness of the populace, so the populace does not change attitudes. Observe how slowly for example racism dissipates. I posit that this would dissipate much faster if a direct democracy was being chocked with back and forth punishing and nonpunishing identical counts, because then it would become full frontal what we are doing. Many of the most bigoted divisive fractions of society would simply feel how they can no longer adress more important matters as long as they have to spend time toggling their votes for settings back and forth on the basis of the in- or out-groupness of some defendant... So the bigots would become apathic to keeping up toggling those specific settings to enforce their bigotry, and get on with their lives.

Currently it is the status quo that is choking the news, which is not what I propose...

I don't read snark in your comment btw... I value your contribution

It's like alphabetization, typically after introduction of one person one vote, people become alphabetic, because by the point the populace has made it clear elitism on this facet (voting) is over, the status quo has every incentive to at least educate the populace in reading and writing...

Similarily, I expect moves toward direct democracy (by popular force) to change the behaviour of the elites and the status quo such that "the brutes who will now unavoidably rule us, should at least enjoy a higher level of education with regards to law and so on", and asking questions about law, finding answers, navigating the law, ... will become standard course curricula for the bulk of the populace in high school...
I contest the use of 'religion' to refer to 'subjective meaning' on the grounds that it doesn't make any sense whatsoever.
The idealistic take is that the United States is a country that maximizes freedom, which includes the freedom to enter into whatever contracts you wish. You aren't forced to take a job that requires you to waive your right to sue; you're choosing to do it. If it were too important, capitalism suggests that another employer would show up, offer you a little less pay and no arbitration clause, and everybody would work for that company instead.

In practice, this isn't how life works, but that's the theoretical reason. The real reason is that pro-corporate politicians hold power and corporations want arbitration agreements to be legal, largely because courts are more expensive, bad PR, and are less likely to work out in their favor.
Love hearing this! The name originated from a Siberian husky and sled dog (Balto) who led his team on the final leg of the 1925 serum run to Nome to stop the deadly diphtheria epidemic. Given one of our challenges is a 'survival pool' we thought it was fitting as you must be the 'leader of the pack' during the long race to win/survive the challenge.
Trying Worlds Spiciest Noodles
Lambda School (YC S17) Is Hiring for 30 Roles: Product, Engineers, Instructors
We define startups as new companies with <2 years since founding and <$5M in funding. We have soft limits, and we'd love to hear from you either way.
The difference in that case if you have a union on your side to help ensure that you get a fair arbiter and a fair process.

Without that, it's all on the company.
https://github.com/google/souper
MySQL’s default repeatable-read is a complex mix, but it is definitely not strictly serializable: https://blog.pythian.com/understanding-mysql-isolation-level...

It’s very unclear what level of serializability MySQL’s “serializable” level actually provides; it is seldom used in practice because the performance cost is extreme (essentially table locks everywhere for both reads and writes).

I would be surprised if either isolation level is correctly enforced across distributed replicas, even with semi-synchronous row-based replication. My MySQL operational experience was strongly characterized by fighting replication divergence.
This is removing forced arbitration. Parties can still agree to settle a case via arbitration. But now it will actually be an agreement between the two parties for a particular case, as opposed to a blanket contractual obligation with unbalanced power dynamics.
"didn't care why he was incommunicado"

That would make it discrimination. By law, you must recognize and respect a person's religious beliefs in the workplace.

Not caring, is equivalent to saying, "you will be unnecessarily put at a disadvantage at the workplace because of your religious beliefs."
It's weird how far you're okay with going here, honestly this makes me concerned there's an issue more than your original comment.

All I said was "be careful" and now you're giving me your ex's lawyer's contact info. What a weird escalation!

This can only go badly for you, I hope you realize...
For another data point consider https://www.reuters.com/article/legal-us-otc-uber/forced-int...

Even if you willingly accept the forced arbitration clause you still may not get justice because the company doesn't want to pay for it!
> I would not sign something like that contract today.

I've been seeing wording to that effect in nearly every contract I've been presented with for years now. Every time, I speak up and suggest replacing it with wording that is much more restrictive (they can own anything I make using their resources or intellectual property, otherwise I own it).

I have yet to have a company not agree to this change.
As a matter of fact, it is in various countries: https://en.m.wikipedia.org/wiki/Right_to_disconnect.

In France it exists since 2001 and had been reinforced by the last labour law. I'm not sure about the actual consequences.
> we have laws in the US that protect people who are observing religious holidays

Do we?

From: https://www.dir.ca.gov/dlse/FAQ_Holidays.htm

> California law does not require that an employer provide its employees with paid holidays, that it close its business on any holiday, or that employees be given the day off for any particular holiday
I agree with you. That said, this case is likely just forcing a payout. While Yelp would be unlikely to lose the case, even if he did say all the crap the former employee claimed, they certainly don't want this as national news for several months while it makes its way through the courts.
CodeAnywhere Closes “Free Forever” Accounts
Their free account was, and still is, advertised as "free forever". However, today I received this email:

"We are writing this email to inform you that as of March 1st 2019 the Free tier will become a free trial and limited to 7 Days use.

Why are we removing free?
We at Codeanywhere have always tried to give our customers the best value for their money making sure that we just cover our operating expenses. Lately the increasing demand from our user base to boost the performance of our container service forced us to increase the operating cost of running our service, and with that, a forever for free plan is no longer feasible.

As mentioned earlier and as you all know yourselves, compute power is not cheap, and as a preemptive measure for this we have to scale back on free usage.

What about education use?
We do offer very large discounts for education use, furthermore if you do decide to upgrade to an Educational licence, only the teacher/admin has to use a Credit Card, students do not have to, so you have no worries there.

What and why now?
We understand that this will be hard on some, and we are very, very sorry for this, we tried to prevent closing free accounts completely, but the economics just did not work out.

We will do our best to help all we can to transition in this period, so please feel to reach out if we can help in any matter or form.

Furthermore this is one of the reasons we have reactivated the lifetime 40% discount, if you upgrade and use the following code (Promo code: 40forlife1533 valid until 15th March. 2019) you will have a 40% discount on any and all plans for the rest of your life.

We truly hope this is the last of our policy changes for a long, long time, and hope you will support us by upgrading, so we as Codeanywhere can continue on this journey of helping you code, from anywhere.

Thank you for understanding.
Your Codeanywhere Team."
To what end? This isn’t like indexing EBay listings, where using standard structures and fields would help you categorize a large volume of low complexity information. Categorization and search of information are not tasks that take up much time in the law.

I just had a trial which turned on a couple of sentences in a contract. I could have a paralegal pull every relevant legal in a couple of hours, through “dumb” terms and connecters searching. More than a year of litigation boiled down to applying a rather small volume of law to a large volume of human facts. Even in appeals, which are case law heavy, the process of finding and categorizing the law takes vanishingly little time compared to synthesizing it into a legal framework, and applying it to a large volume of facts.
Completely agree, and I was a bit disappointed that the interviewer didn't take the opportunity to ask the author's wife her opinions on the way the wife is depicted in that book. She's such a terrible character, maybe there's no way to politely broach the subject!
Just because he was fired for trying to take Christian holidays, doesn't make it anything but religious discrimination. Forcing a Jew to work on Yom Kippur or a Muslim on Eid would be the same.
I had the exact same reaction. Shouldn't this worry the employees the most?
Mostly because people don't care enough.

Lets say you are a stanch Democrat, a Republican candidate runs with Republican policies plus a plan to end forced arbitration. Do you vote for him? For most voters the answer appears to be no.

Small government conservatives vote for large government projects that benefit their donors and friends, on the other side a lot of talk about the minimum wage and socialized healthcare but none if it ever materializes when they have a majority. Then the next election comes and you vote for the same people who failed you the first time, because the other people are trying to kill toddlers and force schoolchildren to become transgender or are all secretly racists out to build death camps for gay people or some other insane claim fed to you by a corporate news network or comedy show that happens to be owned by someone who benefits from the status quo. Don't worry though, keep drinking Pepsi, you are part of the resistance TM brought to you by Viacom.

Why doesn't anything ever get fixed? We keep putting the people who failed back in charge. Nobody in Congress today should have a seat in the next election until something actually changes.
> the choice to agree or not agree to conditions of a private transaction seem to be a fundamental liberty.

A fundamental liberty that eventually leads to all corporations offering you the same choice. Accept it, or go bankrupt and homeless. Or were you able to negotiate terms with you bank, ISP, smartphone vendor, or Microsoft if you're on windows?

Laws restricting which contracts are legal, are just a form of collective bargaining of the voters. Or if you prefer, laws specifying which contracts will be enforced by the State. You're free to try and enforce the rest on your own, like a true libertarian.