skysight-inc/HackerNews huggingface dataset:
> Where in this line of code does it say that a SQL query is going to be performed?

It is implied when you're using a framework with an ORM - after all, how do you end up with a "customer" object to begin with instead of a list representing a DB row?

> So much love for lazy queries eh.

When it comes to performance there's always a trade-off. The same reasoning could be applied to using Python as opposed to languages that compile to machine code, or for that matter using Linux instead of running your code on bare-metal.

Lazy queries trade-off performance in favour of developer productivity. In some cases it's a major problem (fetching 100 objects and looking up related objects for each one), in other cases it might be imperceptible and the time spent fixing them can be probably spent better elsewhere.

> You're so new to Django and yet you pretend to understand everything.

Knowledge of lazy queries and how they work is definitely valuable, but my impression is that most people here do know how they work and what are their pitfalls - they simply disagree with your opinion that "all lazy queries are bad".

> I don't understand how I'm supposed to help someone like you. I hope your tech lead is able to guide you through this.

Some people here (including me) don't agree with your black & white thinking about how lazy queries are always bad. They know their application, requirements and performance targets better than you do and have decided that for their use-case lazy queries aren't a problem in most cases (and can address the problematic cases individually without disabling lazy queries globally and having to waste hours trawling through their codebase for every single place to put a select/prefetch_related with no worthwhile performance gain in practice).
His name is there, just a couple lines below.
Google 'meme stocks'
Maybe--very much depends on the source and destination country. Fact on the ground is lots of people have ended up choosing that as their path, optimal or not.

You can master-out in the middle of a PhD program, which is frowned upon, but it is difficult to get funding if you directly apply for a masters degree.

Perhaps the solution is to decrease the negative cultural backlash against predisposed intention of leaving with a masters despite applying for a PhD, which is currently seen as some sort of betrayal of the adviser if you are going to have your grad students do boring work. It'll be a win-win deal in that case.
Author here---maybe you find my response to the parent post interesting. What you are describing is something I also experienced: a good name can open a lot of doors for you, and academia is certainly not as meritocratic as people might think it is.

I read some anger and disenchantment in your comment. Feel free to reach out in order to get another perspective on your situation. In any case, without knowing the specifics of your situation, and being a more or less anonymous internet stranger providing unsolicited advice, I would suggest you don't do anything hasty. Getting a PhD can be useful in certain domains; at the same time, if you are not engaged and---dare I say it---happy with your overall situation, it might be time to move on.

Whatever you do: the world is big and, with a little bit of luck and foresight, there are additional opportunities to be found! Best of luck to you :-)
Google Reader although I'm sure we have better alternatives now.

I wish I had saved a copy of my own old websites and blog posts. I used to have a Windows Live blog as a young teen. It would be interesting to find it again.
A few web3 projects I think provide value.

1. Handshake

This is decentralized root naming system. This is one of the most practical use of a blockchain where all records need to be public and verifiable. No need to depend on icann and registry owners for having a tld which you own.

2. Unlock

This is membership protocol powered by nft. People can buy a nft and then for authorization, service provider can check whether the wallet has the nft and is valid. This way, nobody controls your membership and you can move them around the web as you like.

They are all connected to a wallet you control.

3. Arweave

Permanent storage using incentives and built on the idea of storage getting cheaper. Of course, this may not scale but I like the potential.
ObservableHQ changed my life. Coding is fun again. I use it to quickly experiment with new libraries, fast prototypes, as proof of concept building, NLP stuff, etc. And I can do it all on my phone!
Enthusiasts have been fitting electric drive systems to older vehicles for decades.
For reference: BBC[0] 'technical specification for the delivery of television programmes'. 35 pages, with links to additional specs for cameras etc.

[0] http://downloads.bbc.co.uk/scotland/commissioning/TechnicalD...
VoLTE/VoWiFi Research
The most obvious Nikon problem is the absence of cine lenses (I skip ergonomic because it is a common 'photo camera for video' problem). Of course, you can use photo lenses, but it's so much pain. More flaws and more time.

- Cine zoom lenses must provide a fixed point of focus when you are zooming. This leads to a more complex mechanism.

- Different cine fixed lenses in one project usually must have identical image quality. That is why they are produced in series (for example 'XEEN PRO Cinema Lenses') with the same technologies.

- Anamorphic lenses... They should exist. They complicate lens production because a stable quality (for series) of an aspherical lens can be achieved only from a central part of a large glass.

- Focusing is the process that often requires a separate person (focus puller) and additional machinery (follow focus system). All cine lenses have exactly the same standard focus wheel. There is no such standard for a photo lens focus wheel.

Nikon F has very few cine lenses and has no series of lenses. Nikon Z has nothing. Thanks to the closed very secret, unique, perfect, bla-bla specification of Z mount and zero collaborations with other manufactures.
JavaScript for form entry even though PDF already has an older form mechanism.
No:

> While I may have made the observation, credit goes to Titus Winters for actually naming it as "Hyrum's Law" and popularizing the concept more broadly.
But one of the big advantage of typed languages is that you CAN throw away that information and still be safe (proven by compiler). You don't have to pay for them at runtime.
Afaik if you have the watch locally available you can just connect it to your PC and deploy it there.

Even the SDK is available for "free": https://developer.garmin.com/connect-iq/overview/
Altered Carbon: A Carbon-Air Battery as a Next-Generation Energy Storage System
>Does anyone happen to know if there is a community-maintained dictionary somewhere?

I remember seeing wikipedia being served over the dict protocol.
I always found literate coffeescript to be pretty neat. https://github.com/jashkenas/coffeescript/blob/master/src/sc...
And now we know the truth. 100% won't achieve herd immunity.
Author here---I love the term 'non-core work.' It encompasses a lot of the things that irk me in academia (and it's a little bit hypocritical because in the end, academic projects also benefit quite a lot from this non-core work...at least, if your goal is to build something that people actually want to use, as opposed to just pushing out papers.)

PS: And upon writing this comment, I had the epiphany that 'pushing out papers' might indeed be the primary objective for some. :-|
Brothers also reject third party toners. My dad has had multiple occasions that his Brother printer rejects third party cartridges.
You can look at the South Africa data which is "quite a while" old. NYC and SF data is already more than good enough to draw conclusions from though.
> One migration file per model is easier to manage. It's my opinion of course, but think about how you'd squash migrations for old models if you're in the habit of bundling multiple RunPython or RunSQL methods in the same migration file.

Squashing is something Django will handle for you through a management command, at which point it doesn't matter whether you're doing one model per migration file or not. Stuff that cannot be squashed (RunSQL/Python operations) will be pointed out by Django and I'm not sure how having one model per migration will help - the difficulty here isn't locating the offending operation, it's to actually figure out whether that operation is still needed and if so whether it can be reworked.
which is why I think 5 years should be enough time to make those affected users a small enough minority that a government could ignore them.

When predictions of our future read like dystopian science fiction such as Stallman's "Right to Read", 1984, etc. the only course of action is to educate the masses and strongly oppose any further progression down that path.
Well "herd immunity" isn't really possible for respiratory diseases because our immunity wanes too fast. If we had "herd immunity" against cold/flu you wouldn't get it every year.
> then a proper cure has to involve fixing society

Where did I say that society is perfect, and that the only thing making people depressed is chemical imbalance?

I agree that our current society can be stressful, and that environmental factors[0] also affect people's behavior.

I agree that we can improve society through collective action, and hopefully that would lead to better quality of life for people, thus reducing the rate of youth suicide attempts.

However, I was addressing to OP's suggestion that medication will not "help at all with anything." Also that "Psychiatric medication often simply numbs your brain ... and it turns you into a robot."

So what are you defending here, exactly? Do you agree with OP? Is that why you are trying to attribute something to me I didn't say to make my argument seem absurd, instead of addressing my actual arguments?

0: Such as climate change, peak oil, the destruction of our natural ecosystem, the massive die-off of earth's biodiversity, and posturing from progressively more desperate super-powers
Surely these standards are not retrospective. I see lots of vintage cars still being routinely driven. eg Landrovers, Morris Minors, etc, etc.
Today's radicalization is tomorrow's mainstream.
Yes, precisely! And I should stress that the students I hire as PhD students are hired as exactly that. No strings attached, no additional duties, etc. They are free to focus on their research. My point in the article was more to put a finger on the fact that there is 'core work' (papers, papers, papers!!!) in academia and 'non-core work.' The latter is rewarded less, in my experience, even though it's a prerequisite to get the former done.
Clifford and de Jong Attractors
It’s called hyperinflation and never ended well
Mind, O Mind
My argument was that the third-party package is what's key here. Merely converting your querysets to a list in code before handing it off to the template won't fully protect you against extra queries.

I'm not necessarily trying to avoid third-party packages, in fact I've installed the package you suggested in one of my projects and will be trying it out.
The medication debate, on this forum of smart and reasonable people, comes out as one side yelling 1+1=2 at a crowd who's yelling back that 2+2=4.

Yes, staying on strong mood-neutralizing antidepressants forever isn't a full life and it's probably bad for your liver. Yes, when you are laying in bed and can't do anything, those external factors that are making you hate your life will get worse until something, including a chemical that's bad for your kidneys, gets you up and walking. They are both true at the same time.
And they should ensure they're not diabetic, above 60, and just be perfectly healthy, right?

"It is what it is" but as of now staff can't work because they're out sick.
We only have mandates because encouragement failed.
I’ve been building free Garmin apps and watch-faces since 2016.

Any developer can download the ConnectIQ SDK and freely publish an app or watch-face in the Garmin App Store. Does not require any license to build, install or publish an app.
That would be the full process but once you've done this once couldn't you just pickup where you left off and just update new entries?
That street view footage is from 2007, for some reason. The next street over is from 2013: https://www.google.com/maps/@33.5300075,-101.6773339,3a,75y,...
You usually own the domain, unless you sell out of course. So you can start wherever you want from scratch on your own or on leased infrastructure. People will connect to the domain/irc network.

I'm not saying you should use IRC over Discord, but hey, that's how the web got centralised and why certain platforms have lots power: because people just gave it to them. If Discord decides to monetize by leveraging ads, good luck to you and your community.
There’s also jp, which interprets JMESPath: https://github.com/jmespath/jp

This one has the advantage of being natively understood by aws-cli, meaning you can pass a JMESPath to an AWS call and only receive the filtered / transformed result back.
TLDR: Yes, Yes, Yes

Infra-red is good for finding some spectral lines, and finding the temperature of exo-planets which can be useful when looking for extra-terrestrial life.

It also lets us look further back in time and through dust clouds.

Early universe observations provide useful info about dark matter possibilities.
Deciding not to serve a market isn’t anti-competitive. I also don’t think keeping the protocol closed so that competitors cannot implement it is anti-competitive, but that’s getting borderline for me.

I also think Apple, if they decided to provide android support, should be allowed make that a paid service. After all, it runs on their back-end. I guess even a reasonable pricing scheme would be met with resistance.
> so you want to get people submitted into a procedure they don't want

yes. peoples freedom stop where other peoples health begins. co-morbidity can not be solved but getting people vaccinated can. even it means it's "against their will", even they shout "fOrCeD mediCaL prOceDuRe". I don't care if it hurts their fragile egos and means they have to tone down the individualism. Either have a doctors exemption, pay a fine, or go to jail (condition upon entry into prison is mandatory vaccination). Boom. Problem solved.

> just say, hey I want everyone to do this so I feel safer.

it's not about me but the people around me. some of them I've already lost. I'm healthy enough not to care. I eat well and have done sports all my life. I survived several tropical diseases. I also lived my life to the fullest. So idgaf. The only thing I care about is people around me getting hurt that I love (my family, my kids, my friends). And don't worry they're some deluded anti-vaxxers among them. They can only be helped by force at this stage.
That definitely wasn’t true when I developed my watch face (https://github.com/kelnage/digital-simplicity) - the Garmin IDE compiled it down to a single IQ file which can then be transferred directly to the device via USB.

Of course if you want to distribute it via their App Store you have to apply (it was free when I did it), and the way changing settings used to work (through a convoluted path on the connected mobile device and via the store) it was often best to do that. But you could also use the settings file software Garmin included in their IDE to do it (or now do it directly on the device).
The Brides of Boko Haram: Economic Shocks, Marriage Practices, and Insurgency
RCS is a carrier standard. It will stagnate and die a slow death over the next 5-10 years just like SMS and MMS. The carriers have absolutely no place establishing or maintaining a standard.

Google epically failed to establish a messaging ecosystem similar to Apple, and so they went to RCS. But they’ll regret it when the standard fades into uselessness.
On Immersion
Thing is, a lot of white collar jobs have always been performative. They just don’t need 6-8 man hours a day. They require very little actual production. It’s collective psychosis.
>daughters

Was it only daughters that attempted suicide? What about sons?

With this language, you are implying the life of a woman is worth more than a man's. Why?
It took 30 years, but literate programming paradigm is now very commonly referenced when working with notebooks, even though it's not what Knuth was going for in the first place and the original intent was different.

Notebooks are a direct evolution of REPLs and at the time of writing (Knuth published his paper on literate programming in 1984), REPLs have been well known (they had been around since 1970s). Yet there is not a single mention of them in the original paper, nor any prediction how literate-programming-capable notebooks could look like. At the time, these were two different concepts each serving its own need (documentation vs exploratory programming).
40 hospitals in the state of New York had to suspend elective surgeries due to COVID. The flu wasn't doing that. Flights are getting canceled like never before due to staff shortages. Restaurants in my home town are opening on half of the shifts due to COVID.

So, no, nothing similar. Stop pretending it is.
>And those who respond with indifference and denial of that reality, much like a person in your position, will have no say or power within the new system.

that wasn't my point. my point is that this technology shows no sign of slowing down, so by just angrily and reflexively dismissing it critics are throwing away an opportunity to make real, constructive criticism like Moxie did here at a time when it could make the most impact.
That would be quite useful as well, though again not without manual additions because not every word has a page (e.g. capacitances) and not every word on each page is spelled correctly (admittedly most are, but just two days ago I fixed a brand name capitalization typo). Perhaps with the addition of Wiktionary it would come a long way, though.
There are things we can reasonably do something about in a reasonable time period.

There are things we cannot (as it sits right now) without killing large numbers of people and possibly ending civilization as we know it.

What might happen isn't as important as what will happen. This isn't necessarily evading the problem but it's also inexcusable to not make the changes we can. Wasting non renewable fossil fuels and the amount of litter and pollution we are producing are horrible no matter the ultimate reality of climate change (which I maintain is poorly understood and over-hyped right now).

There are real problems that are well understood we aren't doing anything about while wringing our hands about that which we practically can't at this juncture.
Just out of curiosity, most ploughing tractors appear go quite slow.

Is there any reason why they cannot be geared as required to plough at 50/60/70mph etc? Is there something about the actual physics of ploughing/whatever/etc that requires slowness? Or is it more the fact that it is physically very arduous for the machine and it would cost too much for both the power required and speed?

Just kinda thinking along the Elon Musk line of thought around robots in a car factory - i.e. why aren't they moving so fast that all we see is a blur etc
Show HN: Racompass 1.1.x – An Advanced GUI for Redis and Redis Modules
Always scratching my head at the language around obesity by some, even experts, as being a disease (as mentioned in your article). Is it contracted? Do they think the cause of obesity is some genuine biological anamoly or defect or disorder?

Obesity was almost non existent 100 years ago, even 50 years ago. The vast majority of obesity is caused by poor diet (in part due to our food supply, in large part also due to our choices) and lack of exercise. There are thyroid issues, there’s more chemicals in stuff we don’t quite understand the effects of, but the majority of it by far is individual behavior.
My biggest problems with university research and its funding (speaking as an academic failure):

1. The grant system overly rewards proposals that grant givers can understand to have a high chance of success. This creates an echo chamber of what kind of research gets funded.

2. The acceptance of mafias based on mutual back-scratching. The dynamics of funding into these mafias.

3. The cut of research funding claimed by universities as operational costs. (How much of your grant money goes to your university as overhead?)

The French Academy of Sciences used to run a mathematical grand prix (in the 18th and 19th centuries... maybe not anymore?) where they would put out a call for essays about a particular problem (e.g. the three body problem) and award a substantial prize to the winning essay. I like that kind of setup more, and I think there could be room for a parallel funding system where private companies or groups of interested individuals offer funding for targeted research using this kind of grand prix methodology.

I was not criticizing academic research for not happening in the public, was merely stating that that should also be a property of the new system.

Also, the same institutions should not be responsible both for education and for research. The objectives are clearly not aligned.
If they stick to the routine and bare minimum, pretty soon they’ll be replaced by robots and software.
> I generally don't need to optimize my queries because my apps are small

Same situation here. I find that being mindful of the ORM is enough to save me from obviously bad queries (fetching 100 objects and then running additional queries for each one), for the rest I get away with it as it's not a problem in practice. Sure, I will probably save an extra milisecond here and there and maybe in the end be able to run my entire DB off a very small computer, but (bare-metal) hardware is so cheap that a few stray queries here and there won't break the bank.

Nevertheless I've installed the package and will be trying it out, but I have yet to be convinced that eliminating additional queries all the time is worth the extra developer effort.
I hope my surgeon doesn't have your attitude.

You need to both do good work and take responsibility to communicate this to your manager.

If you just do good work, but don't communicate it, your manager might not know and won't reward you properly.

If you don't do good work but only "perform", you lack integrity, you're not developing yourself, you're cheating your customers, and you are a drain on your employer and society.
> It’ll scale like S3, et al.: replicated storage requires ongoing payments because sysadmins need to be paid, storage needs to be bought & replaced, network bandwidth is metered, etc.

That's what they are trying to solve with their tokenomics model.

The value of token will appreciate over time whereas the price of storage will keep getting cheaper.

It's simpler than s3 in many aspects so I'm not sure you would need a system administrator. Everyone can run a node and things are replicated many times over. The failover model is to look for the next node. There are no API, security, access, etc consideration to be maintained at the node level.

Data itself is public by default.

> Abuse is the hard problem here: if I host a node, when the police download something illicit my IP is the one they see and I have to prove that it was done without my knowledge. This is why nobody does this except for known sources

Yeah, that's important.
This is a fair question. Especially because the increase was almost entirely among girls. They have a much higher attempt rate but a much lower completion rate than boys. [1]

It is possible that these attempts are more about distress than true attempts to end life. Still a problem, but not as much if the suicide rates did not also go up.

1: https://www.verywellmind.com/gender-differences-in-suicide-m...
>You don't need everyone unless you're trying to IPO

But if you are looking for people to talk to, but they don't use IRC (read: almost everyone) there is no reason to use IRC. If I wanted to talk about speedrunning a game I will go to Discord because that's where the community is, not on some IRC server.