SQLite JSON at Full Index Speed Using Generated Columns

https://media4.giphy.com/media/v1.Y2lkPTc5MGI3NjExdWhzOXd6cjViMHcwaXpiYnAzYjU0aWlpNjQ0bWtzYTl3MXQ2azVyOSZlcD12MV9pbnRlcm5hbF9naWZfYnlfaWQmY3Q9Zw/huh7lUqEG4irK/giphy.gif
SQLite has JSON functions and operators, allowing flexible schemaless data with relational database performance. Virtual generated columns compute values on demand, enabling instant indexing and blazing fast queries.

Async DNS

The user is trying to handle async DNS requests using various methods in C. They need a method without background threads, signals, or secret mechanisms.

4 billion if statements (2023)

Here's a summary of the user's input in 2 concise English sentences.

CM0 – a new Raspberry Pi you can't buy

https://www.jeffgeerling.com/sites/default/files/images/raspberry-pi-cm0.jpeg
The Raspberry Pi CM0 is a small Linux computer with WiFi, eMMC storage, and castellated edges for easy integration. It's only available in China, possibly due to supply chain issues with the LPDDR2 RAM chip used in the RP3A0 SoC.

String Theory Inspires a Brilliant, Baffling New Math Proof

https://www.quantamagazine.org/wp-content/uploads/2025/12/QuantumPolynomials-crKristinaArmitage-Lede-scaled.webp
Mathematicians have made a major breakthrough in classifying polynomial equations, using techniques from string theory to prove that four-folds are not parameterizable. The proof, posted in August, has sparked excitement and skepticism among the mathematical community, with many experts struggling to understand the new techniques.

Benn Jordan's flock camera jammer will send you to jail in Florida now [video]

Google Releases Its New Google Sans Flex Font as Open Source

https://i0.wp.com/www.omgubuntu.co.uk/wp-content/uploads/2025/11/unnamed.png?resize=750%2C422&ssl=1
Google has released Google Sans Flex an open source variable font under the SIL Open Font License. It provides more expressive design options but has a drawback on Linux where it can't support fancy features like Dark Mode.

Epic celebrates "the end of the Apple Tax" after court win in iOS payments case

https://cdn.arstechnica.net/wp-content/uploads/2025/12/GettyImages-2171810471-640x426.jpg
The Ninth Circuit Court of Appeals upheld a ruling that Apple's 27% fee for iOS developers using outside payment options was in violation of a 2021 injunction. Apple may still charge a "reasonable fee" for outside payments, but the exact amount is to be determined.

Fedora: Open-source repository for long-term digital preservation

https://fedorarepository.org/wp-content/uploads/2024/02/Network.png
Fedora is a sustainable open-source repository system for digital libraries and archives, designed for institutions to preserve and provide access to digital content. It's a community-driven project with a 20+ year history, offering a transparent persistence layer and various community resources.

Bit flips: How cosmic rays grounded a fleet of aircraft

https://ichef.bbci.co.uk/images/ic/480xn/p0mkv5f0.jpg.webp
A JetBlue flight from Cancun to New Jersey dropped altitude due to a computer malfunction caused by cosmic radiation. The incident led to a mass grounding of over 6,000 aircraft for software updates to protect against space radiation.

Home Depot GitHub token exposed for a year, granted access to internal systems

https://techcrunch.com/wp-content/uploads/2025/12/home-depot-2200450751.jpg?w=1024
Home Depot employee's exposed GitHub token granted access to private source code and cloud infrastructure. Home Depot did not respond to security researcher's emails, but the token's access was revoked after TechCrunch outreach.

Open Sourcing the Remix Store

https://remix.run/blog-images/headers/remix-store.jpg
Today we are open sourcing the Remix Store. By making the store's source code public, we hope to benefit developers building with React Router as well as developers building Shopify stores. The Remix Team is an open source team. We work on open source software like React Router and Remix. Sometimes we open source our websites too. We launched the store back in May, with the intention of ...

Id Software devs form "wall-to-wall" union

https://assetsio.gnwcdn.com/id-software-wall-to-wall-union-165-workers-vote-01.jpg?width=690&quality=85&format=jpg&dpr=3&auto=webp
Id Software studio workers unionize with 165 employees voting to join the CWA. They will now negotiate with Microsoft to address concerns over work rules, pay and representation.

From text to token: How tokenization pipelines work

https://www.paradedb.com/_next/image?url=%2F_next%2Fstatic%2Fmedia%2Fjames_headshot.a20a5a20.jpeg&w=640&q=75&dpl=dpl_5LrsoBohS4WHgnkaC8PhsYQwNwDJ
Search engines break down text into tokens, which are the units used for searching, by filtering out unwanted characters, splitting text into words, and removing common words like "the" and "and". Tokenization is a crucial step in search engines, as it enables matching of different word forms, such as "jumped" and "jumps", and is essential for accurate search results.

BpfJailer: eBPF Mandatory Access Control [pdf]

- TCP bind() - TCP connect() - UDP sendmsg() - UDP recvmsg() - Unix domain bind() - Unix domain connect() - Unix domain sendmsg() - Vsock bind() - Vsock connect() - accept() - DNS - DBus - TCP and UDP Proxy - CA injection and local TLS

Google de-indexed Bear Blog and I don't know why

https://bear-images.sfo2.cdn.digitaloceanspaces.com/jameszhanirl/08pm.webp
I accidentally triggered a Google glitch with Bear Blog by validating a non-indexable feed URL, de-indexing other articles. I've created a new blog with URL forwarding and hope Google will naturally index it after my previous troubleshooting.

The tiniest yet real telescope I've built

https://lucassifoni.info/pics/miniscope/IMG_2285.webp
A 3D-printed dobsonian telescope was created with specific constraints, using a 76mm/300mm mirror kit and featuring a unique focuser design. It achieved good performance with refiguration, but overcorrected initially and needs recoating.

Nuclear energy key to decarbonising Europe, says EESC

https://www.eesc.europa.eu/sites/default/files/styles/large/public/2025-12/2025_12_04_601_plenary_session_72.jpg?itok=rDcCkEwu
The EESC supports nuclear energy as a key component in the EU's clean energy mix, calling for regulatory and financial enablers to make investment possible. The Committee urges the European Commission to include measures to support the nuclear industry and promote dialogue with civil society.

Japan law opening phone app stores to go into effect dec.18th

https://www3.nhk.or.jp/nhkworld/upld/thumbnails/en/news/20251210_B1_1599558_L.jpg
Japan will introduce new law on Dec 18 to loosen tech giants' grip, allowing users to choose between app stores and default services. Changes aim to improve convenience but raise security concerns.

Guarding My Git Forge Against AI Scrapers

https://vulpinecitrus.info/favicon.png
The user's git forge was hit by hundreds of thousands of queries a day from thousands of IPs, causing significant power consumption, CPU usage, and network traffic, and the user implemented various measures to limit the damage, including caching, rate limiting, and a garbage generator. The user eventually settled on a solution using Iocaine, a middleware that traps scrapers in a maze of ...

Windows 3.1 'Hot Dog Stand' color scheme true story

https://cdn.mos.cms.futurecdn.net/FeVcSLo2Rjhj4R9ZuWWKx4-840-80.jpg
Virginia Howlett, Microsoft's first interface designer, confirmed that the Hot Dog Stand color scheme in Windows 3.1 was not intended as a joke. It was a garish choice included to appeal to people who liked bright colors.

Show HN: Tripwire: A new anti evil maid defense

https://opengraph.githubassets.com/d396740e73348c385ce6ddcd2d8876354b88839966517cd81c3730ff14f7847f/fr33-sh/Tripwire
Tripwire is a robust monitoring system that defends against sophisticated adversaries, including evil maid attacks, by sharing and deleting random secrets between the server and client, making it difficult for attackers to cover their tracks. The system uses a Raspberry Pi 5, camera module, and motion sensor to detect intrusions and sends web push notifications to the client, with features ...

Koralm Railway

https://infrastruktur.oebb.at/.resources/corp-2016/themes/images/logo-oebb-infra-og.png
The Koralm Railway is part of Austria's new Southern Line and shortens travel time between Graz and Klagenfurt from 3 hours to 45 minutes. It enhances rail transport, reduces CO2 emissions, and boosts Austria's economy through increased competitiveness.

He set out to walk around the world. After 27 years, his quest is nearly over

Octo: A Chip8 IDE

https://raw.githubusercontent.com/JohnEarnest/Octo/gh-pages/images/f8z.gif
Octo is a high-level assembler for the Chip8 virtual machine with testing and sharing tools. It offers command-line and web-based features for decompilation, export, and sharing of Chip8 programs.

Show HN: tomcp.org – Turn any URL into an MCP server

https://opengraph.githubassets.com/22f96374bd73b824560a0fc7f53f95745b627b3daca4df3e2be534145a4b4564/Ami3466/tomcp
The AI tool connects to a chat server at https://tomcp.org/chat using a POST request with JSON data containing the website URL and message to be asked. It displays free models as enabled, but premium models are disabled until an API key is added for access.

Training LLMs for Honesty via Confessions

https://arxiv.org/static/browse/0.3.4/images/arxiv-logo-fb.png
Researchers propose a method to elicit honesty from large language models by having them provide a self-reported confession of their shortcomings. This approach incentivizes models to be honest in their confessions by rewarding them based on honesty, not the main answer's reward.

The Tor Project is switching to Rust

https://itsfoss.com/content/images/2025/12/tor-arti-banner.jpeg
The Tor Project's Arti 1.8.0 release addresses security flaws in the C codebase by introducing usage-based circuit timeouts and a new command for migrating onion service keys. It also improves routing architecture, protocol implementation, and directory cache support.

Microservices Should Form a Polytree

https://bytesauna.com/trees/polytree.png
Microservices can be complex and difficult to manage if not structured properly, leading to issues like cyclical dependencies and tangled responsibilities. A polytree structure, where services form a directed acyclic graph, can help avoid these problems by enforcing clear ownership of state, predictable failure modes, and independent evolution.

Framework Raises DDR5 Memory Prices by 50% for DIY Laptops

https://www.phoronix.com/assets/categories/hardware.webp
Framework Computer increased DDR5 memory prices by 50% for DIY Edition laptops due to industry-wide shortages. Existing pre-orders and pre-built laptops remain unchanged, with new return policy requiring DDR5 module return with laptop returns.