skysight-inc/HackerNews huggingface dataset:
> suggesting using a fully-qualified table name if they actually wanted the table column (t.x in the above example).

I just realised why this was bothering me. That means 't' and 't.x' are actually different variables. In standard SQL it's always the case (right?) that an unqualified variable ('t') is just an convenient shorthand for the fully qualified variable ('t.x', or more fully I suppose, '<db>.<schema>.t.x), and you just broke that.
sorry! maybe it's just my thoughts on the matter that have changed. i understand that you can have drugs move through the glymphatic system, but maybe i was just unaware that you can move a whole host of other cell proliferation factors through the glymphatic system also!
This demo downloads the entire React issue repo into browser storage so that the UI can do filters locally with no waits. Also the entire thing updates live between collaborators if multiple people are online at the same time.
Hey, nice to meet you. I'm not sure really. It's just a side project I work on sometimes. Obviously the medium of conversation is a highly flexible one, so I'm not clear who my target demographic is. What is your platform?
Reference: https://en.m.wikipedia.org/wiki/Tulip_mania

> a Viceroy Tulip was worth upwards of five times the cost of an average house at the time.
Perhaps it ruins your fun if you don't like this kind of games – that is okay. But don't pretend it ruins everyone's fun.

Look how many people love Rust or EVE Online.
Mmm it used to be featured here[0], but no longer, well fair enough. Maybe i’ll just plug it in again when I have time :)

[0] https://homebrewserver.club/
Obligatory Onyxia Wipe posting (NSFW) >> https://www.youtube.com/watch?v=tUXdcrSbIho
I've got ethernet cables that I've been using since 2011 without them breaking. My headphones are in fact from 2008, all I've got to do is replace the leather pads every 5 years.

I'm still using the USB-C cables from my Nexus 5X today, no problem with them.

With HDMI cables I just buy them, connect them to my GPU and wait for the AMD driver to tell me the maximum bandwidth they support. Super easy way to measure what they'll support and what not. So now I've got a dozen that work at 4K 60Hz HDR just fine.

On the other hand, I've never been able to get a single bluetooth device to sync reliably for more than 5 minutes.
I have started wondering how much emotional capital I’m burning every week trying not to snap at people doing a cold opening. Lots of people want to ask me questions, and we both know you aren’t just saying hi. Ask the damned question.

Half of my output comes from trying to maintain the balance between accessible and productive. Some months are better than others, and the last couple have been bad. Too often I have my normal work, the surprise bit I didn’t think about, the nasty, low quality, test that’s making that take four times as long because I can’t see why it’s red, someone trying to figure out if we’re having a production or preproduction issue, and someone sending me “Hello” “…” in too close a proximity. It’s a recipe for burnout, and rationally the former should be the ones I focus/fixate on, but the last couple are outsized, as later insults often are.

Then again, managers work with people, so they should expect to deal with people problems, not dispassionate problems based entirely on objective reasoning. Objective reasoning doesn’t need to be managed.

I do try to move a lot of things to the Wiki or code docs, but there are inflection points where everyone doing a little starts to add up, and if you don’t have that critical mass it can be glacial and unrewarding. In those environments your reward is being summoned to the meeting because you have the info, and many people enjoy that feeling way too much.
> This is not and has never been a problem for consumer based devices. All headphones are made +/- with the same impedance.

A quick search for "high-impedance headphones" might be enlightening on this topic.

For example, Beyerdynamic offers 32, 80, and 250 ohm versions of several of their models.

> If cable length is an issue for you then you're using a really bad cable. I mean, really bad. Or have a severely underpowered output amplifier.

A cable has both resistance and capacitance, which means every cable is also a low pass filter.

If you are tuning the DAC/amplifier with power consumption as one of the criteria, then actually, yes, you will want the output power as low as possible -- which means cable length is a factor in the optimization.
There's also the observation that indulging everyone's preference doesn't necessarily lead to a global optimum. A straightforward analogy is traffic, or crowd control - if you let everyone follow what they perceive to be the optimum route, the flow becomes dysfunctional as everyone tries to occupy the same space, and occasionally people even get squished.
There is no link to an actual article, but I found a recent paper "Improved Low-Depth Set-Multilinear Circuit Lower Bounds" by Kush and Saraf [1] that
includes this reference

[LST22] Nutan Limaye, Srikanth Srinivasan, and Sébastien Tavenas. Set-multilinear and noncommutative formula lower bounds for iterated matrix multiplication. To appear in STOC

that appears to be the subject of this quanta article,
and the new paper claims to improve upon their work.
From what I gather, these papers construct some polynomial f of degree n in VNP defined over poly(n) many variables, such that any product-depth ∆ set-multilinear formula computing f has size at least a certain exponential in ∆.

[1] Improved Low-Depth Set-Multilinear Circuit Lower Bounds
>God brings down the mighty from their thrones and lifts up the lowly; about how God fills the hungry with good things and sends the rich away empty

There's nothing anywhere in that quote or analysis that talks about giving to the poor or helping your neighbour. It says god will do that, not that we should do that.

In fact how are we supposed to help our neighbours and uplift them in times of need if we're poor and have no surplus? The bible tells us not to worry about that, god will provide.

I know that other parts of the bible tell us to give our wealth to the poor, but actually supporting the poor is not our problem. God will do it. Giving away our wealth isn't functional, it's not with the goal of solving poverty, it's with the goal of impoverishing ourselves so that we become virtuous because otherwise we will be punished.
Show HN: A program that fetches data from cht.sh based on the topic
This is a little tool that I wrote about 4 months ago that lets you fetch data from cht.sh[0]. It is more of a toy, but someone might find this useful.

[0]: https://cht.sh
Not really-really.

Pepperoni does not exist as an Italian word.

What the US call "pepperoni" is "salame piccante" in Italy.

Peperone (without the double p, one peperone, two or more peperoni) is the green/yellow/red (not spicy) vegetable that in english is called pepper (undistinguished from "pepper", the spicy grains that in Italian are called "pepe").
Is a famous organism in genetics. It grows and blossoms really fast and is well known so you can watch a lot of generations in less time than other plants. Is also conveniently small, so you can culture a lot of specimens in your valuable laboratory space. Is also a Brassicaceae, that are VIP (Very Important Plants) in our agriculture.
If you want to understand the thinking, read Iverson's Notation as a Tool of Thought. These languages are optimized for the user rather than the learner, so the curve is steep but rewarding.
I suspect the answer stems from the commoditization of the hardware - in which the meaningful differences for a particular good are so few between that no one cares much about which brand it is except that it fulfills their needs. And as you said, the reduced profit margins spreads down the chain.

I've also wondered how employers see them from the business perspective. It's hard to determine a 'business profit contribution' value attached to the 'quality of work' they produce except that things don't break down, and stuff gets done on time.

Furthermore, if the embedded code is the sort where once it's done, it's done, and little to no maintenance is required, the business people might see no need for the guy to be around. Maybe someone could clarify if this is true.
Ask HN: What is your go-to backup system for Linux servers?
Except the evergreen rsync
Elon Musk boasts his Neuralink brain chips ‘will 100% cure’ common illness
Isn't this true for all animals? How does a cat know that he is a cat? He never sees himself in a mirror but somehow knows that he is like other cats. I understand that they observe other cats' behavior, but how does he know initially that he is like other cats without seeing himself. This must be something innate. Also for birds mentioned in the article, they must know innately that they are cowbirds.
I don't know, the new QQC tree view does not look as powerful as QTreeView which is a real workhorse
I'm working on a side project that is slightly related to this, where you can basically use JS to quickly transform text any way you want.

It would be really interesting to include many other languages other that JS and this one looks like a great fit (eventually).

If anyone want's to give it spin you can but ONLY SOME FEATURES WORK HERE AND I WILL BREAK THE STUFF YOU DO! IT'S NOT EVEN ALPHA O BETA JUST BEING DEVELOPED. https://texttransform.io/

That said I am interested on HN's point of view of this idea even if very raw, specially people interested in text transformation.
> And as for recognizing a cat or a dog — that's a problem so trivial today

Last time I checked - though it's been a long while I could not check thoroughly owing to other commitments - "«recognizing»" there was "consistently successfully guessing", not "critically defining". It may be that the problem was solved in the latest years, I cannot exclude it - but I have not seen around in the brief "news checking" exercise the signals required for the solution.

The real deal is far from trivial.

A clock can tell the time but does not know it.
> However, we happen to have a very precise way to mesure the axial length of the eyeball (interferometry).

Does this measure the length at the center only? Even if the eye cannot shrink there, it could possibly grow outside of the center or by inreasing its diameter causing a change of the shape.
No need to put it in orbit. A self-sustaining sealed ecosystem is a vital piece of research and engineering for us to do before we leave the planet.
Oh dear wtf is going on at twitter HQ right now. Be interesting to see what happens when the dust settles.
One of the main causes of too many meetings is number of priorities org has. Lots of Parallel initiatives are a big problem. This causes inefficient meetings, not all stakeholders come.
Ask HN: How do I explain gap after college due to health/family issues?
I graduated in December 2017 in CS program, after that I went for a couple of interviews, but I had intention to do something of my own, I did try some ideas, some failed, some got abandoned due to health issue which I will explain later.

I was diagnosed with OCD in 2010, even thought I had been suffering with symptom from 2008,currently I take Fluoxetine daily to control symptoms. Furthermore, I was depressed in 2010 after OCD diagnosis. After graduating college I was trying hard to keep working on my app idea, I have done considerable amount of work, but I kept procrastinating doing other work (volunteering, helping relatives, neighbors, helping my father's farming work), time to time I muster courage to work on my app by summoning my will power, but it only last for about a week, I have read/watch many science based articles./videos for battling procrastinating, but I stil could work for a week by using up willpower. Due to my this chronic procrastination I was blaming myself for years, until this year I decide to learn more about ADHD even though I have heard of it before, after knowing about ADHD, I grasp what is going on with me (executive dis-functioning) which explained by knowing lot and failing execute, time blindness, clouded mind, distractability etc. So I went to meet my psychiatrist, and he prescribed me Atomoxitine, in the first days Atomoxitine regardless of its strong side effects, I felt my mind was clam, I was able to very quickly (ex: tasks that took me a day were done in hour), this remembered me what my mind was used to be like a decade ago, which was quiet and how much benefit those neurotypicals had over me all those years, with medication I was hopeful. After the use of Atomoxitine for first two days quietness of the mind reduced, but I have the ability to keep on working regularly on my projects with Atomoxitine (do not have to use up my will power all the time) which was quite useful, I am thinking of trying other stimulant medication in the future.

During those years I had work on some small freelance projects for friends in React and Android and currently working fully fledge ecommerce site for my cousin as business partners.

I have to keep eye on my parents since my mom is suffering from Parkinson's for years, she needs help with daily activities, sometimes get delusional and suicidal, dad also have high blood pressure time to time, issue in prostate (getting ready for operation later this year). My dad is farmer since he is old and have health issues sometimes I have to look into his farming duties.

So now to my question, recent months I was thinking for applying for job as SE, since I am having hard time with economic crisis and structured environment like company help me to work/learn easily, in the meantime gain career capital. But I do not know how could I explain my 6-year gap of unemployment, whether they will hire me due to my health conditions?

Any advice highly appreciated!
offtopic, but what's a PHB?
Bullying Hurts
Or that certain groups of people survive because the ideologies that they adopt help their group compete with people of other ideologies... and people with successful ideologies are able to convert others from less successful ones.
If they were too competent these bureaucracies would abolish themselves, or at least decimate their own funding.
You would cover all of that material in an intro to digital logic course (no prereqs). I found it a very enjoyable topic to learn. I don't think it would be too difficult to learn on your own. I would try to find a course that included a lab component, testing things out on a bread board is very fun. Sole caveat; debugging circuits can be a challenge if you don't have anyone to help and you're learning.
Most of these forensic findings use publicly known techniques.

What does intrigue me is how they managed to determine the graphics card.

Anyone?
> is the green/yellow/red (not spicy) vegetable that in english is called pepper

Bell pepper to be exact.
“Lack of sun is trivially fixed with lights.”

As someone who lives in Sweden, I can’t agree there.

Lights can never fully replace sunlight. It’s not even close.
I fixed my broken monitor with a hair dryer
It may be millennia-long, but as many people in this discussion have remarked, we certainly didn't have this degree of paranoia 40 years ago - and many countries don't have it today.
And GNU is what most people rush for installing on macOS and Windows which says a lot about the actual needs of people Vs the supposed benefits of Unix purism
I live in a former socialist country (slovenia, then yugoslavia), where housing went from something cheap, something you got for free from the government, or (literally) built yourself over the weekends to something that is not affordable at all.

Our current left parties blame the government not building enough housing, even though every government project is vastly overpaid (due to corruption).

But the real reason for pricing increases is regulation. Back in the time you could buy a plot of land and build. Usually you started building first, then dealt with the papers, permits and all the related stuff... and people knew where the papers won't be problematic, and build housing on plots that were actually ok to build on. In every village, you could buy a plot of land at the edge of it, and just make a house there. You could also literally build the house yourself... usually yu hired someone to dig out the basement, but a lot of the actual work was done by future-owners themselves and their friends. Yes, some houses didn't have proper insulation, or stuff like that, but you had a place to live in.

And now? Usually those same villages are the same size as they were before the breakup of yugoslavia, because you need a permit to start anything (and they're actually enforced), and local governments don't want to change zoning, because of NIMBY neighbours. You can't build/do anything by yourself anymore. We have huge areas of buildable land, empty, and in many places, the only way to build something is to buy an existing old house, tear it down, and build a multi-apartment building there, bringing the prices even higher.

Add to this speculative investments and buying dedicated apartments/houses for airbnb, and the young(er) generations are fucked.

(I'm not saying we should allow everything everywhere, but in places with not enough housing but enough land, we should rethink our zoning)
> For example, Beyerdynamic offers 32, 80, and 250 ohm versions of several of their models.

Yes and you know what happens when you plug a higher impedance phone in a low impedance output right? (and the point is moot because we're talking about consumer devices)

> Headphones with impedance greater than 100 ohms are typically older or professional studio specific design

(or valve outputs - because of course it's "audiophile stuff") https://www.headphonesty.com/2019/04/headphone-impedance-dem...

> A cable has both resistance and capacitance, which means every cable is also a low pass filter.

A cable is a https://en.wikipedia.org/wiki/Transmission_line and while it is technically a low-pass filter you have to show me actual numbers to convince me that it will significantly affect, let's say > 10kHZ at usual headphone cable lengths.
I have been using duplicity so far and it does the job
Even then no, I build a 30 unit building, covid 22 hits, nobodies buying, I'm on the hook for 30mm / day. Nobody would even build with that risk. You'd have low density housing, single unit homes and massive traffic/pollution issues often associated with suburban sprawl.

Yes, 1m/day is hyperbolic, but if you put the constraint on the suppliers (builders, owners), and the demand is inelastic (you've got to live somewhere), then the outcome is to constrain supply for maximal benefit.
The guardian sells tabloid-esque stories in order to enrage the people who can't get jobs. It gives them a reason to point to the company as the problem not the individual.
There is no qualitative way to work this out. Your graphs and numbers here are meaningless.
I've just spent the week making a TUI frontend to an existing application with Bubbletea. It's been a pretty pleasant experience. I don't have much experience doing frontends and I was not familiar with Model-View-Update.

But after a couple of days of head scratching and some help from the Bubbletea slack I managed to put something together that works.

The only inconvenience was that I have to redirect logs away from standard out, but once I did that everything else was a work in the park.

Since the application wasn't really made to continuously report progress I had to poll my data structures and re-render the UI every 100ms. But as the data structures are relatively small that wasn't expensive.
Canary Islands are notably missing. It's practically between 22 and 27C all year long.
I don’t find it confusing, but it’s dreary though. Especially in regions where there’s short days but very little snow.
It's odd. If it was from microdots they should know a lot more than about the printer than "most likely an HP inkjet".
This. Pineapple, a sweet topping, should be paired with a salty topping for optimum flavor.

My preference is anchovies.
Ask HN: Companies in BayArea that hire without leetcode style interviews
Are there any companies in Bay Area that pay well and hire w/o leetcode style interviews for staff+ engineer or engineering manager roles (backend)? As a TLM with 2 decades of overall experience and currently managing a team of 7 and a family of 4 I'm finding it very difficult to find time to sustain leetcode practice for several months. I understand it's a necessary evil these days and this is the best most companies can do to hire talent but still looking for exceptions. Thanks!
In 2017 $100 would buy you about €90, ¥11000, CHF99, £80 (plus/minus about 5% during the year).

Today it will buy you €96, ¥13000, CHF100, £82

Not a great deal of movement
I hope he answers how he felt. Additionally it would be interesting to know his nationality.
Royal Mail is building a fleet of 500 DRONES to carry mail
Other anecdote: I have a thinkpad L450, and randomly during the day, the wifi firmware just "crashes" and disable itself, and needs to be reset via the "troubleshoot" dialog in windows 10.

It's quite annoying, and I can't really think of why it happens.

I wonder if radio interference might be a cause.
> But they aren't, so people trade off living close to a city center with a lower cost single family home.

Yes, but I dont see majority of people doing that worldwide. And where they do that, they prefer houses in near villages where there are stores and community centers nearby. And those houses have small businesses in them.

The local stores or walkable infrastructure are not exclusive feature of cities. That is something that does not exists only where it is illegal to open local store near the houses.
It actually isn't, because most home lighting is far less intense than the sun and the wrong spectrum to boot. Light therapy works but sitting in front of a big bright box is not terribly convenient or fun.

And if your blackout curtains don't work, get better ones. Many Nordic households have double curtains, one solid plastic to block the vast majority of the light and the other from cloth to diffuse/block the rest and look pretty.
Yahoo finance says its 30,279.67 at the moment after a collapse in everything over the last week or so.
Yes, that's basically how it works (kind of like movie credits). On papers with fewer authors, there's a kind of ranking system in the order of the authors: the first author is generally the one who did the experimental work and the actual write-up, the next few may have helped with the write-up and run some of the experiments, the next may have just helped build some of the experimental setup, or otherwise had some material contribution to the research, and the last author is usually their supervisor who reviewed the paper before submission. When the list grows really large like this they usually give up at some point with trying to rank the contributions and just list the rest alphabetically.
Pointy-Haired Boss, Dilbert reference.

https://www.wikiwand.com/en/Pointy-haired_Boss
I'm pretty sure banning words that people use to get around hate speech isn't a particularly good idea...
The biggest thing that bothers me in Bluetooth is the lossy audio compression
In the UK many companies' full time hours are 36-37.5 instead of 40 (still 5 days a week). I know that's not really what you're asking for, just wanted to point out that 40 and above isn't the norm everywhere.
I assume a lot of that information comes from the Machine Identification Code [0], the "yellow dots" emitted by almost all printers.

There's a number of encoding schemes [1], though most of those only identify the printer - they don't go far enough to identify the graphics card or OS where it originated. That's a new capability - if it's being accurately relayed here.

[0] https://en.m.wikipedia.org/wiki/Machine_Identification_Code

[1] https://dl.acm.org/doi/10.1145/3206004.3206019