DEV Community: Kishan vyas

Interview Questions💥: Git/GitHub · PostgreSQL · MongoDB · Python

Kishan vyas — Mon, 20 Apr 2026 18:15:47 +0000

The Ultimate Backend Interview Question Bank

If you're preparing for a backend or full-stack role - or just want to solidify your foundations - this is the most comprehensive question bank I've put together.

This covers everything that actually comes up in real interviews: from Git workflows and database internals to Python deep dives, system design, concurrency, and algorithms. Whether you're a fresher prepping for your first SDE role or an experienced dev brushing up before switching jobs, there's something here for every level.

I've organized it into 22 sections so you can target exactly what you need, skip what you know, deep-dive what you don't.

How to use this: Don't try to memorize answers. Use these as prompts to understand the concept. If you can explain it out loud in plain English, you know it.

What's covered

#	Topic
1	Git & GitHub
2	PostgreSQL
3	MongoDB
4–20	Python (Basics, OOP, Concurrency, Memory, Testing & more)
21	System Design & Architecture
22	Data Structures & Algorithms

Git & GitHub
PostgreSQL
MongoDB
Python — Basics & Built-ins
Python — Data Structures & Collections
Python — Functions & Functional Programming
Python — OOP (Object-Oriented Programming)
Python — Modules, Packages & Imports
Python — File Handling & I/O
Python — Error & Exception Handling
Python — Iterators, Generators & Comprehensions
Python — Decorators & Context Managers
Python — Concurrency & Parallelism
Python — Memory Management & Internals
Python — Standard Library & Useful Modules
Python — Type Hints & Annotations
Python — Testing
Python — Database Integration
Python — Web & APIs
Python — Advanced Topics
System Design / Architecture Questions
Data Structures & Algorithms (Bonus)

1. Git & GitHub

🔹 Conceptual Questions

What is Git? How is it different from GitHub?
What is the difference between git fetch and git pull?
What is the difference between git merge and git rebase? When would you use each?
What is a detached HEAD state? How do you get into it and how do you recover?
What is the difference between git reset, git revert, and git restore?
What is git stash? When would you use it?
What is git cherry-pick? Give a use case.
What is the difference between --soft, --mixed, and --hard in git reset?
What is a Git hook? Give examples of pre-commit and post-commit hooks.
What is git bisect? How does it help in debugging?
What is the difference between origin and upstream in Git?
What is a .gitignore file? How do you ignore an already tracked file?
What is the difference between a tag and a branch?
What is git reflog and when is it useful?
What is the difference between a fast-forward merge and a three-way merge?

🔹 Branching & Workflow Questions

Explain the Git Flow branching strategy.
What is trunk-based development? How is it different from Git Flow?
What is the purpose of a develop, main, release, and hotfix branch?
How do you handle a situation where two developers edit the same file?
What is a pull request / merge request? What is its purpose beyond code merging?
How do you squash commits before merging a PR?
What is code review? What do you look for in a code review?

🔹 Scenario-Based Questions

Scenario: You accidentally committed sensitive credentials to a public repo. What do you do?
Scenario: You have a bug in production. Your last 5 commits are all broken. How do you roll back safely without losing other developers' work?
Scenario: You are working on a feature branch for 2 weeks. The main branch has moved ahead by 30 commits. How do you bring your branch up to date?
Scenario: You need to move the last 3 commits from main to a new feature branch because you committed to the wrong branch.
Scenario: Two team members have merge conflicts on the same PR. How do you resolve it?
Scenario: Your git pull fails due to diverged branches. What are your options?
Scenario: You want to apply a bug fix from one branch to multiple other branches. What do you do?
Scenario: A junior developer force-pushed to the shared main branch and erased commits. How do you recover?

🔹 GitHub Specific Questions

What is GitHub Actions? How does a CI/CD pipeline work with it?
What is the difference between a fork and a clone?
What are GitHub branch protection rules? Why are they important?
What is CODEOWNERS in GitHub?
What is the difference between Issues, Milestones, and Projects in GitHub?

2. PostgreSQL

🔹 Conceptual / Fundamentals

What is PostgreSQL? How is it different from MySQL?
What are the ACID properties? Explain each with an example.
What is the difference between CHAR, VARCHAR, and TEXT in PostgreSQL?
What is the difference between SERIAL, BIGSERIAL, and UUID as primary key types?
What is a schema in PostgreSQL? How is it different from a database?
What is the difference between TRUNCATE, DELETE, and DROP?
What are sequences in PostgreSQL? How do you create and use them?
What is the difference between IS NULL and = NULL?
What is COALESCE? Give a practical example.
What are CTEs (Common Table Expressions)? How are they different from subqueries?

🔹 Joins & Queries

What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN?
What is a CROSS JOIN? When would you use it?
What is a SELF JOIN? Give a real-world example.
What is the difference between UNION and UNION ALL?
What is the difference between WHERE and HAVING?
What is the DISTINCT ON clause in PostgreSQL?
What is a window function? Explain ROW_NUMBER(), RANK(), DENSE_RANK(), and LAG()/LEAD().
Write a query to find the second highest salary from an employees table.
Write a query to find duplicate records in a table.
Write a query to delete duplicate rows while keeping one.

🔹 Indexing & Performance

What is an index? What are the types of indexes in PostgreSQL?
What is the difference between a B-Tree index and a Hash index?
What is a partial index? When is it useful?
What is a composite index? What is column order importance?
What is EXPLAIN and EXPLAIN ANALYZE? How do you read a query plan?
What is a table scan vs an index scan vs an index-only scan?
What causes an index not to be used by the query planner?
What is vacuuming in PostgreSQL? Why is it needed?
What is pg_stat_activity? What do you use it for?
What is connection pooling? Why is it important in PostgreSQL?

🔹 Transactions & Concurrency

What are transaction isolation levels in PostgreSQL?
What is the difference between READ COMMITTED and REPEATABLE READ?
What is a dirty read, non-repeatable read, and phantom read?
What is SELECT FOR UPDATE? When do you use it?
What is a deadlock in PostgreSQL? Give a real-world scenario.
How does PostgreSQL handle deadlock detection?
What is MVCC (Multi-Version Concurrency Control)?
What is an optimistic lock vs a pessimistic lock?
What is SAVEPOINT in a transaction?
What is a two-phase commit?

🔹 Schema Design & Advanced

What is normalization? Explain 1NF, 2NF, 3NF, and BCNF.
What is denormalization? When is it preferred?
What is a foreign key constraint? What are ON DELETE CASCADE and ON DELETE SET NULL?
What is a CHECK constraint? Give an example.
What is a UNIQUE constraint vs a PRIMARY KEY?
What is a materialized view? How is it different from a regular view?
What are table partitioning strategies in PostgreSQL?
What is JSON vs JSONB in PostgreSQL? When would you use each?
What is full-text search in PostgreSQL? What are tsvector and tsquery?
What is the pg_dump and pg_restore tool? How do you take backups?

🔹 PostgreSQL vs MySQL

What are the key differences between PostgreSQL and MySQL?
Why would you choose PostgreSQL over MySQL for a new project?
Which supports better ACID compliance — PostgreSQL or MySQL (InnoDB)?
How does PostgreSQL handle JSON differently from MySQL?
What are the replication options in PostgreSQL vs MySQL?

3. MongoDB

🔹 Conceptual / Fundamentals

What is MongoDB? How is it different from a relational database?
What is a document in MongoDB? What format does it use?
What is a collection? How is it different from a table in SQL?
What is the _id field in MongoDB? Can you override it?
What is BSON? How is it different from JSON?
What are the different data types supported in MongoDB?
What is MongoDB Atlas? How is it different from self-hosted MongoDB?
What is the difference between insertOne(), insertMany(), and bulkWrite()?
What is the difference between findOne() and find()?
What is a cursor in MongoDB?

🔹 Querying

How do you perform conditional queries using $gt, $lt, $gte, $lte, $ne?
What is the $in operator? Give an example.
What is the $and, $or, $not, and $nor operator?
How do you query nested documents in MongoDB?
How do you query array fields using $elemMatch?
What is the $regex operator in MongoDB?
How do you perform a text search in MongoDB?
What is the $exists operator?
How do you sort and limit query results in MongoDB?
What is projection in MongoDB? How do you include/exclude fields?

🔹 Aggregation

What is the Aggregation Pipeline in MongoDB?
Explain the following stages: $match, $group, $sort, $project, $limit, $skip, $unwind, $lookup.
What is $lookup? How does it compare to SQL JOINs?
What is $unwind? When is it useful?
Write an aggregation pipeline to find the total sales per product category.
What is $facet in MongoDB aggregation?
What is $bucket and $bucketAuto?
What is $addFields vs $project?
What is the difference between $sum, $avg, $min, $max in $group?
What is $graphLookup? When is it used?

🔹 Indexing & Performance

What types of indexes does MongoDB support?
What is a compound index in MongoDB? What is field order significance?
What is a multikey index? When is it automatically created?
What is a text index in MongoDB?
What is a TTL (Time-To-Live) index? Give a use case.
What is the explain() method? What does executionStats tell you?
What is a covered query in MongoDB?
What is the $hint operator in MongoDB?
What is index intersection in MongoDB?
What is the WiredTiger storage engine?

🔹 Schema Design & Modeling

What is embedding vs referencing in MongoDB schema design?
When should you embed documents vs reference them?
What is the one-to-many relationship pattern in MongoDB?
What is the many-to-many relationship pattern in MongoDB?
What is the Bucket Pattern in MongoDB?
What is the Outlier Pattern?
What is the Subset Pattern?
What is the Extended Reference Pattern?
What is schema validation in MongoDB?
What is GridFS? When do you use it?

🔹 Transactions & Replication

Does MongoDB support ACID transactions? Since which version?
What is a replica set in MongoDB?
What is a primary and secondary node? What happens if the primary goes down?
What is read preference in MongoDB?
What is write concern in MongoDB?
What is a sharded cluster in MongoDB?
What is a shard key? How do you choose a good one?
What is the difference between a hashed shard key and a ranged shard key?
What is an oplog in MongoDB?
What is change streams in MongoDB?

4. Python — Basics & Built-ins

🔹 Language Fundamentals

What is Python? What makes it different from compiled languages like Java or C++?
What is PEP 8? Why does it matter?
What is the difference between Python 2 and Python 3?
Is Python interpreted or compiled? Explain the execution model.
What is a .pyc file? What is the __pycache__ directory?
What are Python's key features? (dynamic typing, garbage collection, etc.)
What is the difference between == and is?
What is the difference between mutable and immutable objects? Give examples of each.
What is dynamic typing in Python?
What is duck typing?

🔹 Variables & Data Types

What are Python's built-in data types?
What is the difference between int, float, complex?
What is None in Python? What type is it?
What is the difference between str, bytes, and bytearray?
How does Python handle integer overflow?
What is the difference between True/False and 1/0 in Python?
What is type casting? How do you convert between types?
What is id() in Python? What does it return?
What is integer caching (interning) in Python? (caches -5 to 256)
What is string interning in Python?

🔹 Operators

What are Python's arithmetic operators?
What is the difference between / and // in Python?
What is the % operator? What is it used for beyond modulo?
What is the ** operator?
What are comparison operators and what do they return?
What are Python's logical operators (and, or, not)? How do they short-circuit?
What are bitwise operators in Python? (&, |, ^, ~, <<, >>)
What is the walrus operator (:=)? Give a use case.
What are augmented assignment operators?
What is operator precedence in Python?

🔹 Control Flow

What is the difference between if, elif, and else?
What is a ternary expression in Python?
What is the difference between for and while loops?
What is the else clause on a for or while loop? When does it execute?
What is break, continue, and pass?
What is range()? How is it memory efficient?
What is enumerate()? Why is it preferred over using an index?
What is zip()? What happens if the iterables are of different lengths?
What is reversed()? How is it different from [::-1]?
What is sorted() vs .sort()? What is the key argument?

🔹 Strings

Is a Python string mutable or immutable?
What is string slicing? Give examples including step slicing.
What are f-strings? How do they compare to .format() and % formatting?
What is the difference between split() and rsplit()?
What is join()? Why is it preferred over string concatenation in a loop?
What are common string methods: strip(), lstrip(), rstrip(), replace(), find(), count(), startswith(), endswith()?
What is encode() and decode() in Python strings?
What is a raw string (r"...")? When do you use it?
What is string multiplication and string addition?
How does Python handle Unicode strings?

5. Python — Data Structures & Collections

🔹 Lists

How is a Python list stored in memory?
What is the time complexity of common list operations: append, insert, delete, search, access by index?
What is the difference between append() and extend()?
What is list.copy() vs list[:] vs copy.copy()?
What is list.pop() vs del list[i] vs list.remove()?
How does sort() work internally? What algorithm does Python use? (Timsort)
What is list.index() vs list.count()?
What is a 2D list? How do you create and access elements?
How do you flatten a nested list in Python?
What is the difference between list * n and [list] * n? (shallow copy trap)

🔹 Tuples

What is a tuple? How is it different from a list?
Can you modify elements inside a tuple? What about mutable elements inside a tuple?
What is tuple unpacking? Give examples.
What is the * operator in tuple unpacking?
What is a named tuple? How do you create one?
Why are tuples faster than lists?
When should you use a tuple over a list?
What is a single-element tuple? What is the syntax pitfall?
How do you convert a list to a tuple and vice versa?
Can tuples be used as dictionary keys? Why?

🔹 Dictionaries

How is a Python dictionary implemented internally? (hash table)
What is the time complexity of dictionary operations (get, set, delete)?
What is the difference between dict.get() and dict[key]?
What is dict.setdefault()?
What is collections.defaultdict? Give a use case.
What is collections.OrderedDict? Is it still necessary in Python 3.7+?
What is collections.Counter? Give a use case.
What are dictionary views: keys(), values(), items()?
How do you merge two dictionaries? (multiple ways: |, update(), **unpacking)
What is a dictionary comprehension?
What is dict.update()?
What is dict.pop() vs del dict[key]?
What is dict.fromkeys()?
How do you sort a dictionary by value?
What is a nested dictionary? How do you safely access nested keys?

🔹 Sets

What is a Python set? What are its properties?
What is the time complexity of in for a set vs a list?
What are set operations: union (|), intersection (&), difference (-), symmetric difference (^)?
What is the difference between set.discard() and set.remove()?
What is a frozenset? How is it different from a set?
Can a set contain another set? What about a list? Why?
What is set.update() vs |=?
How do you find common elements between two lists efficiently?
What is set.issubset() and set.issuperset()?
How do you remove duplicates from a list using a set?

🔹 Collections Module

What is collections.deque? Why is it better than a list for queues?
What is the time complexity of deque.appendleft() vs list.insert(0, x)?
What is collections.ChainMap?
What is collections.namedtuple vs a regular tuple vs a dataclass?
What is collections.UserDict, UserList, UserString and when do you use them?

6. Python — Functions & Functional Programming

🔹 Function Basics

How do you define a function in Python?
What is the difference between a parameter and an argument?
What are default arguments? What is the mutable default argument trap?
What is *args? How is it different from a list parameter?
What is **kwargs? How is it different from a dict parameter?
What is the order of parameters: positional, *args, keyword-only, **kwargs?
What is a keyword-only argument (parameters after *)?
What is a positional-only argument (parameters before /)? (Python 3.8+)
What is the return statement? Can a function return multiple values?
What happens if a function has no return statement?

🔹 Scope & Closures

What is the LEGB rule in Python (Local, Enclosing, Global, Built-in)?
What is the global keyword? When would you use it?
What is the nonlocal keyword? Give a use case.
What is a closure in Python?
What is a free variable?
How do closures capture variables? What is the late binding problem?
Write a counter function using closures.
What is the difference between a closure and a class?
What is a first-class function in Python?
What is a higher-order function?

🔹 Lambda & Functional Tools

What is a lambda function? What are its limitations?
What is map()? Give an example.
What is filter()? Give an example.
What is reduce() from functools? Give an example.
What is functools.partial()? Give a use case.
What is functools.lru_cache()? How does it work?
What is functools.wraps()? Why is it needed in decorators?
What is functools.total_ordering()?
What is functools.cache() vs lru_cache()?
What is operator module? Give examples of operator.itemgetter and operator.attrgetter.

🔹 Recursion

What is recursion? What is a base case?
What is the maximum recursion depth in Python? How do you change it?
What is tail recursion? Does Python optimize tail calls?
Write a recursive function for factorial.
Write a recursive function for Fibonacci. What is its time complexity?
What is memoization? How does it improve recursive functions?
What is the difference between recursion and iteration?
What is mutual recursion?
What is a recursive data structure?
When should you avoid recursion in Python?

7. Python — OOP (Object-Oriented Programming)

🔹 Classes & Objects

What is the difference between a class and an object (instance)?
What is self? Why is it the first parameter of instance methods?
What is __init__? How is it different from __new__?
What are class variables vs instance variables? What happens when they share a name?
What is __dict__ on a class and on an instance?
What is vars() in Python?
What is dir() in Python?
What is hasattr(), getattr(), setattr(), delattr()?
How do you check if an object is an instance of a class? (isinstance())
How do you check if a class is a subclass of another? (issubclass())

🔹 The Four Pillars

What is Encapsulation? How do you implement it in Python?
What is the difference between _name (convention), __name (name mangling), and __name__ (dunder)?
What is Abstraction? How does it differ from encapsulation?
What is Inheritance? Give an example.
What is single vs multiple inheritance in Python?
What is the MRO (Method Resolution Order)? What is the C3 linearization algorithm?
How do you find the MRO of a class? (ClassName.__mro__ or mro())
What is Polymorphism? Give a Python example.
What is method overriding? How does it work in Python?
Does Python support method overloading? How do you simulate it?

🔹 Special / Dunder Methods

What is __str__ vs __repr__? Which is called in which situation?
What is __len__?
What is __getitem__, __setitem__, __delitem__?
What is __iter__ and __next__?
What is __contains__ (enables in operator)?
What is __call__? How do you make an object callable?
What is __eq__, __lt__, __gt__, __le__, __ge__, __ne__?
What is __add__, __sub__, __mul__, __truediv__? (operator overloading)
What is __enter__ and __exit__? (context manager protocol)
What is __slots__? What are its advantages and limitations?
What is __init_subclass__? Give a use case.
What is __del__? When is it called? Is it reliable?
What is __hash__? What is the relationship between __eq__ and __hash__?
What is __bool__? When is it called vs __len__?
What is __missing__ in a dict subclass?

🔹 Class Methods & Properties

What is @staticmethod? When would you use it?
What is @classmethod? When would you use it?
What is the difference between @staticmethod and @classmethod?
What is @property? What is a getter and setter in Python?
What is a @property.setter and @property.deleter?
When would you use a property vs a regular method?
What is a class factory method? Give an example.
What is __new__ used for? Give a practical example (e.g., Singleton).
What is type() used as a metaclass? How do you create a class dynamically?
What is object.__class__?

🔹 Inheritance & Advanced OOP

What is super()? How does it work with multiple inheritance?
What is a mixin? Give a real-world use case.
What is composition vs inheritance? When do you prefer composition?
What is an abstract class? How do you create one using the abc module?
What is @abstractmethod? What happens if you don't implement it?
What is the difference between an abstract class and an interface (Protocol)?
What is typing.Protocol? How is it used for structural subtyping?
What is a dataclass (@dataclass)? What does it auto-generate?
What are the parameters of @dataclass: frozen, order, eq, repr?
What is field() in dataclasses? What is default_factory?
What is __post_init__ in dataclasses?
What is NamedTuple vs dataclass vs regular class?
What is the Enum class? How do you define an enumeration?
What is IntEnum, StrEnum, Flag, IntFlag?
What is a descriptor in Python? What are __get__, __set__, __delete__?

🔹 Design Patterns

Implement the Singleton pattern in Python (at least 2 ways).
Implement the Factory pattern in Python.
Implement the Abstract Factory pattern.
Implement the Observer pattern in Python.
Implement the Strategy pattern in Python.
Implement the Decorator design pattern (not Python @decorator) in Python.
Implement the Command pattern in Python.
Implement the Iterator pattern using __iter__ and __next__.
What is dependency injection? Give a Python example.
What is the Repository pattern and why is it used with databases?

8. Python — Modules, Packages & Imports

🔹 Modules & Packages

What is a module in Python?
What is a package? What is __init__.py? What is a namespace package?
What is the difference between import module and from module import name?
What is import *? Why is it discouraged?
What is __all__ in a module?
What is a relative import vs absolute import?
What is importlib? How do you import a module dynamically?
What is sys.path? How does Python find modules?
What is __name__ == "__main__"? Why is it used?
What is the difference between a script and a module?
What is __file__ in a module?
How do you reload a module at runtime?
What is a circular import? How do you resolve it?
What is a virtual environment? Why is it important?
What is __package__ attribute?

🔹 Package Management

What is pip? How do you install, uninstall, upgrade, and list packages?
What is requirements.txt? How do you generate it?
What is the difference between pip install and pip install -e (editable mode)?
What is pyproject.toml? How is it different from setup.py?
What is venv vs virtualenv vs conda?

9. Python — File Handling & I/O

🔹 File Operations

How do you open a file in Python? What are the different modes (r, w, a, rb, wb, r+)?
What is the with statement for file handling? Why is it preferred?
What is the difference between read(), readline(), and readlines()?
What is the difference between write() and writelines()?
What is seek() and tell()?
How do you check if a file exists?
How do you copy, move, rename, and delete files in Python?
What is os.path vs pathlib.Path? Which is preferred and why?
How do you list files in a directory? How do you walk a directory tree?
What is glob? Give a use case.
How do you read a large file line by line without loading it into memory?
What is tempfile module? When do you use it?
What is shutil? What can it do?
How do you work with CSV files in Python? (csv module)
How do you work with JSON files in Python?

🔹 Serialization

What is pickle? What are the security risks of using it?
What is json.dumps() vs json.dump()? What is the difference?
What is json.loads() vs json.load()?
What is the indent and separators argument in json.dumps()?
What is shelve? When would you use it?

10. Python — Error & Exception Handling

🔹 Exception Basics

What is an exception in Python? How is it different from a syntax error?
What is the difference between Exception and BaseException?
What are built-in exceptions? Name at least 15. (ValueError, TypeError, KeyError, IndexError, AttributeError, NameError, ImportError, OSError, RuntimeError, StopIteration, NotImplementedError, ZeroDivisionError, OverflowError, MemoryError, RecursionError)
What is the exception hierarchy in Python?
What is try, except, else, finally?
What is the else clause in a try block? When does it run?
What is the finally clause? Does it always execute?
Can you have multiple except blocks? Can you catch multiple exceptions in one block?
What is the order of except blocks? Does it matter? (more specific first)
What is a bare except:? Why is it dangerous?

🔹 Raising & Custom Exceptions

What is raise? How do you re-raise the current exception?
What is raise ... from ...? What does it do to the traceback?
How do you create a custom exception class?
What is exception chaining? What is __cause__ and __context__?
What is warnings module? How is it different from exceptions?
What is contextlib.suppress()?
What is ExceptionGroup in Python 3.11+?
What is except* syntax in Python 3.11+?
What is sys.exc_info()?
Best practices: When should you catch exceptions broadly vs specifically?

11. Python — Iterators, Generators & Comprehensions

🔹 Iterators & Iterables

What is an iterable? What is an iterator?
What is the iterator protocol? (__iter__ and __next__)
What is StopIteration? How is it raised?
What is the difference between calling iter() and next() built-ins?
What is lazy evaluation? How do iterators implement it?
What is itertools module? Name at least 10 functions from it.
What is itertools.chain()?
What is itertools.islice()?
What is itertools.product()?
What is itertools.groupby()? What is its sorting requirement gotcha?
What is itertools.cycle()?
What is itertools.accumulate()?
What is itertools.combinations() vs itertools.permutations()?
What is itertools.zip_longest()?
What is itertools.starmap()?

🔹 Generators

What is a generator function? What makes it a generator?
What is yield? How is it different from return?
What is yield from? Give a use case.
What is a generator expression? How does it differ from a list comprehension?
How does send() work on a generator?
How does throw() work on a generator?
How does close() work on a generator? What exception is raised internally? (GeneratorExit)
What are the states of a generator? (created, running, suspended, closed)
What are the memory advantages of generators over lists?
Write an infinite generator for Fibonacci numbers.
What is next() with a default value?
Write a generator pipeline for processing large files.
What is inspect.isgenerator() vs inspect.isgeneratorfunction()?
What is types.GeneratorType?
How do you convert a generator to a list? What are the implications?

🔹 Comprehensions

What is a list comprehension? What is its syntax?
What is a dictionary comprehension?
What is a set comprehension?
What is a generator expression vs a list comprehension?
Can you have nested comprehensions? Give an example.
What are the performance implications of list comprehensions vs for loops?
What is a conditional comprehension (with if clause as filter)?
What is the difference between [x for x in range(10) if x > 5] and [x if x > 5 else 0 for x in range(10)]?
When should you NOT use a comprehension?
What is variable leaking in Python 2 list comprehensions vs Python 3?

12. Python — Decorators & Context Managers

🔹 Decorators

What is a decorator in Python?
How do you write a simple function decorator?
What is functools.wraps()? Why must you use it in decorators?
What is a decorator with arguments? How do you write one (decorator factory)?
What is a class-based decorator? How does __call__ enable it?
What is the order of stacked decorators? Which applies first?
Write a decorator that measures function execution time.
Write a decorator that retries a function on exception (with max retries).
Write a decorator that caches function results (manual lru_cache).
Write a decorator that validates function argument types.
What is @staticmethod, @classmethod, @property — are these decorators?
What is @functools.lru_cache? What are maxsize and typed parameters?
What is @functools.cached_property? How is it different from @property?
What is a parametrized decorator factory?
What are real-world use cases for decorators? (logging, auth, rate limiting, caching, timing)

🔹 Context Managers

What is a context manager? What protocol does it use?
What is __enter__ and __exit__?
What do the arguments of __exit__(exc_type, exc_val, exc_tb) mean?
How do you suppress an exception inside __exit__?
What is contextlib.contextmanager? How do you write a generator-based context manager?
What is contextlib.suppress()?
What is contextlib.ExitStack()? When is it useful?
What is contextlib.asynccontextmanager?
Write a context manager for timing code execution.
Write a context manager that manages a database connection.

13. Python — Concurrency & Parallelism

🔹 Core Concepts

What is the difference between concurrency and parallelism?
What is a process vs a thread?
What is the GIL (Global Interpreter Lock) in Python? Why does it exist?
How does the GIL affect CPU-bound vs I/O-bound programs?
When does the GIL not matter?
What is threading module vs multiprocessing module? When do you use each?
What is asyncio? How is it different from threading?
What is an event loop in asyncio?
What is async and await? How do they work?
What is a coroutine in Python?

🔹 Threading

How do you create and start a thread in Python?
What is threading.Thread? What are the target, args, kwargs, daemon parameters?
What is a daemon thread? What happens when the main thread exits?
What is thread safety? How do you make code thread-safe?
What is a Lock in threading?
What is RLock (Reentrant Lock)? When do you need it over a regular Lock?
What is a Semaphore? What is BoundedSemaphore?
What is threading.Event? Give a use case.
What is threading.Condition? Give a producer-consumer example.
What is threading.Barrier?
What is threading.Timer?
What is threading.local()? When would you use thread-local storage?
What is a race condition? Give a Python threading example.
What is a deadlock? Give a Python threading deadlock example.
What is thread starvation?
What is the producer-consumer problem? How do you solve it in Python?
What is queue.Queue? How is it thread-safe?
What is queue.LifoQueue vs queue.PriorityQueue?
How do you join threads? What does thread.join() do?
What is threading.active_count() and threading.enumerate()?

🔹 Multiprocessing

What is multiprocessing.Process? How is it different from threading.Thread?
How do processes share memory? What about threads?
What is multiprocessing.Pool? What methods does it offer?
What is the difference between Pool.map(), Pool.starmap(), Pool.apply(), Pool.apply_async()?
What is multiprocessing.Queue? How is it different from queue.Queue?
What is multiprocessing.Pipe? What is the difference between send() and recv()?
What is multiprocessing.Value and multiprocessing.Array? (shared memory)
What is multiprocessing.Manager? What objects does it support?
What is multiprocessing.Lock() vs threading.Lock()?
What is the difference between fork, spawn, and forkserver start methods?
Why is if __name__ == '__main__' required in multiprocessing?
What is concurrent.futures.ProcessPoolExecutor?
What is concurrent.futures.ThreadPoolExecutor?
What is executor.submit() vs executor.map()?
What is a Future object in concurrent.futures?
What is as_completed() in concurrent.futures?
What is wait() in concurrent.futures?
What is chunksize in Pool.map()? Why does it matter for performance?
How do you handle exceptions in child processes?
What is multiprocessing.cpu_count()?

🔹 Asyncio & Async Programming

What is asyncio.run()?
What is asyncio.create_task()? How is it different from await coroutine?
What is asyncio.gather()? How does it handle exceptions?
What is asyncio.wait() vs asyncio.gather()?
What is asyncio.sleep()? Why not time.sleep() in async code?
What is asyncio.Queue?
What is asyncio.Lock(), asyncio.Semaphore(), asyncio.Event()?
What is asyncio.shield()? When is it useful?
How do you run a blocking (synchronous) function inside an async program?
What is loop.run_in_executor()?
What is asyncio.timeout() / asyncio.wait_for()?
What is aiohttp? How does it differ from requests?
What is the difference between a coroutine object and a task?
How do you cancel an asyncio task?
What is asyncio.current_task() and asyncio.all_tasks()?
What are task groups (asyncio.TaskGroup) in Python 3.11+?
What is structured concurrency?

🔹 Scenario / Real-World Questions

Scenario: You are building a web scraper that needs to scrape 10,000 URLs. Would you use threading, multiprocessing, or asyncio? Why?
Scenario: You have a CPU-intensive image processing task across 1 million images. Which approach do you choose?
Scenario: You need to make 1000 HTTP API requests as fast as possible. Which approach gives the best performance?
Scenario: Describe a real-world deadlock scenario in a web application and how you would prevent it.
Scenario: Two threads are incrementing a shared counter. The result is always less than expected. Why? How do you fix it?
Scenario: You have a mixed workload — some tasks are CPU-bound and some are I/O-bound. How do you architect this?

14. Python — Memory Management & Internals

🔹 Memory Management

How does Python manage memory?
What is reference counting in Python?
What is the garbage collector in Python? When does it run?
What is a reference cycle? Give an example.
What is gc module? What does gc.collect() do?
What is sys.getrefcount()? Why does it always return at least 1?
What is __del__? Is it reliable? Why or why not?
What is weakref? When would you use a weak reference?
What is a memory leak in Python? How can it happen?
What is tracemalloc? How do you use it to track memory usage?
What is sys.getsizeof()? What are its limitations?
What is the small object allocator (pymalloc) in CPython?
How do __slots__ reduce memory usage?
What is the difference between stack memory and heap memory in Python?
What is memory fragmentation in Python?

🔹 Python Internals

What is Python bytecode? How do you view it?
What is the dis module?
What is the CPython interpreter?
What are the alternatives to CPython? (PyPy, Jython, IronPython, MicroPython)
What is PyPy? How is it faster than CPython? (JIT compilation)
What is ctypes? How can you call C functions from Python?
How does Python's int object handle arbitrarily large integers?
What is integer caching in CPython? Which integers are cached?
What is string interning? Which strings are automatically interned?
What is __pycache__? What is the .pyc file format?

15. Python — Standard Library & Useful Modules

🔹 Must-Know Modules

What is os module? Name 10 commonly used functions/attributes.
What is sys module? Name 5 commonly used attributes.
What is pathlib? How is it different from os.path?
What is datetime module? How do you get the current date and time?
What is the difference between datetime.date, datetime.time, and datetime.datetime?
What is timedelta? Give a use case.
What is time.time() vs time.perf_counter() vs time.process_time()?
What is random module? Name 5 commonly used functions.
What is math module? Name 5 commonly used functions.
What is statistics module? What functions does it provide?
What is the re module? What are re.match(), re.search(), re.findall(), re.sub(), re.split()?
What is the difference between re.match() and re.search()?
What are groups in regex? What is re.group() and named groups?
What is a compiled regex pattern? Why use re.compile()?
What is hashlib? Name common hash algorithms and give a use case.
What is uuid module? What is the difference between UUID1, UUID4, UUID5?
What is base64 encoding? How do you encode/decode?
What is io module? What is StringIO and BytesIO?
What is logging module? How do you set up basic and advanced logging?
What are logging levels? (DEBUG, INFO, WARNING, ERROR, CRITICAL)
What is a logging handler? What is a logging formatter? What is a logging filter?
What is argparse? How do you parse command-line arguments?
What is configparser? How do you read .ini files?
What is subprocess? How do you run a shell command from Python?
What is subprocess.run() vs subprocess.Popen()?
What is socket module? What is TCP vs UDP?
What is copy module? What is copy.copy() vs copy.deepcopy()?
What is pprint? When do you use it?
What is decimal module? Why use it over float? (floating point precision)
What is fractions module?
What is heapq module? Name its key functions.
What is bisect module? What are bisect_left() and bisect_right()?
What is array module? How is it different from a list?
What is struct module? When is it used?
What is textwrap module?
What is difflib module?
What is calendar module?
What is zlib and gzip module?
What is tarfile and zipfile module?
What is sqlite3 module?

16. Python — Type Hints & Annotations

🔹 Type Hints Basics

What are type hints in Python? Are they enforced at runtime?
What is the typing module?
What is Optional[T]? How is it different from Union[T, None]?
What is Union[T1, T2]? What is T1 | T2 syntax (Python 3.10+)?
What is List[T], Dict[K, V], Tuple[T, ...], Set[T]?
What is Any type? When would you use it?
What is Callable[[args], return_type]?
What is TypeVar? How is it used for generic functions?
What is Generic[T]? How do you write a generic class?
What is Protocol? How is it used for structural typing (duck typing with types)?
What is TypedDict?
What is Final? How does it signal a constant?
What is Literal? Give a use case.
What is ClassVar?
What is overload decorator in typing?
What is mypy? How do you use it?
What is pyright? How is it different from mypy?
What is TYPE_CHECKING? Why is it used?
What are forward references (string annotations) in type hints?
What is get_type_hints()?

17. Python — Testing

🔹 Testing Fundamentals

What is unit testing vs integration testing vs end-to-end testing?
What is unittest module? How do you write a test case?
What is setUp() and tearDown() in unittest?
What is setUpClass() and tearDownClass()?
What is pytest? How is it different from unittest?
What are pytest fixtures? How are they different from setUp/tearDown?
What is fixture scope in pytest? (function, class, module, session)
What is pytest.mark.parametrize?
What is pytest.raises? How do you test for exceptions?
What is pytest.warns?
What is mocking in Python testing?
What is unittest.mock.Mock?
What is unittest.mock.MagicMock?
What is @patch decorator? What does it replace?
What is patch.object()?
What is side_effect in Mock? How is it different from return_value?
What is assert_called_once_with()?
What is code coverage? How do you measure it with pytest-cov?
What is TDD (Test-Driven Development)?
What is property-based testing? What is hypothesis library?

18. Python — Database Integration

🔹 Working with Databases

What is psycopg2? How do you connect to PostgreSQL from Python?
What is a connection vs a cursor in database programming?
What is cursor.execute() vs cursor.executemany()?
What is a parameterized query? Why is it important for SQL injection prevention?
What is connection.commit() vs connection.rollback()?
What is pymongo? How do you connect to MongoDB from Python?
What is SQLAlchemy? What are its two main components?
What is SQLAlchemy Core vs SQLAlchemy ORM?
What is a SQLAlchemy Session?
What is declarative_base() in SQLAlchemy?
What are SQLAlchemy relationships? (relationship(), ForeignKey)
What is lazy loading vs eager loading in SQLAlchemy?
What is Alembic? How do you create and apply migrations?
What is an ORM? What are its advantages and disadvantages?
What is connection pooling in SQLAlchemy?

19. Python — Web & APIs

🔹 Web Frameworks & HTTP

What is requests library? How do you make a GET and POST request?
What is requests.Session()? What are its advantages?
What are request headers, query params, and request body?
What is requests.Response? What are status_code, text, json(), content?
What is httpx? How is it different from requests?
What is aiohttp? Why is it used with asyncio?
What is REST? What are the HTTP methods and their semantic meanings?
What is Flask? Write a simple Hello World API in Flask.
What is FastAPI? What makes it fast? (Starlette + Pydantic + async)
What is Django? How is it different from Flask and FastAPI?
What is middleware in web frameworks?
What is WSGI vs ASGI?
What is Pydantic? How is it used for data validation in FastAPI?
What is dependency injection in FastAPI?
What is uvicorn? What role does it play?

20. Python — Advanced Topics

🔹 Metaclasses

What is a metaclass in Python?
What is type? How is it the metaclass of all classes?
How do you create a custom metaclass?
What are __prepare__, __new__, __init__ hooks in a metaclass?
What is __init_subclass__? How is it used as a simpler alternative to metaclasses?
What is abc.ABCMeta?
What is the difference between a class decorator and a metaclass?
What are real-world use cases for metaclasses? (ORMs, plugin systems, validation)
What is type.__new__() vs object.__new__()?
What is __class_getitem__ used for?

🔹 Descriptors

What is a descriptor in Python?
What is the difference between a data descriptor and a non-data descriptor?
What is __get__, __set__, __delete__ in a descriptor?
How does @property use the descriptor protocol?
How do classmethod and staticmethod use descriptors internally?

🔹 Advanced Python Features

What is __getattr__ vs __getattribute__? What is the difference?
What is __set_name__? Give a use case.
What is structural pattern matching (match/case) in Python 3.10+?
What is TypeAlias in Python 3.10+?
What is ParamSpec in typing? Give a use case.
What is Self type in Python 3.11+?
What is LiteralString in Python 3.11+?
What is zoneinfo module?
What is graphlib in Python 3.9+?
What is the ast module? How do you parse Python source code?
What is inspect module? Name 5 use cases.
What is dis module? How do you disassemble Python bytecode?
What is cProfile? How do you profile a Python script?
What is line_profiler? How is it more granular than cProfile?
What is Cython? How does it speed up Python?

21. System Design / Architecture Questions

(Based on real interview experience — these come up often)

Database Choice: You are a software architect. You have a development team and a client-facing team. How do you decide between SQL and NoSQL for the project?
SQL vs NoSQL trade-offs:
- When is NoSQL preferred over SQL?
- When is SQL preferred over NoSQL?
- What factors influence the decision? (data structure, scale, consistency requirements, query patterns)
PostgreSQL vs MySQL: Both are relational — why would you pick PostgreSQL over MySQL? What about the reverse?
CAP Theorem: What is the CAP theorem? Where do PostgreSQL and MongoDB fit?
ACID vs BASE: What is the difference? Which databases follow which model?
Real-World Deadlock: Describe a real-world deadlock scenario in a web application. How do you detect and prevent it?

Example: Two users trying to transfer money to each other simultaneously.
Scaling: How do you scale a PostgreSQL database? What about a MongoDB cluster?
Caching: When would you add a cache (like Redis) in front of a database?
Sharding vs Replication: What is the difference? When do you use each?
Schema-less vs Schema: What are the advantages and disadvantages of MongoDB's schema-less nature in a production system?

22. Data Structures & Algorithms (Bonus)

(Appeared in interviews — practice these)

Peak Mountain Element: Given an array, find the peak element (element greater than its neighbors). What is the O(log n) approach using binary search?
What is the difference between a stack and a queue? Implement both using Python lists.
What is a linked list? Implement reverse() on a singly linked list.
What is the difference between BFS and DFS? When do you use each?
What is a binary search tree? What are its time complexities for insert, search, and delete?
What is a hash table? How does Python's dictionary implement it internally?
What is the two-pointer technique? Give an example problem.
What is dynamic programming? Explain with the Fibonacci and knapsack example.
Write a function to check if a string is a palindrome.
What is the sliding window technique? Give an example.
What is a heap? What is heapq in Python?
What is the time complexity of sorting algorithms: Bubble, Selection, Insertion, Merge, Quick, Heap, Tim?
Scenario: Given a list of integers, find all pairs that sum to a target value. What is the optimal approach?
What is a trie? When would you use one?
What is a graph? Explain adjacency list vs adjacency matrix representation.
What is Dijkstra's algorithm? What data structure does it use?
What is a topological sort? When is it used?
What is a union-find (disjoint set) data structure?
What is the difference between a min-heap and a max-heap?
What is an LRU cache? Implement it in Python using OrderedDict.

I Spent a Full Day Learning OOP in Python, Here's Everything, Explained Like You're 15

Kishan vyas — Thu, 26 Mar 2026 18:51:49 +0000

Okay real talk.

I used to see OOP code - with all its classes, self, super(), __dunder__ stuff - and immediately feel my brain shut down.

Today I finally sat down, refused to move until I understood it, and... it actually clicked.

So here's my attempt to explain everything I learned in the way I wish someone had explained it to me - with analogies, stories, and zero corporate jargon.

Grab a chai This is a long one. But I promise it's worth it.

What we're covering:

Encapsulation

Inheritance

Abstraction

Polymorphism

Descriptors (bonus brain-bender)

First, the 30 second version of "What even IS OOP?"

Imagine you're building a game. You have a Hero, a Dragon, a Sword.

You could write everything as a big list of instructions:

hero_name = "Arjun"
hero_health = 100
hero_attack = 25
dragon_health = 500
# ... 300 more variables later 😵

Or - you could bundle related data and behavior into objects:

hero = Hero(name="Arjun", health=100)
dragon = Dragon(health=500)
hero.attack(dragon)  # clean. readable. beautiful.

That's OOP. You model the world as things (objects) that have data (attributes) and can do stuff (methods).

Python has 4 pillars of OOP. Think of them as the 4 superpowers. Let's unlock them one by one.

Pillar 1: Encapsulation - "What happens in the class, stays in the class"

The analogy: Think of your phone. You tap icons and apps open. You don't need to know about the CPU, RAM allocation, or kernel calls happening underneath. The phone encapsulates all that complexity.

Encapsulation = bundling data + methods together, and controlling who can access what.

The Underscore Rules 🐍

Python doesn't have "hard" access control like Java. Instead, it uses a naming convention - think of it as a gentleman's agreement between developers:

class BankAccount:
    def __init__(self, owner, balance):
        self.owner = owner       # 🟢 PUBLIC - anyone can see/change this
        self._balance = balance  # 🟡 PROTECTED - "hey, please don't touch this from outside"
        self.__pin = 1234        # 🔴 PRIVATE - Python actually hides this one

Let's test what happens:

account = BankAccount("Arjun", 5000)

print(account.owner)       # "Arjun"
print(account._balance)    # Works... but you're breaking the rules
print(account.__pin)       # AttributeError! Where did it go??

# Python secretly renamed it 👀
print(account._BankAccount__pin)  # 1234 - name mangling revealed!

** Wait, why does Python bother hiding __pin if you can still access it with a longer name?**
Because it prevents accidental access and name collisions in subclasses - not to stop a determined hacker. Python trusts you to be an adult.

@property - The Pythonic Getter/Setter

In Java, you write getBalance() and setBalance(). In Python, we do it better:

class BankAccount:
    def __init__(self, balance):
        self._balance = balance

    @property
    def balance(self):             # called when you READ acc.balance
        return self._balance

    @balance.setter
    def balance(self, amount):     # called when you WRITE acc.balance = x
        if amount < 0:
            raise ValueError("Bro you can't have negative money 💀")
        self._balance = amount

acc = BankAccount(1000)
print(acc.balance)     # 1000  looks like attribute access, runs the getter
acc.balance = 2000     # looks like assignment, runs the setter
acc.balance = -500     # 💥 ValueError

It looks like you're accessing an attribute. You're secretly calling a method. That's elegant.

@classmethod vs @staticmethod - What's the difference?

This confuses everyone. Here's the mental model:

	Knows about...	Use when...
Regular method	`self` (instance)	Working with instance data
@classmethod	`cls` (the class itself)	Working with class-level data
@staticmethod	nothing	Utility function that belongs here logically

class Employee:
    company = "TechCorp"   # class variable - shared by ALL instances

    def __init__(self, name):
        self.name = name   # instance variable - unique per object

    @classmethod
    def change_company(cls, new_name):
        cls.company = new_name    # changes it for ALL employees!

    @staticmethod
    def is_valid_name(name):
        return isinstance(name, str) and len(name) > 0   # no self, no cls

Employee.change_company("NewCorp")
print(Employee.company)                   # "NewCorp" - affects everyone
print(Employee.is_valid_name("Riya"))     # True

slots - For when you need to go fast ⚡

By default, every object stores its attributes in a hidden dictionary (__dict__). That's flexible but uses memory.

__slots__ says: "I know exactly what attributes this object will have. Lock it down."

class Point:
    __slots__ = ['x', 'y']   # pre-declare allowed attributes

    def __init__(self, x, y):
        self.x = x
        self.y = y

p = Point(3, 4)
p.z = 5    # AttributeError - you said only x and y!

When to use it: when you're creating millions of small objects and memory is tight. Think game particles, simulation nodes, etc.

Pillar 2: Inheritance - "Why repeat yourself when you can just... inherit?"

The analogy: You inherited your dad's nose and your mom's stubbornness. You didn't write that code yourself - it came from your parents. But you also have your own traits that neither of them have.

Inheritance = a child class gets all the stuff from a parent class, plus adds its own.

The 5 Types (Yes, Five!)

# Single - the classic
class Animal:
    def breathe(self):
        return "inhale... exhale..."

class Dog(Animal):
    def speak(self):
        return "Woof!"

# Multilevel - grandparent → parent → child
class Puppy(Dog):
    def play(self):
        return "chasing tail..."

# Hierarchical - one parent, many children
class Cat(Animal):
    def speak(self):
        return "Meow!"

# Multiple - inheriting from TWO parents
class Pet:
    def cuddle(self):
        return "purrrr"

class DomesticCat(Cat, Pet):  # gets methods from BOTH
    pass

# Hybrid - combination of above (gets complex fast!)

💎 The Diamond Problem - Python's Trickiest Puzzle

What happens when D inherits from B and C, and B and C both inherit from A?

class A:
    def greet(self):
        return "Hello from A"

class B(A):
    def greet(self):
        return "Hello from B"

class C(A):
    def greet(self):
        return "Hello from C"

class D(B, C):
    pass

d = D()
print(d.greet())  # "Hello from B" - but WHY? 🤯

Python uses MRO (Method Resolution Order) to figure this out. Think of it as Python asking: "What's the search order when I look for a method?"

print(D.__mro__)
# D → B → C → A → object

Python walks left to right through the inheritance chain. It finds greet in B first, so that's what runs. The rule is called C3 linearization - it's a whole algorithm but the key insight is: Python always respects the order you wrote the parents.

Pro tip: Always use super() instead of calling ParentClass.method(self) directly. super() respects MRO. Hardcoding the parent name doesn't.

Pillar 3: Abstraction - "Tell me WHAT to do, not HOW"

The analogy: You plug a phone charger into any socket. You don't need to know the voltage regulation, wire resistance, or circuit breaker internals. The socket gives you an interface (two holes, specific voltage). How it delivers that is hidden.

Abstraction = define what a class must do, leave the how up to subclasses.

Python gives us the abc module (Abstract Base Classes) for this:

from abc import ABC, abstractmethod

class Shape(ABC):          # ABC = "I am an abstract class"

    @abstractmethod
    def area(self):        # Every Shape MUST implement this
        pass

    @abstractmethod
    def perimeter(self):   # And this
        pass

    def describe(self):    # This one is optional - already implemented
        return f"I am a shape with area {self.area():.2f}"

Now let's make some shapes:

class Circle(Shape):
    def __init__(self, radius):
        self.radius = radius

    def area(self):
        return 3.14159 * self.radius ** 2

    def perimeter(self):
        return 2 * 3.14159 * self.radius

class Rectangle(Shape):
    def __init__(self, w, h):
        self.w, self.h = w, h

    def area(self):
        return self.w * self.h

    def perimeter(self):
        return 2 * (self.w + self.h)

# shape = Shape()  TypeError - you can't instantiate an abstract class!
c = Circle(5)
r = Rectangle(4, 6)

print(c.describe())   # "I am a shape with area 78.54"
print(r.describe())   # "I am a shape with area 24.00"

Why is this useful in real projects?
Imagine you're building a payment system. You define an abstract PaymentGateway class with charge() and refund() methods. Now every developer adding a new gateway (Stripe, Razorpay, PayPal) is forced to implement both. No more "oops I forgot the refund method" bugs.

Pillar 4: Polymorphism - "Same name, totally different behavior"

The analogy: The word "run" means different things to a human (legs), a computer (execute), a river (flow), and your nose (drip when sick 🤧). Same word, different behavior depending on context.

Polymorphism = the same method name works differently on different objects.

Method Overriding

class Animal:
    def speak(self):
        return "..."

class Dog(Animal):
    def speak(self):
        return "Woof! 🐶"

class Cat(Animal):
    def speak(self):
        return "Meow! 🐱"

class Duck(Animal):
    def speak(self):
        return "Quack! 🦆"

# The MAGIC - you can treat them all the same!
zoo = [Dog(), Cat(), Duck(), Animal()]
for animal in zoo:
    print(animal.speak())

# Output:
# Woof! 🐶
# Meow! 🐱
# Quack! 🦆
# ...

You don't need to know what kind of animal you have. You just call .speak() and Python figures it out. This is polymorphism in action.

Operator Overloading - Making Python's `+` do YOUR bidding

Did you know + doesn't always mean "add numbers"? "hello" + " world" is string concat. [1,2] + [3,4] is list merge. Python lets YOU define what + means for your own classes using dunder methods (double underscore = "dunder"):

class Vector:
    def __init__(self, x, y):
        self.x = x
        self.y = y

    def __add__(self, other):          # what + does
        return Vector(self.x + other.x, self.y + other.y)

    def __mul__(self, scalar):         # what * does
        return Vector(self.x * scalar, self.y * scalar)

    def __eq__(self, other):           # what == does
        return self.x == other.x and self.y == other.y

    def __repr__(self):                # what print() shows
        return f"Vector({self.x}, {self.y})"

v1 = Vector(1, 2)
v2 = Vector(3, 4)

print(v1 + v2)      # Vector(4, 6) - our __add__ ran!
print(v1 * 3)       # Vector(3, 6) - our __mul__ ran!
print(v1 == v1)     # True - our __eq__ ran!

Here are the most useful dunder methods to know:

You write...	Dunder that runs
`a + b`	`__add__`
`a - b`	`__sub__`
`a * b`	`__mul__`
`a == b`	`__eq__`
`a < b`	`__lt__`
`len(a)`	`__len__`
`print(a)`	`__str__`
`repr(a)`	`__repr__`
`a[0]`	`__getitem__`

Bonus: Descriptors - "The magic behind the magic"

Okay, here's where it gets genuinely mind-bending.

Every time you use @property, you're using a descriptor. And every time Python accesses obj.attribute, there's a whole lookup protocol happening under the hood.

A descriptor is any class that implements __get__, __set__, or __delete__.

class Validator:
    """A reusable descriptor that validates integer attributes"""

    def __set_name__(self, owner, name):
        self.name = name         # Python tells us our attribute name automatically

    def __get__(self, obj, objtype=None):
        if obj is None:          # accessed on the class itself, not an instance
            return self
        return obj.__dict__.get(self.name)

    def __set__(self, obj, value):
        if not isinstance(value, int) or value < 0:
            raise ValueError(f"'{self.name}' must be a non-negative integer. Got: {value}")
        obj.__dict__[self.name] = value

class Product:
    price = Validator()       # ← descriptor instance as a CLASS attribute
    quantity = Validator()

    def __init__(self, price, quantity):
        self.price = price
        self.quantity = quantity

p = Product(100, 10)
print(p.price)       # 100
p.quantity = 5       # fine
p.price = -50        # ValueError: 'price' must be a non-negative integer. Got: -50

Why is this cool? One Validator class works for BOTH price and quantity. You write the validation logic once. @property would need two separate property definitions.

Mind-blowing fact: @property, @classmethod, @staticmethod - they're all descriptors themselves. Learning descriptors is learning how Python itself works at a fundamental level.

Quick Knowledge Check - Can you answer these?

Before you scroll away, try these in your head (or your REPL):

Q1: What's the difference between _name and __name?

Q2: Why would you use @classmethod over a regular method?

Q3: What does MRO stand for, and why does it exist?

Q4: What happens if a subclass doesn't implement an @abstractmethod?

Q5: What dunder method would you override to make len(your_object) work?

(Answers are in the code examples above - go find them! 🕵️)

🗺️ The Full Picture

Here's everything we covered, in one table:

Pillar	Core Idea	Key Python Tools
Encapsulation	Bundle data + control access	`_x`, `__x`, `@property`, `__slots__`
Inheritance	Reuse + extend parent code	`class Child(Parent)`, `super()`, MRO
Abstraction	Enforce interface, hide details	`ABC`, `@abstractmethod`
Polymorphism	Same name, different behavior	Method overriding, dunder methods
Descriptors	Customize attribute access itself	`__get__`, `__set__`, `__delete__`

💬 Let's Talk!

If you made it this far - you're a legend. Genuinely.

Drop a comment and tell me:

Which concept clicked the most for you?
Which one still feels fuzzy?
What should I write about next?

I'm documenting my learning journey here in public - every day I learn something new. Follow along if you want to learn together. 🙌

[Boost]

Kishan vyas — Thu, 22 May 2025 04:46:21 +0000

Kishan vyas

May 22 '25

Understanding 23 Design Patterns in Software Development

Comments

5 min read

Understanding 23 Design Patterns in Software Development

Kishan vyas — Thu, 22 May 2025 04:33:44 +0000

If you're diving deeper into software development and want to write cleaner, more scalable code — design patterns are your new best friends.

In this guide, I’ll walk you through the 23 most commonly used design patterns, grouped under Creational, Structural, and Behavioral patterns — all explained simply and with real-world examples in JavaScript.

Let’s go.........

📦 Creational Design Patterns

These deal with object creation mechanisms. The idea is to abstract the instantiation logic so that the system is not tightly coupled to the specific classes.

1. Singleton Pattern

Only one instance of a class is created and shared.

Use case: Logger, Config manager, DB connection.

class Singleton {
  constructor() {
    if (Singleton.instance) return Singleton.instance;
    Singleton.instance = this;
  }
}

const a = new Singleton();
const b = new Singleton();
console.log(a === b); // true

2. Factory Pattern

Creates objects without exposing the instantiation logic.

Use case: UI component factory, Notification sender (Email/SMS).

class Car {
  drive() {
    console.log("Driving a car");
  }
}

class Bike {
  drive() {
    console.log("Riding a bike");
  }
}

function VehicleFactory(type) {
  if (type === "car") return new Car();
  if (type === "bike") return new Bike();
}

const vehicle = VehicleFactory("bike");
vehicle.drive(); // Riding a bike

3. Abstract Factory Pattern

Factory of factories.

Use case: Theme factory for UI (DarkThemeFactory, LightThemeFactory)

function darkButton() {
  return { color: "black" };
}

function lightButton() {
  return { color: "white" };
}

function UIFactory(mode) {
  return {
    createButton: mode === "dark" ? darkButton : lightButton,
  };
}

const factory = UIFactory("dark");
console.log(factory.createButton()); // { color: "black" }

4. Builder Pattern

Step-by-step creation of a complex object.

Use case: Building complex HTML, query builder, or form builders.

class BurgerBuilder {
  constructor() {
    this.burger = {};
  }

  addCheese() {
    this.burger.cheese = true;
    return this;
  }

  addLettuce() {
    this.burger.lettuce = true;
    return this;
  }

  build() {
    return this.burger;
  }
}

const burger = new BurgerBuilder().addCheese().addLettuce().build();
console.log(burger); // { cheese: true, lettuce: true }

5. Prototype Pattern

Clone an existing object instead of creating a new one.

Use case: Performance optimization, default object templates.

const car = {
  wheels: 4,
  drive() {
    console.log("Driving...");
  },
};

const myCar = Object.create(car);
console.log(myCar.wheels); // 4

🧱 Structural Design Patterns

These are about class and object composition, focusing on how large structures are built from smaller pieces.

6. Adapter Pattern

Converts one interface to another.

Use case: Legacy APIs, payment gateway adapters.

class OldPrinter {
  oldPrint(msg) {
    console.log("Old Print:", msg);
  }
}

class Adapter {
  constructor() {
    this.oldPrinter = new OldPrinter();
  }

  print(msg) {
    this.oldPrinter.oldPrint(msg);
  }
}

const printer = new Adapter();
printer.print("Hello World");

7. Decorator Pattern

Add new functionality without modifying the original class.

Use case: Middleware, logging wrappers.

function coffee() {
  return "coffee";
}

function withMilk(coffeeFunc) {
  return () => coffeeFunc() + " + milk";
}

const fancyCoffee = withMilk(coffee);
console.log(fancyCoffee()); // coffee + milk

8. Facade Pattern

Simplifies a complex subsystem by exposing a high-level API.

Use case: Simplify media player libraries, SDKs.

class Engine {
  start() {
    console.log("Engine started");
  }
}

class Lights {
  on() {
    console.log("Lights on");
  }
}

class CarFacade {
  constructor() {
    this.engine = new Engine();
    this.lights = new Lights();
  }

  startCar() {
    this.engine.start();
    this.lights.on();
  }
}

const car = new CarFacade();
car.startCar();

9. Composite Pattern

Treat a group of objects the same way as a single object.

Use case: File system, nested UI elements.

class Leaf {
  constructor(name) {
    this.name = name;
  }

  show() {
    console.log(this.name);
  }
}

class Folder {
  constructor(name) {
    this.name = name;
    this.children = [];
  }

  add(child) {
    this.children.push(child);
  }

  show() {
    console.log(this.name);
    this.children.forEach(child => child.show());
  }
}

const file1 = new Leaf("file1.txt");
const file2 = new Leaf("file2.txt");

const folder = new Folder("MyFolder");
folder.add(file1);
folder.add(file2);

folder.show();

10. Bridge Pattern

Separate abstraction from implementation.

Use case: Theme-switching, rendering strategies.

class LightTheme {
  getColor() {
    return "Light color";
  }
}

class DarkTheme {
  getColor() {
    return "Dark color";
  }
}

class Page {
  constructor(theme) {
    this.theme = theme;
  }

  getContent() {
    return `Page with ${this.theme.getColor()}`;
  }
}

const darkPage = new Page(new DarkTheme());
console.log(darkPage.getContent()); // Page with Dark color

11. Proxy Pattern

A placeholder that controls access to another object.

Use case: Lazy loading, access control, logging.

class RealImage {
  display() {
    console.log("Displaying image");
  }
}

class ProxyImage {
  constructor() {
    this.realImage = null;
  }

  display() {
    if (!this.realImage) {
      this.realImage = new RealImage();
    }
    this.realImage.display();
  }
}

const img = new ProxyImage();
img.display();

🧠 Behavioral Design Patterns

These are all about how objects interact with each other.

12. Observer Pattern

Notify all subscribers when something changes.

Use case: Event listeners, Pub/Sub.

class Subject {
  constructor() {
    this.subscribers = [];
  }

  subscribe(fn) {
    this.subscribers.push(fn);
  }

  notify(data) {
    this.subscribers.forEach(fn => fn(data));
  }
}

const subject = new Subject();
subject.subscribe(console.log);
subject.notify("Hello!");

13. Strategy Pattern

Change the algorithm at runtime.

Use case: Sorting strategies, payment gateways.

function add(a, b) {
  return a + b;
}

function multiply(a, b) {
  return a * b;
}

function calculate(strategy, a, b) {
  return strategy(a, b);
}

console.log(calculate(add, 5, 3)); // 8
console.log(calculate(multiply, 5, 3)); // 15

14. Command Pattern

Encapsulate requests as objects.

Use case: Undo/Redo, menu actions.

class Light {
  turnOn() {
    console.log("Light on");
  }
}

class Command {
  constructor(device) {
    this.device = device;
  }

  execute() {
    this.device.turnOn();
  }
}

const light = new Light();
const cmd = new Command(light);
cmd.execute();

15. Chain of Responsibility Pattern

Pass requests down a chain until someone handles it.

Use case: Express middlewares, support ticket routing.

function handler1(req, next) {
  if (req.type === "log") console.log("Handler1 processed");
  else next();
}

function handler2(req) {
  console.log("Handler2 processed");
}

function processRequest(req) {
  handler1(req, () => handler2(req));
}

processRequest({ type: "data" }); // Handler2 processed

16. Template Method Pattern

Define the skeleton of an algorithm, but let subclasses fill in the steps.

Use case: Framework hooks.

class Game {
  start() {
    this.init();
    this.play();
    this.end();
  }

  init() {}
  play() {}
  end() {}
}

class Football extends Game {
  init() {
    console.log("Football Initialized");
  }

  play() {
    console.log("Playing Football");
  }

  end() {
    console.log("Football Ended");
  }
}

new Football().start();

17. State Pattern

Change behavior based on internal state.

Use case: Media players, form steps, UI modes.

class TrafficLight {
  constructor() {
    this.states = ["green", "yellow", "red"];
    this.current = 0;
  }

  change() {
    console.log("Light:", this.states[this.current]);
    this.current = (this.current + 1) % this.states.length;
  }
}

const light = new TrafficLight();
light.change(); // green
light.change(); // yellow

18. Mediator Pattern

Centralized communication between objects.

Use case: Chatrooms, component interactions.

class ChatRoom {
  showMessage(user, message) {
    console.log(`${user}: ${message}`);
  }
}

const room = new ChatRoom();
room.showMessage("Alice", "Hello Bob!");

19. Visitor Pattern

Add operations to objects without changing their classes.

Use case: Compilers, object structure traversal.

class Book {
  accept(visitor) {
    visitor.visitBook(this);
  }
}

class BookVisitor {
  visitBook(book) {
    console.log("Visiting book");
  }
}

const book = new Book();
book.accept(new BookVisitor());

20. Interpreter Pattern

Build a simple language interpreter.

Use case: Regex, Expression evaluators.

class Number {
  constructor(value) {
    this.value = value;
  }

  interpret() {
    return this.value;
  }
}

const one = new Number(1);
const two = new Number(2);
console.log(one.interpret() + two.interpret()); // 3

21. Memento Pattern

Capture and restore an object's state.

Use case: Undo features, save/restore.

class Editor {
  constructor() {
    this.content = "";
  }

  write(text) {
    this.content += text;
  }

  save() {
    return this.content;
  }

  restore(saved) {
    this.content = saved;
  }
}

22. Iterator Pattern

Access elements without exposing the structure.

Use case: Custom collections.

const arr = [1, 2, 3];
const iterator = arr[Symbol.iterator]();

console.log(iterator.next()); // { value: 1, done: false }

23. Null Object Pattern

Use an object that does nothing instead of null.

Use case: Avoid if (obj) checks.

class NullUser {
  getName() {
    return "Guest";
  }
}

function getUser(user) {
  return user || new NullUser();
}

console.log(getUser(null).getName()); // Guest

Happy Coding 👨‍💻🔥

Singleton Design Pattern: Explained Simply

Kishan vyas — Sun, 11 May 2025 12:36:05 +0000

The Singleton Design Pattern is a creational design pattern that ensures a class has only one instance and provides a global point of access to it. Think of it as a single, shared resource that everyone can use, but no one can duplicate.

Why Use the Singleton Pattern?

The Singleton pattern is ideal when:

You need exactly one instance of a class, such as for a database connection, configuration manager, or logging system.
You want to control access to this instance to avoid issues like inconsistent states caused by multiple instances.

How Does It Work?

The Singleton pattern relies on three core principles:

Private Constructor: The class restricts instantiation from outside by making its constructor private.
Static Instance: The class maintains a single, static instance of itself.
Static Access Method: A public static method (often called getInstance()) provides access to the single instance, creating it if it doesn’t exist.

Simple Code Example (Java)

Here’s a basic implementation of the Singleton pattern in Java:

public class Singleton {
    // Static variable to hold the single instance
    private static Singleton instance;

    // Private constructor to prevent instantiation
    private Singleton() {
    }

    // Public static method to access the instance
    public static Singleton getInstance() {
        if (instance == null) {
            instance = new Singleton();
        }
        return instance;
    }
}
// Using the Singleton
Singleton s1 = Singleton.getInstance();
Singleton s2 = Singleton.getInstance();
// s1 and s2 refer to the SAME instance

How It Ensures a Single Instance

When you use the Singleton pattern, multiple variables (like s1 and s2) requesting the instance will point to the same object, ensuring only one instance exists.

Real-World Analogy

Imagine a company CEO. There’s only one CEO for the entire company, and everyone accesses the same person for high-level decisions. You can’t have multiple CEOs, and the CEO’s office (the getInstance() method) is the way to reach them.

Key Considerations

Thread Safety: In multithreaded environments, synchronization is needed to prevent multiple instances. Options include using the synchronized keyword or double-checked locking.
Lazy Initialization: The instance is created only when first requested, saving resources.
Eager Initialization: Alternatively, you can create the instance when the class is loaded (e.g., private static Singleton instance = new Singleton();).

Pros of the Singleton Pattern

Guarantees a single instance of the class.
Provides global access to the instance.
Supports lazy initialization to optimize resource usage.

Cons of the Singleton Pattern

Can be tricky in multithreaded environments without proper synchronization.
May cause tight coupling, reducing code flexibility.
Complicates unit testing due to its global state.

When to Use It

The Singleton pattern shines when you need a single, shared resource, such as:

A logging system writing to a single file.
A configuration manager for application-wide settings.
A connection pool for database connections.

Conclusion

The Singleton Design Pattern is a straightforward yet powerful tool for ensuring a class has only one instance while providing global access to it. By leveraging a private constructor, a static instance, and a static access method, you can enforce this constraint effectively. Just be cautious of thread safety and design challenges when implementing it.

Whether you’re building a small app or a complex system, the Singleton pattern can help manage shared resources efficiently!

From Internship to Impact: How I Automated Deployment with Telegram Alerts

Kishan vyas — Mon, 05 May 2025 18:21:18 +0000

In the world of full-stack development, building features is just one part of the job. What really separates a developer from an engineer is how you handle deployments, automation, and monitoring.

As an intern working on a real-world Import Export management system, I recently faced a challenge:
How do I ensure seamless deployment with zero guesswork—especially when working alone or in a small team?

The Problem

Every time I updated the backend code:
I had to manually pull the code on the server.
Restart services and check for errors.
Pray that I didn’t miss something in the deployment process.

It wasn’t scalable. So I built a simple yet powerful CI/CD system with Telegram alerts.

What I Built

Here’s what the pipeline does:

GitHub Webhook triggers on push
Server pulls the latest code
Runs build + restart commands
Sends a Telegram message with the result: success or failure

Tech Stack

Node.js backend
Bash scripts on a Linux VPS
GitHub Webhooks
Telegram Bot API
Nginx for reverse proxy

Why Telegram?

Simple. Instant feedback without needing to check logs or dashboards.
If deployment fails, I know immediately. If it succeeds, I keep building confidently.

Code Snippet

#!/bin/bash
cd /home/udhyog/ImportExport/management-sheet
git pull origin main

if pm2 restart backend; then
  curl -s -X POST "https://api.telegram.org/bot<token>/sendMessage" \
  -d chat_id=<your_chat_id> \
  -d text="✅ Deployment succeeded!"
else
  curl -s -X POST "https://api.telegram.org/bot<token>/sendMessage" \
  -d chat_id=<your_chat_id> \
  -d text="❌ Deployment failed!"
fi

The Impact

Reduced downtime
Instant awareness of issues
Peace of mind as a solo/full-stack dev
Made the system production-ready

Final Thoughts

Small automations = huge productivity gains.
Whether you're an intern, solo dev, or working in a team, it's worth investing time into your deployment process.

Let your code deploy and talk to you.

A Deep Dive into Forward and Reverse Proxy with NGINX on Linux

Kishan vyas — Mon, 02 Sep 2024 01:25:51 +0000

Proxies play a critical role in modern web architecture, enabling secure, efficient, and manageable network communications. NGINX, a powerful and widely-used web server, excels in providing both forward and reverse proxy capabilities. In this blog, we'll dive into the concepts of forward and reverse proxies, how they work in NGINX, and provide code examples for setting them up on a Linux machine.

What is a Proxy?
Forward Proxy
- Definition
- Use Cases
- Setting up Forward Proxy with NGINX
Reverse Proxy
- Definition
- Use Cases
- Setting up Reverse Proxy with NGINX
Key Differences Between Forward and Reverse Proxy
Conclusion

1. What is a Proxy?

A proxy acts as an intermediary between a client and a server. It handles requests from clients, forwards them to the appropriate server, and then returns the server's response back to the client. This can be done for various purposes, such as improving security, load balancing, or accessing blocked resources.

2. Forward Proxy

Definition

A forward proxy sits between a client and the internet. It is used by clients to access resources on the internet that they might not be able to reach directly. This could be due to network restrictions, privacy concerns, or simply to cache content for quicker access.

Use Cases

Access Control: Allow or block access to certain websites or resources.
Privacy: Hide the client's IP address from the internet.
Content Filtering: Block specific types of content (e.g., ads or adult content).
Caching: Store copies of frequently accessed resources to speed up requests.

Setting up Forward Proxy with NGINX

Here's how you can set up a forward proxy server with NGINX on a Linux machine:

Install NGINX: Make sure NGINX is installed on your Linux machine. If not, install it using the package manager:

   sudo apt update
   sudo apt install nginx

Configure NGINX as a Forward Proxy: Edit the NGINX configuration file to set up the forward proxy.

Open the NGINX configuration file:

   sudo nano /etc/nginx/nginx.conf

Add the following configuration:

   events {}

   http {
       server {
           listen 8080; # The port on which the forward proxy will listen

           location / {
               proxy_pass $scheme://$host$request_uri;
               proxy_set_header Host $host;
               proxy_set_header X-Real-IP $remote_addr;
               proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
               proxy_set_header X-Forwarded-Proto $scheme;
           }

           access_log /var/log/nginx/proxy-access.log;
           error_log /var/log/nginx/proxy-error.log;
       }
   }

This configuration tells NGINX to listen on port 8080 and forward all requests it receives to the destination server.

Restart NGINX:

After editing the configuration file, restart NGINX to apply the changes:

   sudo systemctl restart nginx

Test the Forward Proxy: You can test the forward proxy by configuring a web browser to use your Linux machine's IP address and port 8080 as a proxy server.

3. Reverse Proxy

Definition

A reverse proxy, on the other hand, sits between the internet and a server. It forwards client requests to one or more backend servers and returns the server's response to the client. The client interacts with the reverse proxy as if it were the actual server.

Use Cases

Load Balancing: Distribute incoming traffic across multiple servers.
SSL Termination: Handle SSL encryption/decryption on behalf of backend servers.
Security: Protect backend servers by hiding their IP addresses and managing access control.
Caching: Store responses from backend servers to reduce load and improve response times.

Setting up Reverse Proxy with NGINX

Here's how to configure NGINX as a reverse proxy on a Linux machine:

Install NGINX: Ensure NGINX is installed:

   sudo apt update
   sudo apt install nginx

Configure NGINX as a Reverse Proxy: Edit the NGINX configuration file to set up the reverse proxy.

Open the NGINX configuration file:

   sudo nano /etc/nginx/sites-available/default

Modify the server block to include the reverse proxy configuration:

   server {
       listen 80;

       server_name example.com; # Replace with your domain or IP address

       location / {
           proxy_pass http://backend_server_ip; # Replace with your backend server IP or domain
           proxy_set_header Host $host;
           proxy_set_header X-Real-IP $remote_addr;
           proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
           proxy_set_header X-Forwarded-Proto $scheme;
       }

       access_log /var/log/nginx/reverse-proxy-access.log;
       error_log /var/log/nginx/reverse-proxy-error.log;
   }

This configuration directs NGINX to forward all requests it receives on port 80 to the backend server specified by proxy_pass.

Restart NGINX:

After updating the configuration, restart NGINX:

   sudo systemctl restart nginx

Test the Reverse Proxy: You can test the reverse proxy by accessing your domain or IP address in a web browser. The requests should be forwarded to the backend server.

4. Key Differences Between Forward and Reverse Proxy

Direction of Proxying: A forward proxy handles requests from clients seeking resources from servers, while a reverse proxy handles requests from clients and forwards them to backend servers.
Client Awareness: In a forward proxy, the client knows it's using a proxy, whereas, in a reverse proxy, the client is unaware it's interacting with a proxy.
Common Uses: Forward proxies are commonly used for privacy, filtering, and access control, while reverse proxies are used for load balancing, SSL termination, and security.

5. Conclusion

NGINX is a versatile tool that can act as both a forward and reverse proxy, providing a variety of benefits including improved security, load balancing, and access control. Whether you need to set up a forward proxy to control client access to the internet or a reverse proxy to manage and secure backend server traffic, NGINX on Linux offers a robust solution.

By understanding and implementing these proxies, you can enhance your network architecture, making it more efficient and secure.

The Importance of Connection Pooling

Kishan vyas — Sat, 03 Aug 2024 18:29:55 +0000

Introduction

In the world of modern web applications, efficient database management is critical for performance and scalability. One key technique that ensures efficient database interaction is connection pooling. In this blog, we will explore the need for connection pooling, the consequences of not using it, and the benefits it brings when properly implemented, especially in the context of Prisma ORM and PostgreSQL.

Imagine this: every time a user visits your app, a brand new connection to the database is created. Sounds simple, right? But this can quickly lead to delays, especially when your app is handling multiple users at once. That's where connection pooling saves the day!

What is Connection Pooling?

Connection pooling is a method of managing database connections by maintaining a pool of reusable connections. Instead of creating a new connection for every request, the pool reuses existing connections, significantly reducing the overhead associated with establishing new connections.

Why is Connection Pooling Needed?

Resource Optimization:

Establishing a new database connection is resource-intensive and time-consuming. Connection pooling minimizes this overhead by reusing existing connections.

Scalability:

Modern applications often handle a high number of concurrent requests. Without connection pooling, each request would require a new connection, quickly overwhelming the database. Connection pooling helps manage and limit the number of active connections.

Performance:

Reusing connections reduces latency, leading to faster query execution and improved overall application performance.

What Happens Without Connection Pooling?

High Latency:

Every new request results in creating a new database connection, introducing significant latency due to the overhead of connection establishment.

Resource Exhaustion:

Databases have a limit on the number of concurrent connections they can handle. Without pooling, the application can easily exceed this limit, leading to connection failures and degraded performance.

Increased Costs:

In cloud environments, unnecessary creation and management of connections can lead to higher operational costs due to increased resource usage.

Unstable Applications:

Frequent connection creation and teardown can cause instability, leading to frequent crashes and unreliable application behavior.

What Happens With Connection Pooling?

Improved Performance:

Reusing existing connections minimizes latency, resulting in faster response times and a smoother user experience.

Efficient Resource Utilization:

Connection pooling ensures that database resources are used efficiently, reducing the risk of connection limits being exceeded and improving overall stability.

Scalability:

The application can handle a higher number of concurrent requests without overwhelming the database, making it more scalable.

Cost Efficiency:

Efficient connection management leads to optimized resource usage, potentially reducing operational costs in cloud environments.

Conclusion

Connection pooling is essential for any application interacting with a database, especially in serverless environments. It optimizes resource usage, enhances performance, ensures scalability, and reduces operational costs. By implementing connection pooling with Prisma ORM and PostgreSQL, you can significantly improve your application's efficiency and reliability.

DEV Community: Kishan vyas

Interview Questions💥: Git/GitHub · PostgreSQL · MongoDB · Python

The Ultimate Backend Interview Question Bank

What's covered

Table of Contents

1. Git & GitHub

🔹 Conceptual Questions

🔹 Branching & Workflow Questions

🔹 Scenario-Based Questions

🔹 GitHub Specific Questions

2. PostgreSQL

🔹 Conceptual / Fundamentals

🔹 Joins & Queries

🔹 Indexing & Performance

🔹 Transactions & Concurrency

🔹 Schema Design & Advanced

🔹 PostgreSQL vs MySQL

3. MongoDB

🔹 Conceptual / Fundamentals

🔹 Querying

🔹 Aggregation

🔹 Indexing & Performance

🔹 Schema Design & Modeling

🔹 Transactions & Replication

4. Python — Basics & Built-ins

🔹 Language Fundamentals

🔹 Variables & Data Types

🔹 Operators

🔹 Control Flow

🔹 Strings

5. Python — Data Structures & Collections

🔹 Lists

🔹 Tuples

🔹 Dictionaries

🔹 Sets

🔹 Collections Module

6. Python — Functions & Functional Programming

🔹 Function Basics

🔹 Scope & Closures

🔹 Lambda & Functional Tools

🔹 Recursion

7. Python — OOP (Object-Oriented Programming)

🔹 Classes & Objects

🔹 The Four Pillars

🔹 Special / Dunder Methods

🔹 Class Methods & Properties

🔹 Inheritance & Advanced OOP

🔹 Design Patterns

8. Python — Modules, Packages & Imports

🔹 Modules & Packages

🔹 Package Management

9. Python — File Handling & I/O

🔹 File Operations

🔹 Serialization

10. Python — Error & Exception Handling

🔹 Exception Basics

🔹 Raising & Custom Exceptions

11. Python — Iterators, Generators & Comprehensions

🔹 Iterators & Iterables

🔹 Generators

🔹 Comprehensions

12. Python — Decorators & Context Managers

🔹 Decorators

🔹 Context Managers

13. Python — Concurrency & Parallelism

🔹 Core Concepts

🔹 Threading

🔹 Multiprocessing

🔹 Asyncio & Async Programming

🔹 Scenario / Real-World Questions

14. Python — Memory Management & Internals

🔹 Memory Management

🔹 Python Internals

15. Python — Standard Library & Useful Modules

🔹 Must-Know Modules

16. Python — Type Hints & Annotations

🔹 Type Hints Basics

17. Python — Testing

🔹 Testing Fundamentals

18. Python — Database Integration

Operator Overloading - Making Python's `+` do YOUR bidding