skysight-inc/HackerNews huggingface dataset:
Letting null equal null might work okay for a WHERE clause, but it turn JOINing into a terrible muddle. And I don't want null to behave different ways in different clauses.
> Total War economy/society
> quality of life improvements to our health and well being this kind of mobilization would bring would be astonishing.

The impact on quality of life and society would be "astonishing," but they won't be improvements. The Soviets and Chinese tried similar "mobilization[s]" for food production. The idea was to direct society's efforts to producing enough food for everybody. Tens of millions of people died of starvation as a result. It turns out that governments are bad at running economies.

I don't know why so many people think that the same mechanism (a command-and-control economy) will lead to a different result just because you change the goal from food or industrial production to climate change mitigation.
Valve hasn't been resting on their laurels, they've been doing a lot more for gaming than Epic has. They've been doing a lot of work on Proton to allow more people on Linux to play games, plus their "Remote Play Together" that lets you play local multiplayer games with friends over the internet. The EGS is so barebones that people have to go on the Steam forums to get tech support questions, not to mention that they don't have a Linux client, and their limited availability in some countries means that paying for exclusivity prevents some people from being able to play the game.
NULL is similar to floating point NaN (aka not a number) which also has the same comparison operation NaN != NaN.
Your priors are a little misconfigured
I wonder how many people are using coronavirus as a convenient excuse to stay home to nurse their superbowl hangover. :D
Because yesterday there was 60 deaths, a 20% jump over the previous day. At this rate, it'll become way more deadlier than the Flu in only a few days. Considering that around 700 persons world-wide die from the flu everyday and these deaths are happening mainly in Wuhan, this virus is certainly a very deadly one.
I'm very much reminded of this:

https://www.geek.com/chips/john-carmack-explains-why-its-fas...
But it should make the scientists more circumspect about public policy recommendations.

From the article:

Climate models have been doing a fine job projecting warming for a long time. A recent study compared models as old as 1970 with observations made in the decades since. Some models warmed up too much, and some too little, but 14 of 17 past projections turned out to be consistent with the measured path of global average temperatures.

Scientists can not give definite answers in such complex systems, but it is the closest we can get in extrapolating the trajectory that we are on and computing what the effect of various measures is.

I am not sure what else one could base policy on.
so?.. still not equal to anything, two unknowns are not equal

if null = null
print 'true'
else
print 'false'
Heh. No, I was referring to the content. However, Vayenas has been publishing on this since at least 2008. This paper is the latest refinement of the theory. I haven't found any response to his work from the physics community - I would think that if it was easily refutable, that would have happened by now. But virtually all the citations appear to come from the small group of people working with Vayenas.

Professor Vayenas is a distinguished chemist, and his work looks rather like a blend of Old Quantum Theory and particle physics, so I suppose it's an uphill fight for him. However, Bohr did get a lot, e.g. the hydrogen spectrum, from a simple assumption, and Vayenas is trying to follow the same path.

The papers he's published are relatively accessible and full of startling calculations that result in close agreement with experimental results. They make interesting reading, and I haven't found anything so far that would cause me to reject them out of hand.

From the conclusion of the current paper: "Another emerging conclusion is that neutrinos, electrons, positrons and photons are present in all composite particles and are apparently the only undividable [sic] elementary particles."

https://cheme.stanford.edu/events/colloquium-constantinos-g-...
I think you're missing the point. From how I read the parent comment, the problem they see is how scientists are using the data available to them. When you make a hypothesis, you are supposed to validate or invalidate it based on its predictions - not change the predictions to fit the evidence.

If you change your model (hypothesis) to fit the facts, your model is merely descriptive of the evidence that is already available, and useless for prediction - as proven by the act of changing the model. That's how science works.
"I had never even heard of a “James Lovelock” before now, and after skimming the comments here, my desire to know about him went from zero to negative."

Although I question the conclusions, I feel that having read his original work "The Gaia Hypothesis"[1] is required to be broadly literate in our age.

It's a short book.

[1] https://en.wikipedia.org/wiki/Gaia_hypothesis
How to Debug and Fix 503 Service Unavailable Error in WordPress – Life365
Techniques to change and self-manage motivation and behaviour
Phone services disrupted across B.C., but emergency calls still working
I thought the speed of the new Doom was too low, too, but I think the bigger problem is the number of screen- and movement-locking events. Every time you pick up a key or do a finisher move, you have to wait 1-5 seconds for an animation to play out.

I think Doom 2016 is a pretty good and especially gory Serious Sam game. But it’s certainly not Doom.
Why are you talking about the itanium API instead of the x86-64 API?
The damage this viewpoint was massive.

Pascal could have been our present, but now we live the mistake of base so much on top of C/C++, and because we never learn, repeat with JS.
it wasn't so much the theme as it was, and is, the graphics. I can play horror-style games, but with a game like Doom the horror-style + gameplay is just too intense. I'd love a similar game with a less intense theme.

For example, I can handle Nintendo-style cutesy graphics even if the gameplay is really difficult (Celeste, for one).
Why does working from home 1-2 days a week require changing your sleep schedule?
- $_SERVER contains server and execution environment info
- $_REQUEST contains request input parameter values (regardless of http verb)

That's it. It's not a lot. They're 2 super simple arrays.

PHP can also work from command line where $_REQUEST/$_POST/$_GET are unavailable. You can also entirely ignore the existence of the above variables. You can read from standard input and treat input as JSON - options are endless. This merely means that the example shown is not entirely correct - it's not "how it works in PHP". It's merely one of the ways. But the real problem is: no one bothered to research it and you blindly assumed that's how it works.

Laravel (Http/Kernel library) standardized the interface towards the dev and that's great. But the input itself isn't as tied to PHP core as your comment makes it seem.
Also, one thing people often overlook - as you settle more places / build more habitats, you are unlocking the vast resources of the Solar System.

These might give you a hand if any single of the settlements (including Earth) get into trouble. This could range from preventing the disaster in the first place (nearby ship deflecting a potential impactor) to helping the survivors (medical supplies being dropped from orbit, habitat with failing life support being evacuated).

Self sustaining off-Earth settlements go way beyond just "oops, Earth is gone, at least someone is still left".
Show HN: Aggregate search DB for arbitration outcomes
I don't see how that's relevant. Most of those bugs are in GCC 10 which isn't released yet specifically because those regressions are all still open. Meanwhile, GCC 7 just got a bugfix release a few months ago. It just doesn't make sense to compare C/C++ compilers to rustc; my point is that rustc doesn't have a stable LTS release yet. The only way I could see this happening is if developers of other Rust compilers put pressure on your team to make a spec and stick to it for a number of years. Otherwise you're headed for a situation like Haskell where there is only one real compiler and it's permanently in a state of flux. Distro packaging for Haskell and its libraries is still a pretty complex task BTW.
Thanks. I am aware of the start-stop mechanism, but didn't know its name, and have never had it in a car I was driving myself, so am less aware of its implications. (I don't drive often anyway.)
My introduction came from Alan Weisman's book Countdown. I did a couple podcast episodes on it: https://shows.acast.com/leadership-and-the-environment/episo... and https://shows.acast.com/leadership-and-the-environment/episo....

Here's a New York Times article on Mexican soap operas and family planning https://www.nytimes.com/1982/01/05/world/soap-opera-in-mexic...

This article covers soap operas around the world and family planning http://utminers.utep.edu/asinghal/Articles%20and%20Chapters/....

Search results with more https://duckduckgo.com/?q=mexico+family+planning+soap+opera&....
An awful lot of people there, especially the more educated, speak English.
It was also used to raise funds for Homeworld 3, which is currently in development.
Not sure how multiple people working on a shared task needing to collaborate / whiteboard / discuss what they're doing qualifies as constant small interruptions.

In theory happy hour drinks and coffee breaks are things that happen when people aren't in the middle of productive working anyway.
With many of these online services, you aren't paying for the hosting costs but for the services.
Also a blog post from the researchers: "What can people do to self-manage their motivation and behaviour? We found 123 strategies" https://blogs.helsinki.fi/nhankone/2020/01/13/what-can-peopl...
I believe it's partially with the quantity of theft/damage (i.e. a fire) that could occur if all laptops are left in a single location overnight.

A theft at the office, could result in dozens of computers going missing.

A theft a single employee's home, is likely limited to a very small amount of devices.
Ha, Sekiro was the first game that came to mind as a possible way to play a 'Soulslike' without the demons.

Although recently I found Nier: Automata, which scratches a similar itch with a more sci-fi theme (and a dash of horriffic creatures, still).
A common way to seek social security money is to get a bogus diagnosis of autism for your children. This makes life a living hell for people with children that actually have autism and depend on SSA to allow them to act as caretakers.

I think the current system in the US is designed to degrade and abuse people for being poor. People who depend on welfare and disability payments are constantly treated with suspicion as grifters and fraudsters because so many others actually are. They spend most of their time fighting with the government to keep their benefits while having little to no hope of replacing them.

A UBI would allow them to go out and get a job without being afraid they will just have their other benefits cut. There is no means testing or degrading requirements to "Prove" you or your dependent is disabled. The government has no reason to investigate you or pry into your personal life.
Germany had a Total War economy in WW2. North Korea has one today. The Russian Revolution might not be considered 'Total War', but was single-minded in its focus similar to what you're suggesting. None of these economies worked out well for their citizens. Even the US economy/society during WW2 was more than victory gardens and war bonds; personal freedoms were limited, there were interment camps, forced enlistment, war profiteering, and propaganda (along with the hundreds of thousands of deaths).
I wouldn't expect null row values since you're doing a numeric comparison for my_column, and null isn't a number.
https://www.youtube.com/watch?v=Bu6R79FIzZo
This guy's insight and references seem very interesting.
Yes, this is a single persons opinion on this.
1. NOT NULL is very frequently used in schemas, because NULL is often an undesirable value (e.g. for a mandatory field). That doesn't make NULLs bad, and NULLs are still frequently used when you have optional fields or fields where NULL has some other special meaning.

2. NULLs are used by SQL functions and operators as an "unknown" value. So, for example, "NULL AND TRUE" is NULL, because we could substitute NULL with TRUE or with FALSE to get different results, but "NULL AND FALSE" is FALSE, because no matter what we substitute NULL with, the result will always be FALSE.

3. Clearly all these valid uses of NULL do not indicate "flaws" in the database design.

4. Database normalization isn't always a good thing, and beyond a certain level it's almost always a bad thing, so using normalization methods as a standard for whether something is "flawed" is probablyn ot the best idea.

5. No database normalization method, as far as I know, actually tries to eliminate NULLs, so I don't know what "(See database normalizations)" refers to. Can you clarify?
I've been excited by the potential of hyperloop since the first time I heard about it maybe 30-40 years ago. The idea isn't new - there have been pneumatic trains in the 1800s and at least a design for a vacuum train in the early 1900s - it is the engineering challenges that have held it back. I'm sure these challenges would require no less effort to solve than projects like travelling to Mars, but the outcome would benefit more of mankind and would create something truly amazing (until it's been around for a while and then it would seem no more amazing than a laser printer).
I don't want to work for those people. I'll keep negotiating to win when it comes to salary.
> I routinely see people jaywalking in urban environments

Swap 'people jaywalking' with 'people trying to cross a road.'

Jaywalking is a ludicrous concept and even more ludicrous as something to make a legal issue.
"Cultural shift"?

What if men providing resources to their families is a drive that runs deeper than some kind of vestigial macho chauvinism? We already have mass depression, isolation, falling educational outcomes, suicide, and even radicalization of men who are unable to find purpose to attach themselves to in the modern economy.

Are we to gloss over the function and instincts of half the population as an attitude problem? Social engineering is way too easy inside a theoretical bubble, where expecting billions of people to fundamentally reconstruct their entire identities can be handwaved in two words. Progressivism is supposed to meet people’s social needs, not dictate them.
Another one is MIN and MAX ignore NULL values, which make for some interesting rollback scenarios.

I also swear I have seen a gotcha involving UPDATE WHERE IN and not throwing an error where it should have, which is why I always quadruple check my update statements, but I wasn't able to reproduce it and couldn't find any information online. I haven't seen the issue in so long I forgot what it was, but it would update all rows in your table even if your WHERE clause was proper.
Nah, it's true for all columns:

SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 3 15:56:30 2020

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL> create table foo(fook varchar2(10) not null);

Table created.

SQL> insert into foo values ('');
insert into foo values ('')
*
ERROR at line 1:
ORA-01400: cannot insert NULL into ("SPORTSBOOK_DOCK"."FOO"."FOOK")

SQL> create table bar(bark varchar2(10));

Table created.

SQL> insert into bar values ('');

1 row created.

SQL> insert into bar values ('a');

1 row created.

SQL> insert into bar values (null);

1 row created.

SQL> select * from bar;

BARK
----------

a

SQL> select * from bar where bark = '';

no rows selected
This was a mechanic that was in the original Half Life games, it comes from GoldSrc (https://en.wikipedia.org/wiki/GoldSrc), the original Half Life engine, being a heavily modified Quake World engine. It's funny you mention Overwatch, because many of the old Quake players are now playing Overwatch competitively. In Quake this kind of movement is a part of the gameplay, but for Counter Strike, many of the maps were not designed with the intention of this kind of movement being used. The result was people were able to do things like get into the skybox. Even though you can't bunny hop in Counter Strike like you could back then, there are still movement tricks, and maps specifically made for practicing movement. At the time there was also TFC, which was more willing to sacrifice 'realism' for game play, but Team Fortress had also existed previously for Quake World as well. All of that said, right now the most played game is Fortnite, and it definitely does not put realism first.
Blackberry Mobile Is No More, Again
The only thing that I can think of to make Mars a better option than Earth is if Earth is struck by some truly gigantic asteroid. But it would have to be big enough to seriously damage a 1,000 trillion metric ton ball (we'll take it as given that the Earth isn't flat) of iron. Merely stripping the atmosphere wouldn't be enough - you need to fundamentally compromise the structural integrity of the planet to make it as unlivable as Mars.
scientific models != scientific facts.

They are educate guesses or educated estimates to be more charitable. Our computing capabilities are much too weak to accurately model systems as complex as the entire earth's climate.
How to Make Social Media Posts Trend – Adlibweb
I have something that is exactly this in the works, planning to open up on GitHub in the next month or two. It generates multiple technologies for full-stack e2e app implementation and management. It can do more than apps, really anything file based.

I'd be interested in hearing your impressions. I can show you around and/or get you early access. tony@hofstadter.io
The best measure is per mile or per passenger mile. Per motor vehicle is far better than per capita, though.
> This is the insurmountable problem with human habitation of Mars - we would need to become, in many ways, a different species in order to withstand the very greatly reduced gravity - and humans, as we know them, would succumb to all manner of disease and physical maladies until that transition (millenia ?) took place.

Well, you don’t know that humans can’t survive indefinitely at 1/3 gee. I know that because no one knows that, so let’s not speculate on what the threshold gravity would be before we need to “become a different species” would be.

But I’ll admit, unlike radiation and resource concerns, gravity is something we’re never going to overcome. If humans can’t thrive at 1/3 gee, we will never permanently colonize any terrestrial body in our solar system. However, given the range of adaptations humans present, e.g. to extreme altitude, continuous saltwater diving, or long-distance running, I’m willing to bet we can handle, and adapt to, reduced (not micro) gravity.
How about those of us with scruples?
I don’t completely disagree with you, but I would point out the paper ‘A Higher-Order Graph-Based Intermediate Representation’ by Roland LeBia, et al from the U of Saarland Compiler Lab. That paper, which describes the groups Thorin IR, does show some advantage to the sea of nodes based approach (although the representation may not be classified as purely SoN). The advantages seem particularly compelling for mixed functional/imperative source languages, which was essentially their goal.
Software is fun :)
I have so much more respect for these noisy children than the serious adults who have spent millions of dollars lying about this issue and bribing officials to ignore it.
I wish there were decent coops in the city near me. I looked into three, and they were all places that you couldn't pay me to live; one was nearly condemned the year after I looked into it. The other had hallways with only 1 out of 3 lights actually working, and smelled of urine and ramen.

It's a neat idea, but I'm guessing there is a certain culture that makes apartment coops work, and that definitely doesn't exist near me.
I argue we should be building a more capable and survivable successor to biological intelligence that can survive beyond traditional biological extinction periods (M of years).
It's a safety color.
I'm not sure why you are downvoted. Jaywalking is bad for everyone: The pedestrians since it makes them at risk. The cars since it slows them down. Roads were made for cars and white cross-walks for pedestrians to cross them. If you don't like cars around, then remove the roads.
Further, those people are loser PHBs whose antisocial behaviors drive away good talent. Their behavior will eventually catch up with them.
the moral to this story is don't dilute your data. if your data is delivered in gda94, don't convert it to gps coords so all your data is in the same format. instead, when you render it, render it from gda94 into your own coordinate system.

that way, you won't have a problem with interpreting what it means. there's no such thing as 145°E 40°S, but there is “145°E 45°S gps 2016-05-07” and that can forever be handled.
Those Apple Cards are looking pretty busted just six months later
This is common in many parts of the world.
Yes, I agree. My objection is really the template syntax itself. There have been many things added over the years that are good.
I work at a fully remote startup, after working at a mostly remote startup before.

Having an easily accessibly video conference software, committing to getting employees good headsets, and enforcing videos on/1 person per screen makes collaboration very easy.

----

The only thing that's missing is whiteboarding sessions (which seem to be more about fun than actual productivity). Instead, we typically ask a single engineer to write up a proposal doc then have everybody comment on that.

It requires a bit more lead time - write up, feedback, then finalization. However, the actual developer time is significantly less. One developer doing most of the work, with others chiming in periodically.
I like this blog.

As a "semi-retired old dude," I have been absolutely reveling in the productivity I have achieved, working at home. It's been awesome.

It isn't just because I'm working at home. I suspect that a lot of it is because I'm working alone.

I was a manager for a long time, and quickly realized that "team overhead" was the true enemy of productivity. This includes things like Slack convos, and water-cooler chats.

It's a long topic, but all sorts of things are required to enable a good team integration; especially if we need to have a bunch of less-experienced team members on board. I was fortunate to lead a team of very experienced engineers. We shared a vocabulary and a common vision, so a great deal of "basic" overhead was avoided.

The (big) downside of working alone, is that I need to keep the scope of my projects reasonable. I can get a lot more done than most lone developers, but it's still a great deal less than what can be accomplished by a tight team.

As long as we have teams, we'll have overhead challenges.
I agree with the other two comments.

I think it doesn't look like a voting ring problem. (I don't have internal information, It's only a gut feeling looking at the pattern of submissions of the user, the site and the Moon phase.) I'd expect a 50% increase of points, something like 2 or 3 in this case.

If you want an official reply, write to the mods hn@ycombinator.com

In the guidelines, 'roughly' means something like

fake quotes> the difference is part of the secret sauce (for example to prevent spam) and we tweak it constantly (so it's difficult to explain)
Pinterest Lens Recognizes 2.5B Objects