Other Topics #

JSON: A complete guide to working with JSON in Python — parsing, serialization, custom encoders/decoders, validation, error handling, and common patterns in real-world application development.
YAML: A complete guide to working with YAML in Python using PyYAML — YAML syntax, safe_load vs load, custom object serialization, anchors & aliases, multi-document files, and application configuration patterns.
SQL: MySQL A complete guide to connecting to MySQL from Python using mysql-connector-python — creating connections, CRUD operations, parameterized queries, transactions, connection pooling, and safe error handling. MSSQL A complete guide to connecting to Microsoft SQL Server from Python using pyodbc — connection strings, CRUD operations, parameterized queries, stored procedures, transactions, and production-safe connection patterns. Oracle A complete guide to connecting to Oracle Database from Python using python-oracledb — thin/thick modes, CRUD operations, named placeholders, RETURNING INTO, stored procedures, transactions, and LOB handling.
NoSQL: MongoDB A complete guide to MongoDB in Python using PyMongo — connections, CRUD operations, query operators, projections, sorting, pagination, aggregation pipelines, indexing, and safe connection patterns. Elasticsearch A complete guide to Elasticsearch in Python using elasticsearch-py 8.x — connections with authentication, indexing, full-text search, bool queries, aggregation, bulk operations, and mappings.
Message Brokers: Kafka A complete guide to Apache Kafka in Python using kafka-python — topic/partition/consumer group concepts, producers with JSON serialization, consumers with manual commits, and robust error handling. RabbitMQ A complete guide to RabbitMQ in Python using Pika — Exchange/Queue/Binding concepts, exchange types, producers with persistent messages, consumers with manual ack, Dead Letter Exchanges, and reconnection. Amazon SQS A complete guide to Amazon SQS in Python using Boto3 — Standard vs FIFO Queues, Visibility Timeout, Long Polling, JSON serialization, batch operations, Dead Letter Queues, and robust consumer loops.
Caching: Redis A complete guide to Redis in Python using redis-py — connections with connection pooling, data structures (String, Hash, List, Set, Sorted Set), caching patterns, pipelines, Pub/Sub, distributed locks, and error handling. Memcached A complete guide to Memcached in Python using pymemcache — connections, JSON serialization, CRUD operations with TTL, PooledClient, HashClient for multi-server distribution, and comparisons with Redis.
Frameworks: Django A complete guide to Django — project setup, application structure, models, migrations, views, URL routing, templates, REST APIs with DRF, middleware, and production configuration. FastAPI A complete guide to FastAPI — setup, Pydantic models, path/query/body parameters, dependency injection, middleware, JWT authentication, background tasks, SQLAlchemy database integration, and testing. Flask A complete guide to Flask — setup, routing, blueprints, request/response, Jinja2 templates, JSON REST APIs, error handling, middleware, environment-based configuration, and testing with pytest.
Libraries: PyTest A complete guide to PyTest — test structure, fixtures with scope, conftest.py, parametrize, monkeypatch, mocking, coverage reports, pyproject.toml configuration, and correct testing patterns for Python applications. Selenium A complete guide to Selenium 4 in Python — WebDriver Manager setup, By locators, explicit waits, the Page Object Model, ActionChains, screenshots, pytest integration, and reliable automation patterns for testing and scraping.
Articles & Resources: A curated collection of articles, documentation, and YouTube videos for learning Python — from beginner to advanced, covering web development, data science, testing, DevOps, and the Python library ecosystem.