This repository serves as a comprehensive documentation project that provides deep-dive insights into the architecture, internals, and usage of various AI-powered CLI tools. It documents five specific tools: Claude Agent SDK, Gemini CLI, Codex CLI, OpenCode, and Pi Coding Agent, offering detailed explanations of their internal workings, features, and integration patterns. The content is derived from direct source code analysis and aims to fill the gaps in official documentation. The repository is structured with dedicated directories for each tool, following a standardized numbering convention for topics (e.g., 01-overview, 02-technical-stack). It also includes specialized extraction sections for the Claude Agent SDK, breaking down its subsystems into individually documented 'complete' files. This approach demonstrates a reproducible pattern for knowledge extraction from complex software systems. While the repository excels in organizing and presenting technical information, it relies on external source code for its content and does not include the analysis scripts or raw data used to generate the documentation. This makes reproducing the exact analysis challenging, though the documented versions of each tool are specified. The documentation faces a high risk of becoming outdated due to the rapid evolution of the underlying AI CLI tools.
This repository contains a technical book titled 'The Art of Problem-Solving in Software Engineering: How to Make MySQL Better'. It is structured as a collection of Markdown files covering MySQL internals, performance optimization, and problem-solving methodologies. The book does not contain executable code or data processing scripts; instead, it provides theoretical explanations, case studies, and references to MySQL versions 8.0.x and 5.7. Topics include transaction throttling, latch sharding, hybrid data structures, Group Replication enhancements, and performance testing techniques using tools like BenchmarkSQL and SysBench. The repository serves as an educational resource for database administrators, performance engineers, and MySQL contributors seeking to understand and resolve MySQL scalability and performance issues. It emphasizes analytical approaches over trial-and-error, drawing from computer science fundamentals such as queueing theory, distributed systems, and algorithmic optimization. While the book references benchmark results and visualizations (stored as images in the media/ directory), it does not include the raw data, scripts, or tools needed to reproduce those results. As a documentation-focused repository, it lacks traditional software engineering components like APIs, CLI tools, or reusable libraries. Its value lies in the consolidated knowledge presented across chapters, which readers can apply to MySQL tuning and troubleshooting scenarios. The content appears well-organized and researched, but the absence of runnable code or data assets limits its direct utility as a software artifact.