creator profile · 146 approved skills · page 1 of 15
wshobson publishes 146 approved skills on explainx.ai. This page loads 10 skills at a time. Current page is led by sql-optimization-patterns.
total skills
146
showing 10 on this page
page installs
96
96 this week
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to eliminate slow queries. \n \n Covers EXPLAIN plan analysis with key metrics (Seq Scan, Index Scan, cost…
Modern Python tooling, naming conventions, type checking, and documentation standards for maintainable codebases. \n \n Configure ruff for unified linting and formatting, replacin…
Fundamental design principles for writing maintainable, testable Python code. \n \n Covers five core patterns: KISS (Keep It Simple), Single Responsibility Principle, Separation o…
Profile and optimize Python code using cProfile, memory profilers, and performance best practices. \n \n Covers CPU profiling with cProfile, line-by-line profiling with line_profi…
Implement proven backend architecture patterns for maintainable, testable, and scalable systems. \n \n Covers three core patterns: Clean Architecture (layered dependency inward),…
High-performance game development with Unity's data-oriented Entity Component System, Jobs, and Burst Compiler. \n \n Covers core ECS patterns including components, systems, entit…
Production-ready Grafana dashboards for system and application metrics visualization. \n \n Covers RED method (Rate, Errors, Duration) for services and USE method (Utilization, Sa…
Production-ready Kubernetes manifests for Deployments, Services, ConfigMaps, Secrets, and PersistentVolumeClaims. \n \n Covers eight core resource types with step-by-step guidance…
$22
Comprehensive guide to designing distributed systems with service boundaries, communication patterns, and resilience strategies. \n \n Covers service decomposition by business cap…
