MurphyA/hacker-news huggingface dataset:
by Diggsey | 2025-05-04 13:40:29+00:00
Based on my understanding, your comment is the most accurate in this thread.

However, I think it's telling that almost every single comment here has a different understanding of how PostgreSQL works, and nobody can link to any documentation that conclusively addresses this case. I think that indicates that this is a failing if not of implementation, then of documentation.

For example: another comment says that `=` forces PostgreSQL to evaluate the subquery exactly once. I couldn't find any justification for that statement. Is it guaranteed? I don't know.

Another comment says "if only the subquery was ordered then the result would be consistent", but AFAIK, this is not true in the presence of "SKIP LOCKED".

I think the problem stems from the fact that the SQL standard is written from an academic point of view: the ordering of execution of subqueries is not defined because it is irrelevant within the relational algebra, so optimizations which change the execution order are just that: optimizations, with no observable side effects.

Real database systems do not actually have the nice algebraic properties of the relational algebra... The same subquery may give different results over multiple executions, etc. Given this, it's important that the database system give sufficient and sufficiently clear guarantees such that they can still be used correctly, and so that the optimizations implemented by the system can be justified.
by djohnston | 2025-05-04 13:41:28+00:00
Google APIs have always been difficult for me to use. I find their documentation super fragmented, and they always build the same thing twice with awkward overlaps. In this case, it's Vertex and GenAI - two different SDKs with isomorphic data structures that are seemingly incompatible, but only sometimes. I don't understand how these things happen - but as usual I blame PMs trying to mark their territory and pissing all over everything.

The new gemini models themselves though, are killer. The confusion is a small price to pay.
by hnlmorg | 2025-05-04 13:42:28+00:00
There’s also a lot of good design that’s gone into Elvish. And I don’t think it’s fair to call it “dead” when the maintainers for Elvish are active both on Github and here on HN too (probably other places too).

However if you’re looking for an alternative then there’s:

- Murex (disclaimer: I’m one of the maintainers) which does support background processes and has extensive documentation. https://murex.rocks

- Nushell: I’m not personally a fan of its design choices but it has a large following of people who do really enjoy it so it might also appeal to yourself too.

As for Elvish, I do encourage others to give it a go themselves. It’s really well thought out and what might be a deal breaker for some people isn’t for others.
Show HN: Open-sourece personal Spotify listening explorer, supports 10 languages
by wongynnn | 2025-05-04 13:42:55+00:00
Hi HN, I’m excited to share a project I’ve been working on: Auralytics, a open source application for Spotify users!

I love music and always felt Spotify Wrapped once a year wasn’t enough to me. I wanted a way to explore my listening habits anytime, with a smooth and enjoyable user experience. That's why I started to develop Auralytics.

The main features are: view your most played Tracks, Albums, Artists, Genres, Eras across recent 1 / 6 / 12 months.

It supports 10 languages, so users around the world can explore their music habits in their native tongue.

Would love to hear what you think, and if you try it out, please let me know any feedback!
by crazygringo | 2025-05-04 13:42:56+00:00
> you should _never_ schedule a move on the day you have to be out

If you're switching apartments in a city, you usually don't have much of a choice.

Your lease ends at the end of the month, and your new lease starts the next day, and you negotiate a day of overlap. And you sure as heck don't want to be paying rent on two places for a month.
by _heimdall | 2025-05-04 13:44:32+00:00
You're raising that humans eating food is lossy but then attempt to use the opposite to argue against me when it comes to efficiency in using energy from oil. That's pretty confusing and I'm not sure how it helps, I also am not sure why you are comparing burning food - we eat for much more than just the energy alone and the calorie (a measure of burning food) is a ridiculously stupid metric that assumes we run roughly like a steam engine.
by harimau777 | 2025-05-04 13:45:31+00:00
Perhaps it would be more useful to consider "least bad" over a reasonable period of time. That is to say, there are probably times when, due to the factors you mention, the people steer democracy to do something bad that a strong dictator or group of elders would not have done. However, over a given period of time, it's likely that a democracy does less bad things then the alternatives.
by neonsunset | 2025-05-04 13:45:50+00:00
Sounds improbable. Unlike Ruby, JavaScript has multiple runtime implementations with capable JIT compilers that sometimes let it even compete with Java on numeric code. Ruby is very, very far away. Please note that Elixir is also in the same single-threaded performance ballpark as Ruby and Python, of course it does not suffer from any of the single-threaded bottlenecks the other two do though.
by slashdev | 2025-05-04 13:45:53+00:00
You must be referring to the 1948 Arab-Israeli War? That was not started by Israel! You would do well to read up a bit on the history of the region, because "Israel literally started the war by invading Palestine" just doesn't make any sense in a historical context, that never happened.

https://en.wikipedia.org/wiki/1948_Arab%E2%80%93Israeli_War
by account-5 | 2025-05-04 13:46:13+00:00
Ever since I 'discovered' Nushell I've noticed a lot of new shells appearing on HN.

The thing I like about Nushell is it does away with some of the things that I found hard with bash, and made data formats a first class citizen (something I enjoyed about powershell).

I think if you like Lisp elvish would be ideal but for me the lack (seeming, I've not done a deep dive on the docs) of built-in data parsing is a no.
by anovikov | 2025-05-04 13:48:19+00:00
I don't live alone, and in general i'm not against the idea of someone doing it for a fee, but $14k!!! It's a fucking annual minimum wage.

Also, as for driving a truck, sure it sucks driving a truck for days, but shipping a 20-foot container over a very long distance does not cost nearly as much. It's in the $1000-$2000 range. A 20-foot container should fit someone's all possessions. Someone charging $12K for packing and unpacking definitely rips people off, big time.
by linsomniac | 2025-05-04 13:49:27+00:00
>technologies that make speed bumps “disappear”

My 2004 Land Cruiser has such technology. It's called "being a Land Cruiser". As a sports car fan, I'm quite familiar with how hard it is to make speed bumps that work for every vehicle. You're not wrong, but also it's a pretty crude technology, speed bumps.
by thechao | 2025-05-04 13:49:53+00:00
I have a fence that gets absolutely blasted with High Grade Texas Sunlight. It shortens the fence’s effective life by years — this idea is brilliant. Now I just gotta price out 80 sq m of solar panels.

EDIT: The fence gets at least 4 hours of direct sun in the winter; up to 7 in the summer. I can easily install 10KW of panels. I don’t have any way to store the power. I suppose I could build a giant Tesla coil and zap the neighbor’s dog?
by Belsonsan | 2025-05-04 13:51:21+00:00
ey, really appreciate you checking it out — cool to hear you went through all 50!

Yeah, the counter is based on correct answers, so if you get a few wrong, it loops to make sure you hit 50 right. I agree it’s a bit confusing, definitely something I need to fix.

And fair point on the ad — I was testing it quickly, but yeah, it breaks the flow. I’ll tone it down or rethink how to do that better.

Thanks again for the feedback — super helpful!
by sigmoid10 | 2025-05-04 13:51:48+00:00
The article literally says that all tests for infection came back negative. It is not said explicitly, but this heavily implies that she had negative cultures (not uncommon for leptospirosis) and did not present with things like elevated white counts (also not uncommon for this pathogen - especially for superficial infections). The article also clearly says they (mis-)diagnosed it as autoimmune disease and treated with steroids, which is pretty much the worst thing you can do in that case. Leptospirosis goes away most of the time without any treatment if you have a working immune system. So if you really need a contrarian takeaway from this editorial, it's that doctors are still sometimes more dangerous than diseases (which used to be true in general up until about 100 or so years ago).
by brookst | 2025-05-04 13:53:27+00:00
All of the BT+wifi chips I’ve worked with require active initialization of each feature; you have to signal the chip (over i2c or SPI or whatever) with what kind of BT operations you want.

No BT stack in your product, no BT radio initialization, no BT/wifi multiplexing. At least in the (admittedly limited) chips I’ve worked with.
by Fnoord | 2025-05-04 13:56:02+00:00
No, they don't; they let you decide some things which are relevant. People in the know decide defaults. This is how it works everywhere. Else you'd learn to bicycle with your own traffic rules. You'd end under a bus.

Addendum: You could say you want a sandbox, and that such is part of the sandbox to play with. Then you need some kind of way to clean up, like you can clean up the toys your kids play with (or ensure they clean up their own mess), or ensure their sandbox environment is safe (such as no fire hazards in your house). Then I would argue a VM is such. OS with rollbacks or a user account on an OS or locked down iOS/Android could suffice, too.
by klabb3 | 2025-05-04 13:56:29+00:00
It’s good to see a new fresh push for protocols and interop. However, I don’t think it will do the thing we hope for, for non-technical reasons.

During Web 2.0, we saw similar enthusiasm. Instead of AI agents or blockchain, every modern company had an API exposed. For instance, Gmail- and Facebook chat was usable with 3p client apps.

What killed this was not tech, but business. The product wasn’t say social media, it was ad delivery. And using APIs was considered a bypass of funnels that they want to control. Today, if you go to a consumer service website, you will generally be met with a login/app wall. Even companies that charge money directly (say 23&me ad an egregious example) are also data hoarders. Apple is probably a better example. There’s no escape.

The point is, protocols is the easy part. If the economics and incentives are the same as yesterday, we will see similar outcomes. Today, the consumer web is adversarial between provider ”platforms”, ad delivery, content creators, and the products themselves (ie the people who use them).
by aoki | 2025-05-04 13:56:47+00:00
Vygotsky’s Ph.D. was in psychology, from a psychology institute, and he worked professionally as a PI in experimental developmental psychology. Indeed, one of the themes of his work was to try to find a scientific basis for the study of cognition. But nobody is interested enough in studies of Russian children from the 1920s to track down the tech reports. People today read his essays summarizing his theories (like the ones in Mind and Society) so they can understand the connection to later work. The theories were also influenced by philosophy because his undergraduate training was in the humanities, but that doesn’t make his work “just, like, words”.
by lwo32k | 2025-05-04 13:57:14+00:00
I have a "wealth manager" in the family who handles the wealth of these people. And he describes it as taking care of "hyper-domesticated livestock". They are over engineered for max yield to the point, they can't "perform" outside their curated worlds (basically locked in for life) and their existence is super managed, insulated from risk, with a support system that is ever growing in its complexity. He talks about it in terms of Entropy. Such order is only possible at the cost of a lot of other things. And due to rate of change highly unsustainable.
by swid | 2025-05-04 13:59:07+00:00
The comment about = is mine and I thought about rewriting that part of the comment after the fact. It is soooo hard to explain these things without writing a book.

The reason = mean it runs once is because the outer query will only run once, and in this case that query, when using =, can only delete based on a single id. But if that outer query was subquery in a context where it could be run more than once, you are back to where you started. Hence me saying their fix was sort of incidental.
by tim333 | 2025-05-04 13:59:47+00:00
He's always been an independent thinker. He stopped the low price to book value thing ages ago and went more for companies with good long term growth such as Apple. And recently he's switched a lot to cash/t-bills. We'll see if that proved a wise move but he's got a good track record of doing smart things rather than always doing the same thing.
by vvillena | 2025-05-04 13:59:56+00:00
Congratulations on the project! This is an impressive feat at any age. Personally, I love how you found your own balance between extreme minimalism and a useful set of features, arriving at a solution that is indeed below 2k lines of C code. That kind of thinking is not a quality every software developer has, and you could make a career out of it if you decide to work professionally in this field.
by cgio | 2025-05-04 14:00:13+00:00
Lived context is to me more than online learning. I admit I am not so versed in the space as to be able to anticipate the nature of context in the case of online learning, so, yes, indeed I may change my tune if it somehow makes learning more of an experience rather than an education. My understanding is it won’t. I have not proven, but argued that experience compatibility is zero, to the extent a Lim does not experience anything. Happy to accept alternative viewpoints and accordingly that someone may perceive something as a sign of empathy whether it is or not.
by ednite | 2025-05-04 14:00:13+00:00
Honestly, if there is a golf ball–sized black hole out there chilling in the outer solar system, I'm all in.

Let’s fire up a replica of TARS, load up ChatGPT inside (TARS-GPT, patent pending), and yeet it straight toward the Schwarzschild golf ball. It’ll narrate live.

Imagine the livestream:

“Approaching event horizon. Spaghettification at 3%. Mood: stretchy.”

“Entering gravitational lensing zone… wow, even my tokens are redshifting.”

Bonus: With the right timing and Oberth maneuver, TARS-GPT might sling itself into Alpha Centauri before we finish arguing whether Pluto’s a planet again.

Worst case: we lose a robot. Best case: we unlock quantum gravity and get a podcast from inside a black hole.

I'd call that a win.
by xvello | 2025-05-04 14:01:14+00:00
This is the fallacy that LLM-boosters are spreading: "AI can never fail, it can only be failed". But when the fail ratio is so high, it cannot be only an execution problem. It is proof that the LLM technology is over-hyped way over the small niche where it's cost/benefit ratio can be positive.

https://edition.cnn.com/2025/03/27/tech/apple-ai-artificial-...
by chongli | 2025-05-04 14:01:35+00:00
16MB is larger than every single SNES game ever released.

Modern programs have dynamic memory allocation. You can't just start writing to any address you want. You have to request memory from the operating system with malloc() and then free() it when you're done. Memory-managed programming languages handle this for you but it's still there under the covers.

On the SNES, you simply have all memory available from the beginning. No malloc/free, just start reading and writing.
by ndriscoll | 2025-05-04 14:02:31+00:00
> along an upload progress indicator

I could be misremembering, but didn't browsers used to have this built in? Like there used to be a status bar that showed things like network activity (before we moved to a world where there is always network activity from all of the spying), upload progress, etc.

I don't remember if it was in Firefox, but SeaMonkey even has a "pull the plug" button to quickly go offline/online in the status bar.

Bizarre that "progress" is removing basic functionality and then paying legions of developers to re-add it in inconsistent ways everywhere.
by deckar01 | 2025-05-04 14:03:03+00:00
You have to serve their registered agent in a way that satisfies a judge. I tried to sue a company whose registered agent was a high profile attorney. I paid multiple people to serve him, but every time it got back to the judge his office had somehow tricked the service officer into accepting the summons in a way the judge deemed invalid. I had to give up because service fees were approaching a significant chunk of the claim and you can’t recoup that in OK…
by meristohm | 2025-05-04 14:04:36+00:00
To what end, all that work? If ultimately to enrich Capitalists, that's not a train I want to ride or indoctrinate anyone else to ride (I'm a teacher). How much time does it take to meet our needs in a community living on healthy land, with access to clean air and water? That might well fill our days, but I'd consider bonding with others to be a basic need, something many college students do.

Also, this focus on STEM is harmful. Even STEAM isn't enough. History, Philosophy, Languages, learning about arts and cultures- these are as, if not more, important than learning how to convert minerals into tools, because they get at the Why.
by jimbosis | 2025-05-04 14:05:47+00:00
I don't know if it will work for booting Windows, but have you tried installing Haiku's BootManager to the MBR?

https://www.haiku-os.org/docs/userguide/en/applications/boot...

On the booting Windows front, this thread has a few people describing how they successfully used BootManager to dual and triple boot Haiku, Windows 7, and/or Linux:

https://discuss.haiku-os.org/t/dual-booting-haiku-and-window...

I have a laptop (Lenovo ThinkPad T410s) with Haiku, Linux Mint, and Devuan GNU/Linux. I use BootManager in the MBR, and it gives me a menu of all three to choose from. For the two Linux options, I have GRUB installed on each of their own partitions, so BootManager just sends me to the GRUB installed on whichever Linux partition. (Of course, this isn't exactly "replacing" GRUB altogether.)

I do it this way because I find dealing with BootManager to send me to individual GRUBs to boot a particular Linux partition much, much easier than fiddling with GRUB to boot Haiku.

(One last thought, parenthetical as I'm not sure it can even work from a USB drive: Worst case, you might make a USB "boot stick" that uses BootManager to choose between Haiku and Linux and let Windows do its jolly thing on the MBR?)
by superkuh | 2025-05-04 14:06:08+00:00
I still use server side includes. It is absolutely the best ratio of templating power to attack surface. SSI basically hasn't changed in the last 20 years and is solid in apache, nginx, etc. You can avoid all the static site generator stuff and just write pure .html files.

It should not have gone away. It never did for me.

Also, this is kind of what 'frames' were and how they were used. Everything old is new again.
by ativzzz | 2025-05-04 14:06:58+00:00
MDMA is so fun. It's something I would love to do once a year or so for the rest of my life. Unfortunately it seems that people can't really grow up and do drugs responsibly. People either hard pivot away from drugs early on because they were abusing them, or they go down a path where drugs define them. The only way to keep getting good drugs that I know of is to keep in touch with friends on the latter path, but I don't really want to associate much with them.

Same with weed, it seems most people I know either quit smoking completely, or do nothing but smoke weed. I'm in my mid 30s.

Where the responsible casual adult drug users at???
by api | 2025-05-04 14:08:15+00:00
They're not dangerous unless you get too close. A black hole is not a cosmic vacuum cleaner.

If the Moon were suddenly transformed into a tiny black hole with the same mass, it would continue to orbit the Earth at the same distance. Ocean tides due to its gravity would continue normally. There would not be much effect except that it would no longer be visible with the naked eye and would no longer reflect the sun's light back to Earth. If you found it in a telescope, you might see gravitational lensing as it passed in front of the star field. Objects like probes or old spacecraft stages orbiting the Moon would continue to do so.

The only danger would be that if things fell into it I suppose you might get dangerous X-ray and gamma ray emissions from its accretion disc that would be a problem at such a close range. That would not be an issue with a primordial black hole much further away.

If there were such an object we could send probes to orbit it and study it, and some experiments may involve firing objects or shooting lasers or beams of particles into it to attempt to learn about the quantum effects at the event horizon. This could be massive for physics, allowing us to access and observe conditions and energies not replicable here on Earth with any current technology.

BTW we don't have any hard evidence that primordial black holes exist, but many theories predict them. So far such predictions around black holes have a pretty good track record. If you made me bet, I would bet on them existing. They are a candidate for some or perhaps even all of dark matter, though even if that's not the case they might still exist. It's possible that the dark matter haloes we can spot with gravitational lensing are clouds of these things. ("Clouds" of course is a misnomer-- the distance between them would be many light years.)

If planet nine is a PBH it means that at some point one was captured by our solar system into a Kuiper Belt orbit. Even if planet nine isn't one, there still may be small asteroid mass PBHs in our solar system, so we still might find one. They would require extremely sensitive X-ray or gamma ray telescopes or highly accurate gravitational models of the solar system to detect.
by rafram | 2025-05-04 14:08:29+00:00
They were already “replaced” by the internet decades ago, but people keep calling. As the article explains, there are still people in the US without access to the internet or knowledge of how to use it, as well as a lot of people who just want to talk to a human being.

You can call 1-800-CHATGPT if you want, but there’s clearly still a place for this service.
by patrickmay | 2025-05-04 14:08:29+00:00
It also explicitly requires the parties and candidates to think beyond the current election cycle. That behavior is not in evidence for at least one major party in the U.S.

A candidate's personal expectation of costs must also be factored in. When a candidate faces criminal charges (to pick an example totally out of the blue) if they lose but can eliminate those if they win, the calculus changes for them.
by cgio | 2025-05-04 14:09:36+00:00
Yes, I am not in fact expanding on GPs argument but etymologically attack the premise. Pathos is not learnt. When I clutch my legs at the sight of someone getting kicked in the balls, that’s empathy. When, as now, I write about it, it’s not, even in my case where I have lived experience of it. More sophisticated kinds of empathy build on the foundations of these gut-driven ones. Thank you for reading recommendation, will look for it.