Articles

Tech Articles

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

@admin·10 min read·Web Development

Progressive Web Apps (PWAs)

PWAs give web applications native capabilities such as offline access, desktop installation, Push notifications, and background synchronization. This article explains their three core components, implementation steps, and platform support in 2026, including Web Push on iOS.

#React #TypeScript♥ 1240 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·11 min read·Web Development

React Virtualization: Optimizing Large List Performance

Rendering 10,000 records freezes the page? A virtual list renders only the rows in view and swaps them dynamically as you scroll. This article explains window calculation and DOM reuse, how to use react-window and TanStack Virtual, when virtualization makes sense, and its tradeoffs for search, accessibility, and dynamic heights.

#React #TypeScript♥ 1270 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
@admin·6 min read·AI Frontier

Self-Hosting LLMs: Choosing Between Ollama and vLLM

APIs are convenient, but compliance, cost, offline operation, and customization can require self-hosting. This guide compares Ollama for local experiments and personal development with vLLM for high-throughput production inference, then covers quantization, VRAM, hardware selection, and when to use an API instead.

#LLM #Open Source♥ 290 comments