DEV Community

Deepika Pusala profile picture

Deepika Pusala

Full Stack Intern @Sandlogic

Joined Joined on 
Transactions, Isolation Levels, MVCC, Locking, Triggers, Audit Logs & CAP Theorem in PostgreSQL 🔒

Transactions, Isolation Levels, MVCC, Locking, Triggers, Audit Logs & CAP Theorem in PostgreSQL 🔒

Comments
21 min read

Want to connect with Deepika Pusala?

Create an account to connect with Deepika Pusala. You can also sign in below to proceed if you already have an account.

Already have an account? Sign in
CQRS & Event-Driven Thinking: Commands, Queries, Domain Events & the Outbox Pattern Explained 📨

CQRS & Event-Driven Thinking: Commands, Queries, Domain Events & the Outbox Pattern Explained 📨

Comments
16 min read
PostgreSQL Query Optimization: Indexes, EXPLAIN ANALYZE, B-tree vs GIN vs GiST & the N+1 Problem 🚀

PostgreSQL Query Optimization: Indexes, EXPLAIN ANALYZE, B-tree vs GIN vs GiST & the N+1 Problem 🚀

Comments
17 min read
Structural & Behavioral Design Patterns in Python: Repository, Factory, Strategy, Decorator & Adapter Explained 🧩

Structural & Behavioral Design Patterns in Python: Repository, Factory, Strategy, Decorator & Adapter Explained 🧩

Comments
17 min read
SOLID Principles Deep Dive (I & D): Interface Segregation and Dependency Inversion Explained 🧩

SOLID Principles Deep Dive (I & D): Interface Segregation and Dependency Inversion Explained 🧩

Comments
15 min read
SOLID Principles Deep Dive (S, O, L): Explained from Absolute Zero 🧱

SOLID Principles Deep Dive (S, O, L): Explained from Absolute Zero 🧱

Comments
12 min read
Transactions & Basic Indexing in PostgreSQL: COMMIT, ROLLBACK, EXPLAIN & SQLAlchemy ⚛️

Transactions & Basic Indexing in PostgreSQL: COMMIT, ROLLBACK, EXPLAIN & SQLAlchemy ⚛️

Comments
16 min read
Relational Databases, SQL, Normalization & ACID: A Beginner-Friendly Guide 🗄️

Relational Databases, SQL, Normalization & ACID: A Beginner-Friendly Guide 🗄️

Comments
22 min read
Authentication Basics (JWT) & FastAPI Security: A Beginner-Friendly Guide 🔐

Authentication Basics (JWT) & FastAPI Security: A Beginner-Friendly Guide 🔐

Comments
20 min read
SQLAlchemy 2.0 & Alembic Migrations: A Complete Beginner's Guide🗄️

SQLAlchemy 2.0 & Alembic Migrations: A Complete Beginner's Guide🗄️

Comments
28 min read
Pydantic v2 Deep Dive & Custom Validators: Explained from Absolute Zero 🛡️

Pydantic v2 Deep Dive & Custom Validators: Explained from Absolute Zero 🛡️

Comments
21 min read
FastAPI Fundamentals & Dependency Injection: Explained from Absolute Zero ⚡

FastAPI Fundamentals & Dependency Injection: Explained from Absolute Zero ⚡

Comments
16 min read
Python Packaging & Environment Config for Services: venv, Poetry, pip-tools, Pydantic Settings & 12-Factor Explained 🐍

Python Packaging & Environment Config for Services: venv, Poetry, pip-tools, Pydantic Settings & 12-Factor Explained 🐍

Comments
20 min read
Deep Git Workflows: Rebasing, Conflict Resolution & Branching Strategies Explained from Zero 🌳

Deep Git Workflows: Rebasing, Conflict Resolution & Branching Strategies Explained from Zero 🌳

Comments
19 min read
Python Packaging, Type Hints & Testing with pytest: A Complete Beginner Guide 🧪

Python Packaging, Type Hints & Testing with pytest: A Complete Beginner Guide 🧪

Comments
21 min read
WSGI vs ASGI, Uvicorn & Middleware: Explained from Absolute Zero 🚀

WSGI vs ASGI, Uvicorn & Middleware: Explained from Absolute Zero 🚀

Comments
11 min read
Python Asyncio Concurrency Patterns: Semaphore, Lock, Queue, gather & TaskGroup Explained from Zero 🧵

Python Asyncio Concurrency Patterns: Semaphore, Lock, Queue, gather & TaskGroup Explained from Zero 🧵

Comments
17 min read
Instagram Clone Frontend — Part 4: API Client & Networking (Native Fetch API, Auth Header Injection, Base64 File Conversion & Unsplash Resolution)

Instagram Clone Frontend — Part 4: API Client & Networking (Native Fetch API, Auth Header Injection, Base64 File Conversion & Unsplash Resolution)

1
Comments
5 min read
Instagram Clone Frontend — Part 3: State Management (React Hooks & Browser LocalStorage)

Instagram Clone Frontend — Part 3: State Management (React Hooks & Browser LocalStorage)

1
Comments
5 min read
Instagram Clone Frontend — Part 2: UI Architecture (React, CSS & Responsive Layout Engineering)

Instagram Clone Frontend — Part 2: UI Architecture (React, CSS & Responsive Layout Engineering)

1
Comments
5 min read
Instagram Clone Frontend — Part 1: Build Tool & Runtime (Vite, Node.js & npm, and Modern ES6+ JavaScript)

Instagram Clone Frontend — Part 1: Build Tool & Runtime (Vite, Node.js & npm, and Modern ES6+ JavaScript)

1
Comments
4 min read
Instagram Clone Backend — Part 5: Performance & Database Optimization (Pagination, Zero N+1 Queries, Optimistic Locking & Integrity Constraints)

Instagram Clone Backend — Part 5: Performance & Database Optimization (Pagination, Zero N+1 Queries, Optimistic Locking & Integrity Constraints)

1
Comments
6 min read
Instagram Clone Backend — Part 4: Security & Authentication (Bearer Tokens, Argon2id, Enumeration Defense, Actor Extraction & Input Protection)

Instagram Clone Backend — Part 4: Security & Authentication (Bearer Tokens, Argon2id, Enumeration Defense, Actor Extraction & Input Protection)

1
Comments
5 min read
Instagram Clone Backend — Part 3: Database & Persistence (PostgreSQL 16+, SQLAlchemy 2.0 Async ORM, asyncpg & Alembic)

Instagram Clone Backend — Part 3: Database & Persistence (PostgreSQL 16+, SQLAlchemy 2.0 Async ORM, asyncpg & Alembic)

1
Comments
5 min read
Instagram Clone Backend — Part 2: Frameworks and Servers (FastAPI, Uvicorn, ASGI & Starlette)

Instagram Clone Backend — Part 2: Frameworks and Servers (FastAPI, Uvicorn, ASGI & Starlette)

1
Comments
4 min read
Instagram Clone Backend — Part 1: Language and Runtime with Python & Asyncio

Instagram Clone Backend — Part 1: Language and Runtime with Python & Asyncio

1
Comments
4 min read
Week-05 ,Task- 1: Asynchronous Python - asyncio Deep Dive

Week-05 ,Task- 1: Asynchronous Python - asyncio Deep Dive

1
Comments
11 min read
Week 4 - Task 2.3 : From Functions to Powerful Decorators 🐍💜

Week 4 - Task 2.3 : From Functions to Powerful Decorators 🐍💜

1
Comments
5 min read
Week 04- Task 2.2: functools Toolkit: reduce, partial, lru_cache & wraps 🧰

Week 04- Task 2.2: functools Toolkit: reduce, partial, lru_cache & wraps 🧰

1
Comments
4 min read
Week 04 - Task 2.1: Functional Programming in Python: map(), filter(), reduce() 🗺️🔎➕

Week 04 - Task 2.1: Functional Programming in Python: map(), filter(), reduce() 🗺️🔎➕

1
Comments
3 min read
Week 04 - Task 1.3 : @dataclass, abstract base classes via the abc module & composition vs inheritance

Week 04 - Task 1.3 : @dataclass, abstract base classes via the abc module & composition vs inheritance

1
Comments
3 min read
Week 04 - Task 1.2: dunder/magic methods (__init__, __repr__, __eq__, __len__, __add__, etc.)

Week 04 - Task 1.2: dunder/magic methods (__init__, __repr__, __eq__, __len__, __add__, etc.)

1
Comments
4 min read
Week 4, Task - 1.1: Classes, Inheritance & MRO 🐍

Week 4, Task - 1.1: Classes, Inheritance & MRO 🐍

Comments
4 min read
Week-04,Task- 1: OOP & Dunder Methods

Week-04,Task- 1: OOP & Dunder Methods

1
Comments
8 min read
🐍 Python Context Managers: The Easy Guide (with, __enter__/__exit__, @contextmanager, contextlib)

🐍 Python Context Managers: The Easy Guide (with, __enter__/__exit__, @contextmanager, contextlib)

Comments 1
4 min read
Week-03 Task-2: Iterators, Generators & Context Managers

Week-03 Task-2: Iterators, Generators & Context Managers

Comments
7 min read
Python Scope, First-Class Functions, *args,**kwargs & Mutable Default Arguments

Python Scope, First-Class Functions, *args,**kwargs & Mutable Default Arguments

Comments
9 min read
The LEGB scoping rule, first-class functions, *args,**kwargs(key-word args),mutable-default-argument pitfall

The LEGB scoping rule, first-class functions, *args,**kwargs(key-word args),mutable-default-argument pitfall

Comments
8 min read
Mastering Advanced Python: Arguments, Closures, and Memory Pitfalls

Mastering Advanced Python: Arguments, Closures, and Memory Pitfalls

Comments
3 min read
Understanding Python Core: References vs. Copies, LEGB Rule, and First-Class Functions

Understanding Python Core: References vs. Copies, LEGB Rule, and First-Class Functions

Comments
2 min read
Day 7 as a Full Stack Intern: Python Data Model Demystified: Everything-Is-An-Object & Mutability

Day 7 as a Full Stack Intern: Python Data Model Demystified: Everything-Is-An-Object & Mutability

Comments
2 min read
Day 6 as a Full Stack Intern: DOM & CSSOM construction , Render tree

Day 6 as a Full Stack Intern: DOM & CSSOM construction , Render tree

Comments
8 min read
Day-5 as Full Stack Intern: Utility-first vs component-scoped styling philosophy (conceptual intro to Tailwind vs CSS Modules)

Day-5 as Full Stack Intern: Utility-first vs component-scoped styling philosophy (conceptual intro to Tailwind vs CSS Modules)

2
Comments
8 min read
Day-5 as Full Stack Intern: Responsive Images & CSS methodologies

Day-5 as Full Stack Intern: Responsive Images & CSS methodologies

1
Comments
12 min read
Day-5 as Full Stack Intern: Media Queries & Fluid Typography

Day-5 as Full Stack Intern: Media Queries & Fluid Typography

2
Comments
8 min read
sample

sample

1
Comments
8 min read
Day 4 as a Full Stack Intern: Grid, Flexbox VS Grid?

Day 4 as a Full Stack Intern: Grid, Flexbox VS Grid?

Comments
7 min read
Day 4 as a Full Stack Intern: Flexbox

Day 4 as a Full Stack Intern: Flexbox

Comments
5 min read
Day 4 as a Full Stack Intern: CSS Layout- Positioning, Flexbox & Grid

Day 4 as a Full Stack Intern: CSS Layout- Positioning, Flexbox & Grid

Comments
2 min read
CSS Foundations: Understanding the Box Model, Cascade and Specificity

CSS Foundations: Understanding the Box Model, Cascade and Specificity

Comments
9 min read
Understanding the CSS Box Model, Cascade & Specificity

Understanding the CSS Box Model, Cascade & Specificity

Comments
3 min read
Day 2 Diaries: Semantic HTML, Accessibility & the Branch 🌿

Day 2 Diaries: Semantic HTML, Accessibility & the Branch 🌿

Comments
4 min read
Day 1 as a Full Stack Intern: Setting Up My First Real Git Workflow

Day 1 as a Full Stack Intern: Setting Up My First Real Git Workflow

Comments
5 min read
loading...