KAHIBARO Bookshelves
Discord Login Register

31.2. User Management

Overview

In an e‑commerce backend, “User Management” is everything related to customers and admins as data in your system, and the operations you perform on them. In this chapter you will not build authentication or authorization, because those are separate chapters. Instead, you will focus on how to model users, store them in the database, and expose clean, RESTful endpoints that the rest of your e‑commerce backend and frontend can rely on.

You will see how user management connects to other parts of the project, such as orders, carts, and admin features, and how to keep the user model simple but flexible.

User Roles in an E‑Commerce Backend

Most e‑commerce applications have at least these user types:

RoleDescriptionTypical actions
CustomerRegular buyer using the storefrontRegister, login, browse, add to cart, place orders
AdminInternal user managing the systemManage products, orders, users, refunds, discounts
SupportOptional, handles customer issuesView orders, update order status, assist customers
GuestNot stored as a user, but relevant to flows like cartBrowse, sometimes keep a temporary cart

You typically represent roles in one of these ways:

  1. Simple enum column
    • role column with values like "customer", "admin".
    • Easy to understand, sufficient for many projects.
  2. Separate role/permission system
    • A roles table and user_roles join table.
    • More complex, usually combined with an authorization module.
    • Better for larger backends with many distinct permissions.

For this project, use a single role column on the users table, for example:

sql
role VARCHAR(20) NOT NULL DEFAULT 'customer'

This is enough to distinguish regular customers from admins in the rest of the e‑commerce backend.

Designing the User Model

User management starts with a solid database model for users. The goal is to store necessary information, but not to mix in unrelated concerns such as cart details or order data.

Essential fields

A minimal users table for an e‑commerce backend might look like this:

ColumnTypePurpose
idUUID or BIGSERIALPrimary key
emailVARCHAR, uniqueLogin identifier, communication
password_hashTEXTHashed password (never store plain text)
first_nameVARCHARUser’s given name
last_nameVARCHARUser’s family name
roleVARCHAR"customer" or "admin"
is_activeBOOLEANCan the user log in and use the system
is_email_verifiedBOOLEANWhether email was confirmed
created_atTIMESTAMP WITH TZWhen the user registered
updated_atTIMESTAMP WITH TZLast profile update

You may also store contact and marketing preferences, such as:

ColumnTypePurpose
phoneVARCHAROptional contact number
marketing_opt_inBOOLEANWhether they accept marketing emails
last_login_atTIMESTAMP WITH TZLast successful login time

Always store passwords as secure hashes, never as plain text or reversible encryption. The exact hashing method is covered in the Password Hashing chapter, not here.

Example table definition

A possible PostgreSQL schema for the users table:

sql
CREATE TABLE users (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    email VARCHAR(255) NOT NULL UNIQUE,
    password_hash TEXT NOT NULL,
    first_name VARCHAR(100) NOT NULL,
    last_name VARCHAR(100) NOT NULL,
    role VARCHAR(20) NOT NULL DEFAULT 'customer',
    is_active BOOLEAN NOT NULL DEFAULT TRUE,
    is_email_verified BOOLEAN NOT NULL DEFAULT FALSE,
    phone VARCHAR(30),
    marketing_opt_in BOOLEAN NOT NULL DEFAULT FALSE,
    last_login_at TIMESTAMPTZ,
    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

You will later connect this users table to other parts of the e‑commerce schema, such as orders and addresses, using foreign keys.

Separating Users from Addresses

In many e‑commerce systems, a user may have multiple addresses:

  • Shipping addresses
  • Billing addresses
  • Work vs home

It is tempting to put address columns directly on the users table, such as street, city, country. That restricts the user to a single address and makes it harder to manage multiple addresses.

Instead, keep addresses in their own table and link them to users:

sql
CREATE TABLE user_addresses (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,
    label VARCHAR(50),  -- for example "Home", "Office"
    full_name VARCHAR(150) NOT NULL,
    line1 VARCHAR(255) NOT NULL,
    line2 VARCHAR(255),
    city VARCHAR(100) NOT NULL,
    state VARCHAR(100),
    postal_code VARCHAR(20) NOT NULL,
    country_code CHAR(2) NOT NULL, -- ISO 3166-1 alpha-2, for example "US"
    phone VARCHAR(30),
    is_default_shipping BOOLEAN NOT NULL DEFAULT FALSE,
    is_default_billing BOOLEAN NOT NULL DEFAULT FALSE,
    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

Key points:

  • user_id connects the address to the users table.
  • ON DELETE CASCADE means that if a user is removed, their addresses are also removed.
  • You support multiple addresses per user, with flags for default shipping and billing.

Example: A single customer with multiple addresses

user_idaddress labelcitydefault_shippingdefault_billing
U1HomeBerlintruetrue
U1OfficeBerlinfalsefalse
U1ParentsMunichfalsefalse

During checkout, the cart or order system references one of these address records.

Public vs Internal User Data

Your API will often need to return user data, for example:

  • A customer viewing their own profile.
  • An admin browsing a paginated list of users.
  • The frontend showing the current user name in the navigation bar.

However, you must never expose sensitive fields directly, such as:

  • password_hash
  • Internal flags that users should not see, for example is_admin_override or internal notes.

The solution is to define separate models for:

  • Data stored in your database.
  • Data accepted in requests.
  • Data returned in responses.

Example with FastAPI and Pydantic-style models:

python
from pydantic import BaseModel, EmailStr
from datetime import datetime
from typing import Optional
class UserBase(BaseModel):
    email: EmailStr
    first_name: str
    last_name: str
class UserCreate(UserBase):
    password: str
class UserUpdate(BaseModel):
    first_name: Optional[str] = None
    last_name: Optional[str] = None
    phone: Optional[str] = None
    marketing_opt_in: Optional[bool] = None
class UserPublic(UserBase):
    id: str
    role: str
    is_active: bool
    is_email_verified: bool
    created_at: datetime

Notice:

  • UserCreate includes a password, but UserPublic does not.
  • The database model (for example SQLAlchemy User class) will contain password_hash, but the public model will not expose it.

Never return password or password_hash fields in any API response, even to the user who owns the account.

User‑Related Endpoints in the E‑Commerce API

User management in this e‑commerce project focuses on operations like:

  • Creating a new user record when a user registers.
  • Reading a user profile.
  • Updating basic user details.
  • Managing addresses.
  • Admin operations over users.

Authentication and token handling are covered in separate chapters. Here you should assume that:

  • There is a way to identify the currently authenticated user from the request.
  • Admin endpoints are protected by an authorization layer that checks user roles.

Typical customer‑facing user endpoints

Here is a set of common REST endpoints for customers:

MethodPathDescription
POST/usersCreate a new user (registration)
GET/users/meGet current user profile
PATCH/users/meUpdate current user profile
GET/users/me/addressesList current user addresses
POST/users/me/addressesAdd new address
PATCH/users/me/addresses/{id}Update address
DELETE/users/me/addresses/{id}Remove address
PATCH/users/me/addresses/{id}/default-shippingSet default shipping address

The exact paths can vary, but it is good practice to:

  • Keep all user‑self operations under /users/me.
  • Avoid exposing user IDs to customers unless necessary.

Example: Create user (registration) endpoint

Even though the Registration logic like email verification is in another chapter, you still define which fields go into the user:

Request:

json
POST /users
{
  "email": "alice@example.com",
  "password": "strong_password_123",
  "first_name": "Alice",
  "last_name": "Doe",
  "marketing_opt_in": true
}

Backend actions:

  1. Validate the input.
  2. Check that email is not already in use.
  3. Hash the password and store it in password_hash.
  4. Insert a new row into users.
  5. Return a UserPublic representation.

Response:

json
201 Created
{
  "id": "a3a737da-63bc-4c5b-95e9-b755c6715e86",
  "email": "alice@example.com",
  "first_name": "Alice",
  "last_name": "Doe",
  "role": "customer",
  "is_active": true,
  "is_email_verified": false,
  "created_at": "2026-03-10T12:34:56Z"
}

Example: Get current user profile

Assuming a token is already checked by authentication middleware, your endpoint might look like this:

http
GET /users/me
Authorization: Bearer <token>

Response:

json
200 OK
{
  "id": "a3a737da-63bc-4c5b-95e9-b755c6715e86",
  "email": "alice@example.com",
  "first_name": "Alice",
  "last_name": "Doe",
  "role": "customer",
  "is_active": true,
  "is_email_verified": true,
  "created_at": "2026-03-10T12:34:56Z"
}

The backend finds the user by the ID extracted from the token and returns the public representation.

Example: Update current user profile

A partial update is usually done through PATCH:

http
PATCH /users/me
Content-Type: application/json
Authorization: Bearer <token>
{
  "first_name": "Alicia",
  "marketing_opt_in": false
}

Your backend:

  1. Loads the current user.
  2. Applies only the fields present in the body.
  3. Saves the updated record.
  4. Returns the updated public user.

Response:

json
200 OK
{
  "id": "a3a737da-63bc-4c5b-95e9-b755c6715e86",
  "email": "alice@example.com",
  "first_name": "Alicia",
  "last_name": "Doe",
  "role": "customer",
  "is_active": true,
  "is_email_verified": true,
  "created_at": "2026-03-10T12:34:56Z"
}

Admin user endpoints

Admins need broader access to the user base, for example:

MethodPathDescription
GET/admin/usersList users, with pagination
GET/admin/users/{id}View a specific user
PATCH/admin/users/{id}Update user role or status
DELETE/admin/users/{id}Deactivate or remove a user

These endpoints should be protected so that only admins can access them. The implementation of that protection is covered in the Authorization chapter.

Example: Admin list users

http
GET /admin/users?page=1&limit=20&email=alice@example.com
Authorization: Bearer <admin-token>

Possible response:

json
200 OK
{
  "items": [
    {
      "id": "a3a737da-63bc-4c5b-95e9-b755c6715e86",
      "email": "alice@example.com",
      "first_name": "Alicia",
      "last_name": "Doe",
      "role": "customer",
      "is_active": true,
      "is_email_verified": true,
      "created_at": "2026-03-10T12:34:56Z"
    }
  ],
  "total": 1,
  "page": 1,
  "limit": 20
}

This shows how user management integrates with pagination and filtering features of your API.

Relationship between Users, Carts, and Orders

In an e‑commerce backend, users are central to other entities. You will rely on the users table as a foreign key target for several features:

Related entityRelationship to usersExample column
CartsOne open cart per user (usually)carts.user_id
OrdersMany orders per userorders.user_id
AddressesMany addresses per useruser_addresses.user_id
Payment methodsMany per user (if you store them)payment_methods.user_id
ReviewsMany reviews per userproduct_reviews.user_id

Even if you allow guest checkout, it is often convenient to create a “shadow” user record for each guest order. That way:

  • You can send order confirmations.
  • If the guest later creates a full account, you can link it to their previous orders.

For example:

sql
CREATE TABLE orders (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    user_id UUID REFERENCES users(id),
    total_amount NUMERIC(10, 2) NOT NULL,
    status VARCHAR(20) NOT NULL,
    placed_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

Each order belongs to exactly one user. In application code, you might fetch all orders for the current user like this (pseudocode):

python
def get_my_orders(current_user_id: str):
    return db.query(Order).filter(Order.user_id == current_user_id).all()

User management must be designed in a way that these relationships are straightforward and efficient.

Example Implementation Sketch with FastAPI and SQLAlchemy

Below is a simplified sketch, showing how user management might look for this project. It focuses on structure, not on every detail.

SQLAlchemy models

python
from sqlalchemy import Column, String, Boolean, DateTime, ForeignKey
from sqlalchemy.dialects.postgresql import UUID
from sqlalchemy.orm import relationship
import uuid
from datetime import datetime
from .database import Base  # your Base from SQLAlchemy setup
class User(Base):
    __tablename__ = "users"
    id = Column(UUID(as_uuid=True), primary_key=True, default=uuid.uuid4)
    email = Column(String(255), unique=True, nullable=False)
    password_hash = Column(String, nullable=False)
    first_name = Column(String(100), nullable=False)
    last_name = Column(String(100), nullable=False)
    role = Column(String(20), nullable=False, default="customer")
    is_active = Column(Boolean, nullable=False, default=True)
    is_email_verified = Column(Boolean, nullable=False, default=False)
    phone = Column(String(30))
    marketing_opt_in = Column(Boolean, nullable=False, default=False)
    last_login_at = Column(DateTime(timezone=True))
    created_at = Column(DateTime(timezone=True), default=datetime.utcnow, nullable=False)
    updated_at = Column(DateTime(timezone=True), default=datetime.utcnow, nullable=False)
    addresses = relationship("UserAddress", back_populates="user", cascade="all, delete-orphan")
class UserAddress(Base):
    __tablename__ = "user_addresses"
    id = Column(UUID(as_uuid=True), primary_key=True, default=uuid.uuid4)
    user_id = Column(UUID(as_uuid=True), ForeignKey("users.id", ondelete="CASCADE"), nullable=False)
    label = Column(String(50))
    full_name = Column(String(150), nullable=False)
    line1 = Column(String(255), nullable=False)
    line2 = Column(String(255))
    city = Column(String(100), nullable=False)
    state = Column(String(100))
    postal_code = Column(String(20), nullable=False)
    country_code = Column(String(2), nullable=False)
    phone = Column(String(30))
    is_default_shipping = Column(Boolean, nullable=False, default=False)
    is_default_billing = Column(Boolean, nullable=False, default=False)
    created_at = Column(DateTime(timezone=True), default=datetime.utcnow, nullable=False)
    updated_at = Column(DateTime(timezone=True), default=datetime.utcnow, nullable=False)
    user = relationship("User", back_populates="addresses")

Router example for `/users/me`

python
from fastapi import APIRouter, Depends, HTTPException, status
from sqlalchemy.orm import Session
from . import models, schemas
from .dependencies import get_db, get_current_user  # defined in your auth-related code
router = APIRouter(prefix="/users", tags=["users"])
@router.get("/me", response_model=schemas.UserPublic)
def read_current_user(
    db: Session = Depends(get_db),
    current_user: models.User = Depends(get_current_user),
):
    return current_user
@router.patch("/me", response_model=schemas.UserPublic)
def update_current_user(
    payload: schemas.UserUpdate,
    db: Session = Depends(get_db),
    current_user: models.User = Depends(get_current_user),
):
    if payload.first_name is not None:
        current_user.first_name = payload.first_name
    if payload.last_name is not None:
        current_user.last_name = payload.last_name
    if payload.phone is not None:
        current_user.phone = payload.phone
    if payload.marketing_opt_in is not None:
        current_user.marketing_opt_in = payload.marketing_opt_in
    db.add(current_user)
    db.commit()
    db.refresh(current_user)
    return current_user

The get_current_user dependency and password hashing routines are not part of this chapter. They are handled by authentication components of your backend.

Soft Deletion vs Hard Deletion

User records are often tied to orders, invoices, and legal requirements, so deleting them fully can be problematic. Instead, many systems use soft deletion, where the user is marked as inactive while their data stays in the database.

Common approaches:

StrategyHow it worksExample column
is_active flagPrevents login and interactionsis_active = false
deleted_at columnTimestamp of deactivationdeleted_at timestamp
Full deletionRemove record and cascade to related tablesDELETE FROM users

For an e‑commerce system, a common pattern is:

  • Use is_active = false to disable accounts.
  • Keep orders and related data intact.
  • Optionally anonymize personal fields, for example replace email with a hashed value.

Example admin action:

python
def deactivate_user(user: User, db: Session):
    user.is_active = False
    db.add(user)
    db.commit()

Your authentication layer should prevent inactive users from logging in or using the API.

Summary

In this chapter you saw how user management fits into the e‑commerce backend project:

  • Define a clean users table with roles and status flags.
  • Separate user data from addresses, so each user can have multiple addresses.
  • Expose safe public representations of users, and never return password data.
  • Provide user‑self endpoints under /users/me and reserved admin endpoints under /admin/users.
  • Link users to carts, orders, and other e‑commerce entities using foreign keys.
  • Prefer soft deletion or deactivation for users, instead of removing them entirely.

These foundations allow the rest of the e‑commerce backend, such as orders, carts, and admin tools, to rely on a robust and consistent user system.

Views: 0

Comments

Please login to add a comment.

Don't have an account? Register now!

Where to Move

Move chapter:

  • ☰ 1. Introduction to Backend Development
    • ☰ 1.1. What Is Backend Development?
      • ☰ 1.2. Frontend vs Backend
        • ☰ 1.3. How Web Applications Work
          • ☰ 1.4. Client-Server Architecture
            • ☰ 1.5. Request-Response Cycle
              • ☰ 1.6. Static vs Dynamic Websites
                • ☰ 1.7. Backend Developer Responsibilities
                  • ☰ 1.8. Backend Development Roadmap
                  • ☰ 2. How the Web Works
                    • ☰ 2.1. The Internet and the Web
                      • ☰ 2.2. IP Addresses
                        • ☰ 2.3. Domain Names
                          • ☰ 2.4. DNS
                            • ☰ 2.5. Ports
                              • ☰ 2.6. TCP/IP Basics
                                • ☰ 2.7. HTTP and HTTPS
                                  • ☰ 2.8. HTTP Requests
                                    • ☰ 2.9. HTTP Responses
                                      • ☰ 2.10. HTTP Methods
                                        • ☰ 2.11. HTTP Status Codes
                                          • ☰ 2.12. HTTP Headers
                                            • ☰ 2.13. Cookies
                                              • ☰ 2.14. Sessions
                                                • ☰ 2.15. What Happens When You Enter a URL?
                                                • ☰ 3. Development Environment
                                                  • ☰ 3.1. Choosing an Operating System
                                                    • ☰ 3.2. Linux Basics for Backend Developers
                                                      • ☰ 3.3. Command Line Basics
                                                        • ☰ 3.4. Environment Variables
                                                          • ☰ 3.5. Installing Development Tools
                                                            • ☰ 3.6. Code Editors and IDEs
                                                              • ☰ 3.7. Git
                                                                • ☰ 3.8. GitHub and GitLab
                                                                  • ☰ 3.9. Creating Your First Repository
                                                                    • ☰ 3.10. Branches and Commits
                                                                      • ☰ 3.11. Basic Git Workflow
                                                                      • ☰ 4. Programming Fundamentals
                                                                        • ☰ 4.1. Variables and Data Types
                                                                          • ☰ 4.2. Operators
                                                                            • ☰ 4.3. Conditions
                                                                              • ☰ 4.4. Loops
                                                                                • ☰ 4.5. Functions
                                                                                  • ☰ 4.6. Data Structures
                                                                                    • ☰ 4.7. Error Handling
                                                                                      • ☰ 4.8. Modules and Packages
                                                                                        • ☰ 4.9. File Handling
                                                                                          • ☰ 4.10. Object-Oriented Programming
                                                                                            • ☰ 4.11. Classes and Objects
                                                                                              • ☰ 4.12. Inheritance and Composition
                                                                                                • ☰ 4.13. Clean Code Principles
                                                                                                • ☰ 5. Python for Backend Development
                                                                                                  • ☰ 5.1. Introduction to Python
                                                                                                    • ☰ 5.2. Installing Python
                                                                                                      • ☰ 5.3. Virtual Environments
                                                                                                        • ☰ 5.4. pip and Package Management
                                                                                                          • ☰ 5.5. Python Project Structure
                                                                                                            • ☰ 5.6. Functions and Type Hints
                                                                                                              • ☰ 5.7. Classes and Dataclasses
                                                                                                                • ☰ 5.8. Exceptions
                                                                                                                  • ☰ 5.9. Working with Files
                                                                                                                    • ☰ 5.9.1. File Downloads
                                                                                                                      • ☰ 5.9.2. File Validation
                                                                                                                        • ☰ 5.9.3. Image Uploads
                                                                                                                          • ☰ 5.9.4. Local File Storage
                                                                                                                            • ☰ 5.9.5. Object Storage
                                                                                                                              • ☰ 5.9.6. S3-Compatible Storage
                                                                                                                                • ☰ 5.9.7. Presigned URLs
                                                                                                                                  • ☰ 5.9.8. Secure File Handling
                                                                                                                                  • ☰ 5.10. JSON
                                                                                                                                    • ☰ 5.11. Date and Time
                                                                                                                                      • ☰ 5.12. Logging
                                                                                                                                        • ☰ 5.13. Configuration
                                                                                                                                          • ☰ 5.14. Environment Variables
                                                                                                                                            • ☰ 5.15. Async Programming
                                                                                                                                              • ☰ 5.16. Python Backend Best Practices
                                                                                                                                              • ☰ 6. Introduction to Web Backends
                                                                                                                                                • ☰ 6.1. Building a Simple Web Server
                                                                                                                                                  • ☰ 6.2. Routing
                                                                                                                                                    • ☰ 6.3. URL Parameters
                                                                                                                                                      • ☰ 6.4. Query Parameters
                                                                                                                                                        • ☰ 6.5. Request Bodies
                                                                                                                                                          • ☰ 6.6. Form Data
                                                                                                                                                            • ☰ 6.7. JSON Requests
                                                                                                                                                              • ☰ 6.8. Returning Responses
                                                                                                                                                                • ☰ 6.9. Templates
                                                                                                                                                                  • ☰ 6.10. Static Files
                                                                                                                                                                    • ☰ 6.11. Middleware
                                                                                                                                                                      • ☰ 6.12. Application Configuration
                                                                                                                                                                      • ☰ 7. REST APIs
                                                                                                                                                                        • ☰ 7.1. What Is an API?
                                                                                                                                                                          • ☰ 7.2. What Is REST?
                                                                                                                                                                            • ☰ 7.3. Resources and Endpoints
                                                                                                                                                                              • ☰ 7.4. RESTful URL Design
                                                                                                                                                                                • ☰ 7.5. HTTP Methods in REST
                                                                                                                                                                                  • ☰ 7.6. GET Requests
                                                                                                                                                                                    • ☰ 7.7. POST Requests
                                                                                                                                                                                      • ☰ 7.8. PUT Requests
                                                                                                                                                                                        • ☰ 7.9. PATCH Requests
                                                                                                                                                                                          • ☰ 7.10. DELETE Requests
                                                                                                                                                                                            • ☰ 7.11. Request Validation
                                                                                                                                                                                              • ☰ 7.12. Response Models
                                                                                                                                                                                                • ☰ 7.13. HTTP Status Codes
                                                                                                                                                                                                  • ☰ 7.14. Error Responses
                                                                                                                                                                                                    • ☰ 7.15. Pagination
                                                                                                                                                                                                      • ☰ 7.16. Filtering
                                                                                                                                                                                                        • ☰ 7.17. Sorting
                                                                                                                                                                                                          • ☰ 7.18. Searching
                                                                                                                                                                                                            • ☰ 7.19. API Versioning
                                                                                                                                                                                                              • ☰ 7.20. API Documentation
                                                                                                                                                                                                                • ☰ 7.21. OpenAPI and Swagger
                                                                                                                                                                                                                • ☰ 8. FastAPI
                                                                                                                                                                                                                  • ☰ 8.1. Introduction to FastAPI
                                                                                                                                                                                                                    • ☰ 8.2. Routes and Path Operations
                                                                                                                                                                                                                      • ☰ 8.3. Path Parameters
                                                                                                                                                                                                                        • ☰ 8.4. Pydantic Models
                                                                                                                                                                                                                          • ☰ 8.5. Data Validation
                                                                                                                                                                                                                            • ☰ 8.6. Dependency Injection
                                                                                                                                                                                                                              • ☰ 8.7. Exception Handling
                                                                                                                                                                                                                                • ☰ 8.8. Background Tasks
                                                                                                                                                                                                                                  • ☰ 8.9. File Uploads
                                                                                                                                                                                                                                    • ☰ 8.10. Async Endpoints
                                                                                                                                                                                                                                      • ☰ 8.11. FastAPI Project Structure
                                                                                                                                                                                                                                        • ☰ 8.12. Building a Complete REST API
                                                                                                                                                                                                                                        • ☰ 9. Databases
                                                                                                                                                                                                                                          • ☰ 9.1. Introduction to Databases
                                                                                                                                                                                                                                            • ☰ 9.2. Relational vs NoSQL Databases
                                                                                                                                                                                                                                              • ☰ 9.3. Tables, Rows, and Columns
                                                                                                                                                                                                                                                • ☰ 9.4. Primary Keys
                                                                                                                                                                                                                                                  • ☰ 9.5. Foreign Keys
                                                                                                                                                                                                                                                    • ☰ 9.6. Relationships
                                                                                                                                                                                                                                                      • ☰ 9.7. One-to-One Relationships
                                                                                                                                                                                                                                                        • ☰ 9.8. One-to-Many Relationships
                                                                                                                                                                                                                                                          • ☰ 9.9. Many-to-Many Relationships
                                                                                                                                                                                                                                                            • ☰ 9.10. Database Schema Design
                                                                                                                                                                                                                                                              • ☰ 9.11. Normalization
                                                                                                                                                                                                                                                                • ☰ 9.12. Indexes
                                                                                                                                                                                                                                                                  • ☰ 9.13. Transactions
                                                                                                                                                                                                                                                                    • ☰ 9.14. ACID Properties
                                                                                                                                                                                                                                                                    • ☰ 10. SQL
                                                                                                                                                                                                                                                                      • ☰ 10.1. Introduction to SQL
                                                                                                                                                                                                                                                                        • ☰ 10.2. CREATE
                                                                                                                                                                                                                                                                          • ☰ 10.3. INSERT
                                                                                                                                                                                                                                                                            • ☰ 10.4. SELECT
                                                                                                                                                                                                                                                                              • ☰ 10.5. UPDATE
                                                                                                                                                                                                                                                                                • ☰ 10.6. DELETE
                                                                                                                                                                                                                                                                                  • ☰ 10.7. WHERE
                                                                                                                                                                                                                                                                                    • ☰ 10.8. ORDER BY
                                                                                                                                                                                                                                                                                      • ☰ 10.9. GROUP BY
                                                                                                                                                                                                                                                                                        • ☰ 10.10. Aggregate Functions
                                                                                                                                                                                                                                                                                          • ☰ 10.11. JOINs
                                                                                                                                                                                                                                                                                            • ☰ 10.12. Subqueries
                                                                                                                                                                                                                                                                                              • ☰ 10.13. Constraints
                                                                                                                                                                                                                                                                                                • ☰ 10.14. Indexes
                                                                                                                                                                                                                                                                                                  • ☰ 10.15. Transactions
                                                                                                                                                                                                                                                                                                    • ☰ 10.16. Common Table Expressions
                                                                                                                                                                                                                                                                                                      • ☰ 10.17. SQL Performance Basics
                                                                                                                                                                                                                                                                                                      • ☰ 11. PostgreSQL
                                                                                                                                                                                                                                                                                                        • ☰ 11.1. Introduction to PostgreSQL
                                                                                                                                                                                                                                                                                                          • ☰ 11.2. Installing PostgreSQL
                                                                                                                                                                                                                                                                                                            • ☰ 11.3. Creating Databases
                                                                                                                                                                                                                                                                                                              • ☰ 11.4. Users and Roles
                                                                                                                                                                                                                                                                                                                • ☰ 11.5. Permissions
                                                                                                                                                                                                                                                                                                                  • ☰ 11.6. PostgreSQL Data Types
                                                                                                                                                                                                                                                                                                                    • ☰ 11.7. Constraints
                                                                                                                                                                                                                                                                                                                      • ☰ 11.8. Indexes
                                                                                                                                                                                                                                                                                                                        • ☰ 11.9. Transactions
                                                                                                                                                                                                                                                                                                                          • ☰ 11.10. JSON Data
                                                                                                                                                                                                                                                                                                                            • ☰ 11.11. Backup and Restore
                                                                                                                                                                                                                                                                                                                              • ☰ 11.12. PostgreSQL Performance Basics
                                                                                                                                                                                                                                                                                                                              • ☰ 12. ORM and Database Integration
                                                                                                                                                                                                                                                                                                                                • ☰ 12.1. What Is an ORM?
                                                                                                                                                                                                                                                                                                                                  • ☰ 12.2. SQLAlchemy
                                                                                                                                                                                                                                                                                                                                    • ☰ 12.3. Models
                                                                                                                                                                                                                                                                                                                                      • ☰ 12.4. Database Sessions
                                                                                                                                                                                                                                                                                                                                        • ☰ 12.5. Creating Records
                                                                                                                                                                                                                                                                                                                                          • ☰ 12.6. Reading Records
                                                                                                                                                                                                                                                                                                                                            • ☰ 12.7. Updating Records
                                                                                                                                                                                                                                                                                                                                              • ☰ 12.8. Deleting Records
                                                                                                                                                                                                                                                                                                                                                • ☰ 12.9. Relationships
                                                                                                                                                                                                                                                                                                                                                  • ☰ 12.10. Queries
                                                                                                                                                                                                                                                                                                                                                    • ☰ 12.11. Transactions
                                                                                                                                                                                                                                                                                                                                                      • ☰ 12.12. Connection Pooling
                                                                                                                                                                                                                                                                                                                                                        • ☰ 12.13. Database Migrations
                                                                                                                                                                                                                                                                                                                                                          • ☰ 12.14. Alembic
                                                                                                                                                                                                                                                                                                                                                            • ☰ 12.15. Repository Pattern
                                                                                                                                                                                                                                                                                                                                                            • ☰ 13. Authentication
                                                                                                                                                                                                                                                                                                                                                              • ☰ 13.1. Authentication vs Authorization
                                                                                                                                                                                                                                                                                                                                                                • ☰ 13.2. Password Storage
                                                                                                                                                                                                                                                                                                                                                                  • ☰ 13.3. Password Hashing
                                                                                                                                                                                                                                                                                                                                                                    • ☰ 13.4. Registration
                                                                                                                                                                                                                                                                                                                                                                      • ☰ 13.5. Login
                                                                                                                                                                                                                                                                                                                                                                        • ☰ 13.6. Tokens
                                                                                                                                                                                                                                                                                                                                                                          • ☰ 13.7. JSON Web Tokens
                                                                                                                                                                                                                                                                                                                                                                            • ☰ 13.8. Access Tokens
                                                                                                                                                                                                                                                                                                                                                                              • ☰ 13.9. Refresh Tokens
                                                                                                                                                                                                                                                                                                                                                                                • ☰ 13.10. OAuth 2.0
                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 13.11. OpenID Connect
                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 13.12. Social Login
                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 13.13. Logout
                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 13.14. Password Reset
                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 13.15. Email Verification
                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 13.16. Multi-Factor Authentication
                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 14. Authorization
                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 14.1. Users and Permissions
                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 14.2. Role-Based Access Control
                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 14.3. Permission-Based Access Control
                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 14.4. Protecting API Endpoints
                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 14.5. Admin Permissions
                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 14.6. Resource Ownership
                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 14.7. Authorization Best Practices
                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 15. Backend Security
                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 15.1. Introduction to Web Security
                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 15.2. HTTPS and TLS
                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 15.3. SQL Injection
                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 15.4. Cross-Site Scripting
                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 15.5. Cross-Site Request Forgery
                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 15.6. CORS
                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 15.7. Authentication Attacks
                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 15.8. Brute-Force Protection
                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 15.9. Rate Limiting
                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 15.10. Input Validation
                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 15.11. Secure Password Storage
                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 15.12. Secrets Management
                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 15.13. Secure Cookies
                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 15.14. Security Headers
                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 15.15. File Upload Security
                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 15.16. Dependency Vulnerabilities
                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 15.17. OWASP Top 10
                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 16. Caching
                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 16.1. Why Caching Matters
                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 16.2. Application Caching
                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 16.3. Redis
                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 16.3.1. Introduction to Redis
                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 16.3.2. Installing Redis
                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 16.3.3. Keys and Values
                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 16.3.4. Expiration
                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 16.3.5. Distributed Locks
                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 16.4. Cache Keys
                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 16.5. Cache Invalidation
                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 16.6. Caching Database Queries
                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 16.7. Distributed Caching
                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 17. Background Processing
                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 17.1. Synchronous vs Asynchronous Tasks
                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 17.2. Background Jobs
                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 17.3. Message Queues
                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 17.4. Celery
                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 17.5. Redis as a Message Broker
                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 17.6. Scheduled Tasks
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 17.7. Retry Strategies
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 17.8. Handling Failed Jobs
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 17.9. Email Jobs
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 17.10. Long-Running Tasks
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 18. Email
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 18.1. How Email Works
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 18.2. SMTP
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 18.3. Sending Emails
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 18.4. HTML Emails
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 18.5. Transactional Emails
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 18.6. Password Reset Emails
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 18.7. Background Email Delivery
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 18.8. Email Delivery Best Practices
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 19. Testing
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 19.1. Why Backend Testing Matters
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 19.2. Unit Testing
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 19.3. Integration Testing
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 19.4. API Testing
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 19.5. pytest
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 19.6. Fixtures
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 19.7. Mocking
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 19.8. Testing Databases
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 19.9. Testing Authentication
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 19.10. Testing FastAPI
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 19.11. Test Coverage
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 19.12. Automated Testing
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 20. Logging and Monitoring
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 20.1. Application Logging
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 20.2. Log Levels
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 20.3. Structured Logging
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 20.4. Request Logging
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 20.5. Error Logging
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 20.6. Metrics
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 20.7. Health Checks
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 20.8. Monitoring
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 20.9. Prometheus
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 20.10. Grafana
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 20.11. Alerting
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 20.12. Error Tracking
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 20.13. Observability Basics
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 21. Docker
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 21.1. Introduction to Containers
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 21.2. Docker Architecture
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 21.3. Images
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 21.4. Containers
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 21.5. Dockerfiles
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 21.6. Building Images
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 21.7. Running Containers
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 21.8. Volumes
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 21.9. Networks
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 21.10. Docker Compose
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 21.11. FastAPI with Docker
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 21.12. PostgreSQL with Docker
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 21.13. Redis with Docker
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 21.14. Multi-Container Applications
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 21.15. Production Docker Best Practices
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 22. Web Servers and Reverse Proxies
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 22.1. Application Servers
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 22.2. Uvicorn
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 22.3. Gunicorn
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 22.4. Reverse Proxies
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 22.5. Nginx
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 22.6. Traefik
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 22.7. HTTPS
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 22.8. TLS Certificates
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 22.9. Let's Encrypt
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 22.10. Load Balancing
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 23. Deployment
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 23.1. Development vs Production
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 23.2. Preparing an Application for Production
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 23.3. Linux Server Setup
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 23.4. Deploying with Docker
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 23.5. Environment Configuration
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 23.6. Managing Secrets
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 23.7. HTTPS Configuration
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 23.8. Production Logging
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 23.9. Backups
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 23.10. Zero-Downtime Deployment
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 23.11. Rollbacks
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 24. CI/CD
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 24.1. Introduction to CI/CD
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 24.2. Continuous Integration
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 24.3. Continuous Delivery
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 24.4. Continuous Deployment
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 24.5. CI/CD Pipelines
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 24.6. GitHub Actions
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 24.7. GitLab CI/CD
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 24.8. Building Docker Images
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 24.9. Container Registries
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 24.10. Deployment Pipelines
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 24.11. Staging Environments
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 24.12. Production Environments
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 24.13. Rollback Strategies
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 25. Backend Architecture
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 25.1. Monolithic Architecture
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 25.2. Modular Monoliths
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 25.3. Microservices
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 25.4. Layered Architecture
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 25.5. Service Layer
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 25.6. Separation of Concerns
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 25.7. Domain-Driven Design Basics
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 25.8. Event-Driven Architecture
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 25.9. Choosing an Architecture
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 26. Performance and Scalability
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 26.1. Understanding Backend Performance
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 26.2. CPU-Bound vs I/O-Bound Work
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 26.3. Asynchronous Programming
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 26.4. Database Optimization
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 26.5. Query Optimization
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 26.6. Indexing
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 26.7. Load Balancing
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 26.8. Horizontal Scaling
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 26.9. Vertical Scaling
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 26.10. Stateless Applications
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 26.11. Performance Testing
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 26.12. Load Testing
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 27. Advanced API Development
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 27.1. WebSockets
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 27.2. Server-Sent Events
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 27.3. GraphQL
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 27.4. Webhooks
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 27.5. Idempotency
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 27.6. API Rate Limiting
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 27.7. API Keys
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 27.8. API Gateways
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 27.9. Distributed APIs
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 27.10. Real-Time Applications
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 28. Production Backend Engineering
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 28.1. Configuration Management
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 28.2. Database Backups
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 28.3. Disaster Recovery
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 28.4. Graceful Shutdown
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 28.5. Fault Tolerance
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 28.6. Circuit Breakers
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 28.7. High Availability
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 28.8. Monitoring Production Systems
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 28.9. Incident Response
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 29. Project 1: Task Management API
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 29.1. Project Requirements
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 29.2. Project Structure
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 29.3. Database Design
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 29.4. CRUD Operations
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 29.5. Validation
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 30. Project 2: Authentication System
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 30.1. User Registration
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 30.2. JWT Authentication
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 30.3. Role-Based Authorization
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 30.4. Security Testing
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 31. Project 3: E-Commerce Backend
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 31.1. Architecture
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 31.2. User Management
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 31.3. Product Management
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 31.4. Categories
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 31.5. Shopping Cart
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 31.6. Orders
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 31.7. Inventory
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 31.8. Payments
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 31.9. Admin API
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 32. Final Project: Production Backend
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 32.1. Planning the Application
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 32.2. Designing the Architecture
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 32.3. Designing the Database
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 32.4. Building the REST API
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 32.5. Authentication and Authorization
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 32.6. PostgreSQL Integration
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 32.7. Redis Integration
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 32.8. Background Workers
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 32.9. File Storage
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 32.10. Dockerizing the Application
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 32.11. CI/CD Pipeline
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 32.12. Production Deployment
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 32.13. HTTPS and Domain Setup
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 32.14. Performance Optimization
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 32.15. Security Review
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 32.16. Documentation
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 33. Backend Developer Roadmap
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 33.1. What You Should Know Now
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 33.2. Building a Portfolio
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • ☰ 33.3. Creating Backend Projects
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • ☰ 33.4. Contributing to Open Source
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • ☰ 33.5. Preparing for Backend Interviews
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • ☰ 33.6. Backend Interview Questions
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • ☰ 33.7. Database Interview Questions
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • ☰ 33.8. API Interview Questions
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • ☰ 33.9. Linux and Docker Interview Questions
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • ☰ 33.10. Where to Go Next