skysight-inc/HackerNews huggingface dataset:
> I think SQL is irritatingly non-composable, many operations require gymnastics to express

One approach to radically simplify operations with data is to use mathematical functions (in addition to mathematical sets) which is implemented in Prosto data processing toolkit [0] and (new) Column-SQL [1].

[0] https://github.com/asavinov/prosto Prosto is a data processing toolkit - an alternative to map-reduce and join-groupby

[1] https://prosto.readthedocs.io/en/latest/text/column-sql.html Column-SQL (work in progress)
Yeah see I tend to view religious claims as metaphorical or allegorical. I spose a fundamentalist perspective renders my point moot.
I think even if science kills the factual claims of a religion it cannot touch the metaphorical or value based claims.
Ask HN: Study Tracking and Notes Tool
I am going to start studying for an huge certification and I would like to ask what are the best tool for taking notes and keep track of studying progression. My idea was to take note in Markdown and then upload to Github/Bitbucket. The only missing point is the lack of a native diagram tool.
Do you have any other suggestions or do you want to share with me your tools/workflow/experiences?
Interesting. I wonder whether "repaying a debt you feel but are under no legal obligation to repay" should qualify as altruism. (It feels altruistic to me.)
Kubernetes – Kubernetes
Note that this says nothing about long term consequences, i.e. Long Covid, which we've only just started acknowledging when it comes to adults.

Polio was asymptomatic in 95% of cases and most of the symptomatic cases were unspecific and mild, but now we know that it can be followed by the much more severe Post-Polio Syndrome even 3-5 decades after the original infection, which may affect almost 30% of all cases, including the asymptomatic ones.

That children are unlikely to die or have severe complications from Covid doesn't mean it's safe to allow children to be infected, even if we ignore that this could make them asymptomatic carriers infecting at-risk family members who may not be able to get vaccinated for health reasons.

EDIT: If you find the time to downvote this comment, also check out nojito's link to the paper about Long Covid in children: https://news.ycombinator.com/item?id=27793752

If the lower estimate of 20% of Covid cases resulting in Long Covid are right and we lift hygiene restrictions for children because of their "low risk" for hospitalization, that means we could see Long Covid in up to 20% of the population under 12 (assuming vaccinations become available for ages 12 and over).

And that's assuming the data about "low risk" is interpreted correctly. The article states that 25 dead in 12 million children translates to a death rate of 2 per million (or 0.2 in 100,000 if we want to use the same scale used for numbers about the general population) but this wrongly assumes that all of the 12 million children have at some point been Covid positive, which seems impossibly pessimistic given that there have only been 5 million recorded infections in the UK across the entire population.

For comparison, the ONS report[1] estimates roughly 1% of children between age 2 and school year 6 (age 10-11) having been positive with no data on ages younger than 2. This would take the number from 0.2 in 100,000 to 20 in 100,000 -- compared to the total mortality of 228.6 in 100,000[2].

In other words, it looks like children are only 1/10 as likely to die as adults, not 1/1000 as likely.

Also, the article only considers the 25 children who directly died from Covid, not the 36 children who were tested positive but died from "other causes". I'm not sure if this has changed in the UK given that you often read about "deaths within 28 days of a positive test" now, but at least for most of 2020 these 36 children would have counted towards the total death count as I understand it. If we compare the 20 in 100,000 (or 20.8 in 100,000 if we want to be pedantic about rounding) number to the "deaths within 28 days of a positive test" number we actually get slightly more than 1/10 because that rate is 192.2 in 100,000.

[1]: https://www.ons.gov.uk/peoplepopulationandcommunity/healthan...

[2]: https://coronavirus.data.gov.uk/details/deaths
Was just watching Youtube video Veritassium about the non-existence of learning styles yesterday.

I wonder if similar studies would show that there really are no introverts vs. extroverts in the sense that all people really have roughly the same need for human contact.

Kind of like everyone needs physical activity, but some people gravitate more to it than others.

Probably the wrong forum to voice such a theory...
You can't create a successful wiki alone. Get others bought in and contributing. Nothing worse than spending time on a Wiki that just rots from inattention.
See also this graph of annual nuclear vs. (non-hydro) renewable generation, in TWh. Now extrapolate that renewable curve forward 10 years, to when any nuclear plant that was started today might be coming online.

https://i.imgur.com/HLUmcDk.png
I think that's a tough question.

The replies that suggest just yourself, people like you, friends etc don't provide satisfaction to those people who gain the most satisfaction from building things large numbers of other people want to use and ideally enjoy using.

I'm happy to write/build little things for myself, friends and other small groups up to a point. But the motivation is limited. I don't see myself putting in 1000 hours polishing something like that, as it feels like a waste of limited lifespan. It's just not fun.

Whereas I'll happily put in 5000 hours to a project that I feel is, or could be, making a noticable, useful and liked difference to the lives of millions of people. It some level of psychology that's satisfying, a kind of deeper fun.

Don't ask me why it makes a difference how many people are affected. I don't have a good answer.

I know there are many people who don't feel this way, because they say so. But it seems to be how some people are wired.

But there's that pesky scaling problem.

So which people and which projects to focus on?

I think it's a dilemma that a lot of people struggle with in times of creative freedom who are wired that way, and I have yet to recognise any really good articles or guidance on resolving it.
The problem is that they give it to old people, not that they rarely die from it. I'm pretty sure people under 70 have an quite moderate risk of dying of covid (as compared to other endemic diseases that don't cause world lockdowns.) The problem is that they give it to old people.
EU vs. Disinfo: database of known disinformation cases
I use Apple Maps in Shanghai. It's very fast, accurate and shows bicycle/scooter lanes, indoor maps for malls etc. very well.

Google Maps even with VPN (to bypass the censorship) is nearly unusable here by modern map software standards.
Roko's Basilisk will remember this
>Seems all these efforts have failed

What? It's still actively advancing every year. This is like saying manned missions to Mars have failed. We're not there yet but the steps we're taking aren't "failure"
For the sabotaged code base, point them to Atlassian.

I like the new mascot.

People need to stop referring to the product name Github, too, as it causes confusion. It's _Microsoft_, which should serve as a deterrent.
Feds indict “The Bull” for allegedly selling insider stock info on the dark web
It seems like it would be trivial to poison the well so to speak for common function prototypes to add known vulnerabilities that can be exploited later when needed.

I would be exceedingly cautious about running code inserted by a black box fed by public inputs. Similar attacks have already occurred for NPM and I'm sure many other packagers.
You are correct.

Ubuntu installed Debian's popcon as a default package from 2006-2018, although apparently it was not configured to send data upstream.
I'm an introvert but like being in the office. I don't like the commute though so will try to maximize WFH.
There's a difference between a rigorous scientific method providing confirmation evidence, and empiricism. Enpricism is the state of the world that is true, and you don't need science to observe empirical facts.
Show HN: Spring boot startup endpoint analyzer
They are almost competitive on electricity price and much less riksy to build, because they're not some double digit billion dollar project that finishes in fifteen years. Those seem like pretty strong arguments to me. Why do you think otherwise?
Carbon taxes are extremely unpopular in the USA where many doubt the validity of climate change.
He didn't say they were "immune". He said they were "almost immune", which is certainly unscientific but is another way to say they are at very low risk. Trump was often reckless with his words, but you're being pedantic.
Before the lockdowns I thought I was an introvert. Boy was I wrong.
I really hate that people call Linux distributions 'X OS' and you get sites like this which at no point clarify where it is actually a distro or an entirely new OS.

It is confusing and somewhat disrespectful towards Linux.
We've known this since the beginning of the pandemic. The danger with children is them spreading with mild or asymptomatic disease in academic settings, not them succumbing to it.
I'd assume because development process doesn't need to deal with repercussions of accelerated power supply degradation
"Ideally this would be something that could be opted in or out of [...] on the driver's end.”
they did both, tpu is provided by google and coreweave offers gpu runtimes
Apple Maps is quite good if you use it one of the major US cities… but it’s still weak in most other places. As a European customer, Google maps have more up to date information, better traffic data, public construction information etc.
How confident are you that using batteries to reliably serve energy at a civilization scale has no fundamental unsolved problems? Because in my reading about this topic, it comes up quite frequently.
Wow and I hit the google report spam button if they don't give me a one click unsubscribe.
I thought I was an extrovert! Turns out anxiety can masquerade as extroversion.
Github ignored licenses for this project and included code from all publicly-accessible repos. They claim it's not copyright infringement and you can e.g. use code from this AI trained on open-source repos in closed-source projects.
I completely agree with you, I would just add the big unknown is the shift in demand. If renewables are going to be much cheaper in certain times (they are already cheaper than nuclear, on average, for example https://www.visualcapitalist.com/electricity-from-renewable-...), it will be worth shifting energy-intensive industries to utilize that. This might significantly reduce the demand for the base load, and reduce the need for power2gas (and so its cost) significantly.
Also given the fast evolution of the virus (with the newest variants way more infectious and deadly than the original), it's not a given that the low effects in children will continue. Especially if children remain the only vulnerable population - it's conceivable that a variant that is way worse for children will arise.
But (1) that’s just a regional phenomenon and (2) it doesn’t indicate any top-down pressure to convert to boost someone’s political power.
It talks about being an ambivert in order to be successful and balanced. As someone who is energized by independent time, I found the lockdown easier. I could quickly step out for a run, walk, eat lunch in silence, read a book for 20 minutes. There was no pressure to entertain with peers or social networking at the cafeteria. We are social creatures and I liked having finer control over it.

People who meet me in 1 or 2 meetings might think I am an extrovert or non-introvert. I don’t mind speaking in front of 30 people – some of peers would say I excel at public speaking. I just want time to myself afterwards because much of my energy is spent presenting.
And neural rendering to get realistic 3D scenes ;)
Coding the Liar Paradox – Logic, philosophy and coding
Yeah, just keep it in the news more. I'd use Co-pilot as an anti-indicator for hiring.
What exactly is power2gas? Is it a proven scalable technology?
I'm a physically and socially isolated introvert in a rural county and have been working from home for a decade. About the only difference for me was the occasional need to put on a mask before walking in a store. My greatest inconvenience was very minor: I was turned away from a convenience store for not having a mask with me.

Early in the lockdowns I made a trip to the closest big city for a dentist appointment and I was amazed by the transformation, the closed businesses, the long lines, the obvious ubiquitous fear. Several family members struggled after losing jobs. It's quite clear how this disaster has seriously affected so many other people.

So while I don't count myself as a winner in this, it does seem to be a substantial win to not be one of the losers.
The past year has proven how introverted I am.

The best days of my life are the ones where I don't see or speak to another human being. Blessed days.
Or that it is spectrum with most in the middle.

And that anxieties, shyness, awkwardness are orthogonal to it. And that being loud dont imply extroversion either.
All people need a strong sense of connection, but not all people thrive with a high degree of contact.
Is coal-rolling an anti fossil fuel PR stunt? As long as cars are clean (mostly invisible exhaust) the problem is invisible. You can't see CO2 emissions in the atmosphere. It's very easy to deny something that you can't see.

However, these people are using car emissions as weak chemical weapons. They intentionally crank up pollution to harm people. If a single car without emission controls is this bad. The problem becomes visible and the conclusion becomes obvious: There is no way millions of ICE cars with emission controls are good for me.
Just because the attack is contained inside the sandbox doesn't mean it can't do anything, so no, "it's in a sandbox" does not remove all risk automatically.
There's also the Bill Gates-backed solar-concentrator tech that came out of stealth mode a couple of years back...

https://edition.cnn.com/2019/11/19/business/heliogen-solar-e...
And now, I’m remembering Roko’s Basilisk, thanks.
Any unusual or one-off traits that seem "unique", "fun", "quirky" etc tend to do very badly in the actual real estate market. Often, they are poorly engineered and will be a maintenance nightmare in 20 years. Inspection expertise to be able to tell whether it will be a maintenance nightmare will be very tough to find. Most sane buyers will just pass on it rather then try to sort it out.

Even if the market is super hot right now and it seems like people will buy anything, anyone who looks at buying this will definitely be thinking about how hard it will be to sell in 10 years when the market isn't so hot. Most likely 90% of them will either back out or demand discounts that basically assume the whole thing is a mess and will need to be ripped out by professional contractors.
Google maps >>>>>>>>>>>>>>>> apple maps here in Europe especially for medium sized cities (in big cities apple works fine but still a lot worse then google).

For me it seems like fair exchange to give some data, for free and very good service that have no real competition :)
Why post shit that's behind a paywall? Really, why?
Nuclear energy requires very little material handling to build and run.

There will always be a use case for dense energy.

California can import boutique sun grown energy from the deserts just fine. Germany can import Danish wind power. But some nations that would directly have to trade limited arable land for power and/or who do not have wide enough land area (or good enough relations with their neighbors) or grid capacity to roll out solar or wind will likely find that dropping in nuclear to replace fossil fuels is the most cost effective solution.

Pretending that everyone is going to magically go to solar and wind and that hydro and nuclear will not at a bare minimum continue to exist for specific niches is foolish.
And they already can't control cheaters...
There's no performance difference in the engine.

The way you have written it (ANSI-89)used to be the only way joins could be written.

The second one (ANSI-92) was introduced to allow for composability since the entities being joined and the join condition are next to each other in the code and multiple joins can be generated one after the other.

IMO it also enhances developmemt quality of life since you can understand a new-to-you query faster (especially complex ones), you can just comment out a join in one line when testing replacement, cut and paste between queries easier, etc.

An SO question on the topic

https://stackoverflow.com/questions/334201/why-isnt-sql-ansi...
The Veritasium video talks about research and how the evidence doesn't support the learning styles theory. On the other hand, psychology theory into personality has a lot of evidence to show that people vary a lot on their extraversion. The reported results (from Big Five and similar personality tests) are usually in percentiles relative to some reference population rather than a label of introvert or extrovert.
Honestly, super practical for anyone who plays in a band and wants to host practice and have their neighbors like them anyway.

Or has a kid who's in the same situation...
There are filters that remove some patterns from titles at time of submission, e.g. leading numbers or "How ..." occuring at the beginning of a title. The submitter can still edit the title after submission and add it back if they think that the removal was not justified.
Yes, I have a friend who works on projects like that for Siemens in Germany. Apparently there is a regime of renewable buildout (roughly at the percentage where Germany is currently at) where it's cheaper to shape demand than to build storage.
to be fair, for small bussiness it works quite well.

Think, windows small bussiness server but linux based.
But the point is that Apple Maps also has the commute suggestions without the privacy cost
Texan anecdata: I rarely saw coal rolling when I drove my Tacoma. Then, in 2013, I got a Prius. This has been happening to me ever since.
BBC attempting to sway/nudge/gaslight, as usual. Firstly, it wasn't a lockdown, that's just the fear motive militaristic terminology they thought would achieve their goals - so much was open, and traffic congestion across cities daily, it could be called a slowdown or a partial shutdown, but "lockdown" is just transparent. The slowdown is the reason I haven't quit my current employer; my social life is just as crap as it was before, and every other aspect of my life has improved thanks to the slowdown. I absolutely won.
That's where the BBC always was. People hired by the BBC were systematically vetted by MI5 and rejected for left-wing sympathies from its entire history until very recent times. IMO the only difference between then and now is that there are vanishingly few left-wing toffs and strivers in the UK anymore, so when hiring from the pre-filtered pool (of typical BBC candidates) they can get by relying on an informal veto system.
This is a very interesting point. I wonder how this restructuring to follow the energy would impact the efficiency of the relevant industries. In space as well as time, I would imagine - you could perhaps move a lot of energy-intensive stuff out into the deserts, right next to the solar arrays.
Show HN: Guess the movie based on the AI generated poster
Yes, the wisdom of his statements jumps from "utterly nonsensical" to "occasionally somewhat correct" if you interpret what he says with the same leniency you might a 12 year old.

For example, he probably meant immune by the definition "protected from" with the implied thing being "serious medical harm" rather than "infection".

I agree it's disingenuous to call him a deliberate liar here when the truth is he just speaks with the vocabulary and scientific acumen of a candid 6th grader.

The real shame is triplicate here:

1. That we must settle for a president with those verbal skills

2. That his verbal skills are perhaps more reflective of the average American than we'd like to believe

3. That people with sometimes exceptional verbal skills and education can somehow not comprehend some of the simple truths that he can (children being at extremely low personal health risk should've been obvious to everyone after the first few months of the pandemic)

And in my opinion, the well educated being deluded into a false perception of reality is a lot more startling of a fact than that a person who has an obviously mediocre command of his native language and paltry understanding of scientific fundamentals said something that was incoherent and not technically correct when trying to verbalise his opinions.
Moving to Gitlab wouldn't stop them pulling code into the model would it?

I get that it still makes a statement.
"Almost immune" is either wrong or nonsense, and they were still right to remove it.

Children can get COVID, they just don't get a high rate of complications. They do get sick, but not severely.

That is, in no way, "immune".

I'm not "almost immune" to the common cold because it doesn't make me very sick.
The difference between bullshit and a lie is that the liar knows he's wrong, the bullshitter doesn't care.

Trump said whatever was politically useful to him in any given situation at best (either by earning him praise from supporters or by distracting his critics) and whatever he felt like or overheard someone else say at worst. That anyone would look at any statement from him and use it to justify praise for him or use its falseness to dunk on him is silly. Factuality wasn't a consideration for him when making any of his statements.
I love reading about projects like this. They are in a class of projects that are 100% slog and not very sexy but make things a lot better for a lot of people.

Better outputs for more inputs in better time. Beautiful.

Reminds me of Photopea... Oh, I wonder whether they are in competition? Probably not since Photopea seems to be more about image editing and Avocode is more about design and handoff.
The Big Five model statistically shows that extroversion/introversion is one of the five axis over which personality varies. So studies already showed that there are introverts and extroverts.

The only thing you could say is wrong is the supposed dichotomy. Instead, we have a gaussian distribution along the axis.
Interesting! A few weeks ago a sales guy at my job mentioned ClarkConnect. I became curious since that was the first time I’ve heard someone mentioning that product.

Apparently it seems like the foundation that manages ClearOS also created some kinda cryptocoin?!

https://news.clear.co.com/all-clearos-users-now-can-get-free...
What have you found out about yourself?
It's kinda weird they never really mention it. Not great for selling ads if all the people with disposable income don't see any ads I guess
I'd like to hear more about your life experience - how much human contact do you have on a weekly basis?
Your noticing the narrative.

Like how small town book stores are inherently good and big stores evil. Regardless of facts.

Republicans will be portrayed as stupid and dangerous, regardless of facts. So when Trump was saying something it was automatically just that. If need be facts would be twisted until they fit that viewpoint.

For contrast the current president making a joke about running a reporter over is just a laughable moment now. Under Trump it would have been discussed for weeks.

Definitions of Narrative Journalism

Simply put, narrative is the way in which a story is constructed through a particular point of view and arrangement of events.
So what was it that made one a winner of lockdown? As I was definitely a winner. This discussion is going to flood with people who also where quite cozy under lockdown. What is the difference there?
They also seem unpopular in France, see the yellow vest riots in 2018. Consumption taxes in general disproportionately affect the poor.
What do you do all day?