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.
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.
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.
Warren Buffett steps down as Berkshire Hathaway CEO after six decades
Warren Buffett, the renowned investor and chairman of Berkshire Hathaway, steps down as CEO after leading the company for over six decades. Greg Abel, Berkshire's vice chairman, is named as the new CEO, marking the end of an era for the iconic 'Oracle of Omaha'.
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.
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.
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.
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.
2025: The Year in LLMs
The article provides an overview of the major developments in the field of large language models (LLMs) in 2025, including advancements in areas such as improved performance, increased accessibility, and the emergence of specialized LLMs for different domains and use cases.
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.
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.
Tell HN: Happy New Year
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.
Akin's Laws of Spacecraft Design (2011) [pdf]
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.
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.
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
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.
The rise of industrial software
The article discusses the growing importance of industrial software in the modern business landscape. It examines the increasing adoption of industrial software solutions by companies across various sectors, driven by the need for improved efficiency, automation, and data-driven decision-making.
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.
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'.
Meta created 'playbook' to fend off pressure to crack down on scammers
https://archive.ph/Phdes
Stewart Cheifet, creator of The Computer Chronicles, has died
The article provides an obituary for Stewart Cheifet, a pioneering figure in the technology industry who co-hosted the popular TV show 'Computer Chronicles' and helped shape the public's understanding of the digital revolution.
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.
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.