skysight-inc/HackerNews huggingface dataset:
> Do you have a definition for hyper-intelligence?

Trivially, anyone much much smarter than me. :)

Hypothetically, take the top N% of the high end of the bell curve, where N is 0.1 or 0.001 or 0.000001 or whatever. But then you have the question of how to survey intelligence?

Which brings me to my answer to your second point,

> intelligence and impulse control are separable things.

A quality called "intelligence" that does not engender impulse control isn't actually intelligence, eh? In other words I would define intelligence precisely as the ability of self-control combined with the ability to effect desired changes in the world. What's the point of "intelligence" that gives no "leverage", especially in the context of some "we" who are supposedly effective enough to institute a world-wide eugenics program?
> It honestly feels straight anti-vax to make up lies calling it unnecessary and risky ...

I suggest that we charitably assume that everyone here is discussing in good faith. Otherwise it's hard to have productive arguments on contentious topics.
I love this idea for blue states. For red states, it would be DOA.
This reminds me of KEY JOIN in Sybase which, unlike this syntax, does not require to specify the foreign key. I find Sybase's syntax to be too implicit, and challenging to port to other dialects; JOIN FOREIGN with explicit PK reference looks much better.

I wonder how it is expected to work with non-table references (views, CTEs, subqueries), especially when the columns involved in the foreign key (on either side) are not returned explicitly by the referenced object.
This is the cost of decentralization (proving ownership through solving hashes).

A central authority being the source of truth will be cheaper since only one entity needs to verify. Will the cost of proving ownership through decentralization ever be cheaper than 1 single authority doing it?
Seems to me the best leader might be someone who forever feels uncomfortable and uses that positively (eg asking for advice, promoting/delegating to betters, expressing gratitude, admitting mistakes, giving due credit) rather than negatively. A leader without discomfort suggests an unchecked ego…a recipe for eventual disaster no matter how long the good times (if any) may last.
Yeah, I use UPS too
Was not the best idea to do that. Sega is very traditional Japanese company. Consequences are likely to follow, but not the legal ones.
The newest kid on the block is vertico - commonly used together with consult, embark, marginalia, and orderless to replace helm or ivy.
Apple solved the problem in China with surprise inspections done by independent organizations (e.g. the FLA); e.g. see

https://www.theguardian.com/technology/2012/feb/20/foxconn-r...

The title oddly enough is "Apple faces its 'Nike moment' over working conditions in Chinese factories" from 2012.

One challenge here is that the host government (local, provincial, or national) is often complicit and might not agree to allowing such inspections. In that case, you simply have to be ready to walk away.
There should be special scalable government covid wards to handle overflow at this point. This is no longer a collective problem, considering that the remaining unvaccinated are mostly by choice. The externalities are far worse than the disease now.
No. What icambron and I would like is something that can get rid of this group by:

select division_name, branch_name, dealer_id, dealer_name, quarter, month, sum(total_paid)
from divsions, branches, dealers, transactions
where ..... --buncha joins
group by division_name, branch_name, dealer_id, dealer_name, quarter, month

If I didn't want to group the result by division_name, branch_name, dealer_id, dealer_name, quarter and month, why would I put them in the select clause?
This is true for some people, some assets, and some amounts of money. Regardless, for the super-rich, they have enough cash that people can make more honest apples-to-apples comparisons with the same effect.
I wonder if primary objective of this proposal is to increase convenience and reduce the amount of typing that users need to do, when using SQL inline?

If indeed that's the goal, then it targets a rather specific subset of users dealing with explorative/ad-hoc analysis on a database. Once such analysis is done, the queries would usually need to be formalized for robustness and to avoid ambiguities.

Obviously, the whole train of queries would derail, should the FK (which is just an index) be dropped for one reason or the other.

The existing JOIN features are explicit at least on the level of specified table structure. I believe, any constraint details in such context will be, well, ...foreign.

Perhaps, a simple solution to verbosity problem may be to use an "intelligent" SQL client, which supports some form of autocomplete and which may as well internally use as many schema/data details as available.

In anycase, thanks for making the proposal. I was not aware of JOIN ... USING syntax. I often wanted some convenient way of specifying homonymous join columns, as some schemes are consistent in such namings. So typing JOIN on col1, col2... would translate into equality joins between the listed tables. However, again, there is ambiguity here...
Data warehouses have all sorts of different design approaches based on their different requirements, wouldn't this just be another one of them? I actually think that having a way to alter the constraint to non-enforcing sounds like it'd be better for your situation anyway because you can then have your load performance but utilise the constraints with background / delayed process that checks the integrity because the information is still there in a standard form.

Which sort of leads to .... I don't agree with your characterisation of foreign key constraints as business rules. They are genuine information about the structure of the data.
An Lego Mega Factory That Builds Miniature Log Cabins Out of Cucumbers
What we really need is a high-bandwith linking apparatus of some sort... an enclosed cable that could connect directly from your headphones and then plug into your phones, so it could use it's own amp to provide an enjoyable HiFi experience on the go... We'll call it Apple Pro Link (alongside Pro Link Max, a 6ft extension cable) and sell it to you at the formidable price of $39.99.
SQLite: Attach Database
"As a developer that was a bit of a pain since you had to get purchase approval instead of just adding a dependency to a build file."

How much of a pain was it when the vendor refused to fix your bug because it, or you, weren't important enough? When the vendor went out of business, or was bought by a company uninterested in the product you were using?

Oh, and when you consider writing a library internally, keep in mind that patents are a thing.

"It meant that developing libraries was actually a viable business."

Yeah, I remember that. I remember when there were a million billion little companies producing C++ libraries. Then C++ started to get really popular, and those companies' customers went from a small group of experts to a large group of, uh, non-experts. Then they discovered that support was hard and all went out of business.

I really wonder what would have happened it HP hadn't open-sourced the STL...
An opinionated guide to scheme implementations (2013)
The thing I love about emacs is how extensible it is.

The thing I hate about emacs is how extensible it is

Emacs was invented in 1976. You think it would be stable by now?

I filed a bug report for a sub-system I will not name because I think the developers are horrid people and the software fabulous, and I was abused, shouted at and called names for using an emacs distribution three years old (out of date they called it). That is I was using software that was forty four years old.

I love you emacs - I hate you emacs -
And it is important to air contentious opinions. What would Scientific American be if it were only an echo chamber?
Yet they continue to brand their software in his name. Despite the community asking for a rename https://news.ycombinator.com/item?id=21929297, tech publications pushing for a rename: https://en.wikipedia.org/wiki/Reiser4#History_of_Reiser4, and Linux Kernel developers just wanting nothing to do with that name.

At some point, you have to wonder why the developers of a filesystem insist on associating it with a convicted murderer. Maybe stubbornness, edginess, a lack of awareness... or maybe they're friends of Hans Reiser.
JavaScript’s numeric parsing is locale independent. People write too much code blindly to make any kind of locale inference anywhere.

Otherwise I agree with you whole heartedly - I have been stung by absurd locale dependent behaviour in the past (windows’ font loading APIs inexplicably translate the font variant in the programmatic api)
It doesn't hold at all. Open source licences usually clearly state that there are no guarantees. The contract is clear and log4j (or any other) authors don't owe anything to anyone. If you want guarantees, pay for it.
The environment argument is technically incorrect, and typically used by ignorant people as it is a good emotional argument.

There could be 1 or 10000000 NFTs, it makes no difference to the energy usage of the Ethereum network. The energy usage is in the production of Proof of Work blocks. These blocks could be empty or full, and this makes no difference to the amount of energy used to produce them. NFTs are dumb, a grift, etc etc.. but they themselves use no energy beyond that required to create, sign and broadcast the transaction.

It is dishonest to say "NFTs use a lot of energy". They dont. You can blame ethereum, you can blame PoW, you can blame the miners -- but the existence of the NFT contract and transactions makes no difference.
It’s not just the wrong choice, it’s fraud.
What about SELECT * WITHOUT {columns_you_do_not_want} FROM...

EXCEPT is already a keyword and has is used for set-based operations, so I don't think it's good to overload it.
Because it's time to start calling these plants that Apple runs what they are.

As the hint at the bottom indicated -- the substitution was obvious (assuming one read the actual article). And in that sense, not "really" misleading.

Call it dramatic license, if you will.
Ah indeed. But that bubble has been in the making for 10+ years. It's not a topic of conversation because we are all used to it.
Saying I'm "very very" wrong and need to read history/some book isn't a good counter argument. It is the opposite, and a lazy retort at best.

If I am wrong, I'm sure your history lessons should be able to provide good examples how I am incorrect, and I would be happy to hear if that's the case, but I can't see just saying "you're wrong, read history" as productive conversation.
there is a term in use in today's US military - "centralized command, decentralized execution" that mostly captures this sentiment
Does anyone have an idea of what percentage of China's total gain imports (and I guess net consumption) the "increased hoarding" represents?

Eyeballing the graph in the article, it looks like since 2016, China has increased its share of global wheat stocks from like 40% to 50%. Combined with a claim that China has enough wheat stocks to feed itself for a year and a half, that seems to indicate that on average China's "hoarding" increased its overall wheat "consumption" by roughly 10% per year?

That's obviously a significant chunk of wheat, and since, all the prices are interconnected, it obviously has a role to play in global food inflation, but I find the connection made in the article to be unsatisfying. Like it's an obviously true statement, but it also lacks any sense of magnitude of contribution.

I also wonder how the population vs stock share comparison would look like if you limited to say G20 nations. Obviously richer countries have more capacity to stockpile relative to population. Re-scaling that way would put China's behavior in (I think) better context.
Less threatening than the flu if you're vaccinated against flu or just against the flu without vaccination? Influenza is not a harmless disease either, people at risk are advised to get a yearly shot.
The yacht probably had it's own problems after the impact. The tanker wasn't that much smaller than it was.
How to Catch a Polar Bear
I've definitely used that exact wording when ALL of the problems were DEFINITELY triggered by something but I still didn't fully understand how.
https://archive.ph/7RsIo
Why they used users in the first place I don't know, but for IAM credentials - I've seen people using Terraform to generate the users and access keys, and storing the access keys in the terraform state (you can't access secret keys after they are generated), and the entire state of Terraform is typically stored in something like an S3 bucket.

It's definitely not a great practice, but still it's done.
Thanks a lot :)
We are thinking about opensourcing. Not really any experience with it. It's quite easy to build yourself (ESP32 with EDA and heartrate attached).

Can ask the hw team for the schematics (or just the sensing setup, I guess easy to replicate with most embedded platforms).

We might still have a couple of bands in the lab somewhere ... If you have a cool idea what to use it for, could send one out. (Yet, might take a while before I know, Just ping me by mail).
> I think you missed the point, people under 40 are not very likely to be hospitalized so why should they get the boosters.

I don't see the point written anywhere so I suppose I did.

In my opinion, people should get the vaccine as long as the harm of not having it is greater than the harm of having it. Adverse reactions are very uncommon and unvaccinated people are at heightened risk of hospitalisation (even under 40s) so the balance tips in favour of the vaccine. The booster seems like a good idea due to Omicron.

> People should be free to choose booster shots, those who are worried can continue to get booster shots.

I do agree that people should have a choice to take it or not.

However just as I believe the right to free speech doesn't mean I'm obliged to listen, I believe the right to choose not to be vaccinated (or receive a booster) doesn't mean I'm obliged to be around you. That is, I think it's fine for participation to be refused to people based on their vaccination status (though I support say testing as an alternative).
Does one person playing a game on their PS5 for a few hours a day really have the same footprint as one crypto miner running a swarm of several hundred or even thousands of GPUs for the same period of time (ignoring the reality that those things are mining 24/7)?

I don't really know how you can equate the two and also say that an individual person has no incentive to keep their househould energy costs at a minimum. Especially when you consider the socioeconomic status of the average gamer or their family, compared to the average owner of a crypto mining enterprise.
Good, NFTs are terrible and anyone who buys one should be ashamed of themself
What do you mean by "social consensus chain"?

Any UTXO that you create now, when the mining difficulty is quite high, is going to have a very high security, even if the mining difficulty goes down afterwards.
Right but none of these folks were associated with the origins of the net or the web at all. They're people who either inferred post-scarcity through trends they saw or wanted to apply an ideology to the net and the web. DHH is the only technical person in that list.

The reason this distinction is important is because a lot of folks try to make the case that the ideological origins of computer networking were with an eye toward post-scarcity, but this seems incorrect to me. Instead it seems to be ideological anger that the internet is not supporting post-scarcity economics.
Atlas of Poetic Zoology
Fascinating to me that we still have tremendous creative ecosystem of new languages appearing and yet it still seems people are yearning for their "dream" language and unsatisfied with the options. Is it a fundamental truth that we can never have the perfect language?
Antivax for COVID is different, as it became a political sports contest.

Usually the groups who have low vaccination rates are more extreme religious groups. It’s usually not a big deal from a broader population perspective - the exception being measles.
The keys that sign the software are probably located in the US, or are otherwise within reach of US jurisdiction. That’s as much a risk as assembling hardware in the US would be.
Finally Boston Dynamics is releasing a robot that looks like a regular industrial robot.

It seems the pressure to generate sales is forcing them to produce more down to earth products that can be marketed easily.
Same. Remote or bust.
> According to the MPD's third organized crime control division, the names, dates of birth, and sex of 38 men in their 20s to 80s who had applied for Meguro Ward-run housing were recorded on the floppy disks. None of them were apparently affiliated with gangs.

Putting aside the "floppy disk" question, I have to say they seem a hella lot more polite and regretful for the lost data than the constant and more extreme breaches and loss of PII that seem to get stolen regularly here in the U.S. Equifax?
The problem I found out is that SELECT * LIMIT 10 is guaranteed to be needed so it's actually much more important than whatever is in production (you have to explore a lot before writing the production scripts). My idea is that exploration should be as easy as possible.

Things such as SELECT * EXCEPT col1, col2 are really a PIA to write and can build up frustration level really quickly. Certain IDEs such as Datagrip ease the process by providing "macros" but they are not enough.

Another thing is to generate useful boilerplates such as SELECT col1 FROM table GROUP BY col1 ORDER BY col1 to explore all unique values of col1.
The issue is not how many ineffective pro-forma controls banks have. It's whether they stop the activity. Even the Economist agrees that money laundering through the lagacy financial system is out of control.

https://www.economist.com/finance-and-economics/2021/04/12/t...
You're right. I can barely identify a number on sight.
They increase the usage and attractiveness of the Ethereum network. So while they don't directly cost energy, the Ethereum network expands to use all available energy priced less than the current token price (as all Proof of Work schemes do). Anything that increases the token price of Ethereum indirectly increases the energy use of the Ethereum network.
"Designed by Apple in California Assembled in China"

I laughed the first time I saw that because of how proudly it was featured for such a mundane statement. In 2014 I bought the Moto X in part because it was assembled in the US. Remember, it costs $14/hr to pay a US worker compared to $4/hr in China, which makes up some fraction of the cost of a $400 phone but I'm not sure how much. I was also never really clear on how much of the assembly was done in the US. At some point companies were saying things like, "Built in USA" "Final Assembly in USA" or whatever other term they thought could be used to imply "Made in USA"/"Assembled in USA" without alerting the FTC.

In general it's not terribly difficult to find products made in the US. It's a hunt, it takes time, it often costs more, and sometimes the material are from overseas. But clothes, toys, furnishings, food, it's still made here by the people and their businesses which care to make it here.

So why isn't "Made in USA" etched on the back of iPhones today? I think it's not a priority of the company. Maybe that's cynical given that two years ago there was all this news about Mac Pro towers being assembled in Texas [1]. But Apple is the most profitable company in the world, and chooses to etch "Designed by Apple in California" on the back of every phone despite the means to say more, so I don't know why I should expect Apple manufacturing to move to the US unless there is financial incentive.

To be clear: I assume Apple estimates how many people feel the way you and I do (will pay for Made in USA) and concludes now is not the time.

As an aside, I once saw a sale for Tommy Hilfiger USA "All American II" towels. Made in India.

[1] https://pbs.twimg.com/media/EsN2LCcXUAErEkr?format=jpg&name=...
> It is 100 percent Apple's responsibility to guarantee safe and humane working conditions for all workers at every level in its supply chain.

You're advocating a particular ethical framework, but I'm not sure what the justification is. I'd be interested in hearing an argument for why others should adopt it.
MIT commissioned an entire report about its role

https://swartz-report.mit.edu/

-- maybe that includes some of what you're looking for.
In this case SEGA, due to their incompetence lost a bunch of car keys owned by other people despite claiming that they’ll keep them safe (and having a legal obligation to do so under GDPR). So I don’t see any problem with publicly exposing them.
It's also the model underpinning bribery. It's multi-purpose.
Tech companies are not held liable by the justice department or any other federal org. It's against their interests because they now depend on these services to operate. Which is why you will never see Amazon, Google, or Microsoft sued in any damaging capacity for the obvious fraud they commit. That being fake products, reviews, promoting scams, antitrust, etc.
IKEA hikes prices nearly 10% as the supply chain crisis continues
What is the point of exposing the wheels like that? Seems to serve no purpose other than aesthetics and looks to be very dangerous (a finger and foot trap).
Fascinating. TIL. Thanks for the link.

Such a strange situation, where a company has to walk away from letting people work for them because they can't verify their working conditions are good enough. I suppose these are the tricky side-effects of being an international corporation though.
Gavin Wood is a Founder of Polkadot, Kusama and Ethereum. He has put a lot of effort into the development of the crypto industry.
I have only one question: is his blog a gift?
The UK JVCI recommends vaccination only for children who are in contact with immunosuppressed people.
How many other medications do you take, or more specifically _require your children to take_ that:

1. were invented 18 months ago, have been available for only a year, and were hurried through the FDA's processes

2. underwent limited clinical trials

3. the manufacturers and providers are immune from lawsuits

4. the effectiveness was cited as 95% 8 months ago, but has proven to be much less.

...

I'm betting that the number is 0.

One has to admit, these vaccines and their rollout is all very unusual and against normal order. People having hesitation and skepticism is actually very healthy.
> MS-DOS wasn't much more than a program loader, it wasn't supposed to protect anything. After your program did its worst, the OS was write protected, and the only thing you could mess up would be any floppy disks that weren't write protected.

This is obviously only true of MS-DOS on purely floppy-based systems.
I wonder how much the yacht was insured for.

Lots of lawsuits incoming.
A Modern C++ Signature For main() (2017)
JFK, 9/11, and Epstein spring to mind for major conspiracies. I think anyone with a head on can see the government bodies tasked to investigate those affairs were rife with conflicted interests, duplicitous individuals, and some intent that they should be as narrow investigations as possible. Those secrets have been kept or at the very least the limited hangout worked so well that people think only nuts question them.
It's a statistical fluke that has been observed with Delta as well, particularly with the AstraZeneca vaccine:

https://papers.ssrn.com/sol3/papers.cfm?abstract_id=3949410

It stands to reason that the unvaccinated at this point are in large parts hermits who are "protected" by their lifestyle. However, it's also plausible that the non-neutralizing antibodies from the vaccine induce a suboptimal immune response with Omikron.
Interest in NFTs still drives interest in Ethereum so there’s a social aspect working indirectly.