Skip to main content
Knowledge Hub · Give Back Initiative

HUB_STATUS: OPERATIONAL // 20_YRS_OF_KNOWLEDGE · FREE_ACCESS

Two Decades of Engineering Knowledge,Given Back. For Free.

Thousands of interview questions, real-world errors with root-cause solutions, reusable code archives, and structured learning paths — built through 20 years of actual engineering.

One lamp can light a hundred more without losing its own flame. This knowledge hub is not a product. It is not a funnel. It is a contribution — to every developer who once searched alone at 2 AM for an answer that did not exist anywhere on the internet. It exists now. Here.

"A lamp loses nothing by lighting another lamp. This is why this knowledge exists — not to be held, but to be shared."
— Debasis Bhattacharjee
3,500+
Interview Questions

Across 18 languages & frameworks

1,200+
Debug Solutions

Real errors. Root-cause fixes.

800+
Code Snippets

Copy-paste ready. Production tested.

24
Learning Paths

Beginner → Advanced, structured

Section IV · Knowledge Domains

DOMAINS_MAPPED // PHP · JS · PYTHON · AI · SECURITY · ARCHITECTURE

Explore the Ecosystem

View All Domains →
01 · DOMAIN
Interview Questions

Categorized by language, role, and difficulty. From junior to architect-level. With curated model answers built from real hiring experience.

3,500+ questions Explore →
02 · DOMAIN
Error & Debug Archive

Searchable archive of real runtime errors, stack traces, and exceptions — each with root cause analysis and tested fix. Like Stack Overflow, but curated.

1,200+ solutions Explore →
03 · DOMAIN
Code Snippet Library

Reusable, production-tested code patterns across PHP, Python, JavaScript, VB.NET, SQL and more. No fluff — just working implementations.

800+ snippets Explore →
04 · DOMAIN
System Design Notes

Architecture patterns, design principles, scalability thinking, and real-world system breakdowns explained from an engineer who has built them.

150+ case studies Explore →
05 · DOMAIN
Learning Paths

Structured progression from beginner to professional — curriculum-style roadmaps with sequenced topics, milestones, and recommended resources.

24 paths Explore →
06 · DOMAIN
Security & Ethical Hacking

Penetration testing concepts, vulnerability patterns, OWASP deep dives, and defensive coding practices drawn from real security consulting work.

200+ topics Explore →
Section V · Interview Preparation

INTERVIEW_PREP: ACTIVE // JUNIOR · MID · SENIOR · ARCHITECT

Questions & Answers

All 1,774 Questions →
Q·001 Can you explain what a GraphQL resolver is and how it works within a GraphQL server?
GraphQL Frameworks & Libraries Beginner

A GraphQL resolver is a function responsible for returning data for a specific field in a GraphQL query. When a query is executed, the resolver is called with the relevant parameters and context to fetch the requested data from a data source such as a database or an API.

Deep Dive: Resolvers are fundamental to the operation of a GraphQL server. Each field in a GraphQL schema can have its own resolver function that defines how to retrieve the data for that field. When a query is made, GraphQL calls the respective resolvers for each field requested. Resolvers can invoke other APIs, query databases, or perform any necessary computations to return the data. It is essential to understand that if a resolver is not explicitly defined for a field, GraphQL will look for a default behavior, which typically means returning a property with the same name from the parent object. This allows for flexibility but also requires careful management to ensure data retrieval is efficient and correct, especially in complex schemas with nested fields.

Real-World: In a recent project, we utilized GraphQL to build a product catalog for an e-commerce platform. Each product had fields like 'title', 'price', and 'reviews'. We defined resolvers for each of these fields where the 'reviews' resolver fetched data from a separate microservice. This allowed us to keep our GraphQL server efficient and modular, ensuring that each component could be developed and scaled independently.

⚠ Common Mistakes: One common mistake is not handling errors in resolvers effectively, which can lead to unhelpful error messages or partial data being returned. It's crucial to ensure that error handling is integrated into the resolver logic to provide clear feedback to clients. Another mistake is over-fetching data, where developers might retrieve more information from the database than necessary for the specific fields requested in a query, negatively impacting performance. Resolvers should be designed to fetch only what is needed.

🏭 Production Scenario: In a production environment, a situation might arise where multiple clients are querying for different data shapes and volumes. If resolvers are not optimized, this can lead to performance bottlenecks. For example, a resolver fetching all product data might slow down the server significantly if not filtered correctly. Understanding how to structure and optimize resolvers can help maintain responsiveness in a high-load scenario.

Follow-up questions: What happens if a resolver returns null? How would you implement authorization checks in resolvers? Can a resolver call another resolver? How do you handle caching in GraphQL?

// ID: GQL-BEG-001  ·  DIFFICULTY: 3/10  ·  ★★★☆☆☆☆☆☆☆

Q·002 What are some common security concerns when using GraphQL, and how can they be mitigated?
GraphQL Security Beginner

Common security concerns with GraphQL include exposing sensitive data, denial of service attacks, and overly complex queries. These can be mitigated by implementing query depth limiting, using authorization checks, and input validation.

Deep Dive: GraphQL's flexibility allows clients to request exactly the data they need, but this can also lead to unintentional data exposure if proper attention isn't given to security. For instance, a poorly designed schema might allow clients to query sensitive user data without adequate permissions. Additionally, since clients can make complex queries, they may inadvertently or maliciously overwhelm the server with expensive queries, leading to denial of service. Mitigating these risks involves implementing strict access controls, setting limits on query depth and complexity, and validating inputs thoroughly to prevent injection attacks and other vulnerabilities. Monitoring and logging requests can also help identify unusual patterns or potential attacks.

Real-World: In a web application that uses GraphQL to manage user accounts, a developer noticed that users could access sensitive profile information, including emails and phone numbers, even though they should only see their own data. To address this, the team implemented middleware that checks user's authentication and role before resolving queries. They also set a maximum depth for queries to prevent expensive nested queries that could slow down the server under heavy load.

⚠ Common Mistakes: A common mistake is neglecting to implement authorization checks, which can lead to unauthorized access to sensitive data. Some developers mistakenly assume that since GraphQL exposes a single endpoint, they don’t need to manage permissions rigorously. Another frequent error is failing to impose query complexity limits, which can expose the server to denial of service attacks through overly complex requests. Both mistakes can have severe consequences, including data breaches or performance degradation.

🏭 Production Scenario: In a recent project involving a social media application, our team faced significant challenges with GraphQL queries. An attacker attempted to exploit the system by sending deeply nested queries that caused server slowdowns. We had to quickly implement query complexity analysis to safeguard against these attacks and protect the user experience, highlighting the importance of security considerations in our API design.

Follow-up questions: Can you explain how query depth limiting works? What libraries or tools can help with GraphQL security? How do you implement logging for GraphQL requests? What strategies would you use to handle rate limiting?

// ID: GQL-BEG-002  ·  DIFFICULTY: 3/10  ·  ★★★☆☆☆☆☆☆☆

Q·003 Can you explain what a resolver is in GraphQL and its role in handling queries?
GraphQL API Design Beginner

A resolver in GraphQL is a function responsible for returning the value for a field in a schema. When a query is executed, the GraphQL server calls the corresponding resolvers for each field requested, allowing it to fetch data from various sources like databases or APIs.

Deep Dive: Resolvers serve as the bridge between the GraphQL schema and the actual data. Each field specified in a GraphQL query has a resolver associated with it, which dictates how to fetch the required data. The resolver can take arguments and context, allowing it to be flexible and reusable. It's crucial to ensure that the resolvers are efficient to prevent performance bottlenecks, especially in scenarios with nested queries or large datasets where multiple resolvers may be called in a single request. Additionally, error handling within resolvers is important to manage any potential issues that arise when fetching data from external sources or databases. Without proper error management, users can experience vague error messages or broken responses.

Real-World: In a production e-commerce application, a resolver might handle a query for a product's details. When a client requests product information, the resolver fetches data from a database, retrieves the product attributes like name, price, and description, and then formats the response according to the GraphQL schema. If the product has related items, a nested resolver could be called to retrieve those related products, showcasing how resolvers can work together to compose more complex data structures.

⚠ Common Mistakes: One common mistake developers make is not properly handling asynchronous operations in resolvers, which can lead to unhandled promise rejections or slow responses. Additionally, developers sometimes forget to validate the input arguments, which can result in incorrect queries or even security vulnerabilities. Another frequent error is not leveraging batching and caching strategies, leading to excessive database calls and performance degradation, especially when resolving multiple fields in a single request.

🏭 Production Scenario: In a recent project, we faced performance issues due to inefficient resolvers that executed multiple redundant database queries for a single GraphQL request. This situation highlighted the importance of optimizing resolvers and implementing data loading techniques like batching to minimize the number of calls to the database. By adjusting our resolvers to utilize a data loader, we significantly improved response times and reduced the load on the database.

Follow-up questions: Can you describe how you would structure resolvers for a complex schema? What are some strategies to optimize resolver performance? How do you handle errors in resolvers? Can you explain the difference between parent and child resolvers?

// ID: GQL-BEG-003  ·  DIFFICULTY: 3/10  ·  ★★★☆☆☆☆☆☆☆

Q·004 Can you explain what a GraphQL query is and how it differs from a traditional REST API request?
GraphQL Language Fundamentals Beginner

A GraphQL query is a request made to a GraphQL server to fetch specific data in a structured format. Unlike REST API requests, which often return fixed structures, GraphQL queries allow clients to specify exactly what data they need, which can reduce over-fetching and under-fetching issues.

Deep Dive: GraphQL queries enable clients to precisely request the data they need, thereby optimizing network usage and improving application efficiency. This specificity allows for nested querying, meaning clients can fetch related resources in a single request. In contrast, REST APIs provide fixed endpoints that return predetermined data shapes, forcing clients to adapt to these structures. This often leads to situations where a client may receive excess data or require multiple requests to gather related information, which GraphQL effectively addresses by allowing a single request to retrieve all necessary entities at once. Additionally, GraphQL can return errors alongside data, providing more contextual information in responses compared to traditional REST APIs.

Real-World: In a social media application, a REST API might have separate endpoints for fetching user profiles, posts, and comments, requiring multiple requests to build a complete user view. In contrast, a GraphQL query can fetch a user's profile, their posts, and the associated comments all in one request, significantly reducing the number of network calls and allowing the frontend to quickly render the full user experience without waiting for multiple responses.

⚠ Common Mistakes: One common mistake is underestimating how deeply nested queries can impact performance. While GraphQL allows for extensive querying, overly complex requests can lead to slower responses if the server is not optimized. Another mistake is not implementing proper authorization and validation logic for incoming queries. Since clients can request any shape of data, failing to secure sensitive information can lead to data leaks if the developer is not cautious about the data exposed through the GraphQL schema.

🏭 Production Scenario: In a recent project at a tech company, we transitioned from REST to GraphQL to improve our application's data handling. We faced challenges where frontend developers needed additional fields for user data that REST endpoints did not provide. With GraphQL, they could request the exact fields needed for different views, which streamlined the development process and improved client performance, ultimately enhancing user experience by reducing loading times.

Follow-up questions: Can you describe how you would handle authentication in GraphQL? What are some strategies to optimize GraphQL queries? How would you handle versioning with GraphQL? Can you explain the role of mutations in GraphQL?

// ID: GQL-BEG-004  ·  DIFFICULTY: 3/10  ·  ★★★☆☆☆☆☆☆☆

Section VI · Error & Debug Archive

DEBUG_ARCHIVE: LIVE // REAL_ERRORS · ANNOTATED_FIXES

Real Errors. Root-Cause Fixes.

All 1,200 Solutions →
PHP ERROR E_FATAL · #DB-001
Undefined variable: $conn — PDO connection not persisted across scope
Fatal error: Uncaught Error: Call to a member function query() on null

Connection object passed by value. Fix: pass by reference or use dependency injection through constructor.

4,200 views Read Fix →
JAVASCRIPT RUNTIME · #JS-044
Cannot read properties of undefined — React state not yet populated on first render
TypeError: Cannot read properties of undefined (reading 'map')

State initialized as undefined, not empty array. Fix: initialize with useState([]) and guard with optional chaining.

7,800 views Read Fix →
SQL ERROR CONSTRAINT · #SQL-019
Foreign key constraint fails on INSERT — parent row not found in referenced table
ERROR 1452: Cannot add or update a child row: a foreign key constraint fails

Insertion order violation. Fix: insert parent record first, or disable FK checks during bulk migration with SET FOREIGN_KEY_CHECKS=0.

3,100 views Read Fix →
PYTHON IMPORT · #PY-007
ModuleNotFoundError in virtual environment — pip installed globally but not inside venv
ModuleNotFoundError: No module named 'requests'

Package installed to system Python, not active venv. Fix: activate venv first, then pip install. Verify with which python.

5,400 views Read Fix →
VB.NET RUNTIME · #VB-031
NullReferenceException on DataGridView load — DataSource bound before data fetched
System.NullReferenceException: Object reference not set to an instance

Binding fires before async fetch completes. Fix: await the data load, then set DataSource. Use BindingSource for dynamic updates.

2,700 views Read Fix →
WORDPRESS PLUGIN · #WP-012
White Screen of Death after plugin activation — memory limit exhausted on init hook
Fatal error: Allowed memory size of 67108864 bytes exhausted

Plugin loading heavy library on every request. Fix: lazy-load on relevant admin pages only. Increase WP_MEMORY_LIMIT in wp-config as temporary measure.

6,200 views Read Fix →
Section VII · Code Archive

Copy. Adapt. Ship.

All 800 Snippets →
PHP · PATTERN
Singleton Database Connection

Thread-safe PDO connection with single instance guarantee. Works with MySQL, PostgreSQL, SQLite.

private static ?self $instance = null;
12 uses this week View →
PYTHON · UTILITY
Rate-Limited API Client

Async HTTP client with automatic retry, exponential backoff, and per-domain rate limiting.

async def fetch_with_retry(url, max=3):
28 uses this week View →
SQL · QUERY
Recursive CTE Hierarchy

Self-referencing table traversal for category trees, org charts, and menu structures using Common Table Expressions.

WITH RECURSIVE tree AS (SELECT ...)
19 uses this week View →
JAVASCRIPT · HOOK
Custom useDebounce Hook

React hook for debouncing search inputs, form fields, and resize events. Prevents excessive API calls.

const useDebounce = (value, delay) => {
41 uses this week View →
Section VIII · Structured Learning

LEARNING_PATHS: READY // 4_TRACKS · STRUCTURED · MENTOR_GUIDED

Learning Paths

All 24 Paths →

PHP Developer: Zero to Production

Beginner

From syntax fundamentals to building RESTful APIs and WordPress plugins. Designed for complete beginners with no prior programming background.

PHP Syntax & Data Types
OOP: Classes, Interfaces, Traits
Database: PDO & MySQL
REST API Design
WordPress Plugin Development
18 modules · ~40 hrs Start Path →

Full-Stack JavaScript: React + Node

Mid-Level

Modern full-stack development with React, Node.js, Express, and PostgreSQL. Includes deployment, auth, and real project builds.

Modern ES2024 JavaScript
React: State, Hooks, Context
Node.js & Express APIs
Auth: JWT & OAuth 2.0
CI/CD & Deployment
22 modules · ~60 hrs Start Path →

Software Architecture Mastery

Advanced

Design patterns, SOLID principles, microservices, event-driven architecture, and real-world system design interview preparation.

Design Patterns: GoF 23
Domain-Driven Design
Microservices & Event Bus
Scalability Patterns
System Design Interviews
16 modules · ~35 hrs Start Path →

AI Integration for Developers

Mid-Level

Practical AI integration using Claude API, OpenAI, and MCP. Build real AI-powered applications, tools, and automation workflows.

LLM Fundamentals & Prompting
Claude API & OpenAI SDK
Model Context Protocol (MCP)
RAG Systems & Embeddings
Deploying AI-Powered Apps
14 modules · ~28 hrs Start Path →

"The best engineering knowledge is not found in textbooks — it is extracted from late nights, broken builds, angry clients, and the stubborn refusal to stop until the problem is solved."

— Debasis Bhattacharjee · Software Architect · 20 Years in Production

Section X · The Ecosystem Grows

ARCHIVE_GROWING // CONTRIBUTIONS_OPEN · LIVING_DOCUMENT

This Is a Living Archive. Not a Static Library.

Every week, new errors are documented, new interview patterns are added, and new solutions are tested in production. The knowledge hub grows because real problems keep appearing — and every answer earns its place here by actually working.

If you found a fix that saved your project, or spotted an answer that could be better — the door is always open. This ecosystem belongs to everyone who uses it.

Submit via Email
Send your question, error, or solution directly
Submit →
Leave a Testimonial
Did something here help you? Share your experience
Share →
Comment on Facebook
Find us at @iamdebasisbhattacharjee
Visit →
Get Update Alerts
Subscribe to be notified of new additions
Subscribe →
Section XI · Let's Talk

Knowledge is Free.
Mentorship is Personal.

The hub is open to everyone — but if you need structured guidance, 1-on-1 mentorship, or corporate training, that's a different conversation. Let's have it.

hello@debasisbhattacharjee.com  ·  +91 8777088548  ·  Mon–Fri, 9AM–6PM IST