All Sheets
Practical cheat sheets to help you learn and build faster.
Open-Source AI Models – Complete Visual Guide
A 20-page visual guide to open-source AI models, from beginner fundamentals to advanced deployment. Compare Llama, Qwen, DeepSeek, Gemma and other models, learn Ollama and LM Studio, explore hardware requirements, and build AI applications using Python, RAG and fine-tuning.
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.