■ Detailed Tech Stack Interview Cheat Sheet
■ C/C++
RAII: Resource cleanup tied to object lifetime (e.g., file handles).
malloc vs new: malloc allocates raw memory, new calls constructor.
Smart pointers: unique_ptr, shared_ptr prevent memory leaks.
volatile keyword: prevents compiler optimizations on variables that can change unexpectedly.
■ Python
GIL: Only one thread executes Python bytecode at a time in CPython.
List = mutable, Tuple = immutable, Dict = key-value mapping.
Generators (yield) for lazy evaluation.
Virtualenv: python -m venv env → source env/bin/activate
■ HTML/CSS
HTML5 semantic tags: <header>, <section>, <article>, <footer>.
Box model: content → padding → border → margin.
Flexbox (1D) → display:flex; justify-content:center.
Grid (2D) → display:grid; grid-template-columns: repeat(3,1fr).
■ JavaScript
Closures: function with access to outer scope variables.
Event loop: manages call stack, microtasks (Promises), macrotasks (setTimeout).
Debounce: delay execution until user stops typing.
Throttle: run at fixed intervals, e.g., window scroll.
■ React.js
Props = inputs, State = internal data, Hooks manage lifecycle.
useEffect(() => {..}, []) for componentDidMount.
React.memo avoids re-renders if props unchanged.
useMemo caches expensive calculations, useCallback caches function references.
■ Next.js
SSR: Server-Side Rendering per request → getServerSideProps.
SSG: Static Site Generation at build time → getStaticProps.
ISR: Incremental Static Regeneration with revalidate param.
API Routes: /pages/api/*.js for serverless functions.
■ MySQL
ACID: Atomicity, Consistency, Isolation, Durability.
Indexes: CREATE INDEX idx_name ON table(col);
Joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN.
EXPLAIN SELECT * FROM table; → analyze query performance.
■ Node.js
Single-threaded event loop, async non-blocking I/O.
Express middleware → app.use(authMiddleware).
Cluster module for CPU-bound tasks.
npm init -y, npm install express, nodemon.
■ Supabase
Postgres + Realtime + Auth + Storage.
Row-Level Security (RLS) policies secure rows per user.
Auth via JWT tokens → supabase.auth.signIn().
Realtime updates via supabase.channel().
■ AWS
Lambda = serverless, EC2 = VM instances.
S3 storage: aws s3 cp file.txt s3://bucket/.
IAM: define roles/policies with least privilege.
CloudWatch for monitoring logs/metrics.
■ Docker
Image = template, Container = running instance.
docker build -t app . → build image.
docker run -p 3000:3000 app → run container.
docker exec -it container /bin/bash → shell inside container.
docker-compose up -d → run multi-container app.
■ Git
git clone <repo> → copy repository.
git checkout -b feature → new branch.
git merge feature → merge branch.
git rebase main → linear history.
git reset --hard HEAD~1 → undo commit.
git bisect start → binary search for bug.