the person behind the notes ✎

Aditya Mishra Technical Lead at BNP Paribas · runs Stacktrick

Full-stack engineer in Mumbai with about ten years of building web applications: Angular and React front ends, Java and Spring Boot services. He runs Stacktrick and decides what it publishes.

LinkedIn →Portfolio →

Views and content on Stacktrick are Aditya's own and don't represent BNP Paribas.

Work

Aditya has worked as a developer in Mumbai since 2016, about 10 years, mostly on enterprise web applications: Angular and React front ends, and Java and Spring Boot services behind them.

  1. Technical Lead, BNP Paribas May 2025 to nowAngular upgrades from v18 to v20, a shared component library and a React platform for SMS templates
  2. Full Stack Developer, Agiloft Dec 2024 to May 2025A Vue.js component monorepo and the gradual move of JSP pages to a single-page app
  3. Senior Software Engineer, HERE Technologies Sep 2022 to Dec 2024Map-based labelling tools in React and OpenLayers, and Spring Boot microservices
  4. Software Engineer, Adzapier Jun 2020 to Sep 2022IAB-certified consent management and Stripe billing
  5. Product Engineer, Moofwd Technologies Feb 2019 to May 2020Mastercard payment products (MPGS, SRC-I and MDES integrations)
  6. PHP Web Engineer, Trycatch Tech Oct 2016 to Feb 2019Laravel e-commerce and an Angular customer portal

Education: M.Sc. in Physics, Dr. Bhimrao Ambedkar University, Agra.

How Stacktrick is made

Stacktrick began as Aditya's personal blog on this domain (2021 to 2024) and relaunched in September 2026 as an interview-prep site. Drafts are prepared with AI tools. Aditya chooses the topics and reviews each guide before it is published; JavaScript, TypeScript and Python examples are run, Java and Angular examples are checked against the documentation, and every guide states the versions its code targets. The editorial policy explains the process and how to report a mistake.

A few guides to start with

All notes →
read ✓SQL & PostgreSQL · easy

SQL Null and Three-Valued Logic

NULL makes comparisons unknown, not false. See how that drops rows from WHERE, empties NOT IN and slips past CHECK constraints.

~6 min readread →
read ✓System Design · mid

System Design: URL Shortener

Size a URL shortener from 100M links a month, pick between counter-based and random codes, and keep a 4,000 req/s redirect path cheap.

~7 min readread →
read ✓HTML & CSS · easy

HTML Headings and Document Navigation

How screen reader users jump between headings, why levels should follow structure rather than font size, and how to fix skipped levels.

~6 min readread →

Cheat sheets

Interview questions by topic

esc