skysight-inc/HackerNews huggingface dataset:
Eh, `DISTICT ON` is a custom PostgreSQL extension.

A standard* method would be:

SELECT *
FROM tracks
QUALIFY row_number() over (partition by album_id order by milliseconds desc) = 1;

But the QUALIFY clause is so new that it doesn't work on most RDBMSs. If you're on MS SQL Server, you're still using:

SELECT *
FROM (
SELECT *
,row_number() over (partition by album_id order by milliseconds desc) rn
FROM tracks
) x
WHERE x.rn = 1;

That said, I still don't think PRQL is particularly amazing. I can't tell if it's merely syntactic sugar for SQL, or if it's actually meant to control query execution. If it's the former, it's likely to frustrate developers because it's actually just another layer of abstraction. If it's the latter, then it requires the developer to not only understand the data model well enough to be able to write SQL queries, they need to be able to understand the RDBMS impementation details well enough to be able to write queries that best take advantage of the current database's indexes, statistics, and configuration. Even something as simple as sorting before filtering or projecting can be a significant performance issue. Nevermind the fact that relational algebra done in the wrong order can be non-deterministic or not equivalent transformations, so even if the query processor is smart enough to do rewrites whatever the developer enters might be logically different unintentionally.

Ultimately I think it's a tool that lets the developer thinking about the problem in the way they prefer, rather than thinking about the problem in the way that best suits the problem at hand. Like insisting on writing documentation in LaTeX instead of Word or Markdown.

*: I believed this was in SQL 2023, but double checking it looks like it did not have make the final standard. I would be surprised if it didn't make it in the future, however.
@tome for the deterministic system, what if the timing for one chip/part is off due to manufacturing/environmental factors (e.g., temperature) ? How does the system handle this?
Stuck in the Middle with the Fujitsu FM-8
To add another anecdote: I drink minimum one small pot of coffee a day (a pour-over I make with my wife, 30g/450g beans/water), plus a moka pot or two in the afternoon, or a 15g pour-over. And 1-3 espresso shots if I go into the office. I consider the coffee experience positively euphoric. Almost spiritual. Certainly ritual. I would never give up the time of sitting with my wife for half an hour to an hour each morning (especially in this season by the fire).

I have never had anything like anxiety, before nor after coffee. I suspect that for many people's cases with such things, other dietary changes (including unnoticed enormous amounts of sugar with the coffee) may be the real culprit. But it's so hard to say with individuals.
I don’t know, I have no sense of the divine. I enjoy the music and hear that Bach was a Christian. I am a huge Bach fan but I don’t know what the divine is and doubt I’ll ever know. I am like a p zombie but for spiritual matters
I would argue there's a soft spot at around $10M ARR where founders turned full time CXO lose focus and touch with their product. They turn it over to folks who don't seem to carry the customer focus but instead have a focus on building their version. It doesn't seem to play out well and I'm curious why this seems to keep happening.
I find the new default UI usable with the compact mode enabled. I did prefer the old one with the blue highlight line on the active tab, though.
The executive hubris driving five-day in-office mandates
> Imagine there was multiple high speed rails lines going out from Silicon Valley: how far from SF can you get in 25 minutes using 300 km/h train versus how far can you get using a car in rush hour?

I think people who haven’t lived with such infrastructure don’t understand that it’s not as easy as it sounds.

Sure, the train may get you from point A to B very quickly, but you still have to get between your office and the train, then from the train to your housing. That’s three trips total, unless you’re lucky enough to live right next to the stop.

And it adds up: That's actually six trips total for a single day (round trip). If they don’t line up perfectly or you miss one, that’s four different places you have to sit and wait.

This is many why people still drive even when they have access to such transport: You spend so much time going through all the transitions and in-between transits that a long drive no longer sounds so bad.

I tried to use my laptop on the train, but the best I could do was answer a few emails before packing up for the next transit step. Better than nothing, but it’s much more complicated than the internet ideal version of taking a high-speed train straight from your apartment to the office.
I don’t drink coffee as it doesn’t sit well in my stomach, but the thing is, I’ve never felt like coffee does anything for me. I can drink a cup of really caffeinated coffee and drink without any issue and even sometimes the warm beverage actually helps me fall sleep.

But you know what triggers tachycardia and rushing feeling? Corn based food like tortilla, which is really ironic as I’m mexican.
Cock.li: 10 Years of Throbbing Email
This is pretty sweet. The speed is nice but what I really care about is you bringing the per token cost down compared with models on the level of mistral medium/gpt4. GPT3.5 is pretty close in terms of cost/token but the quality isn't there and GPT4 is overpriced. Having GPT4 quality at sub-gpt3.5 prices will enable a lot of things though.
This doesn't work in C because the function is not necessarily defined in the same translation unit.

You'd need to do this at link time instead, which would require completely overhauling the format of object files, dynamic libraries, static libraries so they carry information about the types of functions instead of just the symbol names. It's not an easy fix.
You're mixing written versus spoken language. Russian people largely cannot understand any Ukrainian when spoken. Polish people on the other hand can make out bits of Ukrainian.
Yeah, for sure. This post and these comments just made me google caffeine for a bit.

If I don't get my morning cup I almost always get quite the headache, so I'm not surprised.
Sorry about your Dad but did it help other people? How many did you send and how many had positive outcomes in terms of prolonged life above the expected outcome?
I agree with this.

I see a lot of benefits in advocating this style of interview. However, I am struggling to think of what good does a SaaS bring here.

For one, we use GitHub for all code reviews, and we'd want interview to be as close as possible to the environment that the engineers are familiar with. Any time we tried bringing another tool to the process, it only causes additional stress/friction for everyone involved.

Also, I found that constructing example code for interview produces worst insights than using your actual codebase. We have a few codebases that are of lesser importance that we use for interviews. The extra benefit of this is that the candidate gets to see approximation of how your actual codebase is structured.
“Statistically significant and highly clinically meaningful” perhaps, but not so much that they can say what that actually means.

My understanding is that of all cancer drugs approved by the FDA between 2000-2016 (around 90 drugs), the median life extension was just over 2 months...
I wonder how many people would continue to so casually use these services if they understood that, for the most part, there is rarely proper end-to-end encryption of their data with these services. It is awfully disingenuous when these companies' marketing materials describe their services as "encrypted" when it usually just means there are two independent TLS pipes, which both terminate in their "cloud"; this surely gives a false sense of security to end-users who may not understand the implications of such a setup.
Thanks for saving the animals. Illustrations were great touch and added so much needed whimsy to usually boring error pages. Another improvement that is a must - removable "Add-ons" button. I understand why "Menu" button is not allowed to be removed (although, it would be neat experiment to move it around toolbar), but "Add-ons" is just taking up space. And considering, that other browsers allow to hide their variant of "Add-ons" button, there should be no excuses for Firefox. Customization is a rare feature in browsers these days, and huge pro considering other browsers.
> as you might expect, Mozilla does not care

internal options are internal options, no browser cares much about them outside of e.g. some huge company support contracts

if you have to go to `about:config` for anything but dev or MDA related things then you can't expect things to continue working with any update

and every option is code which needs to be maintained

if I should guess they rewrote the code which used the option and did the faster/cheaper thing of not re-implementing a feature they officially anyway don't support
Hamish from Substack re-stacked my note about a hidden way he recruits for devs
> Yeah, there's a big absolute drop Q4 23

That's when Tesla Model3 had the biggest declines in price though... and Tesla ModelY had plenty of price drops throughout 2023. If EVs are selling less, despite huge declines in price, is that not worrisome?

---------

We can also look at the used-price: https://www.cargurus.com/research/price-trends/Tesla-Model-3...

Used is important for people who plan to sell their vehicles later. If your car declines from $50k to $45k over a few years of use, you feel good. But if your car declines from $65k to $35k after a few years of use, you don't feel near as good.
There's a great talk by Margaret Heffernan where she brings up the term "social capital"[0].

In my own experience working in overperforming small startups, I've always found that this layer of trust can accelerate and multiply the output of small teams that have a tight understanding of how each member's contribution can be maximized.

The social and collaborative aspect of software engineering is indeed highly underrated.

[0] https://ideas.ted.com/the-secret-ingredient-that-makes-some-...
I'm pretty sure QUALIFY was added in SQL 2023. Maybe it was only discussed and didn't make it.
When somebody (related to HN topics like the author of a programming language) dies HN shows a black bar at the top. That leads to questions, e.g. "Ask HN: Why is HN showing a black bar now?". Add explanation to the FAQ and even better add a mouse-over help or click-able help to explain what the bar means.
Fight for it, don't ask!
React is more than UI–it's a side-effect framework
The single most fragile ecosystem in the world is a desert. The casual way folks here throw that line out, again and again - shows a profound lack of understanding about what an ecosystem is.
Caffeine elimination, like all metabolic processes, isn't quite linear. At low levels the elimination rate is proportional to the caffeine concentration, so you get the "half life" exponential decay curve. But at high levels, elimination is limited by liver enzymes and decay is approximately linear.

So yes, there is some level of caffeine intake that exceeds the max rate the liver can remove it and concentration would increase indefinitely.
Theory of alienation in Marxism usually refers to the idea that social hierarchies exist because they're tied to your work. Optimization isn't strictly just production based, it can be carbon capture. Then you get to Marx's other theory: the commodity fetishiation. It's not all doom, you can fetishize some crops by making them organic, carbon negative, low water, etc.

All of knowledge work is very alienating.
Like let companies post some sample code that anyone can pick up and review to provide feedback?
I guess working underground is your only chance of survival if in such a landslide?
Palestinians demand immediate end to Israel's occupation at UN's top court
Slight correction - <output> is not inert for users who use screen readers, though in this case it shouldn't cause issues. If you need an actual inert element, use a div.
You all seem like one of the only companies targeting low-latency inference rather than focusing on throughput (and thus $/inference) - what do you see as your primary market?
still works because it is easier to return the cart and take the token with you for your next shopping trip than it is to get a new token every time you go shopping. Additionally it probably also to do with the culture in some part
Love it! I think this idea has some legs in that a programmer can build their own f****k. Bundling only the pieces that they actually use. I don't see why it should not be used in a production environment...other than someone in the internet disapproves...a fear many of us suffer from. It's a simple idea & can be easily managed in a codebase.

In he spirit of breaking apart HTMX piece by piece, I created hyop (Hypermedia/Hydration Operation). It weighs in at 61 B but uses the "hyop" attribute. I know, I know, I'm bad...but at least I save bytes.

https://github.com/hyopjs/hyop

I'm going to use some of your concepts, with credit of course...like the snippetware idea among others.
>people have large imaginations

There's a guy on youtube[0] that's convinced that every rock he sees is a fossil. His videos are a strange combination of absurd, disturbing, and relaxing.

0- https://www.youtube.com/watch?v=zQnCueSlWLY&t=0s
Well, in the AI space Meta is kind of the good guy in sharing developments and models.

Not that this particular list would feature any saints.
Hi Peter,

It's closed-source / proprietary at the moment, but I'm highly considering opening parts / all of it up as a golang library at a minimum, or do a free/pro version to support development. Any thoughts, suggestions?
I'd say sadly it is almost the inverse.

It's the companies that hire really high volumes that I see resort to leet code tests as sort of a great filter.

I rarely see small companies use leet code interviews, but that does not say much about the rest of their interview quality.
I feel like the biggest loss from the days of big record companies is that no one is going to front a promising young band enough to go away together and make their 'Dark Side of the Moon' or 'OK Computer'

* I know both bands probably could've self-financed those projects by that point in their careers, but would they have? And would their role as investors have changed their artistic decisions?
You can use something you dislike, that wasn't my point.
I was always torn between Denise, Paula and Agnus.
> I'm not writing a philosophical treatise here. I'm not writing a lawsuit to take all coffee lovers to court. And I'm definitely not writing a scientific review... What I'm sharing is the minority perspective.

If you're not mounting an honest case against caffeine, don't call your article The Case Against Caffeine. If your evidence is cherry-picked, as you admit it is, it's disingenuous to have a section called The Science Of Caffeine-Induced Anxiety.
From the description that doesn't seem to be the case, but I don't know this product well

> Accelerator Cards GroqCard low latency AI/ML Inference PCIe accelerator card with single GroqChip
Greener cities: A necessity or a luxury?
I think Sideberry is nowadays more comfortable than TMP.
Doesn't china account for like at least half of that? And even there but also everywhere else it has stalled or even reversed since 2020?

Which is not even getting into the problem that "extreme poverty" is defined by organizations operating from within wealthy countries, who have their own interests, incentives, and constraints around these figures and their boundaries.

If you want to argue for it all being capitalism go ahead, so far you've just stated it.
1. Notice language is complicated for some tasks

2. Propose newer, simpler language to take care of these

3. Newer, simpler language lacks features of original language

4. Newer language adds features, making it more complicated

5. GOTO 1
Stretch goal is to split up the site by geography the way diskprices does. That would probably fix what you’re seeing. But that would double the resource requirements on the backend and I’d have to rewrite/abstract a bunch of stuff…so for now I’m just going to make the pages open in new tabs, and figure we just keep looking until we find what’s available locally. Pretty sure I’m pulling worldwide, so there’s likely stuff not available in the US too.
It really did read like a trivial claim made by a backlink blog spammer.
Source article: https://academic.oup.com/joh/article/66/1/uiad013/7473692
I've produced some KIFS (Kaleidoscopic iterated function system) fractals that look like this
Of course, people who modify their settings in the first place are more likely to disable telemetry, particularly if they're choosing a non-default, low market-share application that specifically bills itself as privacy friendly.
"ERP Enlightenment" conjures images of corporate millenarianism and beige-toned transcendence, as if the arbiter of judgement were arcane B2B systems, the truth of which is held by a select few consultant-priests.
> making the investment is worthwhile and pays off in small and large ways

And... 'making the investment' takes time, and means that time is not able to be invested someplace else.

If the majority of your job is writing SQL or similar (data access, etc) then sure - yes, learn more of those tools. Some folks have a wider range of responsibilities that means you have to decide what to make more time investments in, and saying 'yes' to something is necessarily saying 'no' to other things.
Scientists estimate that there are nearly 9 million species currently living on Earth and far less than a third of them have been identified.

https://education.nationalgeographic.org/resource/biodiversi...
Those sorts of issues are part of timing analysis for a chip, but once a chip's clock rate is set, they don't really factor in unless there is some kind of dynamic voltage/frequency scaling scheme going on. This chip probably does not do any of that and just uses a fixed frequency, so timing is perfectly predictable.
Corporate greed is arguably a market challenge
Did you quit long enough that you got through the withdrawal?

Caffeine withdrawal is pretty bad, and you'll probably have trouble thinking. The first time I quit cold turkey, I felt dumb. Couldn't think clearly or focus until I got past it.
> Communism red scare was also from the 60s-70s, please change your worldview for the reality of the 2020s, not a boogeyman invented during the Cold War.

While the post's reference to communism may have been a bit hyperbolic, it's not too much off the mark. It would have likely been better to state that America is supposed to have a free market and not implement socialist policies to fix a problem created by the government: zoning and building restrictions as other comments in the thread have mentioned.

Nevertheless, communism is a valid threat to current-state America, as there seems to be a large push towards marxist ideologies that are corrupting long standing public institutions.
Well, there is an argument to be had that, for C, a plain unadorned "int" should probably be the native word size for that architecture. On 64-bit systems, "int" would therefore also be 64 bits.
Thanks for the link. As I understood it, it's just the support for the syntax that is mandatory.

> Variable length arrays with automatic storage duration are a conditional feature that implementations need not support
Missed that! Thanks for pointing out!
I remember using my 64mb MP3 player on repeat with 15 or so songs, but never really casette tapes.
Mapped: Science and Technology Hubs
> the ability to view lyrics while listening to music

You can still do that? Am I missing something?
Isn't that a curious thing? The most successful businessmen on the planet, and they don't jump into large-scale solar like the pundits think they should?

Maybe that says something about the business model, hm? About how easy or how useful or how successful such an attempt would be.

Armchair energy experts can say anything, claim anything. But follow the money, that tells you what can work and what can't.

Not saying it will never work. But for now, largescale solar is fraught with landmines. But I said that already and been ignored because it's easier to make wild claims than address hard realities.
A better alternative would be to set state policies that encourage economic development in Stockton rather than spending $100B on high-speed rail. It's really nonsensical to keep trying to cram more people and jobs into a geographically constrained region like the Silicon Valley. There's nothing special about Mountain View.
They did and it's been known for a while. That wasn't lost on the productivity side of the equation. The other side is the cost side. The cost side often won out.

Peopleware https://en.wikipedia.org/wiki/Peopleware:_Productive_Project... was first published back in '87 and had a long list of references back then on previous studies.
Union, intersection, difference, and more are coming to JavaScript Sets
I suspect if you've run into problems with a lot of things built on FUSE, the problem is FUSE.

Yes, s3fs and sshfs can both leave the system in an unstable state. For example, there can be a dead mount which is impossible to unmount, and in severe cases, blocks a clean reboot.

A file system in user space (or in network space) should NEVER break the system, no matter what happens in user space (or in network space). Most network file systems try to respect this (albeit with mixed success). FUSE does not.

I'm not claiming FUSE cannot be made to work. Just that it's very bad since (1) plenty of smart people clearly failed to do so (2) the badness it leaves behind should be more than it's permitted to.

I can point to specific issues, but at the end of the day, that's neither here nor there. At the end of the day, something like:

https://github.com/libfuse/libfuse/blob/master/example/poll....

Is about a hundred times more complicated than it should be. It should not require memsets, pthread mutexes, or flags, and should probably have an implementation in a modern, high-level language. To a large extent, that's the point of moving things out of the kernel.

I'm even perhaps okay with being permitted to do low-level operations for a particularly performance-constrained subsystem, but that's not 95% of the uses of something like FUSE.

Footnote: I actually enjoyed writing low-level code like this a lot, when computers were in the single-digit to triple-digit MHz range, and we didn't need to worry about people breaking in over a ubiquitous worldwide internet, but I left that mindset behind decades ago. Right now, I want code to be stable, simple, auditable, and secure.
Not my project but I have had great success with https://github.com/gtxaspec/wz_mini_hacks & V3 model.

The V3 models need to be downgraded to a specific firmware first and patching it exposes RSTP streams using https://github.com/AlexxIT/go2rtc. Everything doable without ever installing Wyze app on an environment air gapped environment with no internet.