#Backend.
11 posts filed under this topic.
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: Real-World Patterns You Actually Need
Master TypeScript generics — constraints, conditional types, mapped types, utility types, and advanced patterns for production code. Practical examples for every pattern.
Python Async/Await: The Complete Guide for Developers
Master Python asyncio — async/await syntax, event loops, concurrent execution, real-world patterns, and performance optimization. From basics to production-ready code.
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, Networks & Production Patterns
Complete Docker Compose reference — service definitions, volumes, networks, environment variables, health checks, overrides, and production-ready compose file templates.
Nginx Cheat Sheet: Config, Routing, SSL & Performance
Complete Nginx reference — server blocks, location matching, proxy_pass, SSL/TLS, gzip, rate limiting, headers, redirects, and a production-ready config template.
SQL Cheat Sheet: Queries, Joins, Aggregates & More
Complete SQL reference — SELECT syntax, JOINs, GROUP BY, subqueries, window functions, CTEs, transactions, constraints, data types, and common patterns for any relational database.
How to Run PostgreSQL Locally with Docker
Run a full PostgreSQL database locally in under 2 minutes using Docker — with persistent volumes, docker-compose setup, GUI client access, and dump/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.