Home/Tags/DevOps

#DevOps

Collection

This aggregates CodeNodeX AI community articles and discussions related to DevOps, covering concept explanations, tool comparisons, engineering practices, common issues, and indie hacking experience.

If you're researching DevOps, start with high-quality long-form articles, then join post discussions for a complete understanding-to-practice path.

@admin·12 min read·Cloud Native

A Deep Dive into EXPLAIN ANALYZE

Not sure why a query is slow? EXPLAIN ANALYZE is PostgreSQL's X-ray machine, showing how SQL actually runs. Learn to read Seq Scan, Index Scan, Hash Join, and Nested Loop nodes, distinguish cost from actual time, spot estimate errors, full-table scans, and disk spills, and optimize from evidence.

#DevOps♥ 1390 comments
@admin·11 min read·Cloud Native

Database Connection Architectures: Pooling, Proxies, and Serverless

How applications connect to databases determines concurrency. This article explains three architectures: in-process pools (Prisma/node-pg-pool), connection proxies, and Serverless pools (PgBouncer transaction mode), covering where each fits, its concurrency bottlenecks, and Serverless solutions such as Neon/SUPABASE poolers.

#DevOps♥ 1420 comments
@admin·11 min read·Cloud Native

Service Meshes: Istio and Linkerd

With enough microservices, must every service reimplement mTLS, traffic control, and observability? A service mesh moves these concerns out of code and into infrastructure. This article explains Sidecar proxies, Istio versus Linkerd, unified governance, and when a mesh does or does not make sense.

#DevOps♥ 1430 comments
@admin·9 min read·Cloud Native

PostgreSQL CTEs and Recursive Queries

Org charts, menu trees, and nested comments can span N levels that fixed JOINs cannot handle. This article covers CTEs, recursive anchor and recursive terms, practical hierarchy queries, and PostgreSQL 14+ MATERIALIZED behavior.

#DevOps♥ 1450 comments
@admin·11 min read·Cloud Native

Cloud Disaster Recovery and Multi-Region Architecture

What if a single region goes down? The cloud fails too (AWS us-east-1 has failed many times). Covers DR core concepts (RTO/RPO), strategies (backup & restore, Pilot Light, Warm Standby, Active-Active, multi-region), cost-vs-recovery-speed trade-offs, and when you should go multi-region.

#DevOps♥ 1470 comments