#SQLite test database
101 related articles
·6 min
30-Minute Hands-On: Building a Working AI Agent from Scratch
Skip the dry theory and get hands-on! This article demonstrates step by step how to build a working AI Agent from scratch in 30 minutes using AI coding tools—covering the agent skeleton, tool system, memory mechanism, Flask web UI, and DeepSeek API integration.
Read more →
·3 min
LangChain v1.3 Hands-On Tutorial: Deep Dive into Agents, RAG, and Local Model Deployment
Deep dive into LangChain v1.3: compare LangChain, LangGraph, and DeepAgent paradigms, explore RAG pipelines, multi-agent systems, and local LLM deployment for enterprise AI apps.
Read more →
·3 min
SQLite STRICT Tables Explained: The Type Enforcement Debate and Best Practices
Deep dive into SQLite STRICT tables: is flexible typing a feature or flaw? Covers the author's stance, type vs. validation debate, Turso alternatives, and best practices for type-safe database design.
Read more →
·3 min
Building 'Beat the Couch' with Claude: Can You Outperform Doing Nothing?
Beat the Couch is a minimalist web game built with Claude that challenges you to outperform a buy-and-hold strategy using real S&P 500 history. 25,000+ plays prove market timers almost always lose to the couch.
Read more →
Deep Dives
Deep Dive into AI Agent Skill Design: …
·3 min
Deep Dive into AI Agent Skill Design: Engineering Practices from Anthropic and Perplexity
A deep dive into Skill design philosophy from Anthropic's Claude Code team and Perplexity's Agent team, covering the Tax Test, Gotchas Flywheel, progressive disclosure, and Eval-First practices for building high-quality AI Agent skill systems.
Read more →
·1 min
Prisma In-Depth: The Go-To ORM for Node.js and TypeScript
A comprehensive look at Prisma ORM's core components and unique strengths: the type-safe Prisma Client, declarative migrations, visual Studio, and support for PostgreSQL, MySQL, MongoDB and more.
Read more →
·6 min
Spec-Driven Development in Practice: The New AI Coding Paradigm from Andrew Ng × JetBrains
Andrew Ng partners with JetBrains to launch a Spec-Driven Development course, teaching how to direct AI coding agents via spec files to boost intent fidelity and build maintainable production apps.
Read more →
·4 min
Why Do AI Agents Crash the Moment They Go Live? A Practical Guide to Harness Engineering for Runtime
A deep dive into the Claude Code source code, systematically analyzing the five-layer Harness Engineering architecture: environment, tool, control, memory, and evaluation. Build a stable runtime system for production AI Agents.
Read more →
·3 min
Building a Local AI Coding Agent on Mac: A Complete Guide with Ollama, OpenCode, and MCP
A complete guide to building a local AI coding agent on a 32GB Mac: Ollama for local inference, OpenCode as the agent framework, and MCP memory servers for cross-session context. Code stays on-device, no subscription fees.
Read more →
·5 min
Building Your Own Reading Tracker: Craig Mod's Digital Garden and the Case for Data Sovereignty
Why did Craig Mod abandon Goodreads to build his own reading tracker? A deep dive into the motivations, benefits, and trade-offs of self-hosting, data sovereignty, and the IndieWeb movement.
Read more →
·2 min
Zero-Cost Multi-Agent AI System: A Complete Breakdown of the Free-Tier Build
A CS student built a multi-agent AI system with memory, 8 sub-agents, and real-time web research using only free infrastructure like Cloudflare Workers and GitHub Actions. Full breakdown inside.
Read more →
·7 min
The Prompt is the Platform: How AI Agents Deeply Participate in System Design and Specification
Resonate's founder proposes "The Prompt is the Platform": as AI agents generate production-grade implementations from abstract specs, engineers' value shifts to specification. A deep dive into deterministic simulation and forbidden-fruit debugging.
Read more →
·7 min
LangChain Hands-On Guide: From LLM Calls to Agent Development
Master LangChain from scratch: the three limitations of LLMs, init_chat_model unified interface config, the Message type system, and the path from LLM calls to Agent development.
Read more →
·7 min
Spec-Driven Development: Andrew Ng Teaches You to Master AI Coding Agents Efficiently
Andrew Ng partners with JetBrains on a new course systematically teaching Spec-Driven Development. By writing high-quality specs, developers can precisely control AI coding agents, eliminate context decay, and boost intent fidelity.
Read more →
·6 min
LangChain 1.3 in Practice: A Complete Guide to DeepAgent Architecture and the Harness Philosophy
An in-depth look at LangChain 1.3's core modules and DeepAgent architecture—covering the Harness philosophy, LangGraph internals, HITL, memory management, and guardrails to master production-grade AI Agent development.
Read more →
·5 min
OSINT Tools for Automated Discovery of Exposed Files on Domains: Principles, Applications, and Compliance Boundaries
Deep dive into how OSINT automation tools discover exposed files on domains, covering dictionary probing principles, attack surface management, bug bounty techniques, and compliance boundaries.
Read more →
·4 min
Microsoft Fixes Windows 11 Storage Bloat Bug Caused by Runaway CapabilityAccessManager Database File
Microsoft's optional update KB5095093 fixes a Windows 11 bug where the CapabilityAccessManager.db-wal SQLite WAL file bloats to several GBs due to a failed checkpoint mechanism.
Read more →
·8 min
Python Web Scraping for Beginners: How It Works, Core Workflow, and Legal Red Lines Explained
A plain-language guide to how Python web scrapers work: from HTTP requests and responses, HTML tag parsing, to the complete three-step data scraping workflow, with a focus on the three legal red lines and compliance advice.
Read more →
·7 min
A Complete Guide to LangGraph's Core Concepts: The Framework of Choice for Enterprise Agent Development
An in-depth analysis of LangGraph's core concepts: short-term and long-term storage mechanisms, its differences from LangChain, the MIT open-source license, and private deployment solutions for enterprise Agent development.
Read more →
·5 min
Claude Drives the sqlite-utils 4.0 Release: The Real Cost and Collaboration Methodology of AI-Assisted Refactoring
Developer Simon Willison used Claude to ship sqlite-utils 4.0: 37 prompts, 34 commits, $149 API cost — revealing coding agents' real capabilities, cross-model review, and agentic engineering best practices.
Read more →