skysight-inc/HackerNews huggingface dataset:
Snowflake SQL also has the interesting feature QUALIFY.

Their docs go into more detail (https://docs.snowflake.com/en/sql-reference/constructs/quali...), but the short version is that typically SELECT is evaluated in the order FROM, WHERE, GROUP BY, HAVING, WINDOW, DISTINCT, ORDER BY, LIMIT.

But what happens if you want to filter on the result of a WINDOW? Sorry, time to write a nested query and bemoan the non-composability of SQL.

Snowflake adds QUALIFY, which is executed after WINDOW and before DISTINCT. Therefore you can write some pretty interesting tidy queries, like this one I've been using at work:

SELECT
*,
row_number() OVER (
PARTITION BY quux.record_time
ORDER BY quux.projection_time DESC
) AS record_version
FROM foo.bar.quux AS quux
WHERE (NOT quux._bad OR quux._bad IS NULL)
QUALIFY record_version = 1

Without QUALIFY, you'd have to nest queries (ugh):

SELECT *
FROM (
SELECT
*,
row_number() OVER (
PARTITION BY quux.record_time
ORDER BY quux.projection_time DESC
) AS record_version
FROM foo.bar.quux AS quux
WHERE (NOT quux._bad OR quux._bad IS NULL)
) AS quux_versioned
WHERE quux_versioned.record_version = 1

or use a CTE (depending on whether your database inlines CTEs).

I definitely pine for some kind of optimizing Blub-to-SQL compiler that would let me write my SQL like this instead:

(query (from foo.bar.quux :as quux)
(select *)
(where (or (not quux._bad)
(null quux._bad))
(select (row-number :over (:partition-by quux.record-time
:order-by (:desc quux.projection-time))
:as record-version)
(where (= 1 record-version)))
That sounds like the same retailers (I know WalMart was behind it). Wendy's also doesn't take it. I think that CVS used to reject it, but they have been taking it for at least the last couple of years. I use ApplePay for everything.

It is starting to become stupid to reject it. Even the smallest mom-and-pop places I go, now take ApplePay. It's built into the processors. I think they have to consciously turn it off. Last time I got a haircut, I used it. They didn't even know they took it.
Any chance you can add code completion to python terminal? That would make cuda-text a super-editor on the level of vim and emacs but easier to use.
Author is talking about looking up PIDs, kill -9 %1 saves you from that.
SEEKING WORK
Graphic and Web Designer | Illustrator
Design and Visual Development for:
Kids and Youth Oriented Businesses,
Packaging, Games, and Clothes
Decoration Design.
Motion Graphics | Sticker for Telegram.
Digital Assets.
links: https://megabedoya.cent.co/

My skills: Logo design, Brand design, Illustration, Cover design, photo montage and retouching, Graphic editing, Social media, Textile print design, printed product design, packaging, labels, tags, motion graphics, stickers for telegram, and more! (+24 Years Experience in GD.)

p/n:
email: megabedoya at gmail
Rate: $18us - $25us / hr (agreement per task)

===

Raul Bedoya Ching.
> But with good recordings and mastering

That's the issue here. The loudness war made any CD mastering a race to make the most compressed track, just to sound louder than the competition.

Technically, digital should sound better. The technology is better. Sound engineers are making sure this is not the case.
It's actually pretty obvious name. You just need to visualize a Venn diagram and left, right and inner become obvious.
I would ask you more questions like window functions, cte, joins, etc. or how would you address certain questions, and tbh i would be really curious that you know good sql but haven’t heard of having.

In my hiring experience it always acted as my first sql impression of candidates and 100% filter of people who don’t actually know sql besides some basic inner joins and aggregations. There are always exceptions i guess. :-)
Seems this was only done on mice. Wouldn’t it be easy to evaluate (statistically) on males. Basically measure testosterone levels of out door laborers and indoor laborers.

Then as a follow up have the indoor laborers go outside for 1 hr mid-day or something for 12 weeks and measure the effect.
> night of turmoil.

Can you elaborate?
Nodemailer is a project I started 11+ years ago with no backing. It gets millions of download every week and is used by hundreds of thousand of projects and developers around the world.

EmailEngine is a commercial project I started a year ago and now I use the Nodemailer’s homepage to drive traffic to it. Both are my solo projects, no one else is involved.
My personal experience only - my grandpa lived to his mid-nineties:

Don’t bother too much with the medicines and pills. What really matters: daily social interactions (with friends and family members, not random people or nurses/doctors) and a regular schedule of “purposeful” activities to look forward to every week. Bingo every Tuesday, fish dinners on Friday, etc.
The real challenge for newcomers, I think, is to reconciliate this almost magical "monads allow side effects in pure functions" with the very mundane "a monad is a type with a 'return' and a 'flatMap' aka >>= method".
Bonus comment: excellent point about web app notifications! I do use calendar notifications because they are very useful.
It is in fact legal, and does in fact happen. Three examples found with three minutes googling[1][2][3], plus an article identifying 51 mastectomy approvals for under-18s[4] in Scotland alone.

Are these just isolated cases performed by overzealous doctors? No, WPATH's current guidelines allow for mastectomies at age 16, and the latest Standards of Care draft[5] calls for reducing this to 15.

What about the safety and reversibility of puberty blockers? We don't know. See this letter[6] arising from the Cass Review outlining the evidence gap. The current approach to treating gender dysphoria is a slow-motion trainwreck medical scandal. I strongly recommend reading the Cass Review interim report[7] which outlines the numerous ways in which gender-dysphoric children are being failed by current treatment models.

[1] https://thevelvetchronicle.com/double-mastectomy-at-15-detra...

[2] https://www.newyorker.com/magazine/2013/03/18/about-a-boy-2

[3] https://mercatornet.com/chloe-cole-gender-transition/80073/

[4] https://www.thetimes.co.uk/article/scottish-doctors-approved...

[5] https://www.wpath.org/media/cms/Documents/SOC%20v8/SOC8%20Ch...

[6] https://cass.independent-review.uk/wp-content/uploads/2022/0...

[7] https://cass.independent-review.uk/publications/interim-repo...
The way exceptions are handled as a result of siglongjmp'ing out of a signal handler is currently platform-inconsistent and one of the many dark areas I alluded to. It isn't even consistent on Linux between compilers.
Adsense require content, there's no content on this page. Just a form and a graph.
Groom them into knowing http://www.catb.org/~esr/faqs/smart-questions.html . Help them build a basic mental model of the discipline. Teach them how to google but have them send you the thing they want to do before they implement it. Explain why it will or won't work. After they got good at it task them to send questions about the answer they consider implementing in addition. Give them answers on the questions and rate the questions. Build their confidence in trusting their own reason. The make them research the answer to some questions they raised with you about an answer to another question. Give them time to figure out the answers themselves and get them out of the critical chain of business processes while they learn and complete their mental model. If they are unable to adopt or improve see whether them switching employment, ignoring them and ot you switching employment is possible.
My responses fall into 3 broad categories:

1. I consider that to be out of scope for this project, but feel free to fork and add it yourself. (Translation: I think it's a bad idea)

2. That's a good idea, I will consider implementing it at some point in the future. In the mean time, PRs are welcome.

3. Sure, I'll implement it now.

If for some reason they keep asking, I respond with something along the lines of "pay me, or go away" (but perhaps phrased more politely, depending on what mood I'm in).
To expand on the other answer: by choosing a=0 and b=0, you show that the integral (the LHS) is greater than our equal to zero. The article then shows there are values that prove the lower limit is 4.
This thread is not court and the question posed was "why would Musk do it". And the answer seems spot on - he lied and bullied for years and it tended to end for his benefit. There was no reason for him to not think it is going to end the same way.

And it is not even primary issue with Musk, it is primary issue with general economy/justice syatem that favors lying and bullying, pri ided you have enough money.
What We Gain from a Good Bookstore
Where do you shop that doesn't sell plain old soap bars?

Need me to mail some for you?
battery comes from the verb "to batter", which basically means "to bombard"
> Population collapse is likely not going to come from too many people becoming steralized

And if it did, it would probably be from something like pollution/climate change, not a tiny minority of trans people.
If food was plentiful and everyone had access to food, sharing food would not be a virtue. It's only a virtue if it's somewhat difficult for the person sharing (it means they are sacrificing something to help others) and at the same time is valuable to the receiver (the receiver really needs the food).
Did not expect to see that namedrop this morning! “Kostelanetz” by the way.
Because for many studios, the creative staff are cogs to be used for a game then dumped when it's over. Read "press reset" for many examples of this. They want you to stick with the publisher for sequels, not follow the developers as they go from studio to studio. There are exceptions to this (Kojima for one).
What Happens When Your Femtech Startup Can’t Use Social Media for Marketing?
> choice is between the voodoo man, or a professor

Those categories are not mutually exclusive. Universities are filled with gender or other crackpot theories "academics" that don't follow scientific methods. Even in the real science realm, having academics credentials is a more effective way to turn into a voodoo man in an unrelated field than starting from scratch.
Or just let them die, as they should. Why we should all suffer from the Prince Charles's Effect?
Wetiko: The mind-virus at the root of our current global polycrisis
I have been interested for quite some time to dabble with psilocybin but just haven't yet had the chance with buddies(outside of a work related traveling event) to do so.

I absolutely refuse to try anything like this outside of an environment I have some level of control in or trust in the people around me(not the general public I.E: Bars, clubs, Vegas, etc).

Any advice on what to avoid for a first timer from any experienced person here?
It is true this improves the bad path. It ignores desired happy path cases: downstream processes, custom debugging, graceful shutdown, preserved workspaces, and so on.
If you are not sure, get the person involved and see how it pans out. If the person requesting can be asked to "do some work" - diagrams, functional spec, mockups, etc, then it shows commitment. Most cases the user might not be interested, so then it fizzles out. If he/she is really passionate about it, it may turn into a good idea since someone is actually giving it proper attention.
Regarding the tubs, afaik large barrels were sometimes used for bathing, though I'm not sure when and where. I'd guess these wouldn't stand out specifically as bathing implements.

Although a barrel-with-a-seat would probably still be more convenient, in this vein: https://yourhautecouture.com/wp-content/uploads/2017/07/half...
Jagiełło is up there as one of the greatest greats of all time in Polish national mythology.

I mean I’m no historian, but my impression here in Europe is that every nation has its heroes. And that those same heroes are often villains in the histories of neighboring national mythologies.

I know this isn’t some big insight. But from my Polish perspective I think it’s all much more recent than we would like to think. We learn all of this stuff on the basis of a highly politicized curriculum. For instance most of the current Polish national stories/facts date back only to 19th century literature, which was highly focused on restoring the Polish national myth.

Our minds can’t wrap their way around time very well. So, we end up believing that someone from the 19th century somehow knew more than we do about the 17th century. Fact is, someone from the end of the 18th century probably could already have distorted knowledge about the beginning of the 18th century.

So I think shitty nationalist arguments over Jagiełło’s rule have more to do with what modern Poles and modern Lithuanians think, than with what was really going on in that historical period.

Anyways I’m surprised Jaggielonians were this important historically later. I’m a bit suspicious about modern motivations around supporting myths that they’re worth cherishing. Are there ancestors who have an interest in making themselves “royal” for the purposes of their ego?

What’s more - why is this even on Hacker News? Isn’t this, like completely off topic?

edit: I don’t want to be harsh - the subject does sound very interesting, and worth investigating. Oxford historians are probably more than very well aware of everything I said above.
> true for literally anything

Pedantic: no. It’s true for everything that is safe or beneficial to consume. There is no “right amount” of lead or plutonium in your diet.
Right on time for me!
Besides having one thing fewer to carry on your person, I don't see the point. Aren't passports already cryptographic devices, containing your information for external lookup and verification? Why move that to the phone? If anything that decreases security, and it's not like your need your passport available commonly enough like a bus pass to warrant moving to the phone. Passports with a chip offer fantastic security in a discrete package, and if the future is to move this to the phone then I will be a bit disappointed.
Well, I wouldn't mind doing another PhD. I don't reckon I'll ever have the same degree of freedom to follow my intellectual interests, study what I want to study, and produce what I want to produce, ever again.

I still had some restrictions (e.g. I had to publish on the schedule determined by publication deadlines, even if I wasn't quite ready) but even so, the freedom I enjoyed just doesn't compare to any kind of job I had before.

I studied AI and I think it would go great with entomology. A double PhD in AI and entomology, maybe with a third one in robotics... At the very least that would give me a unique background, now wouldn't it?

Ah, but ars longa, vita brevis...
My understanding is that chargebacks are not fun to deal with even if there is overwhelming proof that it's fraudulent.
You could do it on STM32H7, and probably slower ones too.
Cats are the most active hunters for pleasure doing so far more often than humans.

I am not even entirely sure that herding is uniquely human.
Thank you Lio! :)

I had also came across this which could be useful: https://store.afomera.dev/learn-hotwire
Me too, I was just about to disable ublock but then I realised there was stuff below the page of whitespace.
On the opposite, a little later (1980) The Blues Brothers elevator scene (with The girl from Ipanema as music) is a wonderful way to introduce a pause after the action of the car chase.

https://allthetropes.org/wiki/The_Elevator_From_Ipanema
The Canvas of Babel (YouTube)
It’s Hard to Win a Senate Race When You’ve Never Won an Election Before
> Politically, I get it, the academia is overwhelmingly liberal-left, so there is an instinct not to alienate it

> Eschew flamebait. Avoid unrelated controversies, generic tangents, and internet tropes.
YT premium can't be compared against this.
mainly, because the presets are animatable. So you can generate a not repeating noise.
> We don't want our ctrl-c to leak memory. […] If you allocate a piece of memory, you need to store a pointer to that memory from the object graph, and both of those operations need to occur inside of a critical section. Otherwise, if you get interrupted right after the allocation, there won't be any way to reach your memory and it will leak.

Maybe I'm missing something here but… so what? If at the end of your Ctrl+C signal handler you exit() as expected, then the OS will clean up your process's memory anyway.
Thanks for the kind mention!

I am Stephane, the person behind that website/project. I see a lot of people having concerns about the title - Background Sound Canceller - and they are right. That title is not mine, but poster's own.

I describe my project as "Background Noise Generators", or sometimes as as "Non-Distracting Noises and Music".

They are not sound cancellers but sound maskers.

The idea is to create a noise you like, to mask a sound that you don't want to hear. Your colleagues, tinnitus, ... anything.

Because these noise generators are designed to be non-distracting, there is a big chance that your brain will not even hear them after a couple of minutes... but they will keep masking the nuisance you wanted to het rid of in the first place. That is the magic exploited by the project. Create these sonic "focus bubbles".

Happy listening.
That really is a great example, but it's very noticeable that you both went into it with the perfect attitude (and maintained an awareness that each had different needs & goals).

It's the "Veruca Salt" case that's much more difficult to solve for.
For sure. Conflicts of interest are too common in nutrition research, and I think the criticism of this particular paper is laudable.

I simply wanted to point out that there is significant indications from other studies that red meat, and in particular processed red meat, is correlated with heart disease (and cancer).
> low-quality type of data that, on the whole, can only show associations, not cause-and-effect relationships.

I have yet to see anyone pull off a long term double-blind experiment on humans--other than the Nazis.
I get the feeling that at some point the muzak groups did some kind of study that shows shoppers are more likely to frequent a place if they play one slightly obscure song they really like. Which will lead to places like a convenience store playing a string of obscure tracks from a large variety of genre's.

Or at least that's how I explain my local store playing a country song into some obscure song I love from 20+ years ago, into some modernish pop song.

Maybe some place has furthered this with recognition software, but I don't interact with much social media and still have noticed this.
I would gladly buy a book of "SQL Recipes" ranging from beginner-level to advanced stuff that uses features like this, ideally with coverage of at least a few popular database systems, but at minimum Postgres.

Is there such a book?
Monkeypox – The Myths, Misconceptions – and Facts – about how you catch it
Good point. And to that person with the shaky knowledge; I have found it to be impossible to improve their knowledge. The metaphors Window, Button, Desktop, Folder, File, Program, URL, Google Search is impossible to get them to learn precisely. I have given up.
Perfect example, thanks for sharing.
Quite possibly the reason. Though, I think retail, in general, has become quieter, outside of supermarkets (for some reason).

In some ways, it feels like as visual aesthetics went minimalist, so did the soundscape.

I'd personally like to hear an even quieter soundscape. It's so annoying to be sitting in a bar or hotel with sound blasting at you. It's like they expect people fear being alone with their thoughts or to be unable to make conversation when together, so they feel the need to fill the void.
Rapamycin will probably be more effective than any of those. Also, resveratrol has very low bioavailability (<1%) since it has extremely low water-solubility and also doesn't survive first-pass metabolism

Also, get them to a healthy body fat % (as measured by dexa) which is like 15% or less imo, and have them doing regular cardio.
Yeah! That was it.

https://www.macrumors.com/2011/02/24/apples-0-99-facetime-ch...
Isn't it a common phenomenon that smarter people have fewer children? Once you achieve high education people are more strategic about when, or if, to have children and how many.
> The bad actors who really know how to work the systems

Time to bring back retailers sharing a list of names of those bad actors and just refusing to do business with them.

For the people who buy one of each color and then return all but one, a solution is to only ship one at a time.

I'm surprised that Amazon doesn't have (or perhaps has it in secret) a "score" for each customer, and certain kinds of transactions are simply rejected for them.
UVB exposure -> p53 activation -> downstream sex hormones upregulation is hypothesized to be mechanism, so sunscreen that blocks UVB will probably reduce the effect.

This study is part of an interesting trend I'm seeing of studies finding beneficial health effects to well timed, full spectrum sunlight exposure. The circadian benefits of seeing early morning sun every day (and darkness every evening) are well known. What's more surprising is that even UV exposure is not purely negative, and in the context of sunlight in moderate amounts (not to the point of acute sunburn) may be beneficial for health:

https://doi.org/10.1093/jnci/dji019 finds that high intermittent sun exposure actually decreases melanoma lethality. I.e. those who avoid the sun die more from melanoma.

https://doi.org/10.1111/joim.12251 found in a study that followed 30k women over 20 years that more sun exposure was associated with reduced all cause mortality. I.e. those who avoid the sun, apply more sunscreen die more in general.
> Basically measure testosterone levels of out door laborers and indoor laborers.

This is very susceptible to various biases.
Encourage them to walk as much as possible - hopefully daily.

Encourage them to shorten their feeding window. Perhaps as small as 4-6 hours but even 8 hours would be a big step up from a (typical) 12 hour feeding window.

If you wanted to be more ambitious, any kind of resistance training would be fantastic but not at the expense of the walking.

...

I notice you employing a familiar heuristic: "things doctors don't want to talk about" but I encourage you to embrace an even deeper heuristic:

If there were some natural substance, or plant extract, or pressing from (food) or (some combination of purple berries) that made people live longer, we would all know about. It would be carved into stone tablets and embedded in every religious tradition. It would not be a secret.

People have been watching and cataloging their food inputs for millennia - the pressed extracts of winegrape seeds would not have eluded their notice ...
This is why the data engineers get paid the big bucks, and also why having a good data engineer is a lot more important than a good data scientist in the early stages of a company.
the reality is when you are at war, fighting invasion and under immense pressure from a superior military force, you are going to do what you have to do. I doubt Ukraine are intentionally endangering the lives of their own people; they may just be forced into accepting a higher civilian casualty rate in order to preserve what fighting capacity they have remaining