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.
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.
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.