skysight-inc/HackerNews huggingface dataset:
I agree that Spider queries are not necessarily representative of the SQL you might see in the wild from real users, but looking at some analysis I did of the dataset around 43% of the queries had joins, and a number had 3, 4, or 5-way joins.
> Hottest surface temp recorded on earth was 56.7C, no?

Hottest air temperature at just above surface level; excluding several localized extremes like measurements around vulcanos or asphalt roads.

Asphalt surfaces can easily reach 60+°C on days with direct sunlight and little to no wind, and vulcanos supply new surface all the time with temperatures far north of 100°C.
Does this apply to my AWS machine with a misconfigured Docker container?
I don't think the population of China is "largely uneducated" in the sense that began this thread. It is not rare for Chinese kids to go to school, and those schools are not only used for job training.
Thank you for posting this. I've seen it a few times already, but I'm watching it again, and it's cracking me up, yet again.
This is a great read (the thesis is both complex yet legible by a layperson) and an exciting future for vector shape rendering.

I have been wistful ever since the Mischief drawing app died, and look forward to implementing some sort of GL canvas so that I can relive the Mischief experience.
No, you're not, you're making a decision to talk about your work experience with the other manager. Coworkers can talk to each other about work, what people work on is not secret information
In general one problem with that request is that it’s possible to specify times that might not actually happen.

2030-03-24 01:30:00 Europe/London seems like a perfectly reasonable time stamp. But if the UK decides to move BST forwards by a week between now and 2030, that time won’t ever happen.
Have you found a better alternative for someone who trades a lot? I'd like to drill down into trade results per symbol and get ROI statistics and visualize past buy/sell points.
> you'll need to manually tag sync/blocking effects

Well, that's the hard part, so if I need to do it myself, your library isn't providing much value.
> And yet when it happens

When it does happen, like any other mistake, it should be corrected. Just like if someone put secrets into git, it should be explained to them why they shouldn't do that, and an expectation should be set not to do it again. If the individual fails to meet that expectation, disciplinary action should be taken, up to and including termination.

I've in fact had this happen to a developer who took PR comments personally. The rest of the team was very glad to see them terminated. Fifteen minutes per day adds up to a lot, and I'm quite sure it's more for staff whose roles are heavier on communication or those for whom anticipating people's feelings comes less naturally.

> rather than fearing being rebuked at each turn

My point is that a fear of professional criticism is a fundamental flaw in a professional, one that should be corrected to the benefit of the individual and the organization. A leader who refuses to correct this flaw in their reports is holding back their professional development and failing in their role as mentor. One should experience nothing but sublime gratitude that one's mistakes were found and corrected before they caused any damage.
I can see how it comes off that way, fair enough. But I'll clarify:

Abuse can be subjective and you shouldn't be abused based on your personal lines of abuse, which I of course cannot decide. If you are not comfortable in your work environment and have the capacity to leave, I hope it isn't a controversial take to suggest leaving. full time work is a good chunk of your life after all, and abuse will bleed into the other parts of your life even after you leave for the day.

If you have intrinsic reasons to stay despite having that capacity to leave, then I suppose you value those reasons above your personal mental health. Which is unfortuante, but your call.

----

This goes a bit beyond the topic of compliments. But such a topic seem to bring so many experiences of office politics out in this iteration of discussion, so I felt it be worth mentioning. As I edited in my above post, this post feels a lot more "personal" than the discussion 3 years ago.
Fascinating, thanks for the explanation! Makes me wonder if anyone’s tried building a MOO in Erlang/Elixir or another actor-based system. (Though I’ve probably misunderstood how they’d help with the problem.)
I think you've fallen into the trap of "AIs don't generalize, they memorize." But they do in fact generalize. The reason ChatGPT is so valuable is precisely because it can help out with situations that have never been seen before, not because it merely unlocks old preexisting knowledge. The fella who saved their dog with ChatGPT comes to mind. https://nypost.com/2023/03/27/chatgpt-saved-my-dogs-life-aft...
"Less competent individuals embraced cynicism unconditionally, suggesting that—at low levels of competence—holding a cynical worldview might represent an adaptive default strategy to avoid the potential costs of falling prey to others’ cunning."

That's rational behavior when the rate of incoming scams is several per hour or worse. The processing load imposed by today's sheer quantity of scam input is huge.
I hope some mega billionaire is printing all the books and Wikipedia to metal tablets and storing multiple copies in hidden caves around the world, and in low lying areas where the coming floods will hide the tablets and reveal them again when the seas recede in millennia to come.

On a different topic... this episode of the "Fall of Civilisations" podcast is where I heard about the Library of Ashurbanipal.

It's probably the best podcast episode of all time on any topic that I've ever listened to:

https://podcasts.apple.com/gb/podcast/13-the-assyrians-empir...

3.5 hours long!

"Fall of Civilisations" probably being my favorite of all podcasts.
Yeah, I agree it's all about lifestyle choices.

How many people who "can't get ahead" stay in their own city all year long to avoid paying for traveling. How many eat out for most meals instead of cooking all their meals. How many eat multiple meals per day instead of saving money by eating less. How many pay rents or expensive mortgages instead of using a PO box as their residence and living in a tent to save money.

There's no problem with affordability, let's point the finger at people who have relatively modest desires and point out that it's "lifestyle creep"

/s
Why are GPU drivers baked into the kernel?

Wouldn’t it be better to load them in such a way that a crash in the GPU driver can be recovered from as opposed to crashing the whole system?

Other operating systems load the GPUs drivers separately.
Saints Row developer Volition has been shut down
My first one had to replaced after about 6 or 7 years. The plunger rubber had gotten worn down, and the internal wall of the brewing compartment had become blistered from hot water (I used 170-185F water). The new one with different materials seems to be holding up better.
Agreed, but I haven't heard good alternatives. Some form of crowdsourcing might be the way to go?
I think these are both orthogonal arguments. @p-e-w is arguing for tools that neatly and simply compose workflows, while you're arguing for independence of tools set.

Let's explore further.

> It's a huge leap to assert that Unix tools don't implement the Unix philosophy because a specific example doesn't work in the exact way you expect it to.

Fair statement, but it's never just one example. It's tonnes of examples that can be made. There are groups of tools whose sole function is just to help stitch other commands together (I.e. getting ls and rm into the same workflow). It works, but the point being made is that it could be better.

> You could just as well implement a version of `rm` that parses stdin in a specific way by default, but that would likely make it work for that specific use case, and not in the generic and composable way the tools are meant to be used.

I would argue this is _exactly_ what's happened - just that it isn't for only rm, but a whole common subset of tools to bootstrap a new way of working. Your exact argument works still for nushell, if someone wants a new tool for rm (or the legacy one) they could still plausibly do that - and your point above would still hold, it would completely defeat the purpose of nushell, as suddenly _where_ doesn't work. That same argument however applies for current shells... If I suddenly swap out rm, my scripts at some point are going to start failing. Unfortunately we're tightly bound to an environment and ecosystem based on legacy decisions. There are plenty of examples of how that's played out with technology in other ways (for good and bad) - the question should be, is this the right evolution?

> That doesn't mean that we can't do better, but I'd argue that a monolithic shell with a strict contract between commands is not the way to build a sustainable and future-proof ecosystem.

I would point out that no good reason has been given for no contract in existing shells? Or maybe we should observe that there is actually a contract, but it's just a lot less structured. To the point that the contract is just an agreed historical structure that popular individual programs are expected to use. Regardless, a contract isn't a bad thing, especially when it's done correctly to balance flexibility and structure.

I'm not convinced nushell is the way to go, but I would prefer the debate not to be muddled. Sure current shells have done fine. We expect future shells to do better. Will they imbue the Unix philosophy perfectly? Well like any good philosophy that will be up for debate.
Usenet doesn't have a UX by itself, it's a protocol. The user experience is entirely dictated by the software used to access it. And Outlook supported Usenet all the way from the word go. Macs didn't even come with any email clients back in those times, but popular ones supported Usenet and there were also Usenet-exclusive programs available.
Evaluating the fairness of computer vision models
* Meta open sources Dino v2
* Meta releases Facet, a tool for evaluating computer vision models
All observed resistance mechanisms (so far) work via active counter-measures, such as additional ion pumps, and they reduce the fitness of fungal cells as a result.

No, if it allows the organism to survive, it increases fitness by definition. "Survival of the fittest" does not mean "All those fungal cells who went to the gym and ate right and look like Arnold Schwarzenegger get to live because they are so beautiful." It often means the equivalent of drug addicts on skid row, so long as they live longer with the "bad" choice than without it.

Sickle Cell Anemia reduces fitness compared to people without the disorder -- unless you live someplace with malaria and no effective treatment for it, in which case you live longer if you have Sickle Cell Trait than if you don't and, gee, too bad, so sad that having two copies of the gene is so torturous and debilitating.

Survival of the fittest is a war of attrition. It's last man standing no matter how awful he looks or terrible he feels.

It's not we can build a better organism if we plan this in advance, one that is stronger and faster and prettier.
Daily Life Among the Jupiter Brains (1999, PDF)
I'm with you. I really despise web based apps and I really loved having a native app experience with usenet. Google groups was a UX regression and I really would just love to have a native news reader again.
He mentions in the video that he's including the time taken to transfer the data to/from the drives on either end.

SD cards are too slow, taking as much as an extra day to copy the data on either end. These specific USB drives can saturate usb 3.1.
so scrum is a symptom of a company that nobody should want to work for.
I don't know that I should be angry or relieved that I only got half of them right. I've been working with AWS since it existed.
On the topic, I can absolutely recommend this sublime episode of Fall Of Civilizations on the Neo-Assyrian Empire: https://m.youtube.com/watch?v=jpAphcaVJIs
> The elephant in the room here is that these LLM's still have problems with hallucinations. Even its only 1% or even 0.1% of the time thats still a huge problem.

If you heard the bullshit that actual teachers say (both inside and outside of class), you would think that “1% hallucinations” would be a godsend.

Don’t get me wrong, some teachers are amazing and have a “hallucination rate” that is 0% or close to it (mainly by being willing to say they don’t know or they need to look something up), but these folks are the exceptions.

Education as a whole attracts a decidedly mediocre group of minds who sometimes (often?) develop god complexes.
A fun way to learn about your users
are you a product person like me, and hate product onboarding surveys? marketers need that info, while product folks know every individual question increases drop-off in usage.

well, here's a fun way to give marketers the same info but in a way that users love. it's a daily trivia game.
I've always been interested in these fintech APIs but wonder what competitive advantages the companies that build on this have compared to one another. What differentiates a company building on this from another company building on the same API? It seems like the execution would differentiate them the most? I feel like I am missing something here. Could someone enlighten me?
but I want to make a bunch of money like the San Francisco AI people.
I got a kick out of this passage:

> At times, Fourth Wave innovations verge into the realm of obsession, making you wonder how much real difference all of this precision makes to a cup of coffee. At the end (or beginning) of the day, coffee is a ritual. More than mere caffeine delivery, these technologies enable a multi-faceted sensory experience. Exploring the complexity of its flavors and aromas has transformed coffee from an article of consumption into an open-ended object of scientific and aesthetic experimentation.
Those are two separate discussions. Even if I do something dumb and am rightly blamed for it, we can still have a retro to discuss process improvements that would make it harder for that mistake to happen again in the future.
411 on the 909: https://www.dictionary.com/e/slang/909/
Humans are guided by emotion.

Public opinion will swing back in favor of nuclear power as more and more people grow up without having known the disasters that were Three Mile Island and Chernobyl first hand.

Kids these days don't give a shit about Chernobyl - And Fukushima was already more than a decade ago. Most 30 somethings are most likely not even aware of the Harrisburg accident.

What they do know is that their apartments are smaller than their parents were when they were their age. They can't afford to drive cars like their parents did and they can barely afford to pay the electric bills in the winter.

At the same time they are well informed about the causes of climate change, an enormous release of green house gasses into the atmosphere, to power the economy. So what else is there to feed the economy with energy? Wind & Solar? Get real. The obvious solution is to run those electric generators using steam turbines fueled by uranium.
Yeah, that's wild.

I imagine that on a physical vintage PC with a spinning rust hard drive (rather than in an emulator with storage presumably backed by an SSD) we'd be looking at a 1fps slideshow or less.

But, maybe I'm wrong! Maybe things would fit into the HDD's onboard cache and it would perform OK.
just commented to write this as well. By coincidence, I have listened to the Assyrian episode today. There is really nothing like it. I also recommend the youtube videos of the same podcast. They are really the perfect companion to this incredible history podcast.
Regularization of more Flake outputs into schemas sounds compelling. E.g. thanks to this great work on flake schemas, do the definitions of outputs related to NixOS modules, NixOS configs, and nixpkgs overlays even need to be pre-baked into Nix?

In terms of this decomposition effort, one additional thing that would be really nice to see would be turning flake URL schemes & updaters extensible. One could imagine some kind of a dictionary that maps from schemes to derivations that contain the code needed to get the primitive URL for the "latest" version of the flake when an update is called for.
They're downsizing. "This venue is smaller in size than the San Mateo Fairgrounds, where we've previously held Maker Faire Bay Area. It will limit the number of makers exhibiting as well as the number of attendees per day."[1]

[1] https://boingboing.net/2023/07/12/maker-faire-is-headed-back...
>Google search. Before, it was a resource for you to customize and find what you wanted: information about medicine, a product, or a store. Now, it Comes To You. You search for thing X, you end up in a rabbit hole of Y and Z topics or things, and a lot of things seem algorithmically generated or manufactured to steer you rather than help you.

This is because "recommendations" are a big business. For example YouTube generates billions of views from recommended videos and God knows how much revenue. But I think recommendation algorithms are counterproductive from the business point of view because you will sell less ads if your platform content creators figured out how to get recommended by recommendation algorithms.

On the other hand recommendations are good for users because they will hopefully discover new content that they like. Platforms just need to be more flexible and offer their users tools to tweak recommendation algorithms according to their preferences.
I was the primary maintainer for one of the services they asked about, and I still got that question wrong. 4/20 for me, but three were lucky guesses
What's Inside ––Begin (RSA) Public Key–– Files?
With increasing drought and general weather variability, I wonder if they are still reliably provide a base load. For an extreme case, see Lake Powell drying up so much last year it generated little power: https://www.cnn.com/2022/04/30/us/west-drought-lake-powell-h...
What should be your no.1 objective in cyber security
There are two styles of public key, both with Base64 between the boundaries:

-----BEGIN RSA PUBLIC KEY-----
-----END RSA PUBLIC KEY-----
and
-----BEGIN PUBLIC KEY-----
-----END PUBLIC KEY-----

The top answer gives a stellar explanation of internals in response to OP asking how to convert between them.

For the former (older) format, there is this overview in the middle of the post:

> [This is an] PEM DER ASN.1 PKCS#1 RSA Public key

> - PEM: synonym for base64

> - DER: a flavor of ASN.1 encoding

> - ASN.1: the binary encoding scheme used

> - PKCS#1: The formal specification that dictates representing a public key as structure that consists of modulus followed by an exponent

> - RSA public key: the public key algorithm being used

Trivial!

I really appreciated the explanation of all these terms in one place, even if I question that PEM really just means Base64 it is likely a useful simplification.
I think my aunt is great and much cooler than my peers.

I object to this weird anti-family culture. I don't give a shit what is "cool". It's a made-up concept, unlike family. Family has my back, and I have theirs. But I guess on "social" media being social isn't cool.

There's nothing more natural and important than socializing with your family.
https://en.wikipedia.org/wiki/Eric_Rudolph

> His stated motive was an opposition to "the ideals of global socialism" and to "abortion on demand," both of which he claimed were condoned by the United States government.

> At age 29, Rudolph perpetrated the Centennial Olympic Park bombing in Atlanta, which occurred on July 27, 1996, during the 1996 Summer Olympics. He made two anonymous 911 calls, warning about the bomb before it detonated.
So what?

From Snopes:

A story about Musk's father once owning an emerald mine evolved into a larger rumor that had no evidence to support its central claim.
> if your AuthN and AuthZ is down, what else would you do ?!!

Minor miscommunication… from a write standpoint. Obviously if you can’t auth, you are in trouble. But if the billing needs to happen so you can restore a permission, then you need to hit a card (for example) and then somehow update your authz service.

In most cases, it’s not strict availability that’s likely your problem (eg. Full down, no responses) it’s going to be business logic or config issues impacting a small subset of TX.

And, honest, if I’m so wrong about this, where is the XA distributed transaction coordinator for Cognito?

I’d be shocked if Amazon ever implemented a single-point-of-failure distributed transaction coordinator and exposed that from their services.
The user was talking about internal group politics/drama. Not national electoral politics.
at aptible - we prefer fluentd. one of our engs talks about the reasons why in the article above, but the tldr is fluentd is extensible like logstash, but far better performance
Outlook is one of those anticompetitive Trojan horses Microsoft has gotten away with, and I still don't understand why.

For example, a few years ago, they had this functionality in Exchange that would only work if the receiving client was Outlook. On anything else, you would get a partial message plus some non standard binary attachment.

And good luck if you want to export all your emails from Outlook to another client.
Emoticons from 1893
> There's zero value in reading Shakespeare or Lord of the Flies from a "labor preparation" standpoint.

There is zero labor prep value in learning to extract information from text (that you possibly have no interest in reading)?
Any amount of time feels like too long to wait for a brew ever since I got one of these:

https://www.zojirushi.com/app/category/water-boilers-warmers

(To answer the question an inquisitive reader may ask: the keep-warm setting of the model I have uses about 25-60 watts average at room temp 73degF/23degC depending on volume and selected water temp) [1, pg5]

[1]: https://www.zojirushi.com/servicesupport/manuals/manual_pdf/...
In my country, you did not have to use area codes when dialing a local phone number. I guess you had the same experience
If you are interested in this kind of stuff, check out C*NET aka CKTS or Phreaknet. Or maybe the Connections Museum on YouTube. There are a surprising number of people doing weird stuff with old electromechanical switches or emulations thereof.

https://ckts.info/

https://portal.phreaknet.org/

https://www.youtube.com/@ConnectionsMuseum
Where is that hosted?
And have You managed do somehow automatize it in the end?
>redditism

Weird comment considering I'm explaining a point of view that many people on several social networks have. There are plenty of thoughtless knee-jerk comments in this thread in support of several different positions. Mine is not one of them.

It's also weird you're framing me as endorsing authoritarianism when I explicitly said how and why the position I outlined doesn't do that. There is nuance here that you're missing.
I have both of my credit cards and my bank set up to email me with every single transaction. So even if I forget to cancel a subscription it's only going to ding me once to make me remember to cancel.
What you mean to say is that time and time again, users do not want what causes them to maximize engagement levels and click on the most ads. "Users said they wanted this feature, but we implemented it and engagement didn't go up," doesn't mean that the users lied about what they wanted, it just means that they don't want to use the product in a way that requires a lot of wasted time.

TikTok users say all the time that they want the option to see a feed of videos from people they're following, in reverse-chronological order. They're not lying. The issue is that the reason they want that is so that they can use TikTok for a short (30 minutes or less) session to check for updates on things they actually care about and then close the app, which would be entirely contrary to TikTok's fiscal goals.