skysight-inc/HackerNews huggingface dataset:
To get around not using the more of the index, the query could be split into parts, one for each tranche combined with UNION ALL. Each part can examine a narrow subset of rows, disjoint from the other parts.
Oh stop with the "it's too slow" already: https://twitter.com/steeve/status/1426103525050814464?s=20
Technically that's true, but as an economic asset, it would be considered fungible, as it can be exchange for another token (which again, is technologically non-fungible) and it would possess the same 'abilities', so to say.

I'm still trying to understand frangibility, as a word, so correct me if I'm off target.
> both avoidable (though that can admitably be said for a lot of accidents)

I'm pro-nuclear, but the need to be circumspect about safety is real.

I always think of a Bruce Cockburn song, "Radium Rain", written in 1986 when visiting Germany right after Chernobyl:

Every day in the paper
You can watch the numbers rise
No such event can overtake us here
We're much too wise
In the meantime, don't eat anything that grows
And don't breathe when the cars go by
> regulators told gaming companies, including Tencent, that they should stop focusing on profits and instead concentrate on reducing adolescents’ addiction to playing.

> China’s biggest e-commerce groups—Alibaba, Pinduoduo and jd.com—are being forced to confront many of the monopolistic practices that bolstered their earnings in the past.

> Meituan, a super-app focused on food delivery, has been ordered to provide better support to its armies of drivers. Such changes will erode companies’ profits and clobber their share prices.

> Chinese regulators have railed against the “disorderly expansion of capital” by tech firms.

Say what you will about the means, all of these changes sound positive to me.

I wish the U.S. government would grow a spine when it comes to putting citizens interests over investors.
Veolia and GE have a deal
https://www.veolia.com/en/news/united-states-veolia-makes-ce...

In France recycling is mandatory (by law).

The concrete is recyclable, and appreciated:
https://archinect.com/news/article/150240752/recycled-concre...
It's a confidence game being played on 17 year old kids who don't know any better. I agree it's a grey area and the fraud label may not fit, but it's fairly close to the truth.
Not sure how you could draw that conclusion. The vaccines have been instrumental at reducing the incidence of severe symptoms, hospitalization, and death.

Yes, a lot of laypeople were expecting them to outright prevent infection at much higher rates, but that was never the deal from the start. Consider that the clinical trial protocols only called for testing participants for COVID if they started showing symptoms; the numbers presented were never about preventing infection entirely.

The lower percentages quoted in the article are still pretty fantastic, despite their drop from the initial 90%+ numbers from the clinical trials. Remember that the clinical trials were also done pre-delta variant. It's pretty impressive that they've held up so well against delta.
no. this is provably false, and no reasonable observer has arrived at this conclusion.
"Breakthrough infection" means tested positive for COVID despite vaccination.

However, it's important to note that "breakthrough infection" is different from "breakthrough disease". It is possible, and likely common with the delta variant, to be a carrier with zero symptoms.
We should be asking why the fuck this is for sale. Why is this okay? I hate this new normal but I look around and nobody cares. Nobody I talk to IRL gives a shit. This is our reality. How do we learn to navigate this strange new post privacy environment?
Yes, they are great for developing modular python scripts, like for CLIs, where you might want to prototype some feature without importing the entire app.

For example, I'm working on a cli for a client that ingests a bunch of spreadsheets and processes the data in an SQLite db. Pretty lightweight, but it takes a half hour to run. Using Jupyter notebooks to import some classes and iterate on SQL queries without needing the entire corpus of data is handy.
I get it. There are tons of sketchy extensions.
We'll open source our extension so you can see the entire 33kB that's needed to make one settings change.
Also, you can try it out in incognito mode or change those settings manually and hence give it a try :)

But most people need the simplicity and convenience of a few clicks in order to give it a proper try.
shopify is literally hiring kids still in school at Carleton and Yorke to fill their teams through their devdegree program because they can't get enough graduated and qualified coders who want to stay in canada.
The only way nuclear will come back is serious practical next generation reactors. We could have built these since the 70s and didn't. Rather waste money on fusion and renewables.

Based on first principles, nuclear is the cheapest. Its historical path dependency that it isn't.

Fission breeder reactors have the potential to use the least amount of land, be the safest form of energy, have the lowest cost of fuel (essentially free)and use the least amount of total resources (steel, concrete and so on).

These could be used for all kinds of applications, including creating of medical isotopes, nuclear batteries, industrial heat and power.

Non if this is new, these insights are from the 70s and in 50-100 years people will look back and ask 'why were these people don't doing it? They had all the technology, it makes no sense'.
What, from this article, led you to this conclusion?
I've spent the last few years in Oxford with a bunch of PhDs and they all programmed. Those who didn't program were interested in programming & I taught a couple at a community organised code bootcamp. I'm now living next to Stanford and the same thing happened again. This isn't just traditional STEM either but economics and history students. Definitely anecdotal but I expect this is more common than those who don't program, especially as the social sciences and research-based humanities move towards programming. Hell, History degrees at Oxford now have the option of learning how to use databases to store and query information with SQL.
You weren't kidding about the margins! https://static.guim.co.uk/sys-images/Guardian/Pix/pictures/2...
The word “toxic” is real, but also annoying too.
It kinda sounds like Unity is overpaying for Weta, once all these different parts of the businesses are carved out of the sale.
NyquistData is hiring sales rep – fully remote
Before these COVID jabs were released, vaccines used to mean that they could "provide immunity" to specific diseases. Now it's been changed to "provides protection, but ooops that protection can wane over time and eventually disappear".

That is fine, medical science is tough, but don't call it a vaccine instead of changing the definition of what outcomes vaccines historically (pre-2021) had provided.
Give shit like this a platform, and then wonder why social interaction is dying out. Sure is easier to just not talk to anybody.
The heavy handed censorship only comes to light because he is the world's most famous regular butcher (the others are political leaders who bomb and drone countries).
The person you're replying to didn't even mention those advantages though! The ones they did mention are more significant to me.

Of your disadvantages... if I wanted to know when rows were created, I'd just add a created timestamp column.

But "easier to read" is for real -- it's easy when debugging something to have notes referencing rows 12455 and 98923823 or in some cases even keep them in your head. But UUIDs are right out.

And you definitely don't want to put UUIDs in a user-facing URL -- which is actually how you get around "avoids people being able to just iterate through records", really whether you have UUIDs or numeric pks I think putting internal PK's in URLs or anything else publicly exposed is a bad idea, just keep your pks purely internal. Once you commit to that, the comparison between UUIDs vs numeric as pks changes again.
> Mint mobile. Buy the SIM card with cash.

Where can you buy a SIM card with cash and not have to show any ID? And for bonus points: where you will also not be recorded on CCTV doing so.
>airplanes feel unsafe but are statistically MUCH safer than cars.

It depends.
Are you comparing deaths per kilometer, journey or hour?

Deaths per billion

Type...Journey...km.....Hours

Bus........4.3........0.4.......1.1

Rail.......20.0.......0.6.....30.0

Car........40.0.......3.1....130.0

Plane...170.0......0.05....30.8

Do you want to know the likelihood of dying on your next trip, the next kilometer or in the next hour?
It might be sold for $299, but how much do they cost to manufacture?
Nothing else in the space with the same specs sells for anythimg near that.
And that makes me suspicious about how sustainable that price is.
Throwaway as have done work slightly related to this industry.

I looked in to MCIT online but the outcomes appeared to be very mediocre. One of the testimonials was a student who got a job in sales at a tech company.

A big tell is if you go to their outcomes page it is a bit embarrassing in the lack of anything to boast about.
https://online.seas.upenn.edu/degrees/mcit-online/outcomes/

First testimonial: "Halfway through her first year in MCIT Online, Xunjing Wu is considering applying for a product management role."

Pay $26,000 to consider applying for a role.
1.6 billion, and they don't even get the full company :(
Still building coal plant doesn't mean the plant operated continuously in the future. Perhaps they may use those coal plant only when solar power generation isn't good (I don't know).
FWIW, all of those articles were from July and August, before Delta began ripping through the population.

I believe with Delta, the ratio is closer to 19:1.

But uh...still certainly a damn good reason to get vaccinated.
There no longer exists any real debate. Effectiveness of the vaccines have waned over time but as stated in the article "Our findings support the conclusion that COVID-19 vaccines remain the most important tool to prevent infection and death."
It takes less than 5 seconds to upload personal data to a server from a compromised extension.

Not saying you're doing this but it was the first threat scenario that came to mind and it's not even something particularly uncommon in the browser extension world.
> China

The EPR projects weren't such successes, they were overbudget and overschedule. Then an incident lead to a shutdown for examination.

See https://en.wikipedia.org/wiki/EPR_(nuclear_reactor)#Taishan_...

https://edition.cnn.com/2021/07/31/asia/taishan-nuclear-plan...
So if the FBI can arrest them, they're criminals and we should follow criminal procedure, but if the FBI says they can't arrest them, then we "take action" (what action)?
Corrily (YC W21) Is Hiring a Senior Back-End Engineer
What law is this?
The article was incredibly unspecific. No mention if the data from that site ended up being used. No mention that there were multiple sites run by multiple companies doing the testing, which is normal. What stage trials were these? Again, no mention.
This is b.s. fearmongering, as if sharps in the wrong bin means the drug was not tested for efficacy or safety.
I lived with someone project managing a failed pharmaceutical testing run. They throw the data out and use the accurate data from the many other sites. Or do the trials over. It happens. It wastes lots of money but it is no big deal in the grand scheme of things and certainly does not mean the drug is approved without adequate safety and efficacy testing.
"A breakthrough infection is a case of illness in which a vaccinated individual becomes sick from the same illness that the vaccine is meant to prevent. Simply, they occur when vaccines fail to provide immunity against the pathogen they are designed to target."

via https://en.wikipedia.org/wiki/Breakthrough_infection

As far as "breakthrough infection increased risk of death", that's explained a little further down on the page in the article linked here on HN:

Risk of death after SARS-CoV-2 infection was highest in unvaccinated Veterans regardless of age and comorbidity (Fig. 3). However, breakthrough infections were not benign, as shown by the higher risk of death in fully vaccinated Veterans who became infected compared to vaccinated Veterans who remained infection-free.

This is a pretty long-winded way of saying that some people who were vaccinated still became infected, and some of those infected people did die.

The importance of a study like this is to understand how the efficacy of the vaccine holds up over time, which can help inform public health recommendations and policy-making decisions.
Gotta hand it to the pharma companies - we've got Software-as-a-Service, they've invented ImmuneSystem-as-a-Service.
Are warrants necessary? I thought a warrant was a legal way to compel compliance. If the company who owns the data wants to sell it then that's that.

It either shouldn't be collected or if it is then the sale should be prohibited.
TestFlight for macOS is now available for everyone
the entire film industry is "temporary contractors" visual effects most guilty of that among the various departments. (I work in a section of the industry)

I've worked with some of weta's toolset on the avatar sequels and I've also worked with unreal on various projects... it's interesting hearing this and I wonder if that's part of the toolset that will be released
I never found one. I am really interested in it too, but I bwlieve PG ecosystem will support uuidV7 before considering ulid.
My whole life the pitch behind the flu vaccine has been “it might keep you from getting it, and even if it doesn’t you’ll be better prepared to fight it”
This is incorrect, actually. Where did you get this idea?
I loved Down and Out, great to see you reference it! I did dishes at a restaurant gig in a foreign country once: talk about a character building expertise!
Can confirm it's not returning anything for me in the US
> Please don't play dumb. You accused, and I quote, "it's disingenuous to dismiss historical facts about what white people have done in Africa on the basis that it hurts white people in Africa's feelings."

That statement itself isn't "blaming" white people for anything. It's merely stating that it is not reasonable to avoid not-so-pretty aspects of the history of white Europeans in Africa on the basis that some white people in Africa (and Europe) don't want to discuss them.

> You know very well your racist comment was a blanked accusation targeted at entire ethnical groups.

What is the accusation? You conveniently left out the next sentence:

> People who are black have done horrible things in Africa.

As I stated, you can't blame white people for all that ails Africa. But it's also disingenuous to dismiss the malign influence white Europeans have had on the continent. To pretend that racism wasn't a fundamental part of the belief systems of white European imperialists is simply absurd.

White European imperialists believed themselves superior to the people in the lands they conquered, and they engaged in concerted efforts to convince the people they oppressed of their inferiority to the white Europeans as well. Are you totally ignorant of the widely-promoted and widely-held notion that Africans were barbarians incapable of governing themselves and were better off as slaves?[1]

Cecil Rhodes (know who he is?) himself wrote:

> I contend that we are the finest race in the world and that the more of the world we inhabit the better it is for the human race. Just fancy those parts that are at present inhabited by the most despicable specimens of human beings what an alteration there would be if they were brought under Anglo-Saxon influence, look again at the extra employment a new country added to our dominions gives.

Now, I'm not suggesting that we "cancel" the Rhodes Scholarship, but would you find it racist to talk about the fact that Cecil Rhodes was a racist?

Also, I think you meant "ethnic" groups, not "ethnical" groups.

> If you are honestly interested in learning about the crimes against humanity committed within the scope of imperialist agendas, you'll learn very well that the root cause is very specific.

It seems to me you're preferring to talk about "imperialist agendas" without talking about who the imperialists were. Pray tell, who were the imperialists?

[1] https://www.theguardian.com/commentisfree/2015/sep/08/europe...
Job's comforter positivity
I'm so old I remember when these vaccines were supposed to prevent infection and transmission.

I even remember when these same vaccines were "Unsafe experimental treatments being rushed for the election" and anyone doubting them would "be muzzled, they’ll be suppressed, they will be sidelined" for political reasons.
In American tort law, the standard is what a reasonable person would understand from the statement. A reasonable person understands "vaccine" as something sterilizing against the target. The COVID-19 vaccines wouldn't be called vaccines by the average person who completely understood their effect on a person.
It's about choice. I'm a tech head and can easily root phones if I need to. But increasingly, the mobile phone is a key life tool and I'd rather that it works like a fully managed appliance. I'm willing to pay the Apple tax to blissfully live safely in their walled garden. Absolutely no need to wail and rant about Apple and their App Store practices constantly. Just use Android.
Old vaccines also have breakthrough cases. For example, my son got chickenpox despite being vaccinated against it. (He was exposed to shingles)

Also old vaccines do not all provide lifelong immunity. You have to get tetanus boosters regularly.
> > Japan reactivating nuclear reactors:

> Japan invested on nuclear then nowadays don't want it anymore but now needs energy. One has to see them canceling their planned phase-out, as "in March 2021, only 11 percent of Japanese said they wanted that nuclear energy generation be discontinued immediately. Another 49 percent was asking for a gradual exit from nuclear energy" ( https://en.wikipedia.org/wiki/Nuclear_power_in_Japan#Post-Fu... )

Wow. To have even ~40% of the population not opposing nuclear after a national trauma like Fukushima, shows their sophistication as a people.
Try it at your local store, and if they ask, tell them that you don't have an ID card because your wallet got stolen last week. Be a little adventurous.

>where you will also not be recorded on CCTV doing so

This begs the question on whether you are trying to avoid automated surveillance and correlation or whether you are trying to out-do Usama bin Laden at competitive hide and seek. The more important question is: how long is that CCTV data stored for?
Nothing. GP started with that conclusion.
Definitely great news for you, but not so great news for IT talent located the U.S. if more companies start doing this.

It's also bad news for employers in your country, because they're losing top talent like yourself to deep pocketed American companies.
hah personally I've never met one that fit the stereotype, but yes I hear that assumption a lot here in NZ
> Nah. I disagree. In Germany, its illegal to be nazi-sympathizing. As someone who disagrees with Nazi ideology, I think that sort of law (and societal environment) is healthy and don't think we should protect that.

Well, yeah, they were throwing people in gas chambers over there—context matters. Here, you might get a small group of assholes wearing armbands and shaving their heads. And, because they're nazis, they're likely gigantic pussies who aren't going to do anything (and if they do, guys like me will just shoot them). It's moot.

> So any topic that is related to a party platform is political?

Is that what I said? No. And I'm making a guess.

> "Gay" marriage is an important issue in many countries.

You didn't say anything about gay marriage, you said marriage.

> Hate speech is not just speech "that people don't like".

Yes, it is. Unless someone takes physical _action_, "sticks and stones" applies. What's also troublesome about "hate speech" is who gets to define it. Once that cat's out of the bag, all hell breaks loose (what we've seen the past few years is the prototype). People should be free to speak and deal with the social consequences of that speech just like they have for hundreds of years.

> Also why should platforms be forced to host speech that is hateful?

Because they're taking advantage of other protections offered by the U.S. government and operating a U.S. based company which operates under U.S. law (and by extension, the constitution). If they're that concerned about preventing a few assholes from saying stupid stuff, they should move their servers out of the U.S. I'd rather see those companies going after real crimes like scams, pedophiles, etc—not people getting their feelings hurt.

Ultimately, banning speech further excites extreme behavior because those people don't have an outlet. It's far more likely that they'll be corrected (or simply ignored) by others if they're uncensored than they would if they were censored.

Notice how for the first ~15-20 years of the internet, there was no nazi panic? They were around. Nobody paid them any mind. They didn't accomplish anything (and were on no trajectory to do so). Does that mean they're good? Of course not. But I'd rather they have their skinhead jamboree on a forum rather than go after gay people on the street for being "those people who took our speech away."
I back a company around NodeRed, FlowForge Inc. https://flowforge.com/blog/first-deploy/

It is building a low-coding development platform fit for the enterprise with Node-RED at its heart.
Because the prosecutors have no case. The photographer witness was damning against them.

Kyle will walk, we all knew he would. It was a clear case of self defense.

When the narrative isn't supported, the powers at be pretend it doesn't exist.
I think you've held a misconception as to what a vaccine is. A vaccine has never provided 100% immunity in everyone who's gotten it. Certainly some vaccines have come close, but that doesn't change anything. Hell, consider the annual flu vaccine: it's efficacy falls far, far short of 100% every year; I believe it's usually in the 40%-60% range.
>"Yes, a lot of laypeople were expecting them to outright prevent infection at much higher rates, but that was never the deal from the start."

What was the deal? It seems like there was a lot of vague verbiage forecasting, and un-falsifiable predictions (which is unfortunately the norm).
Literally zero vaccines exist that provide 100.00% permanent immunity, if that’s what you’re asking for
Pretext implies dishonesty. Is that the word you meant? Do you also believe tetanus or influenza vaccines have a similar “pretext”?
Until I can give it an 'improper' try from a web page (rather than installing an extension), no.

Funny to say "it's built for devs" then go on to say that an extension is required because normal users...
> Average write operation duration decreased by 50% on our fullest machines

This is probably not a fair comparison.

On the existing lz4 machines, the zfs pools are already badly fragmented, making it difficult to find regular blocks: https://utcc.utoronto.ca/~cks/space/blog/solaris/ZFSGangBloc...

On the new zstd machines, the zfs pools are still pristine, after being restored from backup.

If we want to isolate the effects of migrating from lz4 to zstd, we also need some new lz4 machines for comparison.
Ah gotcha - yeah that sounds right to me.
And furthermore can they reverse the order of said invasive search and payment through a wink-wink arrangement? I think the case is pretty strong against the government here. The EFF should bring a suit.
What other tasks are planned in your current sprint?
What advantages would that bring?
Broccoli is never going to be blamed for giving people cancer or making them overweight.
I suppose this is where we say "CNC would like a word."
Is there a single vaccine that provides 100% immunity against anything?