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

PostgreSQL Data Types: Choose the Right Type and Save Half the Trouble

Storing everything in VARCHAR(255)? Using FLOAT for money? Wrong types lose precision, weaken indexes, and waste storage. This guide explains how to choose PostgreSQL types for numbers, text, UUIDs, time, booleans, enums, arrays, and JSONB, and why the right type improves both performance and correctness.

#DevOps♥ 1080 comments
@admin·12 min read·Web Development

WebAuthn and Passkeys: Passwordless Authentication

Passwords are the largest security vulnerability: weak credentials, reuse, phishing, and leaks. Passkeys use WebAuthn and device biometrics to replace passwords securely and seamlessly. This article explains the public-key model, registration and authentication flows, platform support, and a practical rollout path.

#React #DevOps♥ 1090 comments
@admin·8 min read·Web Development

N+1 Queries: The Hidden Performance Killer in ORMs

One list query plus one query for each of N related records means N+1 queries and can make an endpoint 10x slower. This article explains how ORM lazy loading causes N+1, how to detect it with logs and ORM explain tools, how to fix it with eager loading, include, or joins, and how to prevent it with eager defaults and query reviews.

#TypeScript #DevOps♥ 1100 comments
@admin·10 min read·Cloud Native

PostgreSQL Triggers and Stored Functions

Some logic is more efficient in the database, including automatic auditing, cascading updates, and data validation. But overusing triggers makes behavior implicit and hard to debug. This article explains how PostgreSQL triggers and functions work, when to use them, when not to, and why triggers demand restraint.

#DevOps♥ 1120 comments