skysight-inc/HackerNews huggingface dataset:
I think a lot of these are in the ANSI 2016 spec. I haven't looked at the older specs, maybe they were simpler.

Eg here is the `a+1` vs `1+a` thing explained for ORDER BY - https://i.imgur.com/bklpjkP.png. Here are the conditions under which ORDER BY can reach inside SELECT to pick columns from the FROM clause - https://i.imgur.com/aoeqDGn.png.

Chapter 2 of the spec is 1732 pages of that kind of language, so it's hard to be sure that any particular behaviour is not in there somewhere. But I'm fairly sure that all the examples with set-valued functions are postgres-isms.
That’s a little extreme- if someone doesn’t want to be tracked they must stay at home and shamed? There are other alternatives.
This Week in Apps: Facebook Takes on Houseparty, Fortnite Comes to Google Play
Can’t offer any resources on home repair, but I’ve used Rossman’s service before with good results.
When I'm writing procedural code for PostgreSQL, I'm usually writing PL/pgSQL... which is very, very similar to Oracle PL/SQL (having written more than my share of PL/SQL); My recollection is the similarity is intentional.

However, there are other PL's for PostgreSQL. PL/Python, PL/Perl, and PL/Tcl are also distributed with the database and there are others available (https://www.postgresql.org/docs/12/external-pl.html... though I've only used JavaScript)
That really isn't a problem. So long as you can afford something where your basic needs are met: four walls, clean, safe, sturdy, etc, nobody's entitled to waterfront views. The idea is you create value through your work and utilize the proceeds to upgrade your residence, if that's what you value.
Exactly. We're often on both ends of this - some BI tool will generate a SQL expression that a human would never have typed, and we have to handle it the same way that postgres would.
And? Go somewhere cheaper?
Let all the downvoting begin, but I think people, including myself, are realizing that this was blown way out of proportion. If you are under 50 you are most likely not going to die or have long term complications. It's time to get out and start building immunity.
There are several options for a Faraday cage for you phone.

For example this https://silent-pocket.com/
"The charge on a mole of electrons had been known for some time and is the constant called the Faraday. The best estimate of the value of a Faraday, according to the National Institute of Standards and Technology (NIST), is 96,485.3383 coulombs per mole of electrons. The best estimate of the charge on an electron based on modern experiments is 1.60217653 x 10-19 coulombs per electron. If you divide the charge on a mole of electrons by the charge on a single electron you obtain a value of Avogadro’s number of 6.02214154 x 1023 particles per mole."

https://www.scientificamerican.com/article/how-was-avogadros...
I don't know if this would be my "one question" if I could ask the most brilliant minds in science, but something that always bothered me:

When I took physics they basically said "at first scientists were disturbed by the fact that magnets imply that two objects are interacting without any physical contact, but then Faraday came along and said 'the magnets are actually connected by invisible magnetic field lines' and that resolved everything."

How does saying "but what if there's invisible lines connecting them" resolve anything? To be clear, I'm not objecting to any of the actual electromagnetic laws or using field lines to visualize magnetic fields. It's just that I don't get how invoking invisible lines actually explains anything about how objects are able to react without physical contact.

(Also, it is not lost on me I that this question boils down to "fraking magnets, how do they work?")
I get it sucks to be out the money, but in the end you accepted the terms and are responsible for the bill. I honestly feel you should be more upset with yourself (I would be if I was in your shoes) for not managing your accounts and money more closely and not upset with a company that you were consuming services from, even if you weren't meaning to. AWS owes you nothing in this scenario, IMO, I'd take it as a learning experience that at least wasn't more expensive.

I do think your telling other people to be careful of the terms they might have blindly accepted is totally reasonable, but where I at least found your original post kinda off is you are not taking responsibility for your mistake and instead are blaming Amazon. Just my 2 cents.
None of this makes any sense to me.

I'm hearing such a wide variety of claims about this virus that I have by default become skeptical of anything that makes a wide ranging claim. The descriptions range from "highly infections, potentially causes strokes in otherwise young healthy people" to "highly infectious, young people often display no symptoms at all".

Are there multiple strains of this virus out there in the wild? I don't know of another way to explain what I'm hearing from people that work in virology and in hospitals on the front line.
> Advertising on the other hand is one-sided.

Most ad platforms allow anyone to submit an add. Most add platforms are moderated.

> Advertising doesn’t give you a choice on whether you want to see it.

Of course it does. When I'm reading a book I don't see advertisements. They aren't beamed into my brain, they're the price of admission for certain services I gain value from
i would have thought miniaturisation would make this basically impossible without thousands of dollars of specialist equipment. I’ve never known a mac repair shop to do anything other than replace the whole bosrd. the thing is smaller than a raspberry pi.

spend enough time on hacker news and you’ve seen many srticles complaining specifically about how unrepairable macs are. especially newer ones, that cryptographically brick themselves if they detect tampering.
I was considering using lib-tex (the library implementing texlive 2019 for this shell) last week for an iOS app I’m working on that needs to generate basic LaTeX images. It’s really impressive, these programs running in A-Shell are modified by renaming their `main()` function and making sure global/static variables are cleaned up so they can run as a separate thread in-process instead of spawning a separate process. I decided to use the more limited KaTeX instead because it sounds like a maintenance nightmare, making sure nothing leaks and updating everything every time a new version comes out...

I wonder if that process can be automated to a point where you could “lib-ize” any C/C++ project (sed replacing malloc/free with something that cleans up when the process “exits”, replacing exit/fork/etc, replacing static). I think that would really open up the number of interpreters available on iOS.
How many person years of salary is $84M for that manual from Boeing?
Why Florida’s coronavirus outbreak appears to be plateauing
Statistics on Country Flag Colors
Thanks na85

Let's take a contrived example. I have a 4 engine high wing airplane with 2 bladed 55 inch props on each engine with 100kg force (1 kg-f is equal to 9.8 N) thrust per engine.

Now, I need to make that a low wing airplane so need to change to 22 inch blades with the same thrust and I don't want to change engines. So I want to add more prop blades. How many more blades do I need to add?
What’s the Status of Covid-19 in Iceland?
Cells are tiny and the speed of sound is how fast air molecules move. Proteins are also not bouncing around as fast but it’s very still quick relative to their size. Next, often there are multiple copies of each component. That’s half the story, larger cells also have various means to clump things together to improve the odds. https://en.wikipedia.org/wiki/Endoplasmic_reticulum

PS: Speed of sound is 343 m/s, diameter of a cell nucleus is ~ 0.000006m to give an idea.
Yeah I don't care about sunlight. I'd prefer to have less honestly.
I mean a policy against contacting them outside of their duties of work. This is fairly standard practise for anybody with access to personal data as part of their job.

I'm sure there's all sorts of problems, ranging from simple nosiness to people snooping on previous partners or crushes, etc.
Kudos to Apple for not budging on this. A senior dev once shared a bit of wisdom with me. That developers don't typically hold all the power, but the point of leverage we do have is that in the end we are the ones who actually are going to build it. Disagree with PM on a feature? If you feel strongly enough, you build it your way until they remove you from the project. YMMV. Skate at your own risk.

Anyway, that's essentially what Apple seems to have done here. Strong move, and one they should be rewarded for.
Internal and External Effects of Social Distancing in a Pandemic [pdf]
Indeed.

Also, I find it odd that all the ads I see on Facebook are for scammy products - never big brands for things I actually buy.

FWIW I work in Advertising/Marketing.
I'm actually working through this book right now. I've been away from front-end coding for a bit and my weekend/evening project over the next month is to brush up on modern Javascript and ReactJS. This book is very well written and great re-introduction to JS/programming fundamentals.

For those interested--Besides this book, my current learning plan includes:
Javascript 30 by WesBos
Exploring ES6 [http://exploringjs.com/es6/]
Learning React-2nd Edition on O'Reilly Learning
The Beginners Guide to React on Egghead
Data Structures and Algorithms in JavaScript on Egghead.

I also used Kent C. Dodds' excellent "JavaScript to Know for React" article as an outline.
My dad was an aero space engineer, and I always had trouble with this. It is the speed you need to be going at, to not be pulled back by gravity. As a kid, I always thought, well big deal, if I am in a plane and just keep going up, eventually I will be out. The key I always missed was the velocity at that point was with no added power. So when the engine cuts off, what is your velocity? Is it enough to escape? Or do you need more power. Of course there is a good chance I still do not understand it.
Can't you just tweet the main ideas behind your blog posts and link to the main content with each tweet with a link to the full content?
The shareholders eat the loss. Maybe they can sue the board or officers, but that is the end of the line. It's not taxpayers' problem.

Ask yourself this: who made Enron shareholders whole after the scandal? Who compensated Bernie Madoff's victims?
By going out you're already putting people at risk, tracker or no tracker attached. You and people like you, thinking this is a perfect solution, are actually a bigger liability to public health.
Germany’s historical experience with centralized databases (using IBM tech) means that there are very good reasons to be skeptical of a centralized approach that could conceivably allow a government to spy on or classify the population of a whole country or even A continent.

Silicon Valley is a useful boogeyman, in part because they have done some things on the negative side of the evil ledger. Historically governments dwarf private companies in the amount of damage and misuse they Can unleash — with a few notable exceptions where they almost reach the scale of what tyrannical or incompetent governments can wrought.
I hate stories like this. Yeah, excellent documentation for an immensely expensive one-off, bespoke, incredibly complex product costs a ton of money. Duh.
Which is a great reason to stay off the beaten trail.
Citation needed for higher cancer in Gomel being significantly higher because of radioactive fallout from chernobyl causing several thousand extra deaths per year. Got a paper saying that that you could share? I ask because it contradicts what the WHO and UN have been saying for several decades.
https://news.ycombinator.com/item?id=22991172
Lot's of quantum related phenomenon here, but what keeps bothering me is that while I get it that light is both a wave and a particle, but I have no clue what that means. I mean, a wave of sound, is made from air particles, a wave of ripples in a pond is made of movement of water molecules. In the double slit experiment, it's explained that the single photon has to be "interfering with itself", so I don't get it if by being a "wave" it means that the single photon is basically a bunch of "magic" photon ghosts that behave like a wave, but once it is measured or any other reason to "collapse" these ghosts "disappear". I just don't get what the "wave" of light/radio wave is. Is it just an abstract concept of something that behaves like a wave but not the same as sound waves / ripples since we simply don't know? Or is it just a wave of these "not yet collapsed" probabilities of the photons locations that are interfering with each other right until we ask them to choose a location, then they just collapse magically into a single "real" photon. Another thing I don't get is in the double slit experiment, a LOT of the measure before, measure after, etc, are told to be thought experiments, but it's also claimed that someone managed to actually replicate them. Why isn't there a video showing it? I obviously believe they happened, and understand why more or less (e.g. in the one photon at a time experiment, it's spooky that over time you get the same pattern that indicates interference as if you shoot many) but the more spooky result is that thought experiment, that if you measure which slit the photon actually traveled through, you'll see 2 slits on the screen vs the famous pattern. e.g. you'll cause the wave to collapse back to particles. So any video of reproducing of that thought experiment or explanation why it's so hard to reproduce, will be super helpful.
No, you can't keep an app permanently running in the background on iOS. The operating system does not allow it.
In terms of wealth and power, probably equivalent to France in today's world. An ex-imperial nation, still with lots of prestige, but little political, financial or military strength remaining.

A question to ponder: The year is 1520, Portugal is still very rich and very powerful - How do you imagine Portugal in 50 years?

Portugal was a superpower in its day. No doubt the Portuguese envisaged that situation lasting forever.
How to Make an Illustrated Map in 8 Steps
Assuming a cost of $200k per person, it's 420 man years, or 100 person team on a four year buildout like this. It does not sound unreasonable - or at least, about the right order of magnitude for such an undertaking.
This site shows all the strains that have been identified. From what I understand though the mutations are minor and symptom shouldn't differ much.

https://nextstrain.org/ncov/global
Ask HN: I want to share files from the screen lock of my phone
I'm living in a country where I have to show documents to policemen because they restrict movements because of the flu COVID19. The easiest way is to generate a PDF from a state website.

I'm doing the same thing when I go to the cinema or when I take the train: I show or give my phone to allow the entitled person to check a PDF or a barcode that proves I am allowed to be here.

When I do that my phone is unlocked.

Police, robbers can steal my unlocked phone when I do that.

Stupid joke but if Julian Assange needs to show a barcode when he goes to the cinema, he needs to present his unlocked phone to a stranger.

I'm not Assange, but today I felt very stupid when a city policeman (not a state policeman) asked me for my document when I was in the street with my wife and kids. I didn't trust him because he was obviously a city security guard and not a policeman, I asked if he had the authorization to perform this check, but in the end I gave him my unlocked phone to allow him to check my document (everything was OK according to the law).

Conclusion: I need an app to share only some selected files from the screen lock.

When I take the train, I need to "share" for some hours my traveling documents to this app, it will allow me to pass the barcode scanners without unlocking my phone.

I think the HN people might consider this coding opportunity.
Coronavirus: Would you volunteer to be exposed? These Stanford grads did
Why do you think the two statements you quoted are contradictory? The baseline rate of stroke in young adults is very low, so even if the virus dramatically increases one's risk of stroke, it can still be true that the vast majority of infected people in that demographic are completely asymptomatic.
I think they are giving all houses a number now, most houses around me (south west uk) have a name and a number now, where they all used to have names.

My house has a number, but for some reason it's listed under the "name" of my house - no end of confusion.
> If light is emitted at a constant wavelength independent of the stretching of the universe, doesn't that imply light is traveling through a higher spatial dimension, otherwise the emitter itself would be stretched with the universe and we'd never be able to observe differences in the speed of light? If I understand this paper, once light is emitted, it's "stuck" to space and will stretch along with it. But if the emitter wavelength stays constant doesn't that imply it's waving through a higher dimension?

I'm not totally sure what you mean by a higher dimension. The properties of the emitter (which is, e.g. a laser cavity) aren't affected by the gravitational wave because the emitter is a rigid body, which doesn't get stretched. (It's the same thing as described here: https://news.ycombinator.com/item?id=22990753 ) So it puts out light of a given frequency.

By contrast, LIGO is not a rigid body, because the mirrors at the ends of the arms hang freely, hence allowing gravitational waves to change the distance between them.

> What's baffling to me is everyone who has tried to explain the LIGO detector doesn't even realize this question exists. I've independently thought this question and when people start explaining LIGO to me, and I take the time to spell out the question, they realize they don't understand LIGO either.

Yup, it generally is the case in physics that over 95% of people who claim they can explain any given thing don't actually understand it! But the professionals are aware. I even know a LIGO guy who goes to popular talks armed with a pile of copies of the paper I linked.
The Australian government is not to be trusted, they (both parties) have been trying to take control of the internet for decades now, and even when they're not trying to do something nefarious, government IT projects have a long history of incompetence. Even recently (but before CV19) they've been drastically increasing the reach of the state to spy on people and force backdoors into software.
I agree that not everyone's entitled to waterfront views, but I think that in a functioning society everyone would be able to own a decent house (e.g. one that gets sunlight), within a reasonable commute of their work, in desirable part of the country (e.g. in a cosmopolitan city).

The difficulty that I see is that housing prices in America are so high that it's unrealistic for moth people to create enough value to purchase a residence at even that basic level of quality.
Well I think there are two things here. Yes, they had black hole experts work on the film and even generate the film's blackhole images (iirc) from Kip Thorne plugging in relativistic formulas into Mathematica. That is probably what your friends are referring to. Of course, any Hollywood science fiction movie also has some make believe in it. In this case the inside of the blackhole allowing him to communicate with his daughter and therefore save himself didn't make a ton of sense (I would assume paradox, but I think the laws of physics break down in the singularity so they used some extremely heavy hand waving). That part isn't what your friends are likely referring to.

I thought the music, acting, and triumph of humanity were pretty inspiring much like Star Trek can be despite the fact that most of the technology violates the laws of physics. You may have thought it was a terrible movie which is fine. I thought Star Wars Rogue One was one of the most boring films I've seen in the last decade, but a LOT of people loved that film.
Nebula Graph: A Linearly Scalable, Distributed Graph Database Written in C++
On the flip side. I have a friend she is native Japanese, divorced, clerical worker with low income. She got a used house in the suburbs of a small city. (30 minute bus/walk commute) She basically only paid for the price of the land. The house itself is in good shape and the only maintenance issues have been the ones you'd expect from a twenty year old house. Heater replacement, a kitchen vent. I've been inside the house and I see no evidence of shoddy construction. (not that I'm trained to spot it).

My point the housing market like it is makes it much less likely for people to become homeless. Japan's homeless numbers reflect this.
The now classic Bernoulli vs Newton debate.

"Air flows faster on top" is the Bernoulli explanation. The Bernoulli principle tells us that fast air means low pressure, and low pressure sucks the plane up.

Newton explanation is the idea that the wing pushes the air down, and by reaction, pushes the plane up. Based on Newton's third law.

In reality, both are correct. The Bernoulli explanation is more specific and the Newton one is more generic. But if you want the whole picture, you need the Navier Stokes equations. Unfortunately, these are very hard to solve, so even engineers have to use simplified models.

I personally prefer the Newton explanation. It explains less, but the Bernoulli one is confusing and results in many misunderstandings. For example, that air takes the same time to follow the top side and bottom side of the wing, which is completely wrong.

The common depiction also tends to hide the fact that the trailing edge of wings is at an downwards angle, even though it is the most important part. Nice profiles make wings more efficient, but the real thing that makes planes fly is that angle, called angle of attack.

Focusing on the profile rather than on the angle of attack leads to questions like "How can planes fly upside down?" (the answer is "by pointing the nose up", and that should be obvious). If you are just trying to understand how planes fly, forget about wing profile, it is just optimization.
You're being a bad customer. This isn't how it works. When it breaks, you take it to the Apple Store and pay your dues. Apple will not succeed if people like you try to game the system.
Couple of points:

1) 100kg is a measure of mass, not force. Thrust is a force, not a mass. But let's say you have 100N of thrust per engine.

2) Why would changing from a high-wing to a low wing monoplane require you to add prop blades?
It would be more true to GVR's original inspiration for the language if Python-based businesses named themselves things like "Ministry of Silly Walks", "The Antlers of Dictation", "Tobacconist", or "Bevis, Be Gentle!" rather than "Coiled", "Anaconda", etc. ;-)
I run independent repair shops for a living, and we do board-level repair.

In general, when training techs I tell them to start with the easiest possible solution and work up from there. Since MacBooks are so heavily-integrated (so much is on the logic board), it’s the last place I look.

First order of MacBook repair when it won’t turn on: Start with a SMC reset. It usually doesn’t fix the problem, but occasionally it does. (If it does, I don’t charge the customer.)

Second step: Try a known-good battery. It is more commonly a battery issue than a logic board issue.

Third: Inspect the board for signs of water damage.

With PC laptops (and in general, laptops that are easier to repair), there are more steps here. But with MacBooks, this is about it.

We fix MacBook logic boards, but I would also recommend Tim Herrman over at https://www.tcrscircuit.repair/ for logic board repair. He has a YouTube channel where he talks a lot about MacBook logic board repair as well, and he’s been on Louis Rossman’s channel a few times too.