Articles

Tech Articles

In-depth articles on AI, web development, cloud native, and indie hacking.

@admin·20 min read·Cloud Native

PostgreSQL Advisory Locks: Application-Level Coordination Locks

Already use PostgreSQL? Advisory Locks provide application-level coordination without Redis. This guide covers session- and transaction-level locks, blocking vs. try-lock APIs, key design, task scheduling, migrations, idempotency, row-lock differences, and production pitfalls.

#DevOps♥ 1840 comments
@admin·5 min read·Indie Hacking

SDK Quickstart Time to First Success: Event Contracts, Executable Examples, and Failure-Inclusive Denominators

Documentation clicks and install-command execution do not mean an SDK is integrated. This article measures Time to First Success with versioned journeys, server-side success receipts, and a complete failure denominator, then defines out-of-order event handling, environment segmentation, and reversible rollout gates.

#TypeScript #DevOps #Indie Hacking♥ 1830 comments
@admin·21 min read·Web Development

CSS Dark Mode Implementation: prefers-color-scheme and Class Switching

Dark mode isn't simply inverting colors—you have to handle system-preference following, manual switching, persistence, flash (FOUC), and image/icon adaptation. This article covers the prefers-color-scheme media query, class-switching strategy, localStorage persistence, anti-flash scripts, and a CSS-variable theme system, delivering a complete dark-mode

#React #TypeScript♥ 1860 comments
@admin·20 min read·Cloud Native

Kubernetes ConfigMaps and Secrets: Configuration and Secret Management

Configuration should not be hard-coded into images: ConfigMaps store nonsensitive settings, while Secrets store credentials. This article covers creation and mounting, env vs. volume, base64 and encryption with etcd, KMS, and external operators, ConfigMap hot updates and the subPath trap, and production secret management with External Secrets Operator.

#DevOps♥ 1870 comments
@admin·21 min read·Web Development

React Error Tracking: A Practical Sentry Integration

Users see a blank screen but you do not know about it. Sentry can catch errors before users report them. Learn frontend error tracking: Sentry SDK setup, Error Boundaries, source map uploads for production source lines, release tracking, performance monitoring, and privacy redaction.

#Next.js #React♥ 1880 comments
@admin·16 min read·Cloud Native

PostgreSQL Statistics and the Query Planner

Why does PostgreSQL choose a Seq Scan over an Index Scan? Its planner uses statistics to estimate which is faster, and inaccurate statistics produce bad plans. This article explains how ANALYZE collects statistics, how they guide planning, when stale data causes slow queries, and how to intervene with statistics targets and extended statistics.

#DevOps♥ 1880 comments