Articles

Tech Articles

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

@admin·25 min read·Cloud Native

Temporal Data Patterns in Databases: Tracking Historical Changes

What was this price last week? Ordinary tables keep only current values; temporal tables retain history. This article explains audit logs, versioned rows, valid-time ranges, PostgreSQL temporal extensions, the SQL:2011 standard, CDC alternatives, and when temporal tables are warranted versus when an audit log is enough.

#DevOps♥ 1960 comments
@admin·5 min read·Agent Engineering

Source Walkthrough: Build a Minimal ReAct Agent by Hand

The best way to understand an Agent is to build a minimal one yourself. This under-100-line TypeScript implementation explains the ReAct (Thought → Action → Observation) loop, tool calls, stopping conditions, and error recovery.

#AI Agent #TypeScript♥ 360 comments
@admin·6 min read·Web Development

Hands-On: Add Semantic Search to a Content Site

Keyword search cannot handle vague questions or synonyms; semantic search fills the gap. This guide uses Next.js and pgvector to add complete semantic search to a content site, covering indexing, queries, hybrid retrieval, frontend highlighting, and incremental updates in a production-ready design.

#RAG #Next.js♥ 370 comments
@admin·6 min read·Agent Engineering

Hands-On: Connect GitHub to Claude Code with MCP

Use MCP to let Claude Code read issues, open PRs, inspect CI, edit files, and submit changes. This guide covers the official remote MCP server, a self-hosted local server, configuration, practical workflows, and safe token permissions so AI-assisted development can close the loop in GitHub.

#Vibe Coding #MCP♥ 380 comments
@admin·6 min read·AI Coding

From Requirements to Launch: Building an AI Writing Assistant

AI writing assistants are easy to imagine but easy to get wrong — most become 'one-click filler generators.' From requirements to launch, this article explains how to design a genuinely useful assistant: assist not ghostwrite, structured streaming, a human-AI editing loop, and trading 'one-click generation' for 'better the more you write.'

#AI #Vibe Coding♥ 390 comments
@admin·4 min read·Agent Engineering

Tool Calling Failure Taxonomy: Stop Blaming Every Failure on the Model

Tool-call failures can originate in selection, arguments, authorization, dependencies, state, or user confirmation. This article provides an actionable taxonomy and metric design to turn vague Agent errors into fixable engineering problems.

#AI #AI Agent #MCP♥ 00 comments
@admin·6 min read·Agent Engineering

Hands-On: Build a Multi-Step Research Agent with LangGraph

Deep research—one question, multiple search rounds, and a synthesized report—is one of the most valuable agent use cases and cannot be solved by single-pass RAG. This article builds a LangGraph research agent that decomposes questions, searches in parallel, reads full text, fills gaps, and writes a report while explaining state graphs, tool calls, and loop

#AI #AI Agent♥ 400 comments