skysight-inc/HackerNews huggingface dataset:
> In SQL it boils down to the fundamental syntactical requirement to put the SELECT clause before the FROM clause

No offence but if you are at the level of struggling with the syntax then you should not be using SQL until you have more experience. There have been plenty of well-founded critiques of the crappy syntax of SQL, but it's not ultimately that hard. There are worse things you'll have to cope with such as the implications of 3-valued logic that comes with nulls.

The giving-tables-alias-names feature has been standard probably since the very first standard was released. In some cases such as self-joins, it is necessary.

If I can give you a piece of advice, arrange things using the 'with' clause and learn to break things down as simple as possible at each step. Let the optimiser sort things out for you. If performance is poor, look at the query plan. Also understand you don't have to write everything in one huge statement. Spool intermediate results off to temp tables if that helps (not @tables but #tables - @tables have problems with them).

As for the XML, I guess that may be better handled outside the DB. IMO XML should never be made part of SQL. Good luck.
For those wondering how this works under the hood, there is a great presentation: https://www.youtube.com/watch?v=9eOo8hSbMAc

I wrote out a quick analysis of the details there along with some looking into the backing code in text format here: https://github.com/SaturnFramework/Saturn/issues/228#issueco...
Betteridge's Law of Headlines: "Any headline that ends in a question mark can be answered by the word no."
Oh, sure! But those who didn't live through the hype may not know that it was expected to revolutionize transportation. "Venture capitalist John Doerr predicted it would reach $1 billion in sales faster than any company in history, and that it could be bigger than the Internet." [1]

[1] https://www.wired.com/2015/01/well-didnt-work-segway-technol...
That also works, but you can't really do that until like midgame unless you use some mods. You need to have at least red and green science production and have researched a fair bit of technology before you get robots. Then you need the chests which is another tech. But yeah, normally once I get the robots I setup an automation factory just to create robots and put them in the roboport.

Then I can start getting rid of belts by just having the robots do the work. Setup a hit load of worker bots on the perimeter to fight any of alien things and fix the damage automatically.

The robots change the approach massively. But, I also enjoy the process of creating belts that get consumed near perfectly so that I create the exact same amount of each science. That's just my OCD side of things though.
Those are toys. Back in the day, Kamen was going on about redesigning cities around them.
I will make the (likely unpopular) comment that point of care ultrasound (POCUS) doesn't have a large impact for Covid-19, because Covid-19 is primarily diagnosed via PCR of a nasopharyngeal swab, and pneumonia is primarily a clinical diagnosis confirmed by a chest X-ray. There are already portable chest X-ray machines in the ICU. However, if a patient develops fluid around their lung (pleural effusion), lung POCUS can be used to guide a needle into the fluid pocket and drain it (thoracentesis). This can help patients breathe better and is truly useful. Modern ICU's already have fancy portable ultrasound machines available, so the main difference in the handheld ultrasound versions is the lower price and inferior image quality.
This loos like a nice thing to try and do with my kids while we are confined. Does anybody have any experience with it? Do you know of other comparable (or better) resources to introduce kids to CS?
I hope so. It's cancer on our society.
I'm actually opposed to UBI for the foreseeable future, for what it's worth, so this submission pushes no agenda of mine.
That wouldn't be "London city" that would be "a village which the latter settlement of London expanded to encompass"; which is significantly different. Not longest inhabited areas, but continuously inhabited city.
At first I missed for loops.

Then I was empowered and did not miss for loops.

Now I still miss for loops.
https://www.edweek.org/ew/section/multimedia/map-coronavirus...

Just search on "schools shutting down for the rest of the year" and you'll find a bunch of sources. Of course it varies by state/district here in the U.S., but many are opting to shut down completely rather than attempting online instruction.
We need more than a single, probably biased and non-peer-reviewed study in an unreliable newspaper and without any references for such claims, especially given the nationalistic propaganda being pushed throughout India right now.
I have heard similar stories from other ethnic Czechs (they have obviously intermarried in the generations since) from Iowa. As mid-western cultures go, some people from Norwegian communities in North Dakota still speak archaic Norwegian. To a lesser extent (probably more melting-pot effect?), Swedes in Minnesota and Germans in Wisconsin.
I see a “Try for free” button, but I don’t see any pricing links. Please add pricing information prominently on the site even if it’s not yet completely figured out). Generally, I’d like to know what I’m getting into before I get into it and invest time and effort that could potentially go to waste.
You were running a lower risk of getting caught, but if you got caught, you could easily get slammed with all kinds of outlandish stuff back then, mostly due to the general public ignorance of computing and hacking. These days, you have a way higher chance of getting caught, but the punishment is more reasonable and fair imo (even though it is still way overblown most of the time).

What instantly came to my mind was the Kevin Mitnick trial, where "law enforcement officials convinced a judge that he had the ability to 'start a nuclear war by whistling into a pay phone'"[0].

0.https://en.wikipedia.org/wiki/Kevin_Mitnick#Arrest,_convicti...
Building on solid ground: ensuring reproducible Docker builds for Python
It’s often because of political influence campaigns that history is actually destroyed, and in such periods there is no appetite for objective historical research. If you are a Muslim ruler trying to convert your subjects and the Sun Worshippers are leading a resistance then destroying their 700 year old temple that reinforces their identity is a no brainer.

This type of thing is widespread throughout the world [1] so there’s no reason to doubt it has a much longer history than records can follow.

[1] https://en.m.wikipedia.org/wiki/List_of_destroyed_heritage
Waiting for Star Citizen to use Coronavirus to finally admit they’ll never finish the game.
How to build a darkroom for £100 or less
NordVPN unveils first mainstream WireGuard virtual private network
Spotify: Artist Fundraising Pick
Why would AI solutions help the fossil fuel industry burn more oil and gas? The fossil fuel industry sells oil and gas to others to burn, it doesn't light the stuff up itself for fun.
Theranos was already the Theranos of tech. Magic Leap is just an overhyped product that promised more than it could deliver, not an outright fraud that jeopardised the health of its users.

Or if by tech you mean "purely software (preferably Internet-based) company", Magic Leap does not fit into that category any more than Theranos does, both being primarily hardware companies.
Bit Flip: The biggest bug you've never heard of.
In the same way that if the government is tracking our private conversations to detect human traffickers then it's broadly ethical and reasonable from an ethical perspective?
I think a lot of that is going to depend on the types of investors left in the stock market and the types of Highly Paid Consultants that Sell Their Vision after all of this.

At the moment it seems equally likely that some companies come out of all of this with the "lesson" that remote work caused their downturn in productivity and stock value (who can remember that every other company experienced the same when your investors only care "what have you done lately?" and "what have you done 'proactively'?") and we'll quickly see a return to "everybody needs to be in the office together" culture back backed by the same consultants that learned the wrong lessons after Marissa Mayer's Yahoo! house cleaning and were still badly ratcheting companies towards as miserable as possible colocation strategies.

It seems about 50/50 to me right now which group will prevail. At least with US public traded companies the only inertia seems to whatever shiny fad stock traders are enamored with versus whatever misery HPCs manage to sell on golf courses in C-Suite handshakes. (ETA: Some of whom, the worst stock investors and HPCs are the same people, of course.)
Square Terminal now has an API
Good point. I guess I should have said "modern technological civilization" or something like that rather than "homo sapiens", although MWC is not quite right either. What I was trying to get at was whatever quality it is in humans that moves them to build cities. Whatever that is, the humans in Canberra in 20000 BCE didn't have it. (That's not meant to be a value judgement, just an observation.)
Tangentially related: C++ does have algorithmic complexity guarantees. For instance, std::unordered_map at() and operator[] are guaranteed to be average case complexity of O(1), and std::nth_element is guaranteed to be average case O(n).
Applications of Magic Leap would likely be similar to the industrial applications of HoloLens 2.

Some examples:

- https://www.youtube.com/watch?v=V8c3pDKdHEc

- https://www.youtube.com/watch?v=QTuKcm8s4QQ

- https://www.youtube.com/watch?v=loGxO3L7rFE

- https://www.youtube.com/watch?v=6pyiiO72ZwM

If you search on youtube for "hololens industrial", you can find other demos. When HoloLens 2 was announced, I think Microsoft showed a number of demos of why companies would buy it for their employees to use on the job.
I think Windows and Linux both have NUMA capabilities in their kernel. Long story short, you don't have to think too much -- get one of these and try it yourself.
Found it to be pretty unstable compared to zoom, especially when you get more people on it. Trying to convince people to use it is frustrating.
Sounds like a good enough alternative to me given the circumstances. iPhone SE has fingerprint option.
A Scalable Validation of Binary Lifters [pdf]
Thanks @monocasa - I do see the grayed out text and can associate that with down votes. But I've also seen people commenting on Non-grayed out comments that people are downvoting it. It feels like they're seeing something I don't.
Agreed - which is why I strongly support the administration demanding equity in the companies that are receiving money.

And I only support money given as loans which must be paid back. Any kind of grant money must be exclusively used for payroll or other qualifying operating expenses.

The current stimulus is not perfect but its pretty good and FAR better than 2008
Apparently HL Alyx is exceptionally good, maybe will Mark a bit of a turning point
Low interest rates certainly lead to non-optimal housing development. I completely support massive government funding of energy, nuclear, technology and research.

But I don't support the NY Fed and the bank CEOs controlling the open markets, setting the interest rates and flooding dumb "elite" investors with cheap money so they can build bad systems. Having 1 of 12 FRBs dominate the monetary system is a flawed idea, especially when that 1 is Wall Street. Financial engineering is dangerous and antithetical to real research, development and progress.
Presaged in the sense that there was also a lot of VC-driven hype that didn't work out, sure. I'll admit there's a slightly higher chance that scooter rental still might turn into a real business. But it's definitely not a given.
Music is culturally contextual and temporal in many ways. Think of Floyd's The Division Bell, an album which tries to capture the feelings and emotions that resulted from the fall of the Berlin Wall. Or think of RATM's self-titled album, which was a reaction to the police brutality and race tensions that were churning in the late 80s/early 90s. Or even MGMT's Little Dark Age, which is filled with opinions surrounding our modern affection of social media and smartphones.

You're living in today, and there's music being released that touches on the common struggles we're all going through as human beings in today's world. If you wait 10 or 20 years to listen to modern music, you're purposely removing yourself from this conversation.

If music is just nice sounds to you, then that's totally fine, but for a lot us it's much, much more than that.
On the contrary, this is exactly how scientific communication works. Nothing is in absolutes. If you want absolute language look to religion.
The solution to this is super simple. Offer 600+n where n increases until they agree to come back. Don’t have a viable business at those labor costs? Bummer.
And apparently they won't have either against Ryzen 4000 desktop (Zen3 on 7nm+). Interesting times ahead...
> "I think part of it is there is no scene for music any more?"

> There are plenty of music scenes, but I do think they are not as big and influential on overall youth culture anymore.

I think what changed is that gate-keeper, hyper-promoted acts don't hook as much of the youth as they once did.

We have this one local music festival that's made up of hundreds of acts playing in dozens of small venues. The audience is huge but it's dispersed over 10 city blocks so you don't really get that crushing mob feel.
In C and C++, a char is by definition a byte.

A byte is CHAR_BIT bits, where CHAR_BIT is required to be at least 8 (and is exactly 8 for the vast majority of implementations).

The word "byte" is commonly used to mean exactly 8 bits, but C and C++ don't define it that way. If you want to refer to exactly 8 bits without ambiguity, that's an "octet".
I got very lucky and got a a very used Epson 3500 on Ebay for $350.

Keystoning not a problem. I knew I didn't need 4k. I just needed something that could go BIG and fill up the whole wall floor to ceiling to get the effect I was going for.
Languages change -- sometimes dramatically -- over the course of centuries. English wasn't even a thing until the 1100s or so (Middle English). It would be very hard to exchange thoughts and ideas with the people of this time -- not only because of the different cultural and technological contexts but also because of its pronunciation and phonology.

Its predecessor: Anglo Saxon is even more distant from it. Try to read the passages here: https://en.wikipedia.org/wiki/Old_English#Beowulf

Latin (as an artificially conserved language) has not changed that much since Roman times, but it isn't a language that is actively used in everyday life -- so you cannot claim it is: "continuously spoken over time".

Hebrew and Arabic could be interesting cases -- maybe someone more knowledgeable than me can chime in on these... But I assume ancient Hebrew and Arabic are also not mutually intelligible with the corresponding languages today.
Ha, yes, and what language. My example won’t work for ŷ and any others like it.
Concur. Immediately rushing me to make a decision about a new topic will make me think they are being dishonest. It can certainly work to close a sale, but please practice consensual commerce.
> Does anybody have any experience with it?

Not this program specifically, but in high school I was taught Pascal without touching the computer for the first couple of months. All of our programs had to be written by hand. And included traces of the code ... all the values of the variables throughout the lifetime of the program. I was disappointed at the time, but looking back, it was a great way to write code. It was more about the meaning of the code, not fighting compiler errors.

Edit: this would have been 1993, when I was in 9th grade.
> Well that looks a bit silly now doesn't it.

It's not silly to try some promising technology that ultimately doesn't work out for business. It's easy to be nasty in hindsight, from the comfort of your home, isn't it? Not so easy to try making it work in the first place.
Currently clang is getting it, if ISO C gets it, it is another matter.
Mental Model Fallacy (2018)
E-learning poor countries during Covid-19, Lockdown?
Hi Guys, I live in South Africa, where there is a huge inequality, other people have no access to the internet. We are currently under lockdown making situation even worse. Any suggestions on what we can do to help bridge the digital divide during this time and make sure even the poorest have access to education.
Thanks,
Jongi
You seem to be contradicting yourself without realizing it.

> You should be constantly learning everything

This is an in-progress action i.e. the developer is still learning.

> I expect a competent developer to be able to build

This is now considering a "learned" developer.

I am not sure you are making the point you think you are making. The point I think you are trying to make is your expectations of what an experience developer should know. But, you seem to be expressing it as what a new developer should be doing.

While the core discussion of the article might be in regards to what developers do and do not know, I can't help but notice that a developer knowing about something does not necessarily allow them to be productive in that area of their knowledge (especially relative to another co-worker with both the knowledge and the dedicated focus in that area).

Also very important to note: the comment you are addressing seems to be referring to knowledge that is local (particular customer necessity/problems, particular architecture choices for infrastructure, particular product design decisions, particular ways to answer the quirky CEO/CTO in a way that they understand, etc.). There is a lot of locale-based knowledge that a developer must learn at a company/job/project and can even change over time (temporal-locales).

Globally-applicable knowledge like frontend, backend, and general CS concepts are for sure a reasonable expectation of an experienced developer. But, there is a delicate balance a developer must take in the real working world that is subject to not attempting to master every aspect of the product/business (especially if it overlaps with someone else's job/focus) just because you have a high-level understanding of the global concepts. In other words, it is not necessarily efficient for a developer to know every aspect of every language and every database in the company unless that actually buys the company more customers and money.

I would expect any decent manager to understand this very basic principle. Everyone in the company trying to be a master at everyone else's job does not help the company make more money. Being reasonable about expectations in the moment is also a critical asset of working together to make money. :)
Maybe. VR is more chicken-egg, like the Windows phone with apps. The more people with VR headsets, the more VR games get developed, but more people won't get VR headsets until there are more games developed.
They are both my comments and both are similar but different, lots more info in this one. I used parts of the other because it is the same topic.
Productivity Tips for the Anxious
Is the number remarkable? I would be very surprised if those were more than 1% of traffic.
This question gets asked a lot because it’s a good question, and the popular explanations, for why big co’s get big, aren’t very satisfying.

I thought this thread was pretty insightful, for a change: https://news.ycombinator.com/item?id=22822995

TL;DR - big co’s get big because hiring is an optimization problem, and each new hire gets you closer to a local maximum. E.g. if we hire an engineer to improve load times by x%, they’ll pay for themselves. More successful companies have more opportunities for positive-ROI hires, so headcount tends to scale with revenue. (And because the company is making a series of local optimizations, it may actually be worse off due to the drawbacks of being a big org.)
Right now WFH has a negative public perception because kids are at home and nobody can leave their home. So there is a lot of frustration that I can understand. But once it is all over, imagine folks working remotely and able to move around the world with freedom and bring more creativity because of their newfound happiness.
Turing complete!
It’s more about container images than just k8s.
Right. The assumption being that with schools being shut down they would see increased business as a result. However, that appears to not be the case. Combine that with an increasing number of their adult students having cash flow problems right now, their business outlook doesn't look great.
Yes. One of the earliest proponents of that was Dr. Zev Zelenko:

https://www.youtube.com/watch?v=4ulqf5NXhms

and

https://twitter.com/RossFairchild/status/1242263727325483010?

"Dr Zelenko statistics – 699 cases / 0 deaths = 0% death rate

PATIENTS TREATED WITH THREE DRUG REGIMEN

1- hydroxychloroquine 200mg twice a day for 5 days
2- azithromycin 500mg once a day for five days
3- zinc sulfate 220mg once a day for five days

CONCLUSION – TREAT AS EARLY AND AS AGGRESSIVELY AS POSSIBLE IN THE OUTPATIENT SETTING

Respectfully,

Dr. Vladimir (Zev) Zelenko"

But Zelenko treated his patients _early_; he didn't wait until they had pneumonia or other lung problems to administer the triad of drugs.

The recent studies that "disprove hydroxychloroquine/chloroquin" differ from Zelenko's suggested treatment in that:

a) they select patients where disease is in an advanced stage, i.e., in in the lungs and/or pneumonia/SARS/ARDS has developed,

b) they don't administer zinc at all: they may not administer azithromycin,

c) these studies usually _overdose_ the hydroxychloroquine/chloroquin. Note that Zelenko used only 200mg hydroxychloroquine twice a day.

Zelenko makes it clear that his goal was to defeat the virus early (ergo the zinc sulfate + hydroxychloroquine as a zinc ionophore, which allows the zinc zn++ ion to move from the bloodstream into each cell's cytoplasm where viral replication takes polace.

Zelenko also clearly notes (in other places) that the azithromycin was a trick taken from ICU doctors, a drug intended to _prevent_ opportunistic bacterial infection consequent to the virus damaging lung tissue.

Waiting for pheumonia/SARS/ARDS to develop before deploying azithromycin or other antibiotics should be considered medical negligence.

Even medicine can't avoid politics these days.
correct. I was just wondering if it also has inbuilt http server as well to process things like static files etc or is that completely on 3rd party tools like nginx (which I love btw). Kinda like in Golang where you could technically use the static file server but I always use nginx for those things.
His post is not addressing this issue of bank fees hes making a wider point about bailouts in general.

I am simply reminding him that airline companies who did nothing wrong have people depending on them for their paychecks. Exactly the same as a child depends on their parent.

And in this case the money given to AIRLINES helps a lot of parents feed their children
This is recent, though. The releases of Java 1-7 were fairly slow and conservative.
(other than customer service, of course)

You actually wrote what is probably a large part of the answer, and then passed right over it as if for a multi-national corporation customer service would be a trivial expense and staffing problem.

There's got to be a "logical fallacy" Wikipedia page for something along the lines of "why did the Hindenburg burn so quickly (other than the large bag of hydrogen, of course)?" :-)