PatentLLM Blog

JA GitHub
Dev Tools

Strategic Data Organization Techniques Using SQLite, JSONL, XML, and TSV: Lessons from Implementing PatentLLM and Hanrei-DB

This article explains the data organization know-how gained from developing the patent search app PatentLLM and the case law search app Hanrei-DB. It covers the practical use cases...

Dev Tools

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

This article explains how to introduce and practically use uv, a Rust-based Python package manager developed by Astral. It covers its speed (10 to 100 times faster than pip), venv-...

Dev Tools

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

This article organizes the origins and design philosophies of the major OSS components that constitute the AI development stack, following their historical development. We will pro...

Dev Tools

Skit: The Man Obsessed with Claude Code

A manzai comedy skit between Engineer Takechi, whose brain has been completely taken over by Claude Code, and his junior colleague Niiyama, who desperately tries to pull him back t...

Dev Tools

Leveraging Claude Code's MCP Server

This article explains how to complete SQLite database operations within an AI assistant by utilizing Claude Code's MCP (Model Context Protocol) server functionality. We will cover ...

Dev Tools

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

This article explains a method for proactively and automatically preventing the execution of port conflicts and dangerous commands (e.g., rm -rf, git push --force) by leveraging Cl...

Dev Tools

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

This article introduces a method to solve the problem of excessive token consumption when all information is written in CLAUDE.md, by using a two-layer structure: a Tier 1 index (l...

Dev Tools

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

This article explains how to build a daily report system that automatically aggregates Claude Code and Gemini CLI usage history every morning with a cron job, visualizing token con...

Dev Tools

google-generativeai → google-genai Migration Guide

Due to the deprecation of the google.generativeai package, this guide explains the specific steps to migrate to the google-genai SDK. We will show examples of import changes, Gener...

Dev Tools

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

This article explains how to build a legal AI search system that converts court case law PDFs into text, achieves full-text search with SQLite FTS5, and automates issue extraction ...

Dev Tools

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

This article explains the method for building a dashboard that indexes data from the Chemical Substance Risk Information Platform (CHRIP) with SQLite FTS5 and performs regulatory s...

Dev Tools

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

This article explains how to enable systemd in WSL2 and manage vLLM server, Flask API, and periodic tasks as systemd services. It also covers startup order dependencies and log mon...

Dev Tools

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

A free patent search engine covering 3.5M US patents (2016-2025). Built with SQLite FTS5, BM25 ranking, CPC classification filtering, and Nemotron 9B for tech tag classification....

Dev Tools

Coders at Work: A Guide to All 15 Interviews with Programming Legends

A chapter-by-chapter guide to Peter Seibel's 'Coders at Work', introducing all 15 programmers interviewed — from UNIX creator Ken Thompson to Erlang inventor Joe Armstrong, JavaScr...