Posts
All the articles I've posted.
- 8 MIN READ•Apr 29, 2026
Row vs. Column: How Storage Layout Shapes Everything
Row stores keep records together for fast transactions. Column stores keep field values together for fast analytics. Here is how each layout works and when to use it.
columnar vs row storagecolumn-oriented databaserow store performance - 9 MIN READ•Apr 29, 2026
What Are Table Formats and Why Were They Needed?
Table formats like Apache Iceberg solved the ACID, schema, and performance problems that turned data lakes into data swamps. Here is how each one works.
data lake table formatsApache IcebergDelta Lake - 9 MIN READ•Apr 29, 2026
How Query Engines Think: The Tradeoffs Behind Every Data System
Every database is a collection of engineering tradeoffs. Learn the 9 design decisions that shape how query engines store, index, and process your data.
query engine designdatabase tradeoffsquery optimization - 11 MIN READ•Mar 7, 2026
Context Management Strategies for Zed: A Complete Guide to the High-Performance AI Code Editor
Zed is a high-performance code editor built in Rust that prioritizes speed, simplicity, and real-time collaboration. Its AI integration is designed to be fas...
AI toolscontext managementprompt engineering - 11 MIN READ•Mar 7, 2026
Context Management Strategies for Windsurf: A Complete Guide to the AI Flow IDE
Windsurf is an AI-powered IDE built on the VS Code foundation that introduces the concept of "Flows," a paradigm where the AI maintains deep awareness of you...
AI toolscontext managementprompt engineering - 11 MIN READ•Mar 7, 2026
Context Management Strategies for Perplexity AI: A Complete Guide to Research-First AI Conversations
Perplexity AI occupies a unique position in the AI landscape: it is a research-first tool that combines conversational AI with real-time web search to produc...
AI toolscontext managementprompt engineering - 11 MIN READ•Mar 7, 2026
Context Management Strategies for Cursor: A Complete Guide to the AI-Native Code Editor
Cursor is an AI-native code editor built on the VS Code foundation that integrates AI deeply into every aspect of the development workflow. Its context manag...
AI toolscontext managementprompt engineering - 10 MIN READ•Mar 7, 2026
Context Management Strategies for OpenWork: A Complete Guide to the Desktop AI Agent Framework
OpenWork is a desktop-native AI agent framework designed for local, multi-step task execution on your computer. Unlike browser-based AI tools or terminal age...
AI toolscontext managementprompt engineering - 11 MIN READ•Mar 7, 2026
Context Management Strategies for OpenCode: A Complete Guide to the Open-Source Terminal AI Agent
OpenCode is an open-source terminal-based AI coding agent that prioritizes privacy, local-first operation, and broad model provider support. Built as a TUI (...
AI toolscontext managementprompt engineering - 10 MIN READ•Mar 7, 2026
Context Management Strategies for Google Antigravity: A Complete Guide to the Agent-First IDE
Google Antigravity is an agent-first IDE built by Google DeepMind's Advanced Agentic Coding team. It approaches context management differently from other AI ...
AI toolscontext managementprompt engineering - 11 MIN READ•Mar 7, 2026
Context Management Strategies for Gemini CLI: A Complete Guide to Terminal-Native AI Development
Gemini CLI is an open-source terminal agent powered by Gemini models that operates directly in your command line. It brings Google's AI capabilities into the...
AI toolscontext managementprompt engineering - 11 MIN READ•Mar 7, 2026
Context Management Strategies for Gemini Web and NotebookLM: A Complete Guide to Google's AI Knowledge Ecosystem
Google's AI ecosystem for knowledge work consists of two deeply integrated tools: Gemini (the conversational AI at gemini.google.com) and NotebookLM (the res...
AI toolscontext managementprompt engineering