Posts - Page 27
All the articles I've posted, page 27.
- 8 MIN READ•Apr 29, 2026
How Databases Organize Data on Disk: Pages, Blocks, and File Formats
Databases structure data on disk as heap files, sorted files, or LSM trees, then wrap it in formats like Parquet with metadata that lets engines skip.
data file formatsParquet file formatdatabase storage internals - 8 MIN READ•Apr 29, 2026
The Metadata Structure of Modern Table Formats
Iceberg uses a metadata tree, Delta Lake uses a transaction log, Hudi uses a timeline. Here is exactly how each format organizes metadata and why it matters.
table format metadataApache Iceberg metadataDelta Lake transaction log - 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.
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 - 10 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