#Backend.
Back-end development tutorials covering server-side programming, databases, APIs, and server management.
PostgreSQL Performance Tuning: Query Plans & Connection Pooling
Practical PostgreSQL tuning guide: read EXPLAIN ANALYZE, fix slow queries, use PgBouncer for pooling, and optimize autovacuum for high-performance databases.
Python Type Hints: A Practical Guide for Real Codebases
Use Python type hints effectively with annotations, generics, and Pydantic. Learn to avoid common production gotchas and master tools like mypy and pyright.
Database Indexing: B-trees, Composite Indexes & Performance
Learn how database indexes work, from B-trees to partial indexes. Understand composite index order and how to use EXPLAIN ANALYZE for better performance.
How to Set Up a Reverse Proxy with Nginx
Step-by-step guide to setting up Nginx as a reverse proxy for your web apps. Learn to configure HTTPS, security headers, WebSocket support, and rate limiting.
jq Cheat Sheet: Filter, Transform, and Query JSON from the Terminal
Complete jq reference — basic filters, pipes, array/object operations, conditionals, string interpolation, select, map, reduce, and real DevOps workflows.
TypeScript Generics: Advanced Real-World Design Patterns
Master TypeScript generics with practical examples. Learn constraints, conditional types, mapped types, and advanced patterns for robust production code.
Python Async/Await: The Complete Guide for Developers
Master Python asyncio, including async/await syntax, event loops, and concurrent execution. Learn real-world patterns to build production-ready async systems.
How to Use Environment Variables in Docker
Manage environment variables in Docker containers and Compose files — inline values, .env files, runtime injection, secrets, and production patterns.
PostgreSQL JSONB: Query Patterns & Performance Optimization
Master PostgreSQL JSONB — operators, indexing, querying nested data, aggregation, and performance tuning. Real-world patterns for modern applications.
Docker Compose Cheat Sheet: Services, Volumes & Production
A complete Docker Compose guide covering service definitions, volumes, networks, and health checks. Includes production-ready templates and CLI commands.
Nginx Cheat Sheet: Routing, SSL & Performance Guide
Complete Nginx reference for server blocks, location matching, and proxy_pass. Optimize SSL/TLS, rate limiting, and use our production-ready config template.
SQL Cheat Sheet: Queries, Joins, Aggregates & CTEs
The ultimate SQL reference for SELECT syntax, JOINs, subqueries, and window functions. Master CTEs, transactions, and constraints for any relational database.
Run PostgreSQL Locally with Docker in Under 2 Minutes
Learn to run PostgreSQL locally using Docker. Includes persistent volumes, docker-compose setup, GUI client access, and essential dump or restore commands.
How to Debug a Slow SQL Query in PostgreSQL
Step-by-step: find slow queries with pg_stat_statements, read EXPLAIN ANALYZE output, identify missing indexes, fix N+1 queries, and diagnose lock contention.
PostgreSQL Cheat Sheet: SQL, Indexes, EXPLAIN & psql
Complete PostgreSQL reference — psql commands, CRUD queries, joins, indexes, EXPLAIN ANALYZE, CTEs, window functions, JSONB operators, and admin queries.