SQLite
Embedded SQL database engine
Episodes
-
#5848: The Libraries Nobody Thinks Aboutzlib, SQLite, OpenSSL, and the xz backdoor — the tiny pieces of code running everywhere, and the volunteers keeping them alive. -
#5753: Unpacking as a Warehouse Problem: Sorting vs. TaggingDaniel's move is done but nothing's findable. The fix is a warehouse putaway problem — and his IKEA bag is the slowest possible tool. -
#5434: When Local AI Tools Phone HomeLocal AI tools shouldn't need the network. So why is your on-device writing assistant uploading 40MB at 3am? -
#4931: Building a DIY Barcode Inventory CartOld laptop, USB scanner, and Linux kiosk mode for a dedicated home inventory terminal. -
#3874: How to Tag 4000 Episodes Without Losing Your MindWhy tagging breaks at scale, and how a two-stage AI pipeline fixes it for good. -
#3024: How to Incrementally Back Up Google Photos to Your NASBuild a quarterly backup pipeline for Google Photos using the Library API, hash deduplication, and your NAS. -
#2550: Idempotent Pipelines: Checkpoints, Manifests & Safe Re-RunsHow to design scripts and pipelines so re-running them is safe, even after a crash mid-execution. -
#2501: Describing a Neighborhood: Databases Without ScreensCan you design a relational database using only your voice? We coach a beginner through PostgreSQL from scratch. -
#2492: When AI Agents Collapse Stack Evaluation from Weeks to SecondsHow Claude Code and agentic AI are turning GitHub into a discovery layer and collapsing library evaluation from weeks to seconds. -
#2398: Your Taste, Your Data: Owning Your AI PreferencesWhy can’t you describe your perfect movie—but you’d know it if you saw it? A vision for portable, user-owned AI taste profiles. -
#2203: Knowledge Without Tools: Why MCPs Aren't Just for ExecutionMCPs can be pure knowledge providers with zero tools. Here's why that matters for agents querying government data and authoritative sources. -
#2171: How IQT Labs Built a Wargaming LLM (Then Archived It)A deep code review of Snowglobe, IQT Labs' open-source LLM wargaming system that ran real national security simulations before being archived. What... -
#2070: SemVer, Changelogs, and the Social Contract of CodeStop breaking the internet. Learn the exact system developers use to release software without causing chaos. -
#2043: From Wrappers to State MachinesSkip no-code traps. Learn the real stack for building agentic AI: Python, TypeScript, and Rust. -
#1931: Where Your AI Pipeline Actually DiesWhy do AI pipelines crash? It’s not the models—it’s the plumbing. We break down how to manage data between stages. -
#1862: Hacker News: The Orange Site That Runs Silicon ValleyIt loads in milliseconds, has no ads, and looks like a spreadsheet from 1995. Here’s why Hacker News still dictates what the tech elite thinks ever... -
#1811: Stop Hardcoding User Names in AI PromptsThree methods for storing user identity in AI agents—and why the "Fat System Prompt" breaks production apps. -
#1764: Your Repo as a Knowledge BaseHow to give AI agents instant memory of your entire project—without cloud costs or complex infrastructure. -
#864: The Death of SaaS: Building Your Own Bespoke AI ToolsStop paying for dozens of subscriptions. Learn how AI agents are allowing anyone to build custom, private software tailored to their exact needs. -
#594: Digital Dust: Can NFC Tags Survive for Decades?Explore the science of NFC longevity, from EEPROM bitrot to physical durability, and learn how to future-proof your home inventory system. -
#262: Beyond Git: Version Control for the Solo CreatorIs Git overkill for your projects? Herman and Corn dive into the "war" that created Git and explore simpler tools for solo developers. -
#61: Fork or Stay? The Art of Customizing Open SourceFork or stay? We're diving deep into customizing open source, weighing ownership, contribution, and the hidden costs of going solo.