All Sheets
Practical cheat sheets to help you learn and build faster.
How a Database Index Speeds Up Queries
A visual guide to SQL database indexes, explaining full table scans vs index seeks, B+trees, composite indexes, query planners, and performance optimization through diagrams, real EXPLAIN results, and practical SQL examples.
Why Is My Python App Slow?
An 8-page visual troubleshooting guide to finding and fixing slow Python applications. Diagnose CPU, I/O, memory, concurrency, database, and GPU bottlenecks with profiling tools, decision trees, code examples, and a step-by-step optimization workflow.
Which Database Fits My Project?
An 8-page visual decision guide to choosing the right database for your project. Compare PostgreSQL, MySQL, SQLite, MongoDB, Redis, and more using a nine-question flowchart, practical scenarios, architecture diagrams, and SQL/NoSQL examples.
Turn Any Software Idea Into an AI-Ready Specification
Learn how to turn vague software ideas into clear, testable specifications for AI coding assistants using a 7-layer framework, requirement templates, practical prompts, and a complete worked example.
HTTP vs API vs REST
Understand the difference between HTTP, APIs, and REST with clear diagrams, real request/response examples, HTTP methods, status codes, authentication, REST principles, and practical Python examples.
Vector Search vs Traditional Search — Visual Guide to BM25, Embeddings & Hybrid Search
A 13-page visual guide comparing keyword (BM25), vector, and hybrid search, with embedding models, ANN indexes, FAISS and Elasticsearch examples, ranking techniques, and evaluation checklists.
Which Database Should I Use?
A 10-page visual guide to choosing the right database for your application. Compare SQL, NoSQL, document, key-value, graph, time-series, vector, search and OLAP databases, with practical decision rules, architecture patterns, scaling guidance and real-world examples.
AI Chatbot Website — Complete Architecture & Development Guide
A visual, practical guide to building an AI chatbot website, covering architecture, streaming, memory, RAG, tool use, security, authentication, cost optimization, evaluation, and launch.