Deep Dive

In-depth technical articles on AI, GPU inference, and developer tools

Developer Tools

I Built a SQLite Editor in 180 Lines, Then Rebuilt It in 730 for the Browser

Background I work with a lot of SQLite databases — patent data, court rulings, government...

Developer Tools

Frontiers of AI Agent Development: Claude HUD, OpenAI Monitoring, and the Impact of Astral Acquisition

Frontiers of AI Agent Development: Claude HUD, OpenAI Monitoring, and the Impact of Astral...

Developer Tools

Data Preparation and Security to Accelerate AI Development: Leveraging Open Source Tools

Today's Highlights The field of AI development is evolving day by day. Especially for...

Developer Tools

OpenAI Acquires Astral (uv / Ruff) — What It Really Means

Introduction OpenAI has acquired Astral — the company behind Python's blazing-fast package...

Developer Tools

Why Google Wasn't Indexing My FastAPI Site — The HEAD Request Trap

The Symptom: 93 Pages Invisible to Google I run a technical blog on FastAPI behind...

Developer Tools

Using Python to Load Google Docs into AI — Drive API Minimal Permission Setup

Introduction: The Challenge of AI Not Being Able to Directly Read Google Documents "Please...

Developer Tools

Claude Code Practical Guide: Debugging, Test Automation, and CUDA Environment Setup with Opus 4.6

Introduction Claude Code is a CLI (Command Line Interface) tool provided by Anthropic that...

Developer Tools

Coders at Work — Index of All 15 Programmer Interviews

■ What is Coders at Work? Written by Peter Seibel (2009). A collection of long-form interviews with...

Developer Tools

I Built a Free Patent Search Engine with 3.5M US Patents — No Login, Powered by SQLite FTS5

I'm a patent lawyer who started coding in December 2025. Today I'm launching a free patent search...

Developer Tools

Operational Techniques for Automatically Starting vLLM, Flask, and cron with systemd Services in WSL2

WSL2 systemd Support To enable systemd in WSL2, configure /etc/wsl.conf. # Add to...

Developer Tools

A Regulatory Analysis Dashboard for Fast Searching NITE CHRIP Data using FTS5

NITE CHRIP Data Conversion Regulatory data provided by the Chemical Substance Risk...

Developer Tools

Searching Case Law PDFs with RAG — A Legal AI Search System using Gemini + SQLite FTS5

Challenges in Case Law Search Traditional court databases (e.g., courts.go.jp) have search...

Developer Tools

google-generativeai google-genai Migration Guide

What Happened The google.generativeai package has been deprecated. Migration to the new...

Developer Tools

Skit: The Man Obsessed with Claude Code

Comedy Sketch: The Man Possessed by Claude Code Characters: Niiyama: The...

Developer Tools

A Daily Report System to Automatically Aggregate Claude Code + Gemini CLI Usage History Every Morning with Cron

Why Automate Daily Reports Manually recording daily AI tool usage is a waste of time....

Developer Tools

Reducing Token Consumption in Claude Code — FTS5 Knowledge DB + Tiered Index Design

Problem If all coding conventions, test commands, and documentation for the entire project...

Developer Tools

Leveraging Claude Code's MCP Server

Introduction: The Context Switching Problem in DB Operations SQLite is an excellent...

Developer Tools

Lineage of OSS Supporting the AI Development Stack: Its Origins and Creators

Local AI development environments are built upon numerous open-source technologies. This article...

Developer Tools

Strategic Data Organization Techniques Using SQLite, JSONL, XML, and TSV: Lessons

Introduction PatentLLM (patent search AI) and HanreiLLM (case law search AI) are both...

Developer Tools

Python Environment Management with uv: Introduction and Practical Use of a High-Speed Package Manager Replacing pip/venv

What is uv? uv is a Rust-based Python package manager developed by Astral (Charlie Marsh)....

Developer Tools

Automatically Prevent Port Conflicts and Dangerous Commands Proactively with Claude Code's Hooks Feature

What are Claude Code hooks? Claude Code's hooks feature enables event-driven automation...