MurphyA/hacker-news huggingface dataset:
by charettes | 2026-02-22 14:29:24+00:00
There are valid reasons for not using an ORM but the points made in this article are plain false.

>“Roughly” because Django ORM doesn’t support the JSONB `?` operator.

The `has_key` [lookup](https://docs.djangoproject.com/en/6.0/topics/db/queries/#has...) does exactly that.

> And if you need real SQL intervals, Django pushes you towards raw expressions or `Func()` wrappers.

It's possible to use a very similar construct to SQL Alchemy here by using the `Now` [function](https://docs.djangoproject.com/en/6.0/ref/models/database-fu...) (it uses `STATEMENT_TIMESTAMP` which is likely more correct than `NOW()` here alternatively there is `TransactionNow`) by doing `Now() - timedelta(days=30)`.

The result is the following `filter` call

filter(
metadata__tags__has_key="python",
created_at__gte=(
Now() - timedelta(days=30)
),
)

which translates to the following SQL

("app_video"."metadata" -> 'tags') ? 'python'
AND "app_video"."created_at" >= (
STATEMENT_TIMESTAMP() - '30 days'::interval
)

which can be confirmed in [this playground](https://dryorm.xterm.info/hn-47110310)
by dangus | 2026-02-22 14:29:43+00:00
Well, ads versus algorithmic content recommendations are two very different things.

If FB wants to have low standards for their advertisers, that’s on them. It’s not illegal or even inherently immoral to advertise porn, especially if FB already knows you’re over 18.

But, in general, the algorithmic content recommendations do follow what you want. Ads are different because advertisers pay for the users they want, not the other way around.

And more reminders for this discussion: Facebook isn’t a necessary utility, it has competitors, it is not a monopoly, you can delete your account without any downside to your life. This is very much unlike services like the Apple App Store or Google Play where it’s difficult to function in modern society without using them.

Of course, I’m not saying social media shouldn’t have more regulation and I’m not trying to defend them as a corporation. It’s just that at some point the best way to complain about products is to stop using them.
by PowerElectronix | 2026-02-22 14:30:00+00:00
China economic numbers don't have a winning tune to the in the least. I don't think taiwan could ever be taken by force, but that doesn't matter as Xi Jinping seems to think it's doable and is taking steps towards it (developing landing ships, purging the military of oppsition and pacifists, building a fleet and bombers...)

It would be very surprising to me that taiwan people think a reunification is feasable while the CCP still exists, just see how things are going in HK to see what would be waiting taiwan if they reunite.
by blfr | 2026-02-22 14:30:46+00:00
Sure, the modern Twitter/X feed is not like the original reverse chronological timeline but the latter is still available right next to it. Maybe it's the power of the default but I find the algorithmic feed much better.

The chronological timeline is only manageable up to a point. I follow just under 2000 accounts on Twitter. They at least occasionally at least in some period in the past must have been posting interesting stuff or I wouldn't have followed them. But not all of them all the time. Algorithmic feed surfaces the good stuff, or at least popular, but lately it picks some very niche stuff successfully. Same on TikTok.

The modern feed is a clever generalization of the previous age tech. And sometimes you just like the previous gen more but there is a reason the new version got traction.
by solarkraft | 2026-02-22 14:31:31+00:00
I do this too. Relatively small changes, atomic commits with extensive reasoning in the message (keeps important context around). This is a best practice anyway, but used to be excruciatingly much effort. Now it’s easy!

Except that I’m still struggling with the LLM understanding its audience/context of its utterances. Very often, after a correction, it will focus a lot on the correction itself making for weird-sounding/confusing statements in commit messages and comments.
by qudat | 2026-02-22 14:32:01+00:00
> LLM's are like unreliable interns with boundless energy

This isn’t directed specifically at you but the general community of SWEs: we need to stop anthropomorphizing a tool. Code agents are not human capable and scaling pattern matching will never hit that goal. That’s all hype and this is coming from someone who runs the range of daily CC usage. I’m using CC to its fullest capability while also being a good shepherd for my prod codebases.

Pretending code agents are human capable is fueling this koolaide drinking hype craze.
by JSR_FDED | 2026-02-22 14:32:25+00:00
The article makes a good point about AI not putting people out of work:

> I’ve been really impressed at the ability of an LLM to make a spreadsheet financial model in a few minutes rather than taking a few hours. But … that just means that you spend a few more hours tweaking the model. Because if you don’t, then your competition will; what this means is that you can no longer sell a spreadsheet model that doesn’t have a lot of industry knowledge built in.

Except that the valuable industry knowledge is going to come from experience…which is great for those with experience. But not great for fresh college grads.
by 1718627440 | 2026-02-22 14:33:06+00:00
You don't typically give the intern the task to review all company communication including the messages talking about firing the intern. People seem to have lost common sense about security.

The token prediction tries to simulate (textual) behaviour, which in this case includes blackmailing when threatened to be fired. In other words, SOMEONE has selected that it should exhibit that behaviour by selecting the training data. Sure that someone likely did it by accident, because reviewing such large data sets is just impossible, but maybe that is why such a thing is incredible risky and they should be held accountable for that decision.
by zzzeek | 2026-02-22 14:34:00+00:00
I think this is a great post to have but I'm going to make a critical usability suggestion:

* the videos should have "pause" and a "step at a time" control *

Even at the "half speed", without a deep knowledge of the context, the videos move way too fast for me to read the syntax that's invoking and line it up with the data on the left side. I (and im definitely not the only one) need to be able to sit on one step and stare at the whole thing without the latent anxiety of the state changing before I've had a chance to grok the whole thing.

this has nothing to do with familiarity with the concepts (read my profile). I literally need time to read all the words and connect them together mentally (ooh, just noticed this is pseudo-SQL syntax also, e.g. "select id=4", that probably added some load for me) without worrying they're going to change before watching things move.

please add a step-at-a-time button!
by funkyfiddler369 | 2026-02-22 14:35:04+00:00
it can but it will take one person just as long as a small team without "AI" and that one person will carry all the frustration, doubt, all the to do lists and imaginary pin boards and all that other stuff programmers carry around in their heads, at work and back home. have fun with all that.

side note: indie games are not complex software.

and most "overvalued" and "impossible" and "walking it back now" comments are true in as many cases as they are not true and I really do not understand these commenters. smart people should not fall into the same category as people who think that "nobody cares" because they never met devoted lawyers, investigative journalists and law enforcers passionate about justice AND law. it's all so weird, man ...
by xaskasdf | 2026-02-22 14:35:24+00:00
This was the experiment itself https://github.com/xaskasdf/ps2-llm

The idea was basically to run a llm on a ps2, then I ran into some problems as the 32mb ram cap with 4mb vram cap; so I had to figure out a way to stream layers on the forward pass. Given that ps2 manages to give instructions directly to the vram that's capable of 32bit addresses, it gave an insane amount of tok/s, then I wondered if I could do the same on my puter
by simonw | 2026-02-22 14:36:03+00:00
If you're on iOS or use Safari on a Mac you can install this app https://apps.apple.com/us/app/userscripts/id1463298887 (make sure to read the README on https://github.com/quoid/userscrips) and then install this user script: https://gist.github.com/simonw/652c7fc0e78a99cbe73bd3c4f97c7...
by whackernews | 2026-02-22 14:36:15+00:00
Yeh. I mean I ultimately completely agree with your last paragraph. Society seems to have shifted and no amount of lasers and drugs is able to make people move! Also to your point moving actually takes up a lot of space and, thus, less tickets. It’s really better for maximising profits if people don’t move and ideally advertise the event for you.
by scoot | 2026-02-22 14:36:20+00:00
Going even further off topic, one of the things I love with Apple is having all your subscriptions in one place, and being able to cancel them easily.

The few zombie subscriptions I've had have all existed outside of the App store, one that I didn't even sign up for (looking at you Masterclass). I bought a one year gift subscription for someone else, and because it came with a "free" subscription for me (that I didn't use), I git hit with annual renewals until I noticed it on my credit card statement and cancelled.

Yes, I should check those more frequently, but who has time for that?

It rankles that you can can cancel a free trial before it's over with every app exept Apple's. I like the feature, but the double standard grates.
by mystraline | 2026-02-22 14:37:02+00:00
Notice the go-to for capitalists against communism is "Look at how many people they killed!!!"

No such metric is available for capitalist countries. Thats because its *always* an individual failure in capitalism, not political/societal.

You CHOSE not to have healthcare. (You work 1099, or work a job that doesnt provide healthcare, due to tying job and health.)

You CHOSE to go with UnitedHealthCare that denies 30% for baseless reasons. (The company chose your plan, you have no real choice here.)

You CHOSE to be homeless. (You can't force companies to interview or hire you.)

You CHOSE to eat the only food nearby (You live in a food desert).

Just from Hepatitis C, the company that makes Solvaldi makes a cure. Costs $84k, $1000 a pill for 84 days.

But we see more and more deaths from Hep C. But this is a "personal failure", not a systemic one in a capitalist country.
by skydhash | 2026-02-22 14:37:23+00:00
Yeah! For typing, you could use cat and be done with it. But you think about editing, then ed(1) start to make sense. You think about it a little more and ex(1) makes sense. You want better visual feedback and vi(1) is born. And then you want more programming features and you’ll get vim.

Emacs is what you get when you sidestep the whole process with something as versatile as lisp. Instead of being economical with commands, you just create the specific actions you want
by davedx | 2026-02-22 14:37:33+00:00
I spent a few days running openclaw on a VPS, and it was painful and frustrating:

- no graphics subsystem makes things harder

- VPS IP subnets are often blocked by default by numerous websites and WAFs

- can't easily see what it's doing

Running it on its own PC is definitely the golden path for the way it's architected.
by Ylpertnodi | 2026-02-22 14:37:43+00:00
Learn your own languages' grammar.

Then learn (in all tenses) the below verbs that are (usually) followed by infinitives

Can / am able
Must/ to have to
To want to

Then, 'to be' and 'to have' (to go with the above).

Vocabulary...including a boatload of infinitives.
by interlocutor | 2026-02-22 14:37:50+00:00
A lot of database tools these days prioritize instant sharing of updates over transactions and ACID properties. Example: Airtable. As soon as you update a field the update shows up on your coworkers screen who also has the same table open. The downside of this is that Airtable doesn't do transactions. And the downside of not doing transactions is potentially dangerous data inconsistencies. More about that here: https://visualdb.com/blog/concurrencycontrol/
by jacquesm | 2026-02-22 14:37:56+00:00
I don't agree with that. FreeBSD has more of an engineering than a hacking mentality and it shows in the various architectural choices.

And containers really are a VM-light, so you might as well use the real thing, in fact, VMWare for a long time thought that their images would be a container like thing and many larger installations used them as such.
by stego-tech | 2026-02-22 14:39:12+00:00
Nah, the dipshits are the ones who take the polygrapher at their word that they can be trusted/"this is a safe space" and blab about the crimes they've committed.

Almost anyone who spent enough time at an alphabet agency has stories about polygraph candidates who spill the beans on crimes during their initial polygraph, thinking that somehow gives them "cred" or immunity.

They are the dipshits.
by davedx | 2026-02-22 14:40:01+00:00
> but found it way too wasteful on tokens/expensive

I fear this is intrinsic to its architecture. Even if you use smaller models for regular operational tasks (checking heartbeat), you'll inevitably need to promote back to bigger models to do anything useful, and the whole idea of openclaw is that it can do many useful things for you, autonomously. I think that means it's going to burn a lot of tokens if you're using it as intended.

This is presumably also why the default model mode is to try and oauth its way into coding agent harnesses instead of using lab API's?
by OneMorePerson | 2026-02-22 14:40:13+00:00
I've seen this in Asia, there's an employee who basically is standing at a raised spot in the corner and if you take out your phone they shoot a small laser pointer right into the camera, it messes with the video. They can't get it on there all the time but a video where half of it (or more they are surprisingly accurate) is a strobing laser becomes pretty garbage anyways. While they are doing that another employee/bouncer comes over and warns them, have seen people get kicked out for pulling it out a second time.
by sigwinch | 2026-02-22 14:40:35+00:00
Reminds me of Julius Caesar describing the druids. Part of his political career meant precisely performing important orthopraxy. He probably didn’t meet a druid, but amazingly described them playing the same role he did as Pontifex Maximus.

The orthopraxy requiring those precision rituals, take Rome and Greece, had little or maybe no mandatory beliefs. City-state-sized gods in Mesopotamia probably functioned the same way. Traditions still have precise orthopraxy today. But we talk about differences in belief whereas Caesar doesn’t even acknowledge any.
by kurouna | 2026-02-22 14:40:55+00:00
Thank you for the thoughtful comment and advice! The lightweight binary you mentioned is likely emacsclient, which is indeed a good way to use a running Emacs process as a quick editor.

You are right that if elecxzy were just for editing a single file, it might not offer much over a standard Notepad. However, the real value I wanted to achieve is the ability to view, edit, and integrate multiple sources using muscle memory, without touching the mouse.

While it runs as a simple standalone window, it supports Emacs window splitting commands like C-x 2, C-x 3, and C-x 1.

Here is a quick video I posted a while ago (the text is in Japanese, but you can see the window splitting in action):
https://x.com/elecxzy/status/2020370174818631769

As for contributing to the upstream Emacs to fix CJK issues, I agree that it would be a more impactful approach for the community. But I really appreciate your advice about doing software for myself. I will continue to work on this project for my own use and enjoyment. Thank you for the great advice!
by K0balt | 2026-02-22 14:41:42+00:00
I can’t see anything specific in the link, and you probably already solved this… but just fyi, if it’s the same unit I used, and you are using arduino libraries, the library that worked was called one-bit display IIRC, and it basically acted as 1/4 of a ssd1306 64x128 oled, so you had to use x/y pixel offsets.
by xaskasdf | 2026-02-22 14:42:16+00:00
I did it, but with different quantization compressions, It ran into quality issues, I will try to rerun with the same quants if that fixes the issue, but the most that looks unused, its being used by rotating layers that are being swapped by the cpu from the ram itself, that manages to keep layers warm, ready to use while inferencing and discarding already used ones
by GuB-42 | 2026-02-22 14:43:24+00:00
That's one theory. Another one I can think of is that sharp edges are scary, and most distress calls are high pitched.

Also, the thing about high frequencies and sharp edges lead to a contradiction: babies are more round than adults and produce higher pitched sounds, this is almost universal across all species.

There are other tentative explanations, such as how the vocal tract acts when producing these sounds, with "bouba" sounds being the result of smoother movement more reminiscent of a round shape.

"kiki" is not just higher pitched, it is also "shaped" differently if you look at the sound envelope, with, as expected, sharper transitions.

So to me, the mystery is still there. Is is the kind of thing that sounds obvious, in the same way that kiki sounds obviously sharper than bouba, but is not.
by dangus | 2026-02-22 14:43:53+00:00
That was in the era of $10 shows.

If I am paying $700 to see Lady Gaga you bet your ass I’m taking some pictures.

I actually find k-pop shows somewhat refreshing because there’s zero negative stigma for wanting to record pictures or video. I can easily tell that Gen Z/Alpha has no problem enjoying themselves and even dancing while recording a video.

If a phone is blocking your view the venue is designed wrong (I don’t go to venues with flat floors anymore. Often they weren’t even designed for concerts in the first place).
by heliumtera | 2026-02-22 14:44:12+00:00
>"What is OpenClaw"?

It is an antiemetic device, apparently.

All I hear is "allows you to do x, enables you to y".

It seems that every software pattern or system cannot be described anymore, they became production grade software built from scratch, blazingly fast, secure and sandboxed that allow you to x and enables to y".

And sometimes can be mistaken for general intelligence by ai influencers and other animals
by bjackman | 2026-02-22 14:44:33+00:00
Er... Source for this claim?

If there are people filming on their dancefloor you're in a shitty club.

OK, so the author and a handful of people they quite (including some global superstars who obviously don't represent any kind of norm) seem to be finding themselves in shitty clubs more often than they used to. And therefore we conclude all clubs are shitty now?

Nightlife is the least heterogeneous and least globalised form of public life that exists in "the west". If someone thinks they can make sweeping statements about the state of raving writ large, I don't really take them seriously.
by adrian_b | 2026-02-22 14:44:49+00:00
In the early years after 2000, FreeBSD 4 had a much better performance and reliability in any networking or storage applications in comparison with the contemporaneous Linux and Windows XP/Windows 2000.

However, in 2003 Intel introduced CPUs with SMT and in 2005 AMD introduced multi-core CPUs.

These multi-threaded and/or multi-core CPUs quickly replaced the single-threaded CPUs, especially in servers, where the FreeBSD stronghold was.

FreeBSD 4 could not handle multiple threads. In the following years Linux and Windows have been developed immediately to take advantage of multiple threads and cores, while FreeBSD has required many years for this, a time during it has become much less used than before, because new users were choosing Linux and some of the old users were also switching to Linux for their new computers that were not supported by FreeBSD.

Eventually FreeBSD has become decent again from the PoV of performance, but it has never been again in a top position and it lacks native device drivers for many of the hardware devices that are supported by Linux, due to much fewer developers able to do the necessary reverse engineering work or the porting work for the case when some company provides Linux device drivers for their hardware.

For the last 3 decades, I have been using continuously both FreeBSD and Linux. I use Linux on my desktop PCs and laptops, and in some computational servers where I need software support not available for FreeBSD, e.g. NVIDIA CUDA (NVIDIA provides FreeBSD device drivers for graphic applications, but not CUDA). I continue to use FreeBSD for many servers that implement various kinds of networking or storage functions, due to exceptional reliability and simplicity of management.
by MariosAdamidis | 2026-02-22 14:44:51+00:00
In the past year i have been learning and experimenting, and have assembled a stack which now seems to me like a solid foundation for lab applications such as data processing.
As a PhD student in the Greek reality, my budget was tight especially initially so i have made my basis mostly on the free vertex gemini trial. I have customized an existing gemini pipeline (thank you owndev) to better handle multi-round native tool calling and have it set for example at 20 rounds, and the results are very reliable with the tools i have setup and its free.

I have assembled tools like free web search with langsearch instead of searxng to avoid rate limits, as well as a very thorough literature search and download tool. As well as some prototypes with examples for my scientific tools which can help with SEM, XRD, PL and handle messy data in originlab. Me and (mostly) opus have made some mcp tools for opj files (i hate these) covering batch fitting, peak decomposition, waterfall plots and plot export directly into chat which is really flashy especially for the boomer scientists.
I try to run most stuff locally, for example docling, embed rerank vlm, my file server, jupyter with gpu accel (on rocm not nvidia which is what you mostly come across), metamcp with all of my tools etc.
The stack is split in three profiles, 1. Lab, 2. Coder and 3. Instruments and each one has its own skill files and system prompts so that we get better efficiency and performance. And for my lab to access it i have cloudflare so that its secure somewhat (i hope).
I will try to better document my path torwards doing something token efficient. I already found good success with separating my tools in packets with subtools and individual skill.md files.
I really want to thank the owui community for the great lessons and tools/functions. I will try to port all of my tools in the owui community for download.
This post is intended to start a conversation with other people interested in implementing tools in scientific workloads.
You can take a look at the link (sorry if the github looks messy, im in the process of doing it still)
by ericmay | 2026-02-22 14:45:44+00:00
“Who is left on Facebook besides dopamine junkies and bots?”

“I only use it in this limited circumstance”

You are on Facebook. That’s who. It’s like saying you’re not a drinker because you have a glass of wine every once in a while. Sure you’re not an addict (probably) but you still drink.