6271
SQLite JSON at full index speed using generated columns
One of the coolest patterns in SQLite—store raw JSON documents, create virtual generated columns using json_extract, add indexes, and query JSON at full B-tree index speed.
New
The latest blog posts to take off on Hacker News. 80,819 posts.
6272
Guarding My Git Forge Against AI Scrapers
A summary of the techniques in place to protect my git forge
6273
The tiniest yet real telescope I've built
76/300 Pocket Dobson: a tiny yet real telescope that comes with you everywhere
6274
“Are you the one?” is free money
One of my wife's guilty pleasures is reality TV, usually ones centred around dating - the more American, the better. By extension, I absorb some of this noise and I'm happy to admit I can sometimes get invested.
6275
Freeing a Xiaomi humidifier from the cloud
Thoughts, stories and ideas about of a code poet, bit juggler & logic wizard.
6276
Google de-indexed Bear Blog and I don't know why
Preamble: The whole affair is Google’s fault and not Bear Blog’s. Huge thanks to Herman—Bear Blog’s founder and dev—for his patience and help. A month afte...
6277
CRISPR fungus: Protein-packed, sustainable, and tastes like meat
Researchers have successfully used CRISPR gene editing technology to create a fungi strain that is highly efficient, more nutritious, and significantly more sustainable than its natural counterpart. The fungus Fusarium venenatum already stands out for its meat-like flavor and texture, leading to its approval for food…
6278
Nokia N900 Necromancy
Building a fake battery, adding a USB-C port, booting from SD card, and giving a new life to a classic Linux smartphone.
6279
Denial of service and source code exposure in React Server Components
The library for web and native user interfaces
6280
UK House of Lords attempting to ban use of VPNs by anyone under 16
This is deranged, each nation’s boomers and reactionaries attempting to outdo the others: “Action to prohibit the provision of VPN services to children in the United Kingdom” … th…
6281
What is the nicest thing a stranger has ever done for you?
One of the things I do when I'm feeling blue is to make a mental list of the nice things people have done for me over the years, including perfect strangers.
6282
An SVG is all you need
SVGs are pretty cool - vector graphics in a simple XML format. They are supported on just about every device and platform, are crisp on every display, and can have embedded scripts in to make them interactive. They're way more capable than many people realise, and I think we can capitalise on some of that unrealised…
6283
Pop_OS 24.04 LTS with COSMIC desktop environment
An important message on Pop!_OS, Linux, and one downright fantastic community.
6284
We built a resource hub to fight back against age verification
Age verification laws are proliferating fast across the United States and around the world, creating a dangerous and confusing tangle of rules about what we’re all allowed to see and do online. That's why today, we're launching EFF.org/Age, a one-stop shop for users seeking to understand what these laws actually do…
6285
Going Through Snowden Documents, Part 1
We are building a comprehensive archive and analysis project examining published documents leaked by Edward Snowden. Our methodology involves systematically reviewing each available document with particular attention to small details and information that has received little or no public attention since the initial…
6286
Programmers and software developers lost the plot on naming their tools
In Dec 2022 I watched Richard Stallman's talk on the EmacsConf , it was titled "What I'd like to see in Emacs". One of the interesting points Mr. Stallman pointed out in this talk was "memorable names", "I think every …
6287
GPT-5.2
GPT-5.2 is our most advanced frontier model for everyday professional work, with state-of-the-art reasoning, long-context understanding, coding, and vision. Use it in ChatGPT and the OpenAI API to power faster, more reliable agentic workflows.
6288
Litestream VFS
Query your SQLite database any time, anywhere
6289
Things I want to say to my boss
A new anonymous essay published every day in December in the countdown to Christmas.
6290
From text to token: How tokenization pipelines work
Understanding how search engines transform text into tokens through character filtering, tokenization, stemming, and stopword removal.
6291
The architecture of “not bad”: Decoding the Chinese source code of the void
WTF moment: Why my native OS refuses to return a "True" value.
6292
The Walt Disney Company and OpenAI Partner on Sora
Disney and OpenAI have reached an agreement to bring more than 200 Disney, Marvel, Pixar and Star Wars characters to Sora for fan-inspired short videos. The agreement emphasizes responsible AI in entertainment and includes Disney’s company-wide use of ChatGPT Enterprise and the OpenAI API.
6293
Craft software that makes people feel something
Recently, people have been asking me why I’m pausing Boo to work on a programming language. I think it would actually be cool to write down how I feel.
6294
$5 whale listening hydrophone making workshop
Whale songs were first noticed by accident, when analysts tracking Russian submarines at the height of the cold war heard cetacean interference instead. An engineer sent some recordings to Roger Payne, a biologist friend of his, who did something that proved pivotal: he played the hours-long recordings on his hi-fi at…
6295
The Cost of a Closure in C
I had a vague idea that closures could have a variety of performance implications; I did not believe that so many of the chosen and potential designs for C and C++ extensions ones, however, were so…
6296
6297
Midjourney is alemwjsl
aadil pickle's internet home
6298
Nature's many attempts to evolve a Nostr
P2P and federated protocols converge toward becoming Nostr, but with extra steps
6299
When would you ever want bubblesort? (2023)
There are very few universal rules in software engineering, but there are are a lot of near-universal principles. Things like "prefer composition to...
6300
Developing a food-safe finish for my wooden spoons
You know what they say in the world of products: fast, cheap, good; pick two. That's exactly my experience when trying to find the most suitable wood finish for my hand carved wooden spoons and cups. I got tired of trying to find something food-safe, without chemical smells and that doesn't take ages to cure. So I…