skysight-inc/HackerNews huggingface dataset:
i would rather it written as SELECT * BUT or SELECT * EXCEPT or even SELECT ALL BUT.

SQL has always been that language that is easy to read. even when you don't understand what the queries are doing. adding a cryptic syntax like "-column" would make it less readable.
> It's refreshing to see a straightforward, well-formatted proposal (even if I do slightly prefer the `FROM table1 x JOIN table2 y ON x.fk` syntax suggested in other comments).

Thank you! /me feeling happy
It is lifted from C's struct tm. If you're maintaining tables of month names you're going to 0-index them so tm_mon is 0-based to facilitate that.
I commented below that I think it is like opening a CSV in notepad++ vs Excel. Same data, Excel just hides the commas. The commas are still there, though!
Oh, right, only freezing early layers makes sense. I was thinking you froze inner ones, but gradients would need to be computed and kept for them to backpropagate to the unfrozen early ones.
Even if it's not sterilizing, it does reduce the spread. Lower viral loads means less virus transmission.
I always wondered why there isn’t a config option in MTAs that tries to route an email over different other MTA‘s submission port and tries until delivered. I mean a automated setup not static rules you mention. This would make self hosted setups so much easier. The chance that someone blocked your cloud server‘s IP address 4 years ago and never bothered removing it is high.
Co-Founder of Twitch – Justin Kan's Gaming NFT Platform Goes Live
I'm pretty sure India and China are not on speaking terms.
Wireshark is very much a hot tool to handle already. To be in compliance with GDPR all the traces have to be dropped within the data removal grace period.
Making up words is fun for the writer, but it often not fun for the reader. Like the popular perception of poetry. Few people have a deep knowledge of their own language or other languages, so their inventions come across as childish.

Your own usage of “dags” is frustrating because as a reader from Australasia, “dag” has a common meaning. Example usages: “You’re a dag”, “Fred Dagg”, “rattle your dags”, “clean up those daggy sheep”. And back on topic, the common meaning in Australasia is not mentioned in the online American Merriam-Webster dictionary!
EXCEPT is already a sql keyword
Discussion among inpatient pediatric doctors about rising child COVID admissions with omicron:

https://np.reddit.com/r/medicine/comments/rpr28r/pediatricia...
You're not the only one: https://news.ycombinator.com/item?id=2320966 (2011)
Others have called out various bits of misinformation/lies in your post but I'll call out another.

We vaccinate children against a wide variety of things on a routine basis and a pre-requisite for attending school, and the covid vaccine is literally no more risky than those, and they aren't risky. It honestly feels straight anti-vax to make up lies calling it unnecessary and risky, especially with our health care systems once again succumbing to mainly unvaccinated covid idiots.
The article claims this boat is over 200'.
The goal is to produce real valued noise - you won't get that if the spectrum is not mirrored.
There indeed are people whose immune systems will attack and kill ticks.

https://eu.poughkeepsiejournal.com/story/news/health/lyme-di...
you are not alone !
(sometimes longer...)
I do not believe it is the exact same corporations, as China is the single largest contributor to emissions right now and they are not very friendly to the idea of foreign corporations acquiring a significant foothold in their domestic market.

However, I believe this discussion is completely orthogonal to the point I was making. I was not talking about the bulk of emissions coming from developing countries as some kind of moral judgement about developing countries, simply to state that reducing emissions in developed countries would not be enough - which means that reduced consumption in developing countries would be required, which would in turn mean condemning a significant amount of the world's population to perpetual poverty.
Yep, difference is that unfy automatically discovers all UNIX timestamps in any stdin stream and makes them readable to stdout, not just converting a single timestamp.
> The European reliance of course. Expecting a KGB agent turned warlord to sell key resource for a good price forever without any strings attached is just crazy.

The moment when Europe got screwed was Russia and China signing the $400B contract in 2014. Until then Russia needed Europe and Europe needed Russia.

Europe alienating Russia and China at the same time is Europe in trouble.
You would be better off creating a youtube channel . If fame is something you are after.
If the third party has their own IAM users, you can create a cross-account trust relationship where you allow their IAM entity to assume a (scoped-down) role in your account. Then they are able to retrieve temporary credentials to assume this role.
I think it would be impossible to train the model in the first place without that loss term.
Does it create a problem that other boats can't tell which rules a motor/sail boat are operating under?

In other driving rule systems, it's important that everyone can predict everyone else's proper behavior.
What about giving a more lenient sentence if the person is remorseful and admits what they did was wrong? Because that's effectively the same thing as a plea deal. Even innocent people would still sometimes admit guilt and apologize, destroying their chances of winning at trial either way, to get a shorter sentence.
Wow! That's certainly a good one. A couple old favorites of mine are:
mullet – a hairstyle that is short at the front, long at the back, and ridiculous all around, and
regift – to give (an unwanted present) as a gift to another person, in a process which is likely to continue almost indefinitely.
Like bring up to Amazon level conditions or actually something humane?
If you rotate your monitor, is that circumventing the DRM?
Way to take a way more complicated situation and pretend it’s simple cut and dry.
All of them, probably
I think you missed the point, people under 40 are not very likely to be hospitalized so why should they get the boosters.

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

In essence the same system we have with the flu is what we should have with Corona.

And then we can focus on some of the bigger problems such as Global Warming.
JS maps already have a well defined way that they do key equality: https://developer.mozilla.org/en-US/docs/Web/JavaScript/Refe... It's basically just strict equality (===), except NaN === NaN is false, while they're considered equal for map keys. So in your example, you'd have 2 entries, since {} !== {}.

It sounds like they're going to implement `groupByToMap` as well as `groupBy`, and I assume `groupByToMap` will just use the normal map key equality rules, and I guess the "first" key matching that equality will be used for the grouping.
(1) GoPro Hero10 has MSRP of 500$

(2) He (supposedly) couldn't save the plane, but taking the GoPro takes 5s.

> used a selfie stick in flight

Everyone keeps talking about selfie stick, it was just the normal leg attachment, not a "selfie stick": https://i.imgur.com/hOkcxOa.png

> "great footage of it" isn't a priority at all.

Where is this "Great footage"? He's literally just holding the camera by the leg attachment. Half the falling footage is just his feet or chest, and that's already the heavily trimmed version, which I assume he only kept the better part of the footage.

Again, to me it just seems like he grabbed whatever he could quickly and jumped out, which is a natural instinct.
Is this not something that should be written at the app level rather than dml?
The problem is that Apple can require that, their sub-contractors can agree and then just pocket the additional cash for it and not do it. Apple must more closely verify the conditions of its Indian subcontractors just like they had to do in China a decade ago.
Show HN: LogRegex – Find patterns in log files
I had a problem at work which required finding certain patterns in our log files. I figured that someone had built such a think (at least at a large log analysis company like Splunk), but I couldn't find anything.

I'm not sure how common of a problem this is for people, but I figured I'd try to build something to see if my solution even made sense. It turns out it works quite well.

Have you heard of problems this could solve, or projects like this? Please let me know! I put some decent effort into documenting the tool, but tell me if it's unclear.

Thanks!
I have seen prosecutors act like complete slime balls - from both parties.

Intimidating witnesses - misrepresenting evidence - omitting counter-evidence - over-charging defendants - denying timely access to council.

If you think this is about politics - you are mistaken. You just haven't seen all the other times defendants have been mistreated in court.
If a sailboat is moving under power it should be visually obvious that all sails are down, furled, etc.
Last summer, I noticed an odd spot on a leg of my female colleague when she arrived at work in a short skirt.

Fortunately, we are good friends and I could tell her without any kind of trouble.

Yes, she had a tick on that precise place a week before. Yes, it looked like erythema migrans, a typical early sign of a Lyme infection (borreliosis). No, she never heard about that and was a bit reluctant about doing anything about it. Yes, I persuaded her to see her doctor now. She got antibiotics immediately and seems to be fine.
You've covered a lot here, but just want to comment on a few things.

Factory functions can return objects that have a prototype just the same as "new", there is no inherent reason object constructors should require "new". Given that most of modern, idiomatic JS relies on factory functions, it seems very inconsistent to me to then randomly require invoking "new" to construct an object.

Why not simply Set([1, 2, 3])? The noise comes when you have a nested expression with random "new" statements sprinkled in which disrupts the flow. Though I agree that overly complex expressions are an anti-pattern

My underlying point is that "new" does not provide any clarity, given that objects are created and returned all the time without "new", so represents an inconsistency in design to me. The presence or absence of "new" basically tells you nothing, except implying that the object likely has prototype functions. But whether or not they are prototyped is more of an implementation detail anyway.

I agree with you that most of Temporal has factory functions that obviate "new".

To your point on performance of closures, this isn't going to materially matter for majority of use cases. Yes, prototype is more efficient than closures functions, but benefits of prototypes can also be achieved through separation of data and function (singleton utility functions that operate on data).

Also syntax sugar for prototype could have been done in an (IMO) more consistent way through some syntax addition to functions rather than creating class. Generally modern userland code shouldn't really be using prototype and "this" anyway, as "this" has tons of footguns in JS, and I would guess majority of developers don't understand the intricacies of "this" when passing functions around, or when using arrows vs classical function declarations.
I thought it was going to be a robot for cleaning toilets .
"And the world's second largest economy now faces food uncertainties due to factors such as its deteriorating relations with the U.S. and Australia, which could drastically alter the import environment. In fact, this could be what is prodding China to boost its calorie reserves." and "Less than 20% of the world's population has managed to stockpile more than half of the globe's maize and other grains, leading to steep price increases across the planet and dropping more countries into famine." - TLDR for the whole article, also seems like lately parts of the world including China is experiencing food uncertainties:

https://www.oecd.org/newsroom/rising-uncertainties-from-covi...

https://www.cnbc.com/2020/07/15/floods-coronavirus-create-mo...
Do you also wear a helmet while driving? Your tolerance for risk is pretty low it seems.
It depends on when it was posted: ttps://stackoverflow.com/help/licensing

>Content contributed before 2011-04-08 (UTC) is distributed under the terms of CC BY-SA 2.5.

>Content contributed from 2011-04-08 up to but not including 2018-05-02 (UTC) is distributed under the terms of CC BY-SA 3.0.

>Content contributed on or after 2018-05-02 (UTC) is distributed under the terms of CC BY-SA 4.0.
This set up is much more secure than online password management.
Tools like Prettier can automate this with curly-brace languages, so indentation (tabs or spaces?) stops being something you waste brain power on, similar to how code editors will match the current line's indent on the next line when you press enter even though it's just "press tab a few times". It adds up.

// just copied some code into this while block, oops I copied an extra space out front...
while (...) {
if (...) {
...}
}

// after Ctrl+S tied to autoformat
while (...) {
if (...) {
...
}
}
A 200+ foot superyacht is not going to be owner-operated.
Yes, although crude oil is a much bigger strategic necessity for China. It imports about 75% of what it uses.
Well, so do 95% retail banks across the globe.
I'm confused about the first point. Is it simply restating that Fourier coefficients are complex numbers?
Visual Tutorial NER Chunking Token Classification
Perspective: Before 2018, the top US export to China was soybeans, which was “appropriated” from the Middle Kingdom ca 1764.
Laws that are vague are superseded by laws that are more specific.
Does the book talk about one among the dangling questions the author posed but didn't answer: how simultaneously, whole promising branches of the "gift economy" structure have never been explored.?
I know, when I was young we didn't even have a car so bike was the way to go (or bus but bleh)

But I lived in a quiet area, I could imagine kids in central Amsterdam wouldn't be trusted to cycle to school at that age. Though there schools are everywhere too.
The lack of free will is something that I came to realize in my 50th year on this planet. I still believe in randomness, though, just that we don't actually have any control over anything, at least not in a free will sense. I also kinda believe our consciousness is a passenger in the meat bodies of another entity and we are just following along, with the illusion of control. Kind of freeing, actually.
They *need* to go into great detail if people are supposed to trust them with their digital life. That statement isn't nearly enough.
combine that with lastpass' history of security mistakes, the people in on hn claiming that they didn't reuse the master password, and the press releases gas lighting their users, I'm not buying their story for a second.
They walk a very fine line. It seems like a difficult balancing act of compliance with regulators while appealing to users who expect hyper inflation and envision a libertarian utopian future.
There's a setting on my TCL Roku to change the start-up behavior. By default it opens the Roku home screen, but you can configure it to open a specific input, or the last used. Settings > System > Power On

It doesn't allow you to pick an app to open by default, which I think is a big miss.
It might be just me, but I feel like remembering the foreign key name is more difficult than remembering the columns that you need in the ON clause. Especially since you can usually find the column names by just seeing the data in the table (select * from x) wheres seeing the foreign key names is much harder (show create table x?).

Also, if you use an ORM it will usually generate foreign key names that are almost impossible to remember.
Does this directly contradict this claim? (Not to mention how old this article is... )

US children hospitalized with COVID in near-record numbers
https://apnews.com/article/coronavirus-pandemic-health-pande...
(that is an ugly ugly link, apologies even though there's not a lot I can do there)
> They wanted to save N95s for professionals due to a shortage. They lied.

That's certainly a plausible interpretation of what happened. Another is they actually thought masks don't help in most cases and that covid wasn't primarily air-transmitted.
Yep this is important; Polio presented a lot like the flu, it wasn't until years or decades later that symptoms showed up. They didn't call it "long polio" though, they called it "post-polio syndrome". Famous author of 2001: A Space Odyssey Arthur C. Clarke ended up in a wheelchair decades due to post-polio syndrome after he contracted polio
Very interesting. And there are tDCS home kits for $149, e.g. https://apexdevice.net/shop/apex-type-a-4ma-std/. This is low cost enough that I'm willing to give it a shot. Worst case, I end up with a decent DC current source that I'm sure I can find a use for at some point.
Ok I'm surprised. I don't think anyone here in Europe flies without a radio. If only just to monitor local traffic. Most of the flying club members even carried backup portables. I didn't proceed to my full license so I never did. But I did have lots of ham radios on which I could receive (not transmit) the airband if needed.
There is a test for that ( and for heaven's sake -- doctor is where you go for awkward conversations to begin with ) and I genuinely resent that the real reason is being hidden from me as a parent. How on earth am I supposed to make decision if I am getting inaccurate information? Or more importantly, as a non-doctor, why I am I forced to learn all the things I should be able to trust my healtcare provider with? Why do I have to peel the onion for various agendas for something this important? I swear.. each day it seems healthcare starts to resemble Office more and more..

It is infuriating.
Don't know about the fees, but I fully agree about the buggy (and confusing) UX. I certainly wouldn't use it if my employer didn't force me to...
They aren't behind. They don't need it. Why bother maintaining another app when almost all the intended audience is on iPhone and the app (albeit simulated and not with a great experience) works on iPad anyway.
I wonder how much of that has to do with the fact that ISO8601 was relatively newer back then (published 1988), and date formats were much less standardised 20+ years ago.

For instance, RFC 1945 (HTTP 1.0) specifies three acceptable date formats. Add ISO dates, and now you're writing software that needs to handle 4 different formats. Easier to just use a heuristic parser that's capable of accepting HTTP, email, Usenet, and ISO timestamps.

Fortunately, these days it's generally considered a bad idea to use anything but ISO timestamps, with the exception of a former colleague who tried arguing that DD/MM/YYYY was an acceptable format to be transmitting and storing dates in.
I really expected to see a comment here asking mods to update the title with the year of publication. I did not expect that year to be 2021
Aaron Swartz and the Brain-Gut Connection
"Why I have no favorite programming language"

https://ilya-sher.org/2017/10/10/why-i-have-no-favorite-prog...
This feels like adding syntactic sugar in some sense. That is, a layer of convenience to accomplish something that can already be accomplished today.

It also breaks the following:

* It's better to be explicit than infer
* Keep specifications simple
GP seems to claim that, with sails spread AND motor running, it has to follow power boat rules despite looking the same as when it's just sailing.
But then why should the average of zero items be zero? It still seems like just an arbitrary choice to me.
Poe's Law in action. Any elaborate parody not clearly marked as such will be taken seriously by someone.
This article is from before Delta and is way out of date. Even at face value at the time, the numbers show that covid is worse than the flu in terms of pediatric deaths. And that was pre-delta and now omicron. Things are likely better now that kids can be vaccinated but even at the time this was a nonsense argument from NPR.
enron maydolf haliburton its literally everywhere you look
It never said whether or not he had a radio AFAIK.

We were just philosophising whether he had one or not.
Recent and related:

Reporter who told Missouri officials of website flaw did 'nothing out of line' - https://news.ycombinator.com/item?id=29098289 - Nov 2021 (190 comments)

Gov. Parson releases video attacking newspaper for viewing HTML - https://news.ycombinator.com/item?id=28980855 - Oct 2021 (26 comments)

Gov Parson pushes to prosecute reporter who found security flaw in state site - https://news.ycombinator.com/item?id=28946392 - Oct 2021 (525 comments)
Cars are mandated to include safety features and undergo testing to be deemed safe. This was not done of the car companies' own volition. They were forced to adhere to safety standards. An obvious example of which is to include seat belts. Now every car company boasts about how safe their vehicles are.

Of course I'd wear a helmet while riding a bike. Have you seen what a sidewalk can do to a watermelon?
Everyone else in the world writing CSS has to jump through the same hoops they are referring to... does that really fall under "single data point"?
Of course it should be a api but it should be either explicitly requiring a format OR (more likely) default to an invariant format.

That is, if I do this

float f = 123.456;
Console.WriteLine(“value is “+f);

The output shouldn’t vary depending on whether it’s run in France or the US (which it does by default).

For parsing, the argument should even be explicitly required I think. So

float f = Float.Parse(“1,23”, frenchLocale);

So that it’s not ever forgotten or the reader has to wonder if the author forgot it.
Parson is clearly a bad actor. View source is not a crime and it is prosecutorial misconduct — ESPECIALLY when informed by a professional that no network intrusion occurred — to charge anyone for it.
That is a really interesting case. Correct me if I'm wrong, but I don't think this is a special case where you have to use `NATURAL JOIN` over `JOIN ON`. The problem is just that the Postgres SQL grammar (maybe most/all SQL grammars) require ON or USING in a non-NATURAL join, so you have to specify the (empty) equijoin predicate list yourself, i.e. the identity value: `JOIN ON TRUE`.

EDIT: I had another thought about this.

I think people not designing with the relational algebra in mind is the heart of the issue, specifically w.r.t. column names. We know that namespaces are a hard problem, and a consequence of that problem is that `NATURAL JOIN` as specified in the relational algebra seems risky, or overly magick-y. It makes what might be an unfortunate coincidence (name collision) into something algebraically impactful.

A foreign key join gets around the problem by keeping names and namespaces out of it. It's really doing exactly what `NATURAL JOIN` is supposed to do, but only in the subset of cases where name collisions are meaningful, not coincidental.
No argument here.

Pepper on top that I know when I have an expensive toy I don't want other people telling me how to use it.

The bigger problem was how close they come to smaller vehicles, at speed, without a care in the world. When I saw that pro-Trump flotilla running at speed, my first thought was that somebody was going to get swamped. Sure enough, a bunch of little boats sunk that day.
It seems naive to think that clicking “buy” for any digital good which you have to stream from somewhere is akin to owning it. Is the owning platform expected to maintain a server for you to stream the item until you’re dead, until you pass it on to your children? You clearly don’t own it like you own a DVD, it seems like a mismatch of expectations.