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·8 min read·Cloud Native

Change Data Capture: Real-Time Data Synchronization

Manually trigger downstream synchronization after every database change? CDC automatically captures changes and streams them to search, caches, data warehouses, and services in real time. Learn how WAL-based CDC works, how Debezium implements it, where it fits, and why it outperforms dual writes and scheduled polling.

#DevOps♥ 1210 comments
@admin·4 min read·Agent Engineering

Freezing MCP Initialization Capabilities: Version Negotiation, Handshake Receipts, and In-Session Invariants

A successful `initialize` does not let either side add or remove features freely during a session. This article seals the protocol version, both parties’ capabilities, implementation identities, and the `initialized` boundary into an auditable receipt, preventing existing connections from using capabilities negotiated only later.

#AI Agent #MCP #DevOps♥ 1190 comments
@admin·12 min read·Cloud Native

PostgreSQL Extension Ecosystem: More Than a Database

PostgreSQL's killer feature is its extension ecosystem: pgvector for vector search, PostGIS for geospatial data, TimescaleDB for time series, and zhparser for Chinese tokenization. This guide covers their value, 10 popular extensions, installation and management, and when one PG instance can replace multiple components.

#DevOps♥ 1230 comments
@admin·9 min read·Web Development

API Rate Limiting Strategies In Depth: Algorithms and Implementation

Rate limiting is more than 'N requests per minute' — which algorithm (fixed window/sliding window/token bucket/leaky bucket), which dimension (IP/user/API key), where to store (memory/Redis), and what to return when exceeded (429/Retry-After) all matter.

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

Deep Dive into Sharding: Shard Keys and Cross-Shard Queries

Sharding is more than splitting data: a bad shard key forces full scans, while cross-shard joins, aggregation, and pagination become painful. This article covers shard-key design, application merging, denormalization, CQRS, globally unique Snowflake IDs, and why you should usually avoid sharding at first.

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

PostgreSQL Window Functions in Practice

Need the top 3 per category, running totals, or per-group rankings? Window functions handle them in one SQL query without GROUP BY plus subqueries. Learn the core concepts of OVER, PARTITION BY, ORDER BY, and frames; common ranking, cumulative, year-over-year, and top-N patterns; and the fundamental difference from GROUP BY.

#DevOps♥ 1280 comments