skysight-inc/HackerNews huggingface dataset:
I think the point is rather that a join with a condition (which is the norm) is almost never actually executed as a cartesian product. take for example from tfa

select * from customer_order_items

the grain is one row per customer order item, and the next two joins don't change that

select * from customer_order_items join customer_orders on order_id

the grain is still one row per customer order item

select * from customer_order_items join customer_orders on order_id join customers on customer_id

the grain is still one row per customer order item

..etc..

of course later on they screw it up and take the cartesian product of customer_order_items by employ_markouts, but it's just 2 big factors not 7 - their query did finish after a few seconds. usually mistakes involving cartesian products with 7 factors just run for hours and eventually throw out of memory.
You can see this in any well-disciplined team (often found in sports). Years of training (and practice) and good examples set by those who came before them can make people work smoothly even in incredibly high stress situations. See well-trained pro firefighters, ER medical teams, or fighter pilots.
Democracy and capitalism are not joined at the hip, and while the neoliberals are praising the idol of free market, capitalism is dismembering our democratic institutions, like independant journalism and access to justice.
The article also points out that similar fraud occurs in the natural sciences (it is worryingly easy to falsify experimental data, assuming nobody is looking too closely). But even those who are deeply critical of contemporary practices in natural science research don’t discredit the entire discipline.

Being able to slip some garbage papers into some journals by itself really doesn’t prove anything about a specific discipline, at least not without a comparative analysis of published fraudulent papers (between, say, sociology and physics) that AFAIK doesn’t exist. You could follow your logic to claim that all disciplines have a validity problem... but then what is the point of the observation, other than that human reasoning is imperfect?
Usually when pasta cooked the exact amount of time specified on the package it should be "al dente", but you shouldn't trust it and start tasting it a couple of minutes before that point.

Where did this idea come from?

I used to believe this too and did exactly as you suggest. But I always left it in longer.

So I started following the timing on the pack. It always works for me for normal dried pasta.
Eh our Toyotas have always been bulletproof, our mid 90s Chrysler minivan was a constant string of major problems ranging from total transmission swap to AC failures to electrical issues, including my favorite, the dashboard just going intermittently dead during a long road trip, with all needles dropping to 0. Or the time that the radiator fan stopped working one summer road trip so that we couldn’t stop for any length of time without the car overheating, like a very lame version of Speed. It wasn’t even that old when most of these issues cropped up, so there wasn’t a lot of maintenance that could’ve been skipped. Anecdotal/small sample size, but it did nothing to persuade us that the stereotypes weren’t true. And back to Toyota we went.

I think a similar story happened to a lot of American families, and the stereotype grew.
How much class did you have? My first year at university had three hours of tutorials and ten hours of optional lectures per week. Subsequent years had less. There was plenty of time.
Also I’m certain there is tons of video footage to backup the circumstantial evidence.
Francis II continued to be Emperor of Austria till 1830, Napoleon was outsted in 1815 or there abouts.
In addition to breaking the site guidelines with flamewar (see https://news.ycombinator.com/item?id=26527725 above), you crossed into personal attack here. That also is a bannable offense on Hacker News. No more of this, please.

https://news.ycombinator.com/newsguidelines.html
One possible approach to practice is skipping the “solutionizing” part of the listening-paraphrasing-solutionizing habit you mention. A good listener is able to understand the speaker and prioritizes understanding the speaker’s ideas over conveying their own.

Generally a good way to stay engaged is staying curious in what the other person is trying to communicate. Most people enjoy talking about their lives and will enjoy dominating the conversation. However if you need to fill a silence, a good personal story relating your experience to theirs is an effective way to demonstrate that 1) you’ve been listening diligently and 2) they’re not alone. Always nice to promote a sense of human togetherness!
The easiest way to stop the ,,inverted pyramid'' structure is to reverse aging, which will probably happen in the next 20, at most 30 years. We just started to create aging clocks in the last 5 years, it's much easier to reverse what you can measure. Many people would happily go back to work if they could get back their youth in return.
“It was the dawn of the third age of mankind…”
Author here. Between this and your other response, where you expound on the same point, I think you're being far too hand wavy about what causes performance issues. The number of joins alone doesn't have much to do with the performance characteristics of any query.

What's more important for performance of queries on larger data sets than the number of joins is that there are indexes and that the query is written in a way that can utilize indexes to avoid multiplicative slowdowns. The reason the UNION query is fast is because the query on either side effectively utilizes the indexes so that the database engine can limit the number of rows immediately, rather than filter them out after multiplying them all together. I can expand this schema to have a UNION query with two 10-table joins and it would still perform better than the 7 table query.

I think someone new to SQL is likely to read your statement and think "okay joins are slow so I guess I should avoid joins". This is not true and this belief that joins are slow leads people down the path that ends at "SQL just doesn't scale" and "let's build a complicated Redis-backed caching layer".

SQL performance is a complex topic. The point of our post was to illustrate that a UNION query can simplify how your join your tables and allow you to write constituent queries that have better performance characteristics. Morphing this into "the number of joins is smaller so the performance is better" is just incorrect.
they are not called "sailing yachts", they are merely called "yachts"..
Or fly it in IL-2 Sturmovik or DCS flight simulators!

It feels like a big, heavy, complex machine compared to other WW2 fighters.

Here is a practice run using Track IR head-tracking showing the engine management simulation, including a mid-flight engine failure due to my ineptitude: https://www.youtube.com/watch?v=J_kAFi9G7-0
I was under the impression that mysql wss smart enough to skip parts of the range that isn't needed. https://dev.mysql.com/doc/refman/8.0/en/range-optimization.h...
If you don't mind me asking, did he eventually fly jets? Did he ever express an opinion on which he enjoyed more: jet or prop fighters?
It would be great to move adblocking to an OS/network level, but DNS blocking just isn't comparable to what a browser-level adblocker does.

To get to the point where I would feel comfortable having my OS handle browser blocking, a reasonable chunk web browser functionality would need to be moved out of the browser and onto the OS. I just don't see that happening any time soon, and I'm not sure that's the direction we would want to move with browsers anyway.

Ublock Origin will do things like stub Javascript methods on the page. A Piihole can't do that. And even for simple things like blocking requests based on the current domain -- the movement towards DoH and SNI are going to make that harder and harder as time progresses. You really need an interface that has insight into not just what requests you're making, but where/why you're making them.

Not to say that system wide blockers don't have value, but they're really there for the apps that can't handle their own adblocking. They're a defense in depth for the requests that slip through other parts of your setup, but they're not a good replacement for a browser extension.
Both this drive and the 980 pro have a dynamic SLC cache. When there is a significant amount of erased space available, they will each sustain about 5000MB/s. This drops to about 2000MB/s as the SLC fills. The 980 pro hits a cliff at about 75% written. The SN850 requires less erased space, but I forget the exact point it cuts out.

The size of the dynamic SLC, when available, is roughly 1/3 of the erased space, with an upper bound.

If you don't need the capacity, set aside 30% of the drive in a partition you won't use, then use blkdiscard to erase it. Not only will this increase write performance, it may increase endurance. Increasing endurance with these drives is of interest because they are rated at 0.3 DWPD, compared to 1 DWPD with previous generation drives.

Taking over-provisioning to an extreme, I found that erasing a 980 Pro, then creating a 100 GB partition allowed me to overwrite that partition many times over at a sustained 5000 MB/s. This could be interesting for journaling, so long as you are ok with lack of power loss protection (unlikely for a journal) or cache flushes could be performed to ensure the data is on NAND, not just in DRAM.

But really, if you need to sustain writes at such a high rate, both of these are the wrong drive for endurance reasons. With optane stuck at PCIe gen 3, it may be great for low latency small blocks, but it won't exceed 3500 MB/s in a x4 NVMe form factor.
The important thing to remember with intelligence agencies and a principle of omniscience itself is that if you could see literally all crimes being committed in an area and who is doing them, not only would you be horrified and trust no one ever again but you would immediately be forced to reevaluate what constitutes a “serious” crime worth pursuing
They will! This is called cryptanalysis, and it's very common for ciphers to be weakened over time.
Those are both inner joins, just a different syntax for writing them.
In a drag turbo setup they solve the lag by spooling the turbo off compressed air so at launch they are already into boost.
I'm not the one who called it that, it's nice in many ways, but being unable to trap integer overflow seems 90s to me. Integer overflow (like buffer overflow) is now recognized as a common source of bugs, but it takes several instructions to detect with risc-v. So your compiler has to generate those extra instructions after almost every integer operation to implement trapping (-ftrapv in GCC and maybe LLVM parlance). This is sort of like a cpu architecture where dereferencing a null pointer is required to return 0 rather than trap. So either you have to either generate a bunch of extra checking code, or let software bugs go undetected for much longer than necessary.

I think MIPS had a similar issue but eventually fixed it. Maybe RISCV can do similar.
> 3200Mhz ECC RAM! In a workstation!

If 3200 is your RAM's stock speed, you can probably run it at least 10% faster using "DRAM Calculator for Ryzen".
Mars Bar Robot Chases Customers Around the Store and Tempts Them to Buy Candy
How does the speed talk to the car? How does the stirring talk to the coffee? How does flow talk to the river? How does the orbit talk to the planet? How does the flight talk to the airplane? How does breathing talk to the lungs?

All these questions make the same amount of sense: The mind is activity a part of the body (cf. the brain) is doing. It can stop doing it anytime. When it does, the mind didn't go anywhere; it stopped existing. Later the brain might start "minding" again, with a substrate of memories and sensory activity to direct it. If it gets damaged enough, anything we would recognize as thought can no longer occur.
Kube's main problem is that it's not quite grandiose enough, doesn't have a general encapsulation system.

So everyone which uses Helm. Which is ok, it works decently, but it's also, like, kind of a lot. The target that we've converged on is just a little too sophisticated to make shipping stuff accessible.

We need more grandiosity, in order to be adequately simple.
The old refrain:

EMACS - Eight Megabytes And Constantly Swapping
I don’t find this critique strong at all.

This essay seems to largely evade the main arguments brought forth by the hoaxers and retreat to attacking the imperfect mapping to Mein Kampf.

The hoaxers did not care so much that their paper mapped perfectly or even mapped well to Mein Kampf... the significance is that they got articles published and accepted in the first place, without having any formal education on the subject. Their writing was largely nonsensical and lacked rigor. Their statistics didn’t make sense, etc.

The author ends the essay stating,

“the gleeful efforts to humiliate other academics has nothing to do with a wish to preserve the integrity of science; it is an ideological and political crusade against an entire field of science simply because of its connection to feminism, social justice, and the fight for equality.”

This conclusion is completely undefended by the essay...
You can but only really one will have value

There are crypto punks on Binance / Tron but they are pretty worthless. Everyone knows which one is the real one

For most projects that go multi chain it’s all about wrapping. I.e the main item is on ETH but they are wrapped when on other chains.
It's not trolling, it's sarcasm, although with the crippling inability of far too many HN posters to recognize sarcasm, even when its glaringly obvious, I understand why someone might think it's trolling.
Yeah, well, survival instinct. They could never compete in a void. They need to borrow/interop with what everyone already enjoys.
if you need to do very large "IN" clauses, one option can be a global temporary table where you preload values, so instead of doing an IN you do a join against the GTT.
If you're not well equipped to refute the claim, why do you feel equipped to call it horrible, a conspiracy theory, and a harm to society? The notion that women are more selective than men is something I consider neither harmful, nor particularly far fetched.
The UK makes a convenient scapegoat.

The EU leadership, and the leadership of several prominent EU member states, have not handled the vaccine issue well. In contrast, at least on this issue, the UK leadership's response to the coronavirus has been relatively good so far, partly because it chose not to participate in the EU vaccination programme and instead made its own arrangements.

That would look bad for the EU leaders at the best of times, but in a newly post-Brexit relationship, the optics are particularly harmful. The virus has shown, in the most direct and personal of ways, that some criticisms of the EU made by the more reasonable Leave supporters in the UK did have elements of truth to them.

The almost Trumpian misrepresentations and doubling down from some of the EU and member state leaders in recent days might have been embarrassing and a cause for some friendly Schadenfreude in the UK media under other circumstances, but when people are literally dying as a result, there's no funny side, it's just awful.
Vi/m won the distribution war. It’s everywhere. It’s on every Unix-like system I’ve ever used.
3d Pasta printer
They call this out in the FAQ. Basically, extensions are too locked down.
Again... no technical details or information to back up your assertions. Just you stating it’s an “imposter chain” as a fact. At least I’ve proved that no one should listen to what you say on this subject.
The RISC approach to microprocessor design has been around since the 1980s, but the specific instruction set called "RISC-V" has only been around since 2010.
I sort of want to cure autism so I never have to see posts like this again, but I also don't want to lose /r/wallstreetbets... talk about a catch-22.

This isn't sarcasm, by the way; I'm genuinely conflicted.
stormqloud seems to have a bit of an axe to grind, so it's worth taking their words with a grain of salt.

Someone earning 60K USD in Canada (~75K CAD) would have a marginal income tax rate ranging from 27% to 38%, depending on their province. If they're a contractor, they'd have access to a bunch of deductions against their expenses. They could further use an RRSP to shelter their income, or at least defer taxes to future years with lower income, thus driving their average tax rate down.
It actually seems simpler for one person to do it than many. One person is much more difficult to notice and they would not inherit the sloppiness of everyone they would otherwise be working with. It really isn’t complicated. All they have to do is find one way in. This could be anything from throwing evil usb drives in the parking lot to mailing a free keyboard with a hardware-based keylogger. Also people that bring their phones to work could be carrying around something really old that can be compromised immediately on a WiFi network and then tries to worm anything in range of Bluetooth thereafter. Chain is only as strong as its weakest link and if a skilled motivated person is out to get you it’s a matter of time before they do.
Actually I would invert the problem: I wish nyxt itself were a webextension. IME Using a WebKit forks (or whatever) will always eventually be insufficient.
>your chances of actually fixing the issue you care about are much higher if you pick a reputable organisation to donate to, rather than funding actions directly

I wasn't questioning the merits of working in groups.

However, the only way to have done "due diligence" practically speaking is to engage with an organization that operates near you and deals with something that you have experienced or known someone who's experienced.

Meeting the people who work for an organization, volunteering your time to work with them, observing what they do in your community, is how you do due diligence.
I don't understand what you mean by saying each join creates a cartesian product. Join criteria avoid this. If I left outer join 7 rows on table A and 5 on table B and join on a unique key then I still only get 7 rows, not the cartesian product of 7x5 rows. I query across a dozen or more tables on a regular basis with aggregates, window functions, with statements, having clauses and so on. Performance is rarely a problem.
IIRC it was MaxRequestWorkers to 1500, and MaxConnectionsPerChild to 0 (unlimited)
No responses here note the likely role of FSD actively avoiding pedestrians. If FSD can objectively & significantly decrease injuries, need for crumple zones is mitigated. “No impacts” is better than “softer impacts”.
This is a bad comparison. "Duck hunting at the playground" is more similar to driving your truck through a playground than it is to hitting a pedestrian who enters a roadway full of active traffic.

Why should it be the driver's fault if someone else puts them in a situation where a negative outcome is unavoidable?
They bleed off energy, to the benefit of both.
Unfortunately these kits are unavailable from either digikey or mouser, because they include various obsolete parts which are no longer sold.

Here's the website for the book https://learningtheartofelectronics.com
Ask HN: Any libraries to animate AI avatars based on sound?
I would like for people to submit some photos from which we can make a 3D model, or even better to have their face mapped as they are saying certain things.

Then we would generate their avatar for when they are talking on WebRTC, so they don’t have to be present on video.

I realize the potential for abuse if the models were leaked or someone in our company was bribed, but does the technology exist today?

1. From photos on the web
2. From videos on the web
3. From interactively registering via webcam and face mapping
I am not an average american at all, immigrant, not fat, not white, not rich, stable job. But, I would perhaps buy CyberTruck because, I love Elon, Tesla, SpaceX. I also do not want to buy any of the Tesla cars, because I would love to keep the gas car for daily commuter. Truck only for the sake of owning a tesla. Maybe its just a wish, & I would never be able to afford a own (& pay installments) two vehicles at same time, but I wish I would buy CyberTruck.
Maybe the goodness or badness of a trait depends on context, and sometimes that hustle mentality is very useful, but other times is an impediment.
Loved the Rochester shout-out!
Gotta love the casual dismissal of his explanations, but you're a Musk fanboy, so it's understandable.

What he said makes sense. The tests get harder in order to ensure cars become safer. My car got the best safety rating when it came out, but that was 11 years ago. If Tesla hasn't changed its design for the 2020/21 models to improve safety, then my guess is it doesn't make sense for them to waste their resources testing it.
It takes years for tooling to improve and for industry designs to start making it out into the world. As more designs make it into end-users' hands, the tooling has even more motivation to improve.

I feel like that slow evolution can make it appear "suddenly popular" despite being around for a few years. =)
The Irish have always been white. Ireland isn't old enough for them to have been anything else.
On the other hand, Emacs keybindings are the default at every terminal.
The P-47 (like all American warplanes of this era) gave pilots a lot of control over engine performance. The P-47 pilot could adjust throttle, RPM (controlled by a governor that adjusts prop pitch), fuel-air mixture, turbocharger speed (controlled by opening exhaust wastegates), as well as control of the cowl flaps and intercooler shutters for cooling, as needed.

Conversely, the German fighters of this era were much more heavily automated. A Bf 109 pilot had a throttle lever: RPM, mixture, and radiators were controlled automatically (with manual overrides available).

If you ever look closely at the P-47's throttle quadrant, you'll notice one small feature that's pretty interesting. There is a one-way gate on the throttle lever that catches the RPM lever as it's advanced, precisely because without it, it was too easy for a pilot to (in the heat of combat) shove the throttle forward without adjusting RPM and blow the engine apart.
Somewhere in one of my old electronics boxes I have some nitinol that I purchased back in the 90s called "Muscle Wire". It came with a project book that had plans for "Boris" the walking robot but I only made a simple lever out of cardboard that lifted penny weights.

I may dig it up again as this machine looks really cool, although Im not sure if I can make a smooth enough joint in order to form the looped belt required.
It’s boiling water. What do you think will survive? The only reason not to do it is to maintain the habit so you don’t contaminant other things.
Interesting! Do you know how well Alfa Romeo handled Ferrari's engine in Quadrifoglio, compared to Maserati?
Because the attitudes about women that embodied in this kind of garbage are so abhorrent that they need to be called ou, debunked, and ridiculed. That's why my original point was that more attention needs to be drawn to this nonsense, so it doesn't quietly fester in corners of the internet.
Combining both approaches to safety would make Tesla look smart.
Quick website thing: Some part of the site crashes my iPad browser about half-way down. Feels like a lazy-load call.
I know Google tried to address this by giving Chrome its own independently upgradable certificate store and thought Apple would do something similar, especially since they don't have to rely on OEMs to push system updates.