expert▌

SQLite database expert for Tauri/desktop apps with SQL injection prevention, migrations, FTS search, and secure data handling. \n \n Enforces parameterized queries and input validation to prevent SQL injection; includes security checklist and reference patterns for all user-input database operations \n Covers database initialization with performance PRAGMAs (WAL mode, foreign keys), transaction management, connection pooling, and batch operations \n Implements Full-Text Search (FTS5) with virtua

Vue 3 components and composables in JavaScript with comprehensive JSDoc type coverage, no TypeScript required. \n \n Builds with <script setup> and .mjs modules using @typedef , @param , and @returns JSDoc annotations for full type safety without a TypeScript compiler \n Covers component architecture (props, emits, slots), custom composables, Pinia state management, and Vue Router configuration entirely in vanilla JavaScript \n Includes ESLint JSDoc plugin verification to ensure all public

Expert guidance for fine-tuning LLMs with parameter-efficient methods and production optimization. \n \n Covers LoRA, QLoRA, and full fine-tuning workflows with Hugging Face PEFT, including dataset validation, hyperparameter configuration, and adapter merging for deployment \n Provides a complete minimal working example with LoRA setup, training loop, and quantization variants for memory-constrained environments \n Includes five-stage workflow: dataset preparation, method selection, training wit

Complete iOS/macOS/watchOS/tvOS development with SwiftUI, async/await, protocol-oriented design, and actor-based concurrency. \n \n Covers SwiftUI state management with @Observable, async/await patterns, protocol-oriented architecture with associated types, and actor isolation for thread safety \n Includes validation checkpoints at each workflow stage: compilation verification, strict warning checks for actor isolation, and async test confirmation \n Provides reference guides for SwiftUI pattern

Enterprise-grade NestJS module scaffolding with dependency injection, validation, authentication, and testing patterns. \n \n Generates complete module architecture including controllers, services, DTOs, guards, and interceptors with proper TypeScript typing and dependency injection wiring \n Includes class-validator decorators for input validation, Swagger/OpenAPI documentation, and typed HTTP exception handling across all layers \n Covers authentication patterns (JWT, Passport), TypeORM/Prisma

Rails 7+ specialist optimizing queries, implementing Hotwire real-time features, and background job processing. \n \n Covers Active Record query optimization with includes / eager_load to prevent N+1 queries, plus database indexing strategies \n Implements Turbo Frames and Turbo Streams for partial page updates, and Action Cable configuration for WebSocket-based real-time features \n Provides Sidekiq worker templates for background job processing with retry logic and error handling \n Includes R

Expert guidance for building .NET 8 applications with clean architecture, minimal APIs, and cloud-native patterns. \n \n Covers minimal APIs, Entity Framework Core, CQRS with MediatR, JWT authentication, and AOT compilation for .NET 8 \n Enforces async/await patterns, nullable reference types, record DTOs, and clean architecture layer separation \n Includes reference guides for minimal APIs, clean architecture, Entity Framework, authentication, and cloud-native deployment \n Provides code exampl

Comprehensive monitoring, logging, metrics, tracing, and performance testing implementation for production systems. \n \n Covers structured logging (Pino/JSON), Prometheus metrics (counters, histograms, gauges), and OpenTelemetry distributed tracing with span instrumentation \n Includes Prometheus alerting rule configuration, RED/USE dashboard design patterns, and health check endpoint setup \n Provides load testing with k6 and Artillery, application profiling for CPU/memory bottlenecks, and cap

Technical expertise for analyzing DWARF debug files and understanding the DWARF standard (v3–v5). \n \n Covers DWARF standard questions, parsing debug information from binaries, and code that interacts with DWARF data \n Provides verification workflows using llvm-dwarfdump --verify for structural validation and quality metrics \n Supports parsing tools including dwarfdump , readelf , and DWARF parsing libraries (libdwarf, pyelftools, gimli) \n References authoritative sources: official DWARF sta

Enterprise-grade Nest.js architecture guidance covering modules, dependency injection, testing, databases, and authentication. \n \n Diagnoses and resolves dependency injection issues, circular dependencies, and module configuration problems with proven solutions from 500+ real GitHub issues and Stack Overflow threads \n Covers full request lifecycle: middleware, guards, interceptors, pipes, and exception filters with correct execution order and async handling \n Provides testing strategies for