Show HN: 22 GB of Hacker News in SQLite
Community, All the HN belong to you. This is an archive of hacker news that fits in your browser. When I made HN Made of Primes I realized I could probably do this offline sqlite/wasm thing with the whole GBs of archive. The whole dataset. So I tried it, and this is it. Have Hacker News on your device.
Go to this repo (https://github.com/DOSAYGO-STUDIO/HackerBook): you can download it. Big Query -> ETL -> npx serve docs - that's it. 20 years of HN arguments and beauty, can be yours forever. So they'll never die. Ever. It's the unkillable static archive of HN and it's your hands. That's my Year End gift to you all. Thank you for a wonderful year, have happy and wonderful 2026. make something of it.
Netflix Open Content
Netflix's Open Content initiative provides open-source software and tools for content creators and developers, aiming to drive innovation and collaboration in the media industry.
A faster heart for F-Droid
The article discusses the efforts of the F-Droid team to improve the speed and performance of the F-Droid app store for open-source Android applications. It highlights the various optimizations and changes made to the platform to enhance the user experience.
Stardew Valley developer made a $125k donation to the FOSS C# framework MonoGame
MonoGame, the open-source implementation of the Microsoft XNA Framework, has announced a new sponsor, providing financial support to continue the project's development and maintenance.
OpenAI's cash burn will be one of the big bubble questions of 2026
This article discusses the financial implications of OpenAI's ambitious AI development plans, predicting that the company's high cash burn rate will be a major topic of discussion in 2026 as the technology industry grapples with a potential bubble in AI investment.
Stranger Things creator says turn off “garbage” settings
The article discusses how the creators of the hit Netflix series 'Stranger Things' have asked viewers to turn off their settings and watch the season premiere as intended, without adjustments to aspects like screen brightness or aspect ratio. This is to ensure viewers experience the show as the creators intended.
Non-Zero-Sum Games
NonZeroSum Games is an independent game studio focused on creating unique and engaging digital experiences that challenge traditional game design. The studio's mission is to push the boundaries of interactive entertainment and explore new frontiers in game mechanics and storytelling.
Nicolas Guillou, French ICC judge sanctioned by the US and “debanked”
The article discusses the sanctions imposed by the United States on French International Criminal Court (ICC) judge Nicolas Guillou, which have effectively blacklisted him from the global banking system. The sanctions are part of the U.S. government's ongoing efforts to undermine the ICC and its investigations into alleged war crimes and crimes against humanity.
Go away Python
The article discusses the use of shebang lines in Go programs, explaining their purpose, how to write them correctly, and the implications of their usage in different environments.
FediMeteo: A €4 FreeBSD VPS Became a Global Weather Service
This article explores the story of Fedimeteo, a small FreeBSD VPS that grew into a global weather service serving thousands of users. It highlights how the project's simple yet efficient infrastructure and dedication to open-source principles allowed it to scale and thrive, despite its modest origins.
Honey's Dieselgate: Detecting and tricking testers
This article explores the use of 'honey detectors' to identify fake online reviews and accounts. It discusses how these tools analyze user behavior and content to detect fraudulent activities, providing a way for businesses to protect their online reputation.
I migrated to an almost all-EU stack and saved 500€ per year
This article details the author's experience of moving away from big tech platforms and services, exploring alternative privacy-focused solutions and the challenges and benefits of this transition.
A Vulnerability in Libsodium
The article discusses a vulnerability discovered in the libsodium cryptographic library, which could potentially allow attackers to recover sensitive information. The vulnerability has been patched, and users are advised to update to the latest version of the library.
ManusAI Joins Meta
Manus, a leading hand-tracking and motion control technology company, has joined forces with Meta (formerly Facebook) to collaborate on the next generation of virtual and augmented reality experiences. The partnership aims to accelerate the development of innovative input and interaction solutions for immersive computing platforms.
Times New American: A Tale of Two Fonts
The article discusses the rise of a new conservative political movement in the United States, dubbed the 'Times New American', which seeks to challenge the establishment and promote a nationalist, populist agenda. It explores the ideological foundations, key figures, and potential impact of this emerging political force.
Show HN: Use Claude Code to Query 600 GB Indexes over Hacker News, ArXiv, etc.
Paste in my prompt to Claude Code with an embedded API key for accessing my public readonly SQL+vector database, and you have a state-of-the-art research tool over Hacker News, arXiv, LessWrong, and dozens of other high-quality public commons sites. Claude whips up the monster SQL queries that safely run on my machine, to answer your most nuanced questions.
There's also an Alerts functionality, where you can just ask Claude to submit a SQL query as an alert, and you'll be emailed when the ultra nuanced criteria is met (and the output changes). Like I want to know when somebody posts about "estrogen" in a psychoactive context, or enough biology metaphors when talking about building infrastructure.
Currently have embedded: posts: 1.4M / 4.6M comments: 15.6M / 38M That's with Voyage-3.5-lite. And you can do amazing compositional vector search, like search @FTX_crisis - (@guilt_tone - @guilt_topic) to find writing that was about the FTX crisis and distinctly without guilty tones, but that can mention "guilt".
I can embed everything and all the other sources for cheap, I just literally don't have the money.
No strcpy either
The article discusses the security risks associated with using the C library function `strcpy()` and recommends avoiding it in favor of safer alternatives like `strncpy()` or `strlcpy()`. It highlights the importance of being careful with string handling in programming to prevent buffer overflow vulnerabilities.
HSBC blocks its app due to F-Droid-installed Bitwarden
Akin's Laws of Spacecraft Design [pdf] (2011)
The article presents 'Akin's Laws of Spacecraft Design', a set of principles and guidelines for designing successful spacecraft. The laws cover various aspects, including the importance of simplicity, understanding the system, and considering the entire lifecycle of the project.
Tell HN: Happy New Year
NYC Mayoral Inauguration bans Raspberry Pi and Flipper Zero alongside explosives
The article discusses the New York City mayoral inauguration banning the possession of Raspberry Pi and Flipper Zero devices, alongside explosives and other prohibited items, citing security concerns.
Public Sans – A strong, neutral typeface
Public Sans is a free, open-source typeface designed for use in US federal government websites and digital products. It is highly legible and optimized for screen display, providing a clean and modern aesthetic for government communications.
Efficient method to capture carbon dioxide from the atmosphere
Researchers at the University of Helsinki have developed an efficient method to capture carbon dioxide directly from the atmosphere, which could aid in reducing greenhouse gas emissions and mitigating climate change.
I canceled my book deal
The article discusses an author's experience with a book deal being canceled, highlighting the challenges and uncertainties faced by writers in the publishing industry. It explores the author's perspective on the situation and the broader implications for aspiring authors.
Everything as code: How we manage our company in one monorepo
This article explores the concept of 'Everything as Code' and how it can be implemented in a monorepo structure. It discusses the benefits of this approach, including improved collaboration, reduced complexity, and better version control, and provides guidance on setting up and managing a monorepo for 'Everything as Code'.
Project ideas to appreciate the art of programming
This article provides a curated list of programming project ideas for aspiring developers, covering a range of topics and skill levels to help individuals enhance their coding abilities and build a strong portfolio.
The British empire's resilient subsea telegraph network
The article explores the enduring impact of the British Empire's extensive subsea cable network, which facilitated global communication and connectivity during the 19th and early 20th centuries. It highlights how this network remains a critical component of modern international infrastructure, even as geopolitical dynamics have shifted over time.
Hacking Washing Machines [video]
The article discusses how some modern washing machines can be hacked, allowing remote access and control of the appliances. It explores the security vulnerabilities in the design and connectivity of these smart home devices, and the potential risks and implications for users.
LLVM AI tool policy: human in the loop
The article proposes a policy for the use of AI tools in the LLVM project, emphasizing the importance of human involvement and oversight, as well as guidelines for responsible development and deployment of AI-powered features.
Zpdf: PDF text extraction in Zig
The article describes zpdf, an open-source PDF rendering library written in Rust that aims to provide fast and accurate PDF rendering capabilities. It highlights the library's performance, accuracy, and cross-platform support, making it a promising solution for integrating PDF functionality into applications.