From Hacker News
Stories 1 – 10
No. 01Dev ToolsApplies to you
by ingve · 289 points · 136 comments
SQLite's STRICT mode enforces actual column types instead of the famously permissive affinity system — meaning a column declared INTEGER won't silently accept a string. A must-read if you're using SQLite in any production context, and an easy win to add to your next schema. The lively comment thread surfaces real-world gotchas and migration strategies.
No. 02AI ToolsApplies to you
by tionis · 257 points · 58 comments
Iroh's peer-to-peer networking layer gets put to an ambitious use: spreading LLM inference across multiple machines without a central coordinator. This is early but genuinely interesting architecture for anyone who wants to run large models without a single beefy box. The approach could pair neatly with local-first AI workflows.
No. 03Dev Tools
by theMackabu · 269 points · 115 comments
Another challenger enters the JS runtime wars — Ant bills itself as a fresh take on the Node/Deno/Bun ecosystem with its own twist on the standard library and toolchain. The HN comment thread is skeptical but engaged, probing its performance claims and compatibility story. Worth a look if you track where the JS runtime landscape is heading.
No. 04Dev ToolsApplies to you
by saisrirampur · 209 points · 48 comments
ClickHouse's team digs into the internals of PgBouncer and explains the specific changes they made to quadruple connection-pooling throughput on managed Postgres. Concretely useful for any .NET or backend developer hitting connection limits under load. The write-up is technical, detailed, and reproducible.
No. 05AI ToolsApplies to you
by marzukia · 57 points · 24 comments
A hands-on account of tracking down and squashing three bugs in mlx-lm to get the massive Qwen3.5-122B model running reliably on a Mac Studio — no cloud needed. Directly relevant if you're chasing local LLM performance on Apple Silicon. The author's patches are already upstream.
No. 06AI ToolsApplies to you
by cosmtrek · 49 points · 17 comments
Mindwalk visualises coding-agent session replays as a navigable 3D graph of your codebase, so you can see exactly where an AI agent went and what it touched. For anyone using Claude Code or similar agents on a large codebase, this is the kind of observability tool that could change how you audit and debug agent runs.
No. 07ActionableApplies to you
by acley · 172 points · 50 comments
A project-based learning platform that has you build Redis, Git, SQLite, and other core tools from scratch in your language of choice. The best way to deeply understand the tools you use every day is to write them yourself, and this gives you a structured path to do it. Immediately useful as a weekend challenge or team exercise.
No. 08AI ToolsApplies to you
by jamiebeach · 150 points · 28 comments
A beautifully minimal LLM agent built in 100 lines of Lisp, exposing just how simple the core agentic loop really is when you strip away framework bloat. Great for anyone who wants to understand agent architecture at a first-principles level before layering on abstractions. Thought-provoking alongside heavier tools like Claude Code.
No. 09Dev ToolsApplies to you
by _superposition_ · 80 points · 60 comments
Amber is a typed, modern scripting language that transpiles to Bash, Ksh, or Zsh — giving you safety, syntax, and familiar shell portability all at once. If you've ever wished you could write shell scripts with proper types and sane error handling, this is worth a serious look. Installable and usable today.
No. 10Dev ToolsApplies to you
by rellem · 41 points · 11 comments
EF Core 11 quietly ships meaningful performance improvements to split queries — the feature that avoids Cartesian explosion when loading related collections. Essential reading for .NET developers who rely on Entity Framework in production. The benchmarks show real-world gains you can get just by upgrading.
From Pinboard Popular
Stories 11 – 20
No. 11Privacy & Security
Pinboard Popular · tagged: internet, doom
LWN takes a clear-eyed look at how AI training crawlers and mass scrapers are throttling small sites, overwhelming servers, and eroding the incentive to publish openly on the web. The piece connects the scraping tsunami directly to the AI data-hunger economy. Essential context for anyone building public APIs or open content.
No. 12Privacy & SecurityApplies to you
Pinboard Popular · tagged: ai
Bruce Schneier argues that AI-powered surveillance is qualitatively different from what came before — cheaper, scalable, and increasingly used against the very social movements that historically drove progress. A characteristically sharp take that connects AI capability to civil-liberties risk. Required reading if you care about the downstream effects of the tools you build.
No. 13AI Tools
Pinboard Popular · tagged: mitp
Ars Technica reports that OpenAI allegedly misrepresented its ability to search training data and concealed billions of log entries in its copyright litigation with the New York Times. If the allegations hold up, this could fundamentally reshape how AI companies disclose training data. One of the most consequential legal stories in the AI space right now.
No. 14Privacy & Security
Pinboard Popular · tagged: ai, patreon, cloudflare, training-data
Patreon has teamed up with Cloudflare to actively block AI training crawlers from harvesting creators' paid content — one of the more concrete opt-out moves by a major platform. The policy framework they're building around consent, credit, and payment is a template other platforms may adopt. Good to watch as the training-data consent debate heats up.
No. 15AI Tools
Pinboard Popular · tagged: Google, ai, Gemini, Web
A cohort of major publishers is now seriously weighing opting out of Google Search indexing as AI Overviews siphon traffic without compensation. This is a tipping-point story: if big content producers defect from Google's index, it has cascading effects on search quality and the AI training pipeline. Watch this space.
No. 16Dev ToolsApplies to you
Pinboard Popular · tagged: webdev, frontend, history
A sweeping retrospective on how frontend development transformed from a simple button and an FTP upload into the sprawling ecosystem it is today — bundlers, frameworks, build pipelines, and all. Written to be accessible to those who stepped away and came back confused. Angular/TypeScript devs will recognise the inflection points firsthand.
No. 17Creative Software
Pinboard Popular · tagged: fonts, ai, technology, inspiration
Ghost Font is a typeface deliberately designed to be legible to humans but invisible to current AI OCR and vision models — a creative hack at the intersection of typography and adversarial ML. You can type a message and download a video clip to share it. A delightful creative provocation and a genuinely usable steganographic trick.
No. 18Creative Software
Pinboard Popular · tagged: untagged
A browser-based digital collage studio that lets you pull scanned magazines from the Internet Archive, clip elements, and compose them on a canvas. The kind of creative tool that makes the Archive's vast holdings actually tactile and fun to work with. Instant weekend time-sink for anyone who likes generative or mixed-media art.
No. 19Creative Software
Pinboard Popular · tagged: programming, graphics, patterns, tiles, javascript, fun, opensource, visualization, onlinetools, free, learning, interesting, art, interactive
Pattern Collider is an open-source, browser-based explorer for quasiperiodic tilings — think Penrose tiles and beyond — where you can tweak parameters and watch intricate patterns emerge in real time. Both a beautiful creative toy and a legitimate maths visualization tool. Pairs well with anyone doing generative or algorithmic art.
No. 20New Apple AppsApplies to you
Pinboard Popular · tagged: apple, ios, accessibility, kids, safety
An HN-surfaced tip about a little-known iOS accessibility mode that strips an iPhone down to a minimal set of apps — essentially turning it into a dumb phone without buying new hardware. Extremely practical for parents in the Apple ecosystem who want safer devices for kids. The thread is full of complementary Screen Time and Focus mode tricks.