skysight-inc/HackerNews huggingface dataset:
I am currently interviewing a lot of data engineers and I use the following question:

Given a table that contains a history of spot readings from many different sensors

readings(sensor_id bigint, reading_ts timestamp, reading_value decimal)

show me the latest known reading for each sensor.

Things I look at:

1. Does the candidate immediately reach for a window function?

2. Can they do it without a window function?

If the candidate fails at this stage, it's a no-hire, then I can use the same task to check their seniority.

3. Do they actually know the right window function?

4. Can they explain why a window function is better here than grouping in a subquery?

5. Can they do it in an imperative language?

If they can answer at least two out of three, they are a solid middle.

6. Can they suggest a way to store the data that makes the query take O(number of sensors) time?

Okay, this is a senior engineer.
I wish you the best of luck, `/salute`.
I don't get it. Why do you have to read the internal implementation details of a preprocessing tool when using it?
> Moving to telegram doesn't make sense at all if you are worried about your privacy

Depends on the threat model. If you're being in opposition to Western governments, you can be relatively sure that Telegram will stick the finger to them and not cooperate beyond occasionally shutting down public channels that promote violent terrorism and thus garner media attention.
Thanks for all the detail, I'm interested to know if you have explored CYP gene expression (polymorphism) and it's impact on metabolising ketamine as factor in treatment?
There's more to the world than the US. You can get an EV for $4500 in China, and surprise surprise, sales are going gangbusters: they sold more than the rest of the world combined last year.
> The only improvement is if they could get rid of the requirement that you use a phone number to sign up for these services, which is a regression from AIM, MSN, ICQ, IRC and Jabber/XMPP.

That would only lead to one thing: absurd amounts of spam.
It seems that every language, given enough time, wants to tend towards Haskell!
> but how do you keep track of your credit card(s), bank account(s), possibly your significant other's as well, subscriptions, fees, automated payments, cash in/out, taxes, varying income, investment returns, savings, balances on platforms you may use like wise/revolut (for travel) in different currencies, automated "fees" like interest on savings, loans, which may change every now and then, etc?

I do things like that.

All those accounts can be represented. Many of those things are Scheduled Transactions.

When you Reconcile a statement from a bank or something, it'll even prompt you for recurring interest, in case you don't already have a transaction for that (because, e.g., the interest transaction was already there when you imported the OFX/QFX for that statement).

Investments like stocks and funds are tracked by shares, you can easily enter dividend reinvestment, and you can pull data for the current value in whatever primary currency.

You can also mix many world currencies in the same file, and see the totals according to exchange rates, and you can even define your own units and exchange rates for some purposes (which I've done in the past for metals and cryptocurrencies).

You can enter transactions as you go, and when you periodically Import, any transactions you didn't enter will be added. You can check this when you Reconcile a statement.
Under this legal argument wouldn't youtube just need to add the equivalent of a cookie popup to gain consent?

Or switch to a serverside approach?
> I submitted an estimate for the drying out of the house (just the drying, not rebuilding). It was $130,000.

What does drying a house entail?
There have been a lot of large volume methane releases too methane are much worse ozone damaging molecule compared to CFCs. Plus Siberia and northern regions with melting permafrost are releasing large amounts of methane.

Turkmenistan seems to be the worst for methane emissions from industry. https://www.theguardian.com/environment/2023/mar/06/revealed...

>The variability of the size of the ozone hole is largely determined by the strength of a strong wind band that flows around the Antarctic area.

Who knew water and winds could also damage the ozone layer?!
Flu vaccines are only effective *if* they guess the strain that breaks out the following winter. Sure, it's an educated and necessary guess (given the necessary lead time for manufacturing and distribution) but it's still a guess.

Cardiovascular disease *continues* to kill and maim (i.e., stroke) more than Covid did and does but *no one* from NIH, CDC, WHO, etc. is in the media every other day saying,"Put down the Coke and fries and go for a long walk...". But now that there's a jab for weight reduction maybe that'll happen. Funny how that is.

Coincidentally, those with excess weight (and associated medical conditions) fared worse against Covid. At yet the weight/cardiovascular pandemic doesn't get a spotlight? Why?
As much as what you say is factually accurate, I think it's important to contextualize within the broader Russian consciousness.. the same could be said about almost any American. Just as Americans have certain exceptionalism all the way down to their bones, Russia is similar. The idea that a Russian politician wouldn't at times speak in ways that harken back to that core should not be used as something that dismisses a man of incredible courage who is truly exceptional within a body politic of others that are perennially silent. I've seen this trope before and believe it comes from a naive perspective. In order to have any chance of successfully rallying of people you do need to appeal to some of their base instincts
No one can co-opt it but it's like Pepe frog...

Once a group that you don't want to be affiliated with starts to using it and the "outside" world associates the the symbol primarily with the "baddies", you rather look for another symbol

There definitely seems to be a trend of people abandoning Allahu Akbar

https://trends.google.com/trends/explore?date=all&q=Alhamdul...
Where do you live may I ask? Where I live most people and media know it was Israel and the mainstream American media is lying again just like Iraq.
A Brief Introduction to Military Pillboxes
Yes, "just" is false (as it is in many cases), it requires a lot more effort to discover
It's made for deno if I've read the docs correctly.

But there's a lot of things that seem to be very WIP.

And some of the features sounds like something you can easily include (like state) or the buzzword is just not something that is familiar, specifically "hybrid".
Other way around. It is seeking truth if there is actually a conspiracy. How many so-called "conspiracy theorists" said there was a risk that the shots would alter your DNA, and were then shouted down by people who blindly repeated The Science without engaging with the debate. It's not possible, they said, only uneducated Trump voters could believe that, they said. The Science says the shots can't alter your DNA because mRNA can't do that and anyone who objects should be blasted off the face of the internet, have their bank accounts seized, be forced to take the vaccines to keep their jobs and be prevented from seeing their families.

Only, whoops, mRNA isn't the only thing in the vials, and what is there is the sort of thing that can change your DNA. And the pharma companies must have known that, the regulators turned a blind eye, and testing the vials externally to find out what was in them was forbidden by law (hence why the doctors who blew this open had to test residues from preserved empty vials).

So, yet another win for the so-called conspiracy theorists.

BTW basically everyone has realized this by now. Boosters are still being advertised and promoted but uptake is near zero and Pfizer/Moderna stock prices have disconnected from the rest of the pharma industry, going much lower. Investors are getting worried.
I guess the "Why should i let some strangers sleep over in my apartment?" startup hits its limits the more you try to act as an unsupervised hotel.
Last week, at my girlfriend's place she couldn't make AirDrop work to display a video on the TV so we ended up using a HDMI cable after of ~30 mins of no luck. Yesterday I went over and the same thing happened only that she mentioned that I'm a bad influence since it worked that last two times when I wasn't there.

I took a quick self evaluation and concluded that I'm not possessed by demonic powers, I don't have excess electromagnetic radiation and other supernatural explanation. I remembered the "OpenOffice will never print on Tuesdays" and "My car doesn’t like vanilla ice-cream" stories so it got me curious what changes. The only thing that I added to the equation was my Android phone connected to Wifi. I put it to airplane mode and voilà, AirDrop started working.
But that's insane! These candidates hold people's lives in their hands, and they just hured unqualified candidates!
Why do you need a google or apple account to download it?
so, so, so many discs...
How exactly were they forced to adopt it?
Yeah. Before Firefox Quantum (i.e. abandon of XUL-based add-dons), one can at least use 3rd-party addons to make switching profiles easier.

Now I barely use profiles in Firefox while I have 5-6 profiles in Chrome for various things as it's much easier.
OTOH, insurance frauds exist.

Investigation take time.
> it can only collect so much and stare for so long.

It all comes down to dwell time - the more statistics the better.

Of course it's not just down to time dwelt on target star X, they can work in all the data from all the stars that come from a similar family and share gross characteristics.

There's a sneaky trick in airborne gamma ray spectroscopy where, while a plane travels at (say) 70 m/s and you can only accumulate one seconds worth of ground source radiometric decay over any 70 m patch (along with cosmic gamma, gamma from aircraft and pilots wrist watch, gamma from gases, etc) .. that "one second snapshot" can be pimped the heck up by 'knowing' what tens of hundreds of thousands of 'typical' one second spectrums look like.

If your ground patch of interest is in the "typical" class, the result is greatly (and accurately sharpened) by training and if the ROI patch (region of interest) is atypical - lights up as "very much not like the others".

This, of course, has parallels in astro spectrums - that paper is littered with ThisName and ThatName inside references.

In a parallel earth based field there are papers like (say)

Minty | Hovgaard Reducing noise in gamma-ray spectrometry using spectral component analysis

https://sci-hub.ru/10.1071/EG02172
I guess that's another reason not to use threads
It’s backwards. For A to be assignable to B, A must implement B, so A’s methods must be a superset of B’s.
I agree. It posits a lot of mechanisms for the vaccine's supposedly present plasmid DNA to integrate itself into the genome of human cells, but I remain rather unconvinced until it could be empirically tested.

For instance, I think with HIV you can use immunohistochemistry to generate images showing the viral DNA embedded into the human genetic material in the nucleus. [0]

[0]: https://www.researchgate.net/profile/Luis-Montaner/publicati...
Are you everyone?

That is only one example of a shortcut which doesn't work.
Bonus: RTX has also previously been investigated as a treatment for lifelong premature ejaculation (PE).. Volunteers for clinical trials, anyone?
> and not hoping that Airbnb is going to take this seriously over social media

Unfortunately (or perhaps fortunately?) social media is often faster than a lawyer:

https://twitter.com/AirbnbHelp/status/1715055098420748295
Hi, happy to see this on HN. I'm the author, AMA! =)
it immensely helps in creating and switching profiles. it is like how firefox support tab containers, but multi-container extension improves UX
Generative AI Legal Explainer
Its useless placeholder page - during recent big outage everything was green there.
Formerly known as Pepper Twitter.
> I have Treestyletabs in one and Sidebery in another, just to evaluate both and see for myself

You don't have to put them in separate browsers/profiles, you can just switch which one takes the sidebar, on the fly. I use both Grasshopper[1] and Tab Center Reborn or Sideberry and switch between on the fly them depending on what features I need at any specific moment.

[1]https://news.ycombinator.com/item?id=37306058
it's iOS, there is an app category about 3rd party keyboards in both App Stores. Not a listed app category, but a type of app.
The Means of Gaming Production: video game industry labor cooperatives
yeah, from the ones I a have used (Netflix, Disney+, Prime, Maxdome) only Prime is atrocious, all others are not perfect but usable.
> what else are chrome/edge offering

Having a simple UI that you can just click and launch other profiles, really.
So, if I’ve got this straight, in a few thousand years the known universe will be ruled by the son of a first generation Taiwanese immigrant who has evolved into / mystically merged with a chip foundry?

At least, on the good side, we know the AI thing won’t pan out, after the Butlerian Jihad.
> An update Thursday Oct 19th 7pm:

> - no response from anyone at Airbnb

> - no email or call from Airbnb

https://twitter.com/ErikaCoaches/status/1715187405236703572
The state, or the city? Because the state has a lot of affordable housing.
> And people really wonder why I'm a Libertarian.

Libertarians don't have a monopoly on concern about abuses. But here you go:

https://old.reddit.com/r/copypasta/comments/58eo3q/libertari...
- "Not only are the authors claiming to identify silicates but nanoparticles of quartz vs. other silicates and/or oxides using broad spectral bins and with big error bars. I just don't see how they get there no matter how much they "torture the data."

My understanding of these things, generally, is that they disregard every candidate outside of a narrow set drawn from theory-based atmospheric models. Like: it's 90% Bayesian priors + 10% experimental evidence. I agree with your sense that it's sketchy how they present these results to the public.

I've complained about this at least twice on HN (on unrelated JWST research papers):

https://news.ycombinator.com/item?id=37473122 (dimethyl sulfide bullshit)

https://news.ycombinator.com/item?id=37782393 (polyaromatic hydrocarbon bullshit)
Seconding this, the GnuCash manual is fantastic. The principles of double entry accounting are very simple but if you're not used to thinking in those terms it can sometimes be a little confusing how to fit real life scenarios into that framework. The GNC manual has a lot of helpful explanations and examples.
The example academic paper has puts the definition of variables into a tooltip when you click on them. That's a nice feature for academic papers.
Oh definitely, it's more annoying than anything.

I can sympathize with genuine causes but cheap potshots like whataboutism is just such a cynical means.
Cool, let me know how it goes! =)

Yeah, being able to immediately edit files with your favorite local tools is a big advantage over an online data management system. That's one of the things I'm most excited about!
Good. X is a trash fire and the more companies leave it, the better for everyone.
Fraudulently misrepresenting the level of insurance cover also exists, and it isn't the first time Airbnb's supposed "insurance" left the homeowner holding the bag.

(not that Airbnb is alone in this, it's very common in the industry: https://www.dpreview.com/forums/thread/4404268)
You’re calling this poor leadership, can you share a time you were in a similar situation and did something different or are you armchair quarterbacking?
Elon Musk announces more changes to X
Lots of industrial-grade dehumidifiers running for weeks.
I dont think hosting it under the main domain is a good idea.
https://status.slack.com.

There is a non-zero chance that something bad could happen with the domain,
or something else that would prevent people from visiting the status page.

Using an independent 3rd party provider for such communication is, in my
opinion prudent.

I believe that there are a few companies who run services for it.

Personally, I do not want the hassle of having to set up, and
maintain a list of various RSS, ActivityPub, pubsub, whatever else for every tech vendor I am in contact with.

It is a good use case for Twitter.
(even though they suck)
I've been using GnuCash for over a year now and I still don't know the answer to the following: is it possible to transactions tag transactions with custom tags, and then breakdown reports on those? I mean actual tags, not accounts.

Someone on the Beancount thread explained his workflow using tags link transactions to IRS form entries. I would like to try the same on GnuCash, but haven't yet figured out whether tags even exist (haven't had the time to check since)
That's not what they're saying. They're formally accusing management of not doing their jobs.
Makes me happy seeing the BeamVM getting more usage! It deserves it.
I used to use GnuCash but I never quite found it gave me benefits enough to justify the enormous amount of time required for the data entry.

If it was possible for an open source application to support Open Banking (it isn't), that might now be different.

https://lists.gnucash.org/pipermail/gnucash-user/2020-March/...
about:profiles is not pretty but works without installing 3rd party extensions.
> in expense of the shareholders.

Lol, lose more money than invested.

> A wage labourer should be able to expect to know if they will be able to feed their families the next month.

A wage laborer should make $1,000,000 per year.
And while it doesn’t use the sam language precisely, I think in the broader “postfix Vi with visual feedback” category Kakoune[1] also warrants mentioning. The command language, in my experience, feels much more logical than that of Vis coming from a blank slate (things might be different if you come from Vim, but even when I used Vim regularly I never used the editing language that much exactly because I could never remember the damn thing).

And having mentioned Kakoune it’d probably be unfair to then not point out Helix[2]. It has a very similar editing language, but it’s a fairly anti-Unix everything-bolted-in affair on the inside (“everything works out of the box” being the advertising take) compared to Kakoune’s Acme-inspired no-scripting scripting (there’s an ex-style command to exec a user program that can then drive the editor over stdio RPC, a set of hooks, and that’s it). So if you’ve come for the Plan 9 feels, I don’t expect Helix to be that appealing. It’s still an excellent editor, nevertheless.

[1] https://kakoune.org/

[2] https://helix-editor.com/
At a higher level of abstraction, arxiv is an attempt to fix problems with the review process. Attempting to fix more problems with the review process would.... Etc
Russia is literally a meme country: https://twitter.com/jacopo_iacoboni/status/16797651991783096...
You can die from anything that stresses the body.
I think these days anyone with more than a few hundred dollars of cash on hand is justifiably raising suspicion. Who uses cash these days? Except when someone is flying to a country where credit cards are poorly or not at all accepted (wartime Russia), or where the exchange rate is manipulated so it's silly to use them (Venezuela, Argentina), and maybe some 3rd world countries in general. Yes i take $5-10K of cash with me when i fly to Kyrgyzstan "just to feel safe" (but i have nothing at all to substantiate my concern and never actually needed it - cards are accepted everywhere except taxis), but we are speaking about U.S. domestic flights.

Seeing people with considerable amounts of cash as suspicious makes some sense to me.
> Why should they be allowed to walk away?

Because we decided ages ago that compelled labor is a bad idea.
Agreed.

Pop culture "obsession" may have been useful for overcoming blanket bans on research, funding, etc. It was obsession that created these bans in the first place, and obsession that triggered them.

Now obsession it's interfering with science and (especially) science communication.

Meanwhile, parent comment (the "trip" is the active substance) is a hypothesis... on the face of it. A reasonable hypothesis that needs to be considered, and if possible tested.

There's probably no getting around obsession here. This is literally the namesake "culture war," dating to 60s counterculture.
> “The one-sided Israeli victimhood narrative demands buy-in from media institutions and the U.S. government itself.”

Yeah, one sided. Because of unchecked or misread reporting on alleged civilian death, Synagogues around the globe were attacked.

This will of course never happen the other way around. I don't support to hide any information about civilian death, but there is also a very one-sided reason for it.
>> Why is the US occupying part of Syria? Why is the US involved in the middle east at all?

Because it has economic or geopolitical interests(or both) in there and because it can. Even a tiny country(i.e Belarus, North Korea) can play a role in a big conflict so why would U.S give up influence?

If the U.S doesn't show up Russia or China takes the whole cake(influence wise).

Not to mention the 9/11 thing. Imagine the whole Syria ruled by Al-Qaeda or IS

Like it or not America's isolationism ended after WWII began and I think overall it was a good thing for the whole world(at least a big part of it).
What drugs are you on?
Stacktraces are not useful for end users of the program and should never be shown unless there is a bug in the program.

It is silly how many Java or Python programs display stacktraces on trivially preventable problems that are not bugs (e.g. file not found) instead of giving short human readable messages.
Extremely little. His a nationalist (has argued for occupation of Crimea, genocide in Georgia, "cleansing" russia of non-whites, etc) that is irrelevant in Russia and only popular abroad in the west with people that don't speak Russian and don't know his actual nationalistic positions.
>> often robust if the Copy Paste technician has a little bit of nous

This is faulty logic. Human error isn't an exceptional thing, it's extremely common and expected. There's an entire field of study dedicated to it: https://en.wikipedia.org/wiki/Human_reliability

In many scenarios the right thing to do is just accept the error risk - as humans, we often don't need perfect execution but i don't think this is one of those.

The person quoted in the article gets it right: "We need senior management that know what they're doing, who realize that this is not, and never was, the way to run an HR system"
FUD is common both ways. Your comment could be interpreted as FUD against anything new.

I take it you don't use linux, containers, kubernetes, the cloud, or html5 - but lots of other people do ;-)
> They're cool, yeah, but how do you keep track of your credit card(s), bank account(s), possibly your significant other's as well, subscriptions, fees, automated payments, cash in/out, taxes, varying income, investment returns, savings, balances on platforms you may use like wise/revolut (for travel) in different currencies, automated "fees" like interest on savings, loans, which may change every now and then, etc?

I use a phone app (there are many out there) for my needs instead of desktop software, but in my case I log every single bit of income/expense ASAP - if I buy groceries, I pull up the app and categorize it (takes like 20 seconds). Sometimes my bank is kind enough to have their phone app alert me of new changes in account balance, but that's really flaky, so I check the balance on their website/app occasionally as well and log the changes.

Since I log just my own data, the approach scales wonderfully well (since it doesn't need to scale much). If I ever want to have a look at more data, I export the statements from my bank and either just open them up in LibreOffice, or maybe do some light Python code.