skysight-inc/HackerNews huggingface dataset:
Agree! I like django's ORM and I love SQL databases. It is nice that your in-code model changes, will reflect the schema changes in the database. And migrations are a blessing. (Of course it has some foot guns.)

For optimizations:
my_queryset.explain(verbose=True, analyze=True) is very nice to understand what is going on. If you cannot get it done with django's database abstractions, there is always:

my_queryset.extra() or even my_model.objects.raw(). Where the last one maps the result to the model, for free.

To others responding that ORMs are bad:
IMHO saying that raw sql is better than ORMs is short sighted. Many simple things are nice in ORMs. Queries are often simple. Today, in django, complex queries are also nice. For edge cases raw sql can be better.

Extending queries is also super easy with a good ORM, where with raw sql you would have to maintain two almost the same queries.

Just remember to run and inspect queryset.explain().
In perhaps the most frustrating linguistic confusion of the pandemic (competing with "lockdown"):

A respirator is a mask.

A ventilator is a pump.

Ventilators are far more dangerous than respirators.
People that take this attitude against distributed processing usually have never had to process an amount of data bigger than would fit on one machine or always have the budget to fit everything on one very expensive large machine. It's lack of experience masquerading as cleverness. The only ones that have a right to make this arguments are the people that spread all their processing out as streams on one machine or using distributed streams but even that has serious limitation.
> medicine was Humorism, blood letting and faith healing.

I suspect the doctors of the 23rd century will be similarly horrified by their 21st century counterparts practices.
If isolation with a net connection for a few months dropped multiple IQ points, then all the shut-ins who do nothing but hang around on the Internet all day would be losing multiple tens of IQ points a year and would be functionally disabled by now.
Mean-Bean Is Looking for Mentors
The issue is from 2014...

For "recent" development, there's a lot of work going into fixing latency issues and improving load times of packages generally: https://github.com/JuliaLang/julia/pulls?q=is%3Apr+label%3Al...
Couldn't they just disassociate "Trash" with the label concept? On the backend, implement special logic for the "trash" function instead of tying it to a label, and you can solve the problem.
> you can't version control SQL

Aren't stored procedures part of the database schema? Which can be version controlled?
Is this also a solution to edge-cases for autonomous vehicles? eg. driven by AI 99.9% of the time, and for the 0.1% (eg. breakdown, flooding, police action) they are taken over by a remote driver and driven slowly and carefully back to normal road conditions?
There are several: https://arstechnica.com/science/2020/10/the-unreasonable-eff...

Also comes with some, but relatively light trade-offs for what's gained, IMO. The worst of trade-offs, compile overheads, are mostly not intrinsic to Julia and are being reduced every release and by packagecompiler.jl.
It's totally fair and honest to take an issue from 2014(!) and go ''well this is why X sucks''.
Why not just use Scala and frameless? No style guide needed :)
Now I want to get a job in the server room. Boot strapping the master sounds like fun suddenly.
Potentially great news for adoption

Potentially good news for HODLers

Potentially bad news for decentralization
The @angular repositories do that too... The worst are the "lock bots" which prevents any new information being added to the issue... Which is super annoying.... But it must be hard for a maintainer to deal with the notifications
You're not finding duplicates within open issues, you must find them among ALL issues. There are 20 times more, making that 400 times more pairs (10 billion).
Could you see a product being made from your experience?
You're moving goalpost by quite a bit. Mainstream adoption and seriousness - whatever that might be exactly - are certainly not the same metric. For example, in your sibling comment, you mention ADA as serious language. ADA certainly is not mainstream.

> The fact that a specific corporation has implemented a specific project by using a specific tool is completely meaningless as to the appropriateness of using that tool in another context.

You're entirely correct. That's another goalpost move - nobody proclaimed that being used for business critical projects makes rust in any way magically fit for any and all other conceivable projects.
NP-complete problems can be polynomially reduced to each other. If you had a magical oracle that was able to solve any one specific NP-complete problem in O(1) time, you could turn that into a O(n^k) solution for all NP-complete problems.

That's the idea behind DNA-computing, for instance.

The question is whether it is actually possible to do so at a reasonable cost and at scale.

Regardless, what "nature" does has 0 to do with P vs NP, computability or anything else. P vs NP is a statement strictly about mathematical objects, there is no notion of "nature" anywhere in it.
What seems weird about this is that the process for deciding that an approved drug is useful for a certain condition (not the one it was intended for) is really informal, it seems to rely on common knowledge circulating in the guild.

For the initial approval, we have this very formal process, the FDA wants this kind of data from trials of this size to show this statistical level, etc. All very scientific-looking.

But once it's on the market, random doctors try it out for other conditions. If it seems to work they tell their buddies, tweak the mixtures, share anecdotes. If it becomes widespread, some industry club records this for the purpose of arguing with insurance companies. I am told this off-label use now constitutes the majority of drug prescriptions. All based on (as far as I can tell) no statistically driven testing at all, just stories.

(To be clear, I'm not at all surprised that drugs have "off-target" effects, and may be very useful for things their inventor never imagines. I'm just a bit shocked how pre-modern our system for collecting this knowledge appears to be. But not an expert, and would love to know more.)
Energy scavenging nanogenerator finds power all around us
Speed. Multiple dispatch. A language actually designed for numerical work and data science and all that, instead of a language that accidently found a niche there. A chance to look at the status of Python and fix it's pain points.
Because they don't use it or because they "reinvented the wheel"? Perhaps it wasn't mature enough when they started this journey.
House-wide RCDs are also standard so if any current is not returned through neutral the circuit will be broken.
Pretty much never.

People who are basically commodity steering wheel holders will get outsourced to low cost countries and then to AI. People who's job requires thinking don't have much to worry about.

Most forklift drivers have duties that include a non-trivial amount of getting off the lift and doing some amount of moving things and a good amount of planning (often specific to the business situation that day) as to where stuff will go. Same goes for someone operating a front end loader or excavator. Anyone can hold a steering wheel. The reason they're not paid min-wage like delivery drivers is because they're paid to think and plan ahead. It's really hard to outsource that kind of stuff in a manner that is actually cheaper in the long term. I suspect that just like in IT, the companies that successfully outsource will be the big ones that heavily invest in profit to the point where any given person is just following process, not really thinking and planning (think mines, major manufacturing operations, large food distributors, some LTL freight, Walmart, etc).
> ...the discovery gives us another target to avoid during radiation treatments for patients with cancer, as salivary glands are highly susceptible to damage from the therapy.

The discovery, therefore, has practical uses.
I can see why it would take 5 meter dishes to uplink to the satellites... but if you just need to measure the positions of the satellites, can't it be crowdsourced?
If you have a few dozen people with fixed ground stations, rubidium clocks, and persistent internet, they could help out quite a bit, couldn't they?
their TTM FCF is -108M$. please stop being stupid in public places.
Of course it's intrinsic to Julia. What do you mean? Julia is a JIT-compiled language, and so gets the curse of JIT-compilation: Compilation latency. That's unavoidable*

* Okay, technically, someone could write an interpreter for Julia, or do streaming compilation, but I wouldn't hold my breath for this to actually happen.
TypeScript: Migration from Namespaces to Modules
What bothers me is that nobody realizes you can only automate simple tasks. The more complex the task, the larger the back end is to support the single device to perform the task. Sooner or later you end up with a single specific automating pieces that are costing you far more than had you just hired someone for 35k with ok benefits.
Yes absolutely it should. I think you get a pass if you're a tiny startup on some of your i18n and a11y. But not if you're one of the biggest software companies in the world.

Users should not be expected to know a second language if you offer products in their language. I agree that Arabic and Farsi are somewhat outliers here, but this behaviour impacts languages like German 'Papierkorb'

I would expect searching in:papierkorb to work as expected.
My favorite one, for obvious reasons, is selectric-mode. As one user said, "I use it for typing documentation, because it sounds important". ;-)
I thought the main reason people use Firefox is that they dont like Google in the first place? Bing is my default for that reason.
Symptoms from chemo therapy are NOT commonly classified as symptoms of the cancer that it's supposed to treat.

Why do we have to make up extra rules for everything Covid-19 related?
It’s deeply troubling to me not in the medical sciences.

We know so startlingly little about how our own machines work in many ways.
He's replying to the comment in front of him. Seems relevant.
Thanks for your response. Why do you think Facebook is wrong? Honest question.
> I'm looking specifically at the meme that public companies are somehow required to maximize short-term profits for their shareholders.

I love that meme for how wrong it is. Public companies don’t maximize short-term profits, maximize profits (with future profits discounted).

The fact that to a lot of people “profits” == “short term profits”, reveals quite a lot about our assumptions and time preferences..
In a best-case scenario, the Legislative Fiscal Bureau found the state wouldn’t break even until 2043. Depending on how many people Foxconn hired, each job would cost taxpayers somewhere between $200,000 and more than a million dollars. The average subsidy in the US is around $24,000 per job.

-Shouldn't we simply ban these special tax breaks and credits and cash payments altogether? Isn't that what the free market is supposed to be about?
Yes Hasura looks like a serious contender. Uses Postgres as database and GraphQL interface. Supports real-time updates.
More precisely, yes then no.

Yes the smell effect is studied, no it's not neurological.
Thomas believes cryptography should be done by experts and reviewed by experts, but not decided by committee.
A large part of this comes down to the venue. The early part of GitHub really exemplified the "move fast and break things" mentality. GitHub broke the software world's ability to grapple with bugs, both in affordances i.e. the tools that it exposes for managing them, and, it would seem, cognitively. The way that GitHub approached bug tracking is one of the most frustrating examples of throwing away all progress just to start over from scratch and ignore everything that came before.

A majority of GitHub's users' first experience interacting with a bug tracker was probably on GitHub, so they never really knew any better. The rest seem to be experiencing some collective amnesia about how to effectively file and otherwise triage/manage bugs. Basically none of the issues ever stumbled upon start with a clear and anodyne set of steps to reproduce. Every "issue" is a conversation. (And this seems to be not only tolerated but encouraged. It's madness.) About half are support requests, maybe more. Even when GitHub is used "correctly" to file bona fide bugs, on the whole, project maintainers seem to treat it as a general intake area for everyone else to file issues, and the project authors themselves hardly use it as their own database for known bugs. They're all jotting down vague descriptions in a text file that stays on their local machine or something, who knows.

The entire phenomenon and attitude has to be one of the top 5 most annoying things about software development in 2020.
I’d love to learn more about your use case... I think SPARQL and RDF are pretty interesting technologies, but haven’t seen many real applications using them.
Why It's Not the Code, It's the Environment
Maybe some AI and sensors would also be useful in the fully remotely driven vehicles to ensure
that people can also operate in the warehouse without too much fear of being run over.

Otherwise I'd hate to rely on somebody who-knows-where noticing in time that I'm there or responding in time to my voice.
Sure, but if you're worried about them using a specific DNS, aren't you already worried about them not using DNS; resolving `phonehome.evil.co` once per release and shipping the baked-in IP? Stops working if it can't reach that IP, 'xx needs to update', gets new IP?
It's really nice to see that the Nim ecosystem is gaining more and more traction. A good web framework is indeed quite an important step towards making a language/ecosystem more appealing to a more general audience.

I've yet to encounter a small enough project with low risk where I could get away with trying something completely new, but I'm looking forward to trying Nim in the (hopefully very near) future.

One negative thing that stood out to me was that commit messages are sometimes really bad, like "break" or "let me try". I'm not trying to bash the author, but I feel it's somewhat unprofessional.
I would be interested to read how they made it work, given that it seems to violate the principle of type-stability. Did they just implement the slow runtime type check, or did they do something clever?
Localisation is too hard in general, we'd have to separate the interface from the command list, and while it would be technically possible, I'm guessing it would be bringing lots of unintended side effects. The author is mentioning the difference between trash and bin, but the keyword `in` is also in english.

Just thinking about the command implementation in french, the inbox is called `boîte de réception`, good luck on having every user writing it with all the correct tildes.

Gmail's choice is not because it's too hard to localise commands, it's because it creates a lot more stability with the product.
I think it was the 'almost nobody' crack. Everybody is somebody.
Have you heard of ECC memory?
ORMs thought me to build my own ORM, I even ported the thing to MySQL, Oracle and Postgres! It's available to try if you use my own "wordpress": https://github.com/tinspin/sprout

But the source is not all there: http://rupy.se/util.zip (bunch of helpers) http://rupy.se/memory.zip (I called the ORM memory!?) and http://rupy.se/test.zip (my first test of any software, more of a tutorial) is where you find all the details.

Also the thing has a graphical editor: http://move.rupy.se/file/logic.html

All of this is very complex for something I later solved with JSON files over HTTP instead: http://root.rupy.se but parts of it can be reused for other useful things; like logic was used to build game dialogue trees.
Teleport: A Telepresence Robot
s you're saying that big tech does not want to PAY for using big tech? :D
I guess all roads do lead to Prolog.

Why risk the naming confusion? Doing a search for "prologue language" yields millions of Prolog results on both DDG and Google.
There is some evidence that anesthetics can cause cognitive impairment.

https://www.ncbi.nlm.nih.gov/pmc/articles/PMC6443620/
I was making a general comment about the community. I don't have a problem specifically with the original post (which is several years old now).
Thanks for telling. It's heartwarming to hear a story of competency, problems solved, and efficiency for once.
Not a medical person, but I think this is much like asking "what's a species?". Nature is clearly clumpy, your body has one heart & two lungs & they have obviously different tissues & purposes. But precisely how many organs, and precisely where you draw the divides, is something we don't have sharp answers to. We adjust as we go along.
I think you're being a little mean to the dark ages.

Galen was a pretty accomplished medical researcher, and Roman-era medical implements were quite sophisticated, and were well-established by the time of the dark ages. By the late dark ages, we also saw a lot of modern medical techniques coming in from the Middle East.

There's this stereotype of people being filthy, ignorant, and dumb, but it's not really true. And for many of the bad practices from then do persist in poorer parts of the world today affecting likely around a billion people (and some, like homeopathy, even in wealthy parts).

Note that I'm not weighing in on the overall debate about where modern medicine is relative to the dark ages. We've made a lot of progress. I'm just refuting the stereotype of the dark ages.
Not before the exec milk every single ounce they could before exiting.
Installing and Managing Argo CD Through CD Pipelines Using Codefresh
I have run an mostly remote company for 11 years and have 200 employees. I paid my in office employees more for several reasons:
-Smaller pool of people to choose from as it is geographically limited.
-Office workers have an average of two extra hours per day of overhead... Getting up and dressed, driving to work, spending a lot of time away from family, etc.
“We are working with central banks and thinking of all forms of digital currencies and how PayPal can play a role,”

does that mean a 'centralized' entity will try to facilitate payment based on 'decentralized' currency

wow
Smart devices are exploited for domestic abuse
TLDR: Cache is faster than RAM, which is faster than disk.
Garbage Collection in JavaScript
Julia already has an interpreter, and the core team has plans for tiered compilation.

Also the JIT compile time can be minimized to the point where it's a very minor thing. There's also smarter and slimmer static compile, which is also planned.
I thought about that, but I don't think I'd be able to offer something significantly better than what's already available.

One of the difficult parts of the process that you can't really "productize" is cataloguing. If you receive a stranger's videotapes, you wouldn't be able to label a clip, "Grandma Alice Visits for Bobby's Kindergarten Graduation," because you don't know anyone's names or relationships or the context of the video.

There might be a product in a tool that helps people edit and tag clips after they've digitized them, but I'm not passionate enough about that work to go after a product like that.
Moments in tech that defined the past 25 years
Automate Photoshop with Python
I’ve always seen this debate as kind of moot. The thing with optimizing, is that you always optimize with a target.

Large corporations rule top-down because goals are set at the top. That’s very different from a society problem.
I happen to live in Sweden, and that means for the past 8 months, every news source around the world has written wild, baseless, stories about how either Sweden is a disaster or the a beacon of enlightenment when it comes to corona. Lately Sweden has also become a partisan gambit, in countries all over the world, and the press is eating it up. This means that foreign press will print any criticism of Sweden form anyone.

Are there people in Sweden who disagrees with the approach? Yeah! Are there any other countries where everyone is in total agreement over the handling of Corona? No. The fact that someone disagrees is not news.

Anders Tegnell, heard of the Swedish Corona response has repeatedly admitted the mistakes that where made, so the idea that "no one talks about it" is patently false. This article tries to make it sound like there is a conspiracy when there isnt one.

At the current state its far too early to draw conclusive judgment for a variety of reasons. A long string of people has come out of the wood work, making headline grabbing statements, that are provably wrong, or unknowable. Lena Einhorn is prime example of this. She hasn't worked in medicine for 40 years, and when she did she did not work with infectious diseases. So yes, just like I'm going to be dismissive of articles about "the other side of global warming" I'm going to be dismissive of this.
And GitHub kinda endorses this by having a stock "question" label in newly created repos.
Love the visualizations, anyone know where other animations like that of electron cloud motion around molecules can be found?

If this method scales to larger crystals and quantum dots, we might start seeing ML models guide materials development soon...
You could post a list of topics that are frequently posted on HN and mark each topic as positively commented on or negatively commented on. Maybe add a trending graph over time too.

Edit: I’m not being snarky. Such a list or view could be useful to get the pulse of the times on HN.
Re-analysis: No statistically significant detection of phosphine on Venus
I have long imagined that this is how long-haul trucking will be end to end computerized, as the highway miles are the (relatively) easy part to automate with FSD, as most of that tech is already here (adaptive cruise, lanekeeping). Getting the thing from dock to highway, and from highway to dock, will require (remote) human eyes and hands for some while yet.
Making Music in C
As someone who has built event pipelines from GDELT data, I'd advise folks to not start (a GDELT project) with high expectations. Not only are there plenty of duplicates, but tagging quality is all over the place, especially for non-Western media.
You understand exactly why I am focusing on President Trump and Fox News.

President Trump is a serial liar (fact), implicitly condones white supremacy (fact), and actively undermines the important norms of our democracy, like elections (fact).

Fox News, for the most part, has been propaganda which is supporting him in that process.
I don't have a bias - rather, I believe in small-d democracy, human rights, and valuing the truth and honest behavior, as much as one can in this world.

Their actions are significantly worse than most other politicans (excepting Trump's political enablers) and news organizations at this time.
Huh, I thought 'pegging' a server came directly from the sexual meaning. TIL.
After the 2017-18 craze, I don't know if HODLers have gained anything on stock market. It has almost followed the broad stock market movement these days.

Look at the covid crash in March, coins like BTC also dipped and peformed worse than indexes like Nasdaq while traditional currency hedge gold rose in value when both of them were crashing.
I think it's parsed specially, but I could be wrong.

Definitely no runtime check
A more proper comparison might be revenue instead of units sold. Otherwise I could compare Intel's 8051 sales figures which dwarf AMD's gpu sales figures.

(and tesla does make their own chips)