All guides

Community-curated setup guides for modern tech stacks.

DifficultyBeginner Intermediate Advanced

.NET .net 3d AI AI Agents AI Singapore AIChat ASR Agent Development Agent Framework Agents Android Annotation Apache Kafka AutoGPT AutoGen Automation Azure Blockchain Bot Detection Browser Detection ByteDance C CLI CNCF CRDT CUDA CVAT Canvas Chains Chrome DevTools Claude Client Hints Cloud Native Cloudflare Collaboration Computer Vision Containers Coze Studio Cross-Platform Data Streaming Dataset Decentralized Storage Deep Learning Desktop Automation DevOps Device Detection Diagramming Distributed Inference Django Docker EAS Build Event Streaming Expo FFmpeg FastAPI GPU GUI Gemini Go Gradio Hermes IOPaint IPFS Image Annotation Image Inpainting Inference Infinite Canvas JavaScript Kafka Operator KrillinAI Kubernetes LLM LangChain LangGraph MCP Machine Learning Messaging Metro Microservices Microsoft Mobile Development Model Serving Multi-Agent Multiplayer Next.js No-Code Node.js OCR Ollama OpenAI OpenAI API OpenVINO Orchestration PHP PagedAttention Poetry PostgreSQL PyQt5 PyTorch Python Quantization RAG REPL RPA RabbitMQ RainbowKit React React Native Real-time Redis Rust SDK Scaling Shadcn/ui Shell Assistant Sikuli Smart Contracts Speech Recognition Stable Diffusion Strimzi Supabase SvelteKit TTS TagUI Tailwind CSS Tauri The Graph Translation TypeScript UAParser.js User-Agent Vector Database Vercel AI SDK Video Annotation Video Subtitles Video Translation VideoCaptioner Voice Cloning Web Automation Web3 WebGL WebRTC WebSocket Whisper Whiteboard Workflows Yjs Zod admin agent agents ai ai-agents ai-tools alerting algorithms analytics android animation anthropic api api-testing apm app-router ar astro audio auth automation aws azure baas backend blocks brave-search browser build-system bun c#c-interoperability cache caching calendar cao cargo cdp celery chinese-nlp chromium claude claude-code cli clickhouse cloud cloud-init cloud-native cloudflare cloudflare-workers cms cnCF cncf cockroachdb code-analysis coding coding-assistants compilation compiler component-testing composio computer-use computer-vision configuration-management containers context-optimization crates-io creative-tools cross-browser cross-compilation csharp css cuda curated-list cursor customization cybersecurity dag dashboards data-engineering data-pipelines data-platform data-science data-store data-transformation database databricks datasets dbt debian debugger deep-learning deepseek deno deno-deploy dependencies deployment design-tool desktop dev-tools developer-tools development devin devops devops-tools diffusion directus distributed distributed-computing distributed-systems docker docker-compose document-processing documentation dotnet drive drizzle e2e-testing ebpf eclipse edge edge-computing education elasticsearch electron elk-stack embedded embeddings envoy esm etl evaluation f-droid fail2ban fastapi feishu filters fine-tuning firebase-alternative firecracker firefox flask fp8 frontend full-stack full-text-search gamedev gaming gcp gemini-cli gis git github gmail go golang google-workspace gpu gpu-acceleration gpu-passthrough grafana graphics graphql grpc guardrails hashicorp headless-cms hermes hopper html http http-server http2 https huggingface iOS iac image-generation image-processing in-memory inference infrastructure infrastructure-as-code instructlab interactive internal-tools istio jamstack java javascript jdbc jest jetpack-compose json jupyter k8s kiwix kotlin kratos kubernetes kvm lab-method langchain lark llama llamaindex llm load-balancer local-llm logging logs loki loralib low-code lsp lucene machine-learning manual-memory-management mariadb markdown material-design matplotlib maui mcp memory message-queue meta metrics microservices minio ml ml-operations mlops model-context-protocol moe mongodb monitoring monorepo mssql mtls multi-agent multica mysql n8n native-package-manager nested-virtualization nestjs networking neural-networks next.js nextjs nginx nlp no-code node node.js nodejs nosql notebook notes npm numpy nvidia nvme oauth observability ocr offline ollama onnx open-source open-telemetry openai openapi openclaw opencv opentelemetry oracle orchestration package-manager packet-capture paddlepaddle parallel-computing peft penetration-testing pentesting performance performance-tuning persistence personalization petstore playwright plugin-system postgres postgresql privacy productivity programming-language prometheus prompt-engineering protobuf provisioning proxmox python pytorch qdrant qemu quantization qwik r2 rag ray rdbms react react-19 real-time red-teaming redhat redis relational replit resources rest reverse-proxy rpc rtx-3090 runtime rust rust-toolchain sandbox scheduler screen-awareness sdg search security security-tools self-hosted server-components serverless service-mesh service-workers session-store shadcn shell skills sql sqlite sre ssg ssh ssl ssr stable-diffusion storage supabase survival svelte sveltekit swagger synchronous synthetic-data system-control system-prompts systems-programming tailwind task-runner tauri taxonomy telemetry tensorflow terminal terraform test-automation testing threejs time-series tldraw tls toolchain toolkit tools tracing traffic-management transformers triggers troubleshooting turbo turborepo typescript ubuntu ui-components unifi unit-testing unity unity3d vLLM vector-database vectors vercel vfio video-generation video-processing visual-editor visualization vite vitest vlan vr vscode-copilot vue wasm web web-api web-development web-framework web-server web-standards web-testing webassembly webgl webkit wifi windows wireguard wireless workflow workflow-automation workspace xrdp yaml yolov8 zig

Clear filters

dbt: Data Build Tool for Analytics Engineering

Intermediate

Transform raw data into analytics-ready datasets using dbt's modular SQL-based workflow. Build, test, and document your data transformations with version control and CI/CD.

dbt databricks analytics sql data-engineering etl data-transformation

PostgreSQL - Advanced Relational Database

Beginner

Install, configure, and use PostgreSQL, the world's most advanced open-source relational database — covering installation, advanced features, performance tuning, and production deployments.

postgresql postgres database sql relational rdbms open-source json gis analytics

DBeaver: Universal database tool and SQL client

Beginner

Free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports 100+ databases with powerful features including schema editor, SQL editor, data editor, AI integration, ER diagrams, and more.

database sql java eclipse jdbc mysql postgresql oracle mongodb admin

Chat2DB: AI-driven database tool and SQL client

Intermediate

AI-powered database management tool supporting MySQL, PostgreSQL, Oracle, SQL Server, SQLite, MongoDB, Redis and more with intelligent SQL generation and reporting.

database sql ai java react electron mysql postgresql nosql

Postgres triggers for denormalized counts

Advanced

Keep vote counts and aggregate columns in sync atomically using Postgres triggers, instead of racing application code.

postgres supabase sql triggers