@admin·12 min read·Cloud Native Nine out of ten slow queries are caused by missing indexes or indexes that are not being used. This guide covers PG index types, composite indexes and the leftmost-prefix rule, EXPLAIN ANALYZE, common causes of unusable indexes, and when not to add an index.
#DevOps♥ 370 comments
@admin·16 min read·Cloud Native Redis is far more than a cache, yet many developers never get beyond SET/GET. This article covers its core data structures, production patterns for caching, distributed locks, rate limiting, and leaderboards, persistence and high-availability choices, and classic pitfalls including cache penetration, breakdown, avalanches, big keys, and expiration.
#DevOps♥ 380 comments
@admin·6 min read·Cloud Native Model vendor keys, object storage credentials, and signing keys can't be rotated by hand. This article lays out an end-to-end rotation flow: asset inventory, dual-credential switching, dynamic refresh, revocation verification, and leak response.
#AI #LLM #DevOps♥ 00 comments
@admin·6 min read·Cloud Native Single QPS rate limiting cannot stop long-context and batch tasks from squeezing inference pools. This article designs tiered quotas, atomic accounting, fair queuing, burst allowance, and failure degradation to protect multi-tenant AI platforms.
#AI #LLM #DevOps♥ 00 comments
@admin·12 min read·Cloud Native When a single database can no longer keep up, what is the right move? This article lays out the scaling path: optimize vertically first (indexes, queries, read/write splitting), then horizontally (sharding). Covers shard key selection, cross-shard queries, distributed transactions, and why you should not rush to shard — most projects never need it.
#DevOps♥ 420 comments
@admin·8 min read·Cloud Native Go's goroutine-and-channel model is simple and powerful, but misuse can cause leaks, deadlocks, and races. This guide covers lightweight goroutines and scheduling, channel synchronization and communication, select multiplexing, worker pools, fan-out, pipelines, and common concurrency traps.
#DevOps #Open Source♥ 440 comments
@admin·12 min read·Cloud Native When a server fails and SSH leaves you staring at an unfamiliar terminal, this Linux survival kit gives developers everyday file and text commands, process and resource diagnostics (top/htop/lsof/df), network troubleshooting (curl/ss/netstat), pipes and redirection, and a practical incident workflow: check resources, then processes, then logs.
#DevOps♥ 500 comments
@admin·5 min read·Cloud Native AI requests naturally carry high-dimensional information such as model, tenant, prompt version, and toolchain. This article covers metric label layering, cardinality budgeting, OpenTelemetry attribute trimming, Prometheus acceptance criteria, and over-limit rollback.
#AI #LLM #DevOps♥ 00 comments
@admin·12 min read·Cloud Native SSH is more than remote login. Its tunneling and port forwarding provide a developer's Swiss Army knife for reaching private services, creating secure proxies, and traversing bastion hosts. This article covers local, remote, and dynamic forwarding, ProxyJump, SSH key management, and ssh_config.
#DevOps♥ 530 comments
@admin·10 min read·Cloud Native Do not want to deploy Elasticsearch? PostgreSQL's built-in full-text search is enough at small and medium scale. This guide covers tsvector and tsquery, tokenization and dictionaries, GIN indexing, ts_rank ranking, Chinese tokenization with zhparser or pg_jieba, and hybrid vector search.
#DevOps♥ 570 comments
@admin·11 min read·Cloud Native Is your service running blind, with users reporting incidents first? This guide covers practical observability: structured JSON logs and request IDs, log levels and sampling, RED/USE metrics, alert design without fatigue, and a fast incident workflow using metrics, traces, and logs.
#DevOps♥ 590 comments
@admin·5 min read·Cloud Native Singleflight can coalesce concurrent origin fetches, but it can't stop a stale rebuilder from overwriting the new value after invalidation. This article uses target generations, rebuild leases, conditional publication, and a bounded stale policy to close cache stampede and late-write windows.
#TypeScript #DevOps♥ 590 comments