skysight-inc/HackerNews huggingface dataset:
sorry you missed my ninja-edit - it sounds like SOME lateral join queries CAN be efficiently maintained but not ALL (not the ones that are surprisingly expensive for whatever reason) that's where the promise of "we can materialize any query!" starts to fall apart for me. presumably the surprisingly expensive cases are the ones where some rewrite rules can't guarantee correctness without hiding indexes or predicate pushdowns or whatever - the doc says review the explain plan first but what precisely about the explain plan would tell me that the materialized view won't be efficiently maintained? ideally these cases can be known ahead of time so I can come up with a conformant query rather than trying variations to see what works.

..and more to the point, there are obviously limits to what can be efficiently maintained. I would love to see that list as this is what would give me a good idea of how Materialize compares to my daily driver RDBMS which happens to be SQL Server and whose limits I'm unfortunately intimately familiar.
Totally agree. Those who are risk averse should impose restrictions on themselves, not require everyone else to alter their lives. Life after all, carries risks. Anything you do has a nonzero risk. And if normal life is OK during a seasonal flu why is COVID any different? It seems arbitrary to suddenly claim that personal choice and individual assessment of risk-benefit tradeoff is not allowed above some risk threshold. Same for the potential reality of required vaccinations - bodily autonomy is sacrosanct and it should not be violated.

I say this as someone who wears masks, hasn’t been to any gatherings, and is fully vaccinated. Freedom and choice matters.
Sounds like something easily automated. If the electricity price goes above x, cut off power to a, b, c, leaving on d.
> If a government leader thinks they can put pandora back in the box at this point, by taking more liberties away, they're a fool

I don't think anyone believes they're putting pandora back in the box. Most officials pushing for restrictions are compromising their public goodwill (and [re]electability) to try to save lives.
Yea, this shouldn't be surprising at all. Every company I've ever worked had some wiggle room with salary and equity, but when it came to the legal terms, they were not negotiable. I tried the cute "redlining" thing a few times, and without exception it always ended up with a stern letter from Legal: "Sign it unmodified or GTFO!"

I don't know who all these Captains Of Industry are who claim to be able to actually negotiate any of these terms with their company's legal department. Unless you are some kind of unicorn super-star or exec, I don't see any company wanting to deal with the hassle of negotiating a special snowflake contract for you.
Wait, so in your first comment you’re upset that I’m being partisan, and then here you’re saying it has to be partisan?

That’s quite the turn around.

You’ve also made some pretty bold claims without explanation. What makes you feel that it’s “unconscionable and based in partisan politics” to not give a single city two senators and instead follow the two options I proposed?

ETA: Your hypocrisy is brought into even starker relief with this comment. You’re like the people who were arguing for packing the courts (before the election) because it just makes sense (for whatever inane “nonpartisan” reason they could come up with), and then when asked “What if Trump wins?”, their face just drops...
Almost everyone who would benefit from Starlink in a rural area shares the sky with a major metropolitan area containing millions of people.
Living in greater Tokyo for the past 5 years, can speak the language fluently. Added the Tamahide restaurant to visit sometime, thanks!

The biggest thing I've felt since moving here: whether or not you can speak and interact in Japanese makes a world of difference. Seriously. I have interacted with expats who have not studied any inkling of Japanese, nor have tried any kind of interactions apart from other expats, and it felt their life was so bland. For example, they'd struggle to order anything except at big chain restaurants that have English menus, so that small alleyway restaurant that serves super nice ramen? Or that washoku (Japanese food) restaurant that's famous for its signature dish in Japanese? Very hard.

And that's without all the intricacies of interacting with Japanese people (beyond asking for directions where people are very helpful). Boy, that's a rollercoaster ride. Sometimes you strike up conversations with people so easily because you can speak the language. Sometimes you get hurt because of differences in ways of thinking. Sometimes you try to put yourself in a Japanese person's shoes and try to understand what they're thinking. To me, it's been one of the most fun parts so far.

And I feel much more welcome. For example, the bento (packed lunch) shop run by a family where I buy a takeout from once a week? They know my name and can tell my voice when I call to order a bento. I ask them how's life and they do as well as we chitchat while visiting their shop. I leave the shop with both of us saying "Thanks as always!". These small things do make a difference when you're living thousands of miles away from your home country.

I'm not complaining that there should be more English stuff in general; I feel people are trying to improve the situation. Nor that I'm saying not knowing Japanese will make your life hell; it won't. But, it will be bland. Especially if you happen to end up at a local town in rural Japan. That has its own charm points but you'd miss out most of them.

TLDR: Speaking from experience, if you ever plan to stay long-term in Japan, learn Japanese. I'm sure you won't regret it.

(Sorry for the long rant.)
Neither a SIP trunk nor a cellular modem confer access to SS7, which is used internally between telcos and is limited to access only by those telcos. The majority of VoIP providers, SMS aggregators, and other telephone-adjacent companies do not have SS7 access either as it is traditionally limited to wireline telcos, so they must contract a telco to perform those services for them. SS7 routing is strictly static and addresses are statically assigned, meaning that gaining unauthorized access to the network with a new device is usually not feasible (there would be no routes for traffic to reach it).

Instead, SS7 access is usually gained by either locating a crooked telco, or compromising a device within a telco.

While SS7 has essentially no security features, the primary security measure is the difficulty of accessing the SS7 network since it is entirely based on address management and routing by central authorities. This has been sufficient to slow the pace of SS7 vulnerabilities but not at all to stop them, as both crooked telcos and telcos with poor security practices can be found throughout the world.
Time spent on smartphones not linked to mental health problems – new research
What is dead may never die. Server Push never gained any traction sadly, despite having a great potential.
This snarky response unfortunately misses my point, and your point is trivial to anybody who has taken even a remedial course in probability. The key detail is that we know the "RNG" in question might be flawed. If I tell you I implemented a RNG and you run it and find that it imediately spits out the ASCII codes for DONTBEADOUCHE in binary, you might rightly assume you've been duped.
I liked this for a beginning - http://web.archive.org/web/20160611061746/http://www.cryogen... . Sadly, author now asks Wayback Machine to remove the content of the site...
I think as battery technology keeps getting better. Building batteries in the shape of 40 foot or 20 foot shipping containers would be the way to go. Container ships can then replace battery containers on every port call just like they do the shipping containers. As worldwide we already have networks for the movement and storage of these containers the cost of implementing this system would not be very high apart from the charging stations for the containers but that would be another source for revenue for the ports.
It may be just as likely to win but it's not just as good, the expected value of the prize is much smaller because the prize will be shared with a large number of people. Better to choose a random set of numbers.
This is also such an insane take because organized labor at Google stopped a project (Dragonfly) that would’ve been used against “troublesome” workers in China, as well as a military project that also undoubtedly would’ve been used to kill more poor people.

Yes, unions watch out for their member’s bottom line, but even without a union, workers at Google have organized to protect others beside themselves!
FSearch is inspired by Everything. https://github.com/cboxdoerfer/fsearch

For general file search at ludicious speeds like Everything does on windows its pretty good :)
Could you provide some evidence for this rather remarkable claim?

> It is likely that engineers at FAANG companies would make less money if they join a union, because the union would level people out by negotiating a standard salary for workers at similar levels at all companies. I haven't seen anyone refute this.

More than one union exists in the world, they also compete with each other to offer their members the largest benefits. I don’t see why unionisation would reduce pay competition, if anything it should increase it by ensuring that anti-poaching agreements never happen.
Ask HN: Do you feel exhausted after a pair programming session?
I haven't done pair programming (PP) in a while, but our team has practiced it for 1 or 2 sprints in the past. And my experience is kind of mixed.

PP is good and all, but after each session, I feel exhausted because I have to talk and think and code at the same time. Usually lost my voice and feel dizzy.

I wonder how others think about it here in HN? Any tips?
Google never liked HTTP/2 push. I've been hosting some pages on Google App Engine and push never got implemented for the mandatory frontend proxy.
> But this was the only significant change during this period

No, there's a very noticeable drop in social mobility as well in mid-July according to: https://covid19.apple.com/mobility

How do you know which change had the largest effect?

Also, if you introduce a mask mandate, people will obviously change their behaviour, they won't just go on and live their lives exactly as before, but with a mask on. Therefore, mask mandates might reduce the spread not because of the masks themselves, but because they cause people to behave differently.

> You can't just wear masks and go about life as normal

Right, and that's exactly my point, you have no idea how much mask mandates contributes to minimizing spread because it always happen in conjunction with a ton of other restrictions and behaviour changes. Yet you are arguing that masks - in isolation - are so good that it's a no-brainer to mandate them?
The Attack on Beauty
So the Fed and central banks are going to relinquish their control of the money supply? What's the saying: when hell freezes over...?
They will fight this tooth and nail until they finally get control of it somehow. Or keep it buried deeeep underground.
Related to this: I've tried to figure out what the oldest surviving organization in the world is (specifically something with some form of rules or decision-making process that has been formally kept and amended over time instead of being replaced by a new code of rules). Best I could do is the Roman Catholic Church, but I feel like my search terms might be missing something.
MS Research: Node2vec efficiently approximates matrix eigendecompositions [pdf]
Apple is pretty ridiculous for what they've been doing. The M1 is pretty cool but jesus christ not only did it take them 2 years to fess up going "sorry we got caught that our keyboards were trash..." but they KEPT SELLING THEM! For the cost of an Apple product, that's downright unacceptable. Those should've been recalled on the spot. But oh no, Apple cant have a recall. Gimme a break. They only care about their consumers with endless pockets.
An example I heard on the radio was about the men who work in Chicago. The buggy takes them. As they are leaving their family, it should not be a trivial to do that. They had cell phones for emergencies, but when at home they were kept in the out house as they had no place when everyone was home.
Parental leave is part of compensation. It's just extra cash but with strings attached.

Things like parental leave are exactly why some people don't like collective bargaining. It means you get stuck being compensated with something you're not going to use instead of cash.
It is. Although there is also a fair amount of Angular work. It's a big red flag for me though.
Liable for what? The virus is a separate agent from humans carrying it, like a background weather condition. It isn’t the person unknowingly carrying it who is causing harm. It also seems arbitrary to assign liability to such an intermediary. If anyone is liable it might be the CCP, for initially suppressing reports of the coronavirus when that information could’ve prevented international spread. Would you support everyone with COVID taking China’s government to international court?

Also where would your proposed approach to managing externalities end? If you want to start tracing the cost of externalities across the board then you have to also do things like start taxing people below certain IQ levels for the externality of being a burden (net loss of utility) on society.
> It required Microsoft to innovate more - and look where they are now!

Arguably things went seriously downhill with Windows 8 and culminated in the horror that is W10: ads everywhere, invasive tracking that can't be made to shut up for good, extremely ugly redesign.
Does anyone know if there is an opensource self-hosted equivalent?

I'd love to install it on my NAS for the kids to play/experiment with..
I still remember the furore it caused when I asked for a copy of the 業務規則.
(because the new overtime pay policy was paying ~$3/hr worked after 10pm and I wanted to see the section that covered that calculation)

I just wanted to read the actual language around hours worked and overtime because it was never stated what the policy was.

Turns out you couldn’t read it without a director sitting next to you, and it was in a binder that you weren’t allowed to touch.

My conversation with the CEO:

“Why would you need to read that?”

“Because my contract says ‘in accordance with the 業務規則’ and I’d like to know what my contract is”

“Well you can ask me a question and ill tell you if it’s in there”

Glad I got off that sinking ship.
Rants are by definition long right :)? It was a good one and I enjoyed it! Thanks.
The largest power stations at the moment are always going to be stored hydro - they take up a lot of land. Those large coal burners also take up a lot of land when you consider the mines, transport infra, tailings dams, coal piles not to mention the clean air they "take up"
There is also an Armbian beta (which supposedly is pretty good) and a stable release should be soon..ish.. maybe

https://www.armbian.com/pinebook-pro/

https://forum.armbian.com/topic/12332-pinebook-pro/page/3/
What’s the relevance of that stat?
Of course it's not the headline on the rental ad, but that is a factor in what makes a rental property desirable. If you're not taking average utility bills into account when looking for a rental, you should be.

Maybe this is more relevant in cold climates. As a student I once rented an old house where the heating oil bill would surpass the rent in the winter. I won't make that mistake again, even if the rent on the house is cheap.

A self sufficient unit with 0 power bill would be pretty attractive to me as a tenant.
Killing jobs won’t help debt treadmills, either. It will likely have a cascade effect to many folks.

We know a lot more about covid than we did 8 months ago. It’s reasonable to allow someone to measure their own risk. If that means they absolutely must work I support it. Philosophically I think there’s a great deal of reflection to be done but it shouldn’t force folks who are willing to accept the risk to abandon their routine.
Amazing. This should be the default!
You're mostly right, but it wasn't just to make it handle like the previous versions, it was to satisfy FAA certification rules on how it handled.
I've use Rancher projects to do some amazing things for clients. Please, how does it fall short?
While I can't find the press release he put out, here is the original discussion with Phil (@PhilM). He responds to a lot of the questions and makes statements regarding his actions in it. Hopefully this will help you see his side a little better.

https://archived.forum.manjaro.org/t/change-of-treasurer-for...
The simple fact that 40 states are getting involved just says Facebook is guilty until proven innocent at this point. They should've just kept out of conservative circles and let them exist. Now they're facing not only a conservative stacked supreme court, but several conservative states that are out for nothing but blood.

Facebook played it way too liberal here and now they're gonna get screwed.
> Apple enablers downvoting.

It's a comically bad idea to talk against Apple around here, but the guidelines are clear: don't talk about downvotes. If you have good points corrective votes will happen.

That being said, while Apple is strongly anti-consumer (in everything except for privacy), Facebook is orders of magnitude worse in more regards than merely celebrating choice. Definitely a great second contender, but the world would be genyinely better place without Facebook.
The Mayday/Air Crash Investigation episode titled "Hidden Danger" has good info on this and covers several crashes iirc.
The have redress through the U.S. Court of Appeals for noncompliance with their decisions, so this really isn’t true at all.
Iconic Images Programmers Happen to Know
姦 always cracked me up.
> On the contrary. Artificially large doses of antioxidants disrupt signaling systems, preventing exercise recovery and wound healing. They are simply not a good idea.

TIL. That's fantastic.
Don't live tweet your HN submission, it's a shitty way to get followers to upvote the submission even if you didn't mean to do that. Next time, save your tweets for 12+ hours after submission and post it on twitter.
How Radio astronomy helped prove the existence of dark matter
I usually don't, but I'm fairly extroverted. I think being introverted or extroverted plays into this.
I was bitten by this just the other weekend. Out in the middle of nowhere for an organised event, and the organisers said we had to use the backup route. I had it downloaded to my phone, but Garmin Connect won't work at all without an internet connection.

Ended up just using my phone for navigation, and even though I was recording GPS and heart rate the whole time, I'd only used 50% battery after 14 hours riding. Nice.

There was another guy at the campsite who was looking for someone who had downloaded the route. I AirDropped it to him, and he transferred it to his Wahoo bike computer with no trouble.

For shorter rides/runs, I use the WorkOutdoors app on the Apple Watch. It's only battery life that's an issue when the activity is longer than 6 hours. Just this morning I had the opportunity to go for a run a bit out of my normal zones, so within a minute I had sketched out a route on the phone and transferred it over to the watch. (That some of the paths I'd used didn't actually exist anymore was a separate issue, but I've already updated OpenStreetMap to fix that.)
As someone who helped contribute to Google's pre-HTTP2 apache/mod_spdy push, I am sad :(
Face Recognition Software Shows Improvement in Recognizing Masked Faces
There was talk about how the expiration of Let's Encrypt's intermediate cert at the end of the year will have ramifications, as Let's Encrypt's root cert is not included in older versions of Android, which much of the developing world makes use of. The suggested fix was that they download Firefox, due to it staying updated on older versions of Android, in addition to having it's own certificate store.
By "they all have to work" gp is referring to Saudi citizens, not the migrant workers. They (citizens) won't get deported anywhere.

The migrants will try to migrate somewhere else that has work.
An 1x engineer is a distinguished vp in progress
Also for Amazon, Walmart, CVS, Costco... Disallow white label products. They just learn about products, copy, undercut then crush them due to distribution. Its anti-competition and demotivates new advances.
Should have gotten royalties for his very successful game thought
Interesting. That's not how it works in Australia at all.

Here, salary expectations are given in the first screening call. If they can't meet the expectation or you won't be happy with their lower offer things end there.

Interviews / code tests happen.

Offer comes over phone or email. This includes salary.

There is no signature at this stage and nothing is set in stone, its just an offer. If you accept the offer a contract is drawn up. Still nothing is certain.

Changes to the contract can happen here.

Once both parties sign. That is when you're "signed".

This happens well before your start date, usually you would stipulate the start date in the contract, so if you need to give a month's notice to your employer your new contract with a start date from a month is signed before you even hand in your notice.

There is a 3 month trial period on all employment where they can walk without much repercussions, but this is more of a concession on your part because employment is very well protected.

Any weird IP bullshit or other conditions of employment that need signing would be in the contract you signed on for.

They can't bait and switch like what you're discussing. Any NDA's are discussed up front and at least their existence is disclosed in the contract giving you a chance to see them early.

Basically you can't put new conditions of employment on people after the fact, and if you did it wouldn't be valid in court anyway, contract law trumps contract content here no matter what.

Things don't have to work exactly like this, you might want to leverage the offer for a higher pay at your current job, counter offering is commonplace here but I wouldn't ever accept one. They'll be looking for your replacement as soon as you accept.
The "they" in "what do they do" refers to unproductive Saudi citizens, not productive Saudi immigrants.
Except it’s not public and you agree to the rules in order to participate.
> I think you should be liable for all the illness you cause should you infect anyone.

My entire rationale is that this has shifted to risk management. Can’t I be taught how to minimize the probability of infecting others? It’s not black and white. I can conduct my life and do my best to help my fellow human.

There is no fault here and this shouldn’t remotely suggest “covid transmission insurance”. It’s about making educated, science based risk calculations. Right?
Making a monitor stand out of an IKEA shelf
Fuck, I never thought of it that way.

Man. Seems kinda relentless.

Submit a PR that responds to "Ok Google, enough!" by degoogling your life including automatically submitting your resignation.
Alternative analogy. The haggling at the flea market already occurred (compensation negotiation), and the price was agreed upon. As you are picking up the goods, the seller shouts at you that he also gets to rifle through your phone, no take-backs, and you definitely agreed to it because you're picking up the goods.

One party here is altering the verbal agreement, and expecting the other party to accept without additional negotiation.
You are describing the case where there are 2 groups that are isolated/partitioned.

But what if there are more than 2?