skysight-inc/HackerNews huggingface dataset:
I'm not GP, but I would say it is essential to understand query plan debugging if you're doing, or plan on doing, database development at any scale--scale of data throughput, or scale of the size in code/developers of the application. It's essential in three ways: in principle, practically, and career-wise.

It's essential in principle because RDBMSs are not magic, but are asked, as an application grows, to do increasingly magical things. Understanding how, and more importantly why the DB chooses to execute your query in a given way is absolutely key to understanding how to design data flows and distribution across the non-DB parts of your application. The people who designed your RDBMS are smarter than you; the query planner is (albeit limited) insight into how they applied their intelligence rather than just how you benefit from it. Understanding that databases are collections of variously-traversed data structures underneath, chosen carefully to balance multiple use cases, can lead you to better understanding of other code you write.

It's essential practically because without consistent discipline and coordination (things that diminish, typically, as companies and codebases grow), queries and schemas tend to grow over time. Even outside of the complex reporting use cases, it's not uncommon to have really big/weird queries running on a very high utilization production database. Those queries interact with other stuff that's running in sneaky ways, causing everything from slowdowns to absolute deadlocks, and understanding exactly what is breaking them requires a thorough understanding of how the query plan works. "Add indexes and don't use the DB as a message queue" is excellent advice, and will get you very far, but past a certain size/cruft level, you need to go deeper.

It's essential career-wise because every company with more than a handful of engineers has a database guy or gal, and that person is typically considered essential and worthy of lucrative reward--even in environments where other backend engineers are considered replaceable cost centers. This is usually not the DBA, but an application developer who really deeply understands how the queries from your code hit the database, how it behaves if more than one of them run at the same time, and how to fix it if it breaks. A DBA debugging an unfamiliar/new query has to start from closer to first principles: how is it broken, how to tweak it to fix it, how to isolate it, etc. The database guy starts from the other end: is the code that generated it sane, given the data access patterns it's requesting? The querying code is a solution to whatever problem its writer was trying to solve, but is it the right solution? The query planner and database statistics/activity views are this person's bread and butter.
> (usually with a couple of hundred ID's)

> I had an update loop go from taking 90 seconds to 3.

How is the performance with prepared statements? It seems like repeatedly executing the same statement with different values is what prepared statements are made for.
> And Russian empire was not that much backwards. Their economy was agriculture-based

That's quite an understatement, the Russian empire did not do any industrial revolution at all, it was a mostly undeveloped agricultural wasteland.

> Plenty of countries had to catch up with the UK.

But none of them succeeded to the extent of the Soviet Union at that time. One of the main argument of the communists at that time was actually to point out the failures of capitalism in Asia as why capitalism would never work. At that time the industrialisation receipe did not work for a lot of countries and plenty of people believed the industrialisation of the West could not be reproduced, and especially not with capitalism.

Everything is obvious in hindsight, it's how history work, you would create your own country now, it would not take that much time to industrialise it with modern techniques. The Soviets managed to take one of the least developed agricultural country of Europe (comparatively worse that current African countries) and transform it into a global superpower while other countries failed to even industrialise, this isn't a small feat at all.
Totally dating myself here.

In the Hardy Boys book “Hostages of Hate”, Frank Hardy’s girlfriend, Callie Shaw, is kidnapped and is able to send a secret message to Frank by blinking her eyes on a video recording.

Funny what sticks in your mind from a young age.
Science, Technology Section Debuts at Beijing Int’l Film Festival
This is arguably tangential, but also arguably relevant:

How does hardware video decoding and encoding work?

Does the fact that modern processors have on-chip GPUs with acceleration mean the instructions are any different?

(Graphics has long been a "???" of mine, but I don't want to get into generalizations in this particular thread. Hardware video {de,en}coding seems mildly relevant though.)
My impression is that "US taxes are complicated" arises from the fact that they have such a wide variety of possible tax deductions and tax credits, each with complicated conditions and rates. For medical expenses, moving expenses, training expenses, for various personal purchases that you use for work, for solar water heaters, and so on.

If you earned salary from one employer and used only a few standard deductions, then filing US taxes should be easy as well.
Technically yes, but that's really just the raw buttons and switches.

A version of the godbolt compiler explorer that included execution would be cool.
Sure, I agree with those two points.
Though this does throw away early-exit, which means it will be many times slower for unsorted cases.
Kernel lockdown locked out – for now
>I do feel that my sense of pleasure from other things in life has been somewhat blunted for many years after.

ex addicts always say stuff like this. or, "I started balding after getting clean!" "I have no more energy!"

its also known as getting old.
MS has given up 'significant sales' over concerns customer will use AI for evil
Was Nigeria's ruling party's Twitter account sold to John McAfee?
The most moving Morse code story I’ve heard is this one from Somalia: A man writes a letter complaining about conditions in a hospital, and the government imprisons him in solitary confinement, with no one to talk with and nothing to read. After eight months, his next door neighbor whispers across: “Learn ABC through the walls....” and he learns an ad-hoc Morse Code through knocks and taps. Then, after two years, the neighbor begins “reading” to him, via the code, the 800 page novel Anna Karenina.

https://www.npr.org/2017/09/11/550058353/rough-translation-h...
It's really not much more complex. This is from someone whose bro has been hospitalized twice. Antipsychotics work wonders and ”solely by some checmical” sounds rather ignorant. Guess what, you're life IS controlled by some chemicals.
I think this would be doable with QEMU, which AFAIK reasonably keeps up with CPU capabilities.

Hm, it could actually make for a fun hack.

Adds to todo list
Unless the ticket subcommand has been radically redesigned it is very clunky to use. Some of my complaints when I used the CLI last: Multiple runs of it with long parameter list are needed to navigate. Updates involving copying a UUID is a slow process. Updates commands to add comments, change ticket state, add files, etc are unintuitive. Listing ticket information does not nicely fit the dimensions of a terminal. Colorization does not appear to render in a terminal. No input validation. Cryptic documentation per sub-command.

As per the JSON API and TH scripting, they're both for the web UI (AFAIK) which I was trying to avoid if possible as it slowed down my overall workflow (though much more time has been put into making that usable by the fossil devs). As a last note TH is a bit of an oddity which I imagine may be a turn-off to other people getting started with tweaking fossil.
If you select a checkbox on the left, when you clear it the page scrolls back to the top. >_<
I've always been under the impression that H&R block tax preparer are not very qualified employees who aren't regulated in any way, and don't have to really undergo any rigorous training.

It's worth ponying up a little extra for a CPA, or spending a little extra time reading the instructions on the tax forms and googling/asking online for answers.
No, they're not good enough. If you can read what's in the memory or disk images, then you can find all the interesting things there are to find.
I think morse code could be helpful for someone with locked-in syndrome, like Jean Bauby. In 'dictating' his memoir 'The Diving Bell and the Butterfly', it took him an average of two minutes to write each word by blinking at the time when the next letter he wanted was presented to him.

https://en.wikipedia.org/wiki/The_Diving_Bell_and_the_Butter...
You can only deduct 10k of state taxes starting next year
https://en.wikipedia.org/wiki/Attack_of_the_Crab_Monsters
Also Template Haskell is not supported by all Haskell implementations (eg: Reflex on mobile).
Because the represent a group which has membership in your district.
Of course, I’m familiar with the term and its origins. Obviously bacteria were not created by humans, but they were a runaway reaction that ended up covering the entire planet and even deep below the surface. The early microbes were things like hydrogenotrophs (etc) that could feed on non-biological matter, although limited compared to the hypothetical technological version.

I was just pointing out the oft-observed notion that the development life itself (especially simple life like bacteria) was a kind of grey go moment, but is being held in check by viruses.
> It implies no choice, it implies that your life is controlled by chemicals.

This implication would be correct. Hormones and other chemical messengers heavily influence brain "states" such as moods. The brain learns to make decisions that maintain homeostasis through the development of somatic markers, which represent body states that are composed of nerve and chemical activity. Even nerve impulses themselves are initiated by chemicals. And of course the structure of your brain and body are dictated by, you guessed it, chemicals. (Specifically deoxyribonucleic acid.)

"Choice" is a powerful illusion driven by our hypercompetent rationalizing system, whose purpose is to hide our true intentions in order to help us better operate in a social world. In the end, we are just elaborate stimulus-response systems, that is unless you believe in a "soul" or pseudoscientific quantum magic.

Edit: to more directly address your point about overcoming addiction. The brain's reward and drive systems are indeed very complex, and I do think that the suggestion of an "ultimate" goal is a gross oversimplification. On the other hand, if someone were able to maintain a permanent high (with no need to re-dose, find more drugs, find money to pay for drugs, etc), then perhaps it would indeed be impossible for them to overcome their addiction. From the addict's perspective, part of the problem with getting high is that the inevitable "low" may be worse, especially when tolerance and dependence kick in, followed by withdrawal.
FWIW HeroicKatora gives an improved version on Reddit: https://www.reddit.com/r/cpp/comments/8bkaj3/is_sorted_using...
Your link disproves you, not him.

"NRA receives 350M/yr in 2014"
"NRA has received, in total, 80M from individual donors in the past 13 years"
"NRA received 22M from individual donors in 2014"

22M of 350M revenue means that individual donors are very small.

Where does the other 330M per year come from, if not individual donors?
Offtopic, but I have a really difficult time reading articles like this. I don’t know if this reflects a problem with the style or my ability to focus, but I find it really annoying:

> “SANDHOGS,” THEY CALLED THE LABORERS who built the tunnels leading into New York’s Penn Station at the beginning of the last century. Work distorted their humanity, sometimes literally. Resurfacing at the end of each day from their burrows beneath the Hudson and East Rivers, caked in the mud of battle against glacial rock and riprap, many sandhogs succumbed to the bends. Passengers arriving at the modern Penn Station—the luminous Beaux-Arts hangar of old long since razed, its passenger halls squashed underground—might sympathize. Vincent Scully once compared the experience to scuttling into the city like a rat. Zoomorphized, we are joined to the earlier generations.

This goes on for about seven paragraphs before I have any idea what the article about. I understand “setting the scene” but I can’t tell whether or not to care about an article if it meanders about with this flowing exposition before indicating what its central thesis is.

It seems like a popular style in thinkpieces and some areas of journalism. The author makes a semi-relevant title, provacative subtitle, and five - ten paragraphs of “introduction” that throw you right into the thick of a story whose purpose doesn’t seem clear unless you know what the article is about. Rather than capturing my attention with engaging exposition, I find it takes me out of it. But it must work if it’s so uniquitous; presumably their analytics have confirmed this style is engaging.
There's a genetic component to depression, there is a societal component to depression, and there are situational components to depression. A lot of therapy is to identify rumination when it happens so that you can short circuit that neural pathway (thought process) and focus on being more realistic (ironically) or in the moment. You can think of depression as a deep neural network that's been overtrained on certain inputs to always predict depression. A life or death scenario forces you to act in the moment and decide in the moment (or very near future). That short circuits the rumination as well. Maybe it is an entirely different brain system as well.
This isn't even an argument.
Let me rephrase then:

"Why does this _headline_ feel a little like fear-mongering?"
And people whose only jobs as adults have been elected or appointed positions will still mysteriously become worth 7 or 8 or 9 figures by the end of their careers, even though their only reported income has been a government salary.
It could be that they've adapted to the input. Basically the novelty of the dive has worn off. It'd be interesting to see if they still get the same adrenaline response every time.
Doesn't this strongly imply that we are actually quite immune to virus naturally, and only that a depressed immune system is what allows viruses to wreak havoc?
I enjoyed it and I think that it is helpful in the sense of calling "naked man" at the emperor. It doesn't do any harm at all for the AI community or startup community to look at itself and think hard about what it's doing and saying.

This time round there will be no million fold increase in compute power to bail everyone out!
Open source software, in general, tends to make things more reproducible. Sure, software licencing might not be the singular root cause, but why does that suggest we shouldn't capitalise on the improvements available?
UK & Ireland still does trial by jury for a lot of trials. So it's not as straight forward as everyone in Europe/EU doing it the same
The slides for this talk.

https://github.com/nilenso/media/blob/master/presentations/v...
I got a tour on one of the first two LCS ships a while back. It was pretty apparent that it wasn't fit for purpose.

One glaring example was that its hull could be Swiss-cheesed by a mere 50 caliber machine gun.

Another bad sign was that their proposed solution for dealing with small incoming boats was to drive the ship in a manner that swamped the enemy with wakes.

I understand the need to let R&D take risks, but I think LCS made it too far off the drawing board.
Ask HN: Jenkins vs. Spinnaker?
Hi all,

Anyone used Spinakker in production? How is it going compare to Jenkins? What's the benefit and drawback?
Whatever they say, Omni-Path isn't (compatible with) Infiniband just because it supports the Openfabrics interface, like some Ethernet technologies. Qlogic's Infinipath was, so you could mix Mellanox HCAs and Qlogic switches, for instance; I assume that also applies to Truscale, but I haven't used it.

DFT programs like VASP are likely dominated by time in mpi_alltoallv at scale, and probably depend on the implementation of that more than the fabric, assuming similar latencies. I don't know how/if that's helped by offloading; I (and a colleague at another site) couldn't make a previous generation of the support work properly and promises of help never materialized. Also, real usage may not reflect IMB-type mpi_alltoallv benchmarks. (VASP is a particularly unfortunate example, since the licence requires you to be a member of a specific research group, as opposed to general support staff or, as far as I could see when I read a copy, vendors.)

At least without the complication of offloading, according to http://simgrid.gforge.inria.fr/ a few P2P metrics characterize the network well for simulating real MPI programs/libraries.
It’s annoying to see this pop up every year. H&R Block and Intuit aren’t somehow blocking tax reform that would simplify filing for all the other huge companies that do taxes. That’s an absurd theory. They’re lobbying to support something that’ll happen anyway because a huge bloc wants people to be outraged every April 15 when they do their taxes.

And you know what? It works! Every year I write a check to pay our marriage penalty and fume about how it. I think it’s responsible for why middle and lower income Americans feel like they’re over taxed (even though they pay much less taxes than in europe).
All countries in the world was pre-industrial monarchies just 150 years ago. Please point to your point.

Moreover, in WWW2, USSR lost about 1/6 of population. It's hard to name such losses as "win". Western Allies, which is also at war with Germany, provided continuous aid to that "superpower" in addition to their own soldiers at war.
What can we do to support healthy physical posture and movement whilst also maximising productivity when working with with electronic representations of textual and numeric data?

There are some obvious avenues to explore -- but it is not clear if anything is going to be available to consumers in the near future.
I really don't understand for this is trolling in China they do stuff like this all the time and it's very effective, I just think we need to discuses these things openly. I see it as inevitable that something like this happens, the sky high salaries paid to private sector who add no appreciable value to society is unsustainable.
Vipassana has helped me with so much physical and emotional discomfort and pain, precisely in this way.
What kind of money do you think is involved?
There isn't a check box on the LLC form that says all your actions from now on must be evil. There are going to be citizen interest groups you disagree with and corporations you agree with. And a lot of high-profile lobbying is corporations arguing against each other.

If there was a simple heuristic like whatever corporations want is bad and whatever individuals want is good, then governing wouldn't be hard. Policy would be easy and not full of complex dilemmas with multiple competing interest groups that all have roughly prima facie coherent perspectives and interests.

Some of these groups will of course be wrong on further examination, but sorting that out isn't some one line test.
Those attitudes were complex and reflected the Jefferson republican positions that faded as well as the tension between the cash rich north and land/slave rich south.
This episode of Sam Harris' podcast may be a good starting point.

https://samharris.org/podcasts/111-science-meditation/
> The tie-breaker is financial.

It can be both financial and social: individual institutes are all too happy to pay for Mathematica licenses, and consequently institute members can use it to produce reproducible research with it. However, the reproducibility of the resulting notebooks is drastically hindered by the fact that a reader essentially also needs to pay for Mathematica to get the full benefit out of these notebooks (even if they are readable without Mathematica). As a consequence, few people bother using it even though they can afford to. Social drivers disincentivise its usage.

By a similar dynamic, Git beat out the competing DVCS: in this case mostly technical rather than financial factors that drove individual actors to prefer Git over alternatives (due, to a large part, to GitHub). But many people don’t actually care about technical considerations (or even prefer other systems over Git in this regard). What people most care about is seamless integration. In the end, a social driver caused Git’s adoption.
Is there any theory that suposes this might happened, on a small scale, and the temps (and crust) warm? Could that loosen things up, so to speak, and trigger more volcanic activity?
Austin is piloting blockchain to improve homeless services
Campaign contributions, for one.
I don't mean to knock the pg docs but I honestly come away reading them with the feeling "what did I just read?". They seem dense and dry. So personally I appreciate the articles like this to help me really learn. I will skip over official documentation and go to this sort of content.
Laundry folding robot with actual smarts to it: https://m.youtube.com/watch?v=DzK38ylMTXk

Inferior to a human, sure. But a start.
Could the algorithm be applied to block cache problem with single item size, like filesystem block cache or database cache?
Big companies don’t need lobbyists to influence government. Environmental organizations do.

Look at Amazon. They put out bids for a place to build HQ2, and states fall over themselves to accommodate them. Corporate donations to candidates are already illegal. It doesn’t matter—the CEO of a big employer can just call up a Congressman and say “hey, I employ 10,000 constituents in your district. It’d be a shame if anything happened to their jobs.”
I actually like the baffler, but I 100% agree. The New Yorker and LRB are similar with the new yorker being far far worse. Its distracting and takes away from the story for me as well, and I love long form journalism.
The kind of money that wins an election.
https://youtube.com/watch?v=1BWYqHbF00c

Glad the pdf doesn't include the annoying baby nor the occasional father head covering the presenter.

Parents that bring babies to public events bring out the aggro-nihilist in me.
I'm not sure how you got that impression from this article. We don't learn very much about Amber, but nothing in there seems to suggest that she's unable or unwilling to work as hard as anybody else to achieve her dreams, merely that school doesn't offer any options which are appealing to her. I think it's very disingenuous to suggest that any paths which are not supported in current schools are "lazy and unmotivated".

It's a story so common as to be a trope in media for the school dropout to end up going on to great things once they find an avenue for their enthusiasm, and the article hints that Amber may be finding something like that in her culinary work.

How, then, is this meaningfully different from typically well-recieved stories about teenagers who don't get on with school but are enthusiastic engineers or programmers? The specific path is different, but the story is the same. Why should one be interpreted as "potentially the next Bill Gates" and the other as "lazy unmotivated"?
Summary: Some Android phones only pretend to install security updates
Generic code yields better results than SSE/AVX optimized ones. I wonder why that could be.
What is the advantage of using Gnome Maps over just OpenStreetMap.org? From their website[1], it seems like it's still just a client for the various services
Thank you for your tips. I see myself in the same situation you were a few years ago: After several years of experience, I'm a bit of tired of doing great stuff for so-so pay, also, I'm looking for a relocation.

I'll certainly put finance as an alternative, now.