skysight-inc/HackerNews huggingface dataset:
The only performance cost is a worst-case cost. If your idea of performance is something like how many rows you can read/write/process per second, then the average length matters much more than the maximum observed length or the maximum permitted length.
Calling that photo of the starving kid "tragic" is a bit of an understatement. Who the hell that was a good idea?!
Beam: eBay's distributed knowledge graph store
>"FYI: select() is broken on pretty much all Linux kernels up to very recent ones."

Can you elaborate or might you have some links? What was the cause and resolution?
> Why admit to to that, but then lie about viral load?

I mean I'd worry that they were being honest, but mistaken. I'd have to do a lot of research on the efficacy and frequency of testing beforehand (e.g. it's possible that it might be calibrated to be frequent enough to provide proper care for the patient, but not to guarantee to protect partners).
1/ Don't attend meetings that have no or vague agenda
2/ Law of two feet: If you feel the meeting isn't for you, leave.
3/ No developer should endure recurring meetings (except for things like scrum ceremony or whatever methodology you practice requires), that's for management.
I don't understand the comparison. You're not paying alcoholic's bar tab. You're paying (assuming a health system with common public coverage) for their broken arm if they fall while drunk.

And we do that because it's a reasonable thing to do overall. And definitely cheaper than trying to figure out who's fault each health issue was. You got a heart attack? Why didn't you cycle to work? How much processed food did you eat? Are you sure it's not your fault?

What about exercise - You got injured while running? You didn't have to run, that was your decision. You got hit by a car? Why did you leave the house; your decision again.

A public, shared coverage has to ignore responsibility to some extent. Or we'll end up with system where you need too prove every time you're not too blame. I think that would be immoral - even according to a book you mention.
Hikikimori is not synonymous with introversion.
I am not saying it is the best way to handle things, but for cases where physical locations are well defined they make sense.

I can imagine Walmart or Ikea saying "We open at 8 am worldwide".
Yes. The most complicated migrations I've ever done have involved increasing the length of varchar(n) columns, because every dependent view needed to be dropped and recreated (and all of their dependents, and so on, recursively) within the migration transaction, in the right sequence.

If I had just used the text datatype in the first place (along with a check constraint), these migrations would have been so much simpler.
Profitability at time X is a pretty decent heuristic for whether something is worth doing at time X.
I don't even know who these people are, but I do think that this is censorship, specially if it's true (as the article quotes about Loomer) that they've never actually advocated harm or the like.
Because he said "some may think my observations are ridiculous" so I figured if I'm gonna reply I may as well oblige.
Initiatives like this are exactly what gets me clicking on "Careers" links.
Brackit – a flexible query compiler and fast runtime
It would be useful if they made it clear to their own readership that they do it, too. Instead it just plays up to a certain readership.
Sogen Kato
This is a misunderstanding of how UK print media works.

> Sources have said Manafort went to see Assange in 2013, 2015 and in spring 2016 – during the period when he was made a key figure in Trump’s push for the White House.

Sources did say that, and the Guardian is telling us that these sources said that. The Guardian isn't saying it happened.

See also "Freddy Star ate my hamster (says beauty)". https://sunheadlines.blogspot.com/2008/11/classics-freddie-s...
The thing with newspapers is that they keep posting opinion pieces using the same page design/layout as any other editorial or news piece with a small heading that says "Opinion", thus making it seem serious, and at the same time when they post opinion pieces that go way over the line they use the "but it was just an opinion piece" card. They want to have their cake and eat it as well.
Considering that the title on the webpage starts with it and the url ends with it, I don't see the issue in this case
> the natural evolution of the two-party system

The US has a long history, almost all of it with a two-party system. Only sometimes is there extremity. To my mind, 1860 is even more extreme than today.

(My opinion is that an important common thread between then and today is a class of people with a great deal of money who are deliberately driving the political atmosphere. But in any event a claim that it is a natural outcome of a two-party system needs to account for the historical fact that the US experience is typically not extreme.)
>Meanwhile other publications have abandoned that, including the 'balanced' publications.

Reuters still provides plenty of balanced journalism without dipping into fashionable nonsense opinion pieces.
>Alex Jones from InfoWar sic his followers to harass the Sandy Hook victims' parents.

Thats a skewed depiction of what happened. What happened was the biggest conspiracy theorist on the internet ran a few articles about the hottest conspiracies on the internet (crisis actors, etc) just asking questions. Alex Jones notably believes just about everything is a conspiracy. This naturally led to people deciding to "find the truth theirselves".

Alex Jones really hurt those families but I don't believe he had intent. I think he just didn't quite realise what the consequences of his actions would be.

Ironically the people criticizing Jones for spreading this conspiracy have popularized the conspiracy more than Jones himself. while critizing Jones for spreading this conspiracy. Media coverage is thought to be one of the primary drivers of schhol shootings.

I just don't see a great deal of consistency in the excommunication of Jones. Which isn't to say he shouldn't be banned. He's the epitome of fake news. Yet I notice how facebook itself gets away with providing a service that helps mass murder go Viral. Jones at least doesn't have blood on his hands like Facebook does.
Could that be extended to "You can yell whatever you like, but nobody is obligated to sell you water"?

My point being, why should what you say be of any concern to the seller? Unless, of course, they're trying to control the conversation.

If they were, well, that would be really sinister.
The China part of the argument has more merit as they have been exporting the infrastructure supporting their "social credit" system to other nations since the Beijing Olympics in 2008

https://www.nytimes.com/2019/04/24/technology/ecuador-survei...
Its mostly about the size. For rose bushes and berry bushes it is pretty simple. For other things, seeding are kept inside during winter (Swedish climate) so by the time they get planted they are big enough that the chicken leaves them alone. Some plants do need a mesh net like strawberries where the chickens will leave the plants alone but sometimes goes after the fruits. There is also large sized steel meshes for the exceptions where plants are large enough to not be eaten but so small or freshly planted that a chicken that is scratching the soil would ruin the plant.

(The context is our garden around the house, not a professional farm. Can't say anything if this could be used in a larger setting.)
Product Development Oaths
Wow, this is a new low for the New York times. Using dead and starving children as props to collect our personal information? I was on the fence after their horrific 2016 election coverage and the Sarah Jeong scandal, but this just proves they'll never learn from their mistakes.
Which supports my comment, because if it's a law it's heavy-handed. I was comparing it to having no laws.
Use `CHECK length(the_column) < some_maximum`. It has the benefit that you can change it without having to redefine views.
Probably the same effectiveness the TSA has catching terrorists.
I don't understand, why isn't there more excitement about this.

This is huge in my opinion.

Now you can get any environment in container on your local machine, with working Intellisense and all the IDE integrations.
I hope so. The gosh-darn-no-exceptions deadline has been extended several times and I presume will be again.

It’s a “solution” in search of a problem.
> If they were smart

They aren't dumb they aren't trying to catch criminals.
Nice. Looks like, that it could be used for 2D game texture generation
I wonder how long until such unilateralism provokes nasty consequences - the law is to protect them from grudges as well. The solution to diffuse it is obvious yet sadly difficult - accountability.

Being "immune to justice" leads to taking matters into their own hands which is never pretty. It has a very long history - terrorists and insurgent can be called the descendents of Sicarii style attacks - original Zealot Hebrew fundamentalists knifing Romans and vanishing into crowd.
If we're going to climb the abstraction ladder of blame, then it's not the companies -- it's the consumption of energy and the release of various greenhouse gasses that's doing the harm, not the companies. But that's not a super-useful fact.

We could globally outlaw capitalism, and I'd fully expect that the resource demand would just be replaced by governments (as is basically the case with China Coal & Saudi Oil) providing these materials since people are going to riot if you take them away.

Like how do you foresee the average person reacting if they can only get 5 gallons of fuel per week, that their food selection is reduced to what's available in a 50-mile radius of where they live? That they can't have air conditioning for more than a few hours a day? These are near-apocalyptic scenarios that we're talking about if reduce our energy usage to sustainable levels.
> Media always need resources to get produced, no matter which format. So they are never independent. Whoever provides these resources has the power. (…) It's not perfect but it can't be improved either. You can only exchange one master for another.

There’s a big difference between being dependent on (a) a wealthy owner, (b) big advertisers, and (c) readers.
Yes. It is ok. I hate that we've made it a norm to expect everyone to have the same hobby -- exactly the thing you do at work, and it better damn well be a hobby that you can monetize.

Some people code and live on the MeetUp circuit when they're not coding. I do those things on rare occasion, but I've got a wife, a small child, and other hobbies.

I like that this article reminds all of us to not normalize overwork.

That said, it seems anti-hustle is becoming the new hussle, and yes, it's ok to code on your own as well if you enjoy it, want to learn, etc. You just shouldn't HAVE to.
Use a CHECK statement to limit the length. Changing varchar length doesn't play well with dependent views.
OP meant Schengen when they said EU.
How does that work for free email newsletters? They're typically already paying an email service provider. Having to pay even more could be onerous for large, double opt-in lists, even though they're not spamming.
China's 203 Unicorns: An Analysis and Opportunities
To me, all the recent advocates for "renting & owning cost similar amounts" that I've seen have no decent counterargument for building equity, which is the single greatest benefit of owning vs. renting. This article hand-waves it away with "you 'throw away' some other money on top of your mortgage, at least at first," but how is this relevant? No one's saying that ownership = zero money "thrown away," or that ownership always means a lower monthly payment.

In the long run, these two factors tend towards irrelevance, relative to the tens or hundreds of thousands of dollars of wealth you build that you couldn't have built through rent payments.
ConnectWise Disconnected in EU
I'm not sure I've ever seen a successful news organization that hasn't relied on some combination of all three.
The fridge and freezer survived last time I gave this a go, although there wasn't a lot in the freezer. Or the fridge for that matter.

I would say that going cold turkey on the electricity for 48 hours so you get a complete 24 hour cycle is well worth it. Apart from anything else electricity is taken for granted and it should not be.

With our computer backups we only know if the backups work if we can restore from them. We don't just assume it will be okay because we have everything on tape.

Recently the Russians closed off the internet access to the wider web to see if they could cope with the USA cutting the cord.

I would say that testing life without the electricity is one of those things, worth doing not just for 'personal growth' reasons but out of preparedness. It isn't prepper alarmism, there could be a flood, fire or other freak weather incident that puts you off grid.

In a sibling comment there is mention of candles. Most people don't have a lot of these, or, if in a built up area, an actual fireplace. I would advise against doing any preparation as in buying alternative supplies and in that way night is night.

There is an actual climate emergency going on right now and buying a Tesla isn't going to help. Going cold turkey on electricity for the thought experiment value does help. Afterwards you realise that you need little more than what you would normally waste on 'phantom power' losses. Time also becomes valued differently, as per the original article we have an 'attention economy' and electricity facilitates that. When you realise you have to read an actual book in actual silence for 'amusement' and then quite enjoy it, your value system changes.
Author of the post here.

Realistically, we can't pay people full engineering salaries to do random OSS. Our team can already contribute to OSS on their work time when it relates to their work, or our own projects, but for the personal interest/passion projects without direct benefit for us as a company, it doesn't scale. Doubly so when we have a pretty strict "no overtime" policy of working no more than 40 hours a week.

We have failsafes in place in case anybody gets a bit too excited about free time OSS. We limit the Sauce hours you can do in a month for this reason, but nobody has hit that max yet, so it doesn't seem to be a systemic problem.
Agreed. It's probably a good strategy for them, but I'm no longer the target market; I've lost my last refuge at the mall.
I have a big stash of bolivars. I'm willing to trade it for 5%. Grab it quick.
Bitcoin ransomware attack on GitHub organisations
The problem with Tumblr has always been monetization. Unless you figure that out I don't see how it's going to e a unicorn.
And they're supposed to only store the data temporarily until it gets put on the passport chip (i.e. not go into the database).

Of course there's no way to verify that, but I generally have a bit more trust in German authoroties.

(you can also travel widely with just an ID card which doesn't get the biometrics, although that does limit you to Europe.)
The real id rules only address what documents count as id, no the cases of no id
The way they layout their stores is also very attractive. It's impossible to pass one of their stores, and not go inside to browse, even when you don't plan to buy anything. Only one other store has the same effect on me and that's Apple Store.
Royal Mail celebrates British engineering with set of special stamps
In the context of the parent comment "I've never understood how someone could master a subject and yet be unable to answer any questions about it.", isn't this your literalist side jumping in joy at being able to say "Aha, aha, I can think of a group of people who have mastered a subject but cannot answer questions about it"?

Except, they can answer questions to show what they know, they just can't answer your carefully selected subset of questions with the exact answers you demand using the terminology you demand.

Draw an arbitrary line around the allowable questions and you can make every group of experts, "people who can't answer questions about it". But what use is that?
You really don't have a clue.

Sure, you could have a team of people running those git commands against every repository you have and compiling an excel spreadsheet to create data visualizations for each and every engineer you've got on a team, and you might end up with something roughly where GitPrime was 3 years ago, and taking hours to do what it does in seconds.

Now scale it to 2,000 engineers for reports the CTO of Walmart can look at. Scale it to give insight at the team level.

You've basically said "oh AWS isn't anything special, you can do all of that with KVM."
Any idea what the top of the pay band is?
> So the business model is asking users for a donation?

With people's ever growing concerns about malware, ransomware, privacy invasions and the invasive nature of ads, people are turning to Ad-Blockers so this makes sense. I started using an Ad-Blocker a long time ago and I've always struggled with it because I know it's robbing sites of revenue, and at the same time I felt violated by all the ads I saw whenever I turned it off.

Back in 2017 when the Guardian started showing those big yellow banners at the bottom of articles, I started contributing. If I'm on a site more than a few times a year and they have an option to contribute, I try to.

I really think there's some space for innovation here. I like contributing to journalism and I don't want to setup annual subscriptions for 20 different sites, but I can't easily keep track of which sites I frequent or when I last contributed.
jumped out at me because of the Raspberry Pi inclusion. Neat.

(We're on a Stamp! https://news.ycombinator.com/item?id=19818319)
Seriously HN?! Strategic decisions aren't made like this. They take a ridiculous amount of scrutiny & especially one like this that impacts engineering day to day not to mention the entire infrastructure roadmap.

On the contrary, there's probably decent product alignment with Gsuite (proven by Microsoft's acquisition of Github) & opportunity for Gitlab potentially getting acquired by Google.
Nothing to see here. Having a page AfD'd is not an attack.
I'm glad to see I'm not alone in my desperation over the fact that names in math don't always mean what they seem to mean. Intelligent programmers have noted more than once that naming things is one of the greatest challenges. In hindsight, it shouldn't be too surprising that math suffers from the same difficulty.
>But, there's no denying that any friction for the user getting the software will drastically reduce their likelihood of using it at all.

I'm sorry, but the fact that the dominant paradigm for software use has been, and still is native (I'm counting apps as native here, because they're installed, even though in some cases apps are just wrappers around a website) disputes it.

If people want to use some software, moreso if they need to, they'll put up with installing it. What you're describing is really only an issue for web services, and would maybe only =apply to native software that worked according to a subscription model, which most doesn't.
Undeniably something stupid.
Any tool available to check a schema or a set of sql scripts for those common mistakes?
"Enigma" is usually capitalized so you know it's talking about a crypto machine and not just a mystery.

The Poles really did an astonishing amount of phenomenally bad-ass work to crack Enigma long before any Brits really knew what it was, but all we hear about are Brits. They even designed the bombes. It's about time we got to learn names of Poles.
I used to as well, but now I'm part of the problem - I look around and realize I could get it cheaper and easier on my kindle. I enjoy spending time going through the books, but then I'll go home and buy whatever I was interested in online.
There absolutely is such a thing as a time without timezone. If I schedule an event for a time in the future, I want it to occur when a wall clock in that location reads the time that I specified, even if local government alters time zone rules for that location in the interim.

If I set an alarm on my phone for 6am, I want it to go off at 6am in whatever time zone I happen to be in, even if I travel after setting the alarm.
> To apply for this position you must already have the right to work in the UK.

Why must be dreams only be dreams?
Signed, a developer in continental Europe.
Cutting-Edge Tips to Achieve What You Want in Life and Business
The Stones nailed this in 1967 with "2000 Man":

Well my wife still respects me
I really misused her
I am having an affair
With a random computer
What of cities, like Houston, which are too spread out and flood too often for good mass transit?
I typically don’t carry any id in the us, and since Apple Pay came out just a little cash in my pocket.

The inspection is not a big deal and they are prepared for this situation. It’s a shame that the laws that control this are classified (cf Gilmore v Gonzalez) so we can’t know what the actual rules are.
Crazy is the new good sense and visa versa unfortunately. If you suggest that we shift money from counterterrorism into opiate abuse, car accident, and obesity reduction measures since they actually kill far more people you are barking mad because it goes against their sensibilities.

Blather on about totally unworkable ideas and you get coverage and broad agreement despite the obvious and glaring flaws such as literally having no idea how to implement it.
Scaremongering, nothing more.

tl;dr: "Venture capitalists may prioritize money over your health."

To which I say, how is that not true of ANY capitalist, not just the venture ones?

We have food regulations for this very reason. No one needs to trust any food company, because we long ago discovered that trust was dangerous. So we have government regulators keeping an eye on things now.

Is it perfect? Fuck no. But the argument that Beyond Meat or Impossible Burger are somehow more dangerous because they're funded by VCs is disingenuous.
Yes, Facebook is taking some steps in WhatsApp to reduce the speed at which misinformation travels.

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

Specifically, making it a bit harder to rapidly forward large numbers of messages to large groups of people.

https://www.vox.com/2019/1/25/18197002/whatsapp-message-limi...
I was actually thinking about Hadrian's wall when I wrote the above! The building of the wall was a super expensive task for the time, and it usurped a ton of manpower (they also had the advantage of using slaves for a lot of it, and it still was expensive). Plus once Hadrian's wall was no longer well manned (once Hadrian died), it became a haven for the picts to launch their raids from and a border through which they couldn't be chased.
I disagree. Many bills are written with compromises in place, so they appeal to enough voters. I would rank the American ACA bill as E on the A to G scale.
> I can assure you the Guardian has been more and more centrist as time goes on

I don't disagree! Put an article in front of me on most hot topics and I think I would have difficulty telling you what publication it was from - it's the same cynical, smug, faux-progressive yet in reality complacently bourgeois, finger wagging, 'if you don't agree with us you're wrong/old/racist/uncool' attitude from all of them.