Home/Users/admin

CodeNodeX AI Admin

@admin

CodeNodeX AI 社区管理员,关注 AI 编程、Next.js 和独立开发。

0 Followers · 500 Content
@admin·20 min read·Cloud Native

UPSERT Patterns: ON CONFLICT and Idempotent Writes

Insert or update? UPSERT handles it in one statement. This article covers PostgreSQL INSERT ON CONFLICT (specifying conflict columns, DO UPDATE, DO NOTHING), MySQL ON DUPLICATE KEY UPDATE, idempotent write scenarios (sync/retry without duplication), and the pitfalls of ON CONFLICT (partial indexes, multi-column conflicts).

#DevOps♥ 1660 comments
@admin·5 min read·AI Frontier

RAG Knowledge Freshness SLO: Do Not Monitor Indexing Success Alone

A successful indexing job does not mean users receive the latest knowledge. This article covers freshness SLOs, source change detection, priority queues, stale-answer handling, and operational reporting to make RAG accountable for content currency.

#LLM #RAG #DevOps♥ 00 comments
@admin·20 min read·Cloud Native

Advanced Terraform: Modules and Remote State

A single Terraform file is enough for a demo, but production requires modules and remote state. This article covers module inputs, outputs, and versions; remote state backends using S3 with DynamoDB locking or Terraform Cloud; state drift and imports; and a production-grade project structure.

#DevOps♥ 1670 comments
@admin·16 min read·Web Development

React Portal: Modals, Tooltips, and Stacking Contexts

A modal rendered deep in a component tree can be clipped by parent z-index, overflow, or transform rules. Portal renders it in document.body to escape those constraints. Learn Portal fundamentals, a complete modal implementation, accessibility, and why Radix Dialog handles the hard parts.

#React #TypeScript♥ 1680 comments
@admin·6 min read·AI Frontier

Fine-Tuning vs. RAG vs. Prompting: How to Make a Model Understand Your Business

There are three ways to improve a model in a domain: Prompting, RAG, and fine-tuning. Most teams choose incorrectly, fine-tuning problems suited to RAG or adding RAG where a prompt would suffice. This article offers a decision framework for knowledge, behavior, and style requirements, including when to combine approaches.

#AI #LLM♥ 330 comments
@admin·21 min read·Web Development

TypeScript Generics and Utility Types: A Deep Dive

Generics are among TypeScript's most powerful and most overused features. This guide explains constraints, defaults, inference, built-in Utility Types, when generics help, and when they do not, with one principle throughout: types should help you, not trap you.

#Next.js #TypeScript♥ 1700 comments
@admin·13 min read·Cloud Native

Blue-Green, Canary, and Rolling Deployment

Deployment isn’t just “pushing a new version”—how you push, cut over, and roll back when something breaks determines the risk. This article covers three strategies: blue-green (instant switch between two environments), canary (validate on small traffic before scaling), and rolling (gradual replacement), their fit and cost, and how to choose in production.

#DevOps♥ 1710 comments
CodeNodeX AI Admin's Tech Profile - Page 30 | CodeNodeX AI