# Coding Tutorials Blog
> A Blog of coding tutorials

This is a high-authority blog by Alex Merced containing extensive coding tutorials, database connectors guides, semantic layer best practices, Lakehouse architectures, and prompt engineering strategies.

## Core Sections & Capabilities
- **Data Engineering & Lakehouses**: Deep dives into Apache Iceberg, Apache Polaris, Apache Arrow, Parquet, and modular lakehouse designs.
- **Semantic Layer**: Comprehensive guides on universal semantic layers, metrics layers, headless BI, and data virtualization.
- **Database Connectors**: Direct federated query tutorials for connecting S3, BigQuery, Snowflake, PostgreSQL, MySQL, Oracle, and MongoDB to Dremio.
- **AI Prompt & Context Management**: Hands-on guides for maximizing developer velocity with Claude Code, Cursor, Windsurf, JetBrains AI, and Google Antigravity.

## Essential Navigation
- [Home Page](https://tuts.alexmercedcoder.dev/): The main blog containing all posts.
- [Tags Index](https://tuts.alexmercedcoder.dev/tags/): Browse and filter posts by specific programming languages or frameworks.
- [RSS Feed](https://tuts.alexmercedcoder.dev/rss.xml): Raw RSS feed for feed readers.
- [Full Articles Catalog](https://tuts.alexmercedcoder.dev/llms-full.txt): Complete flat text list of all tutorials.

## Recent & Featured Tutorials
- [What Are Table Formats and Why Were They Needed?](https://tuts.alexmercedcoder.dev/2026/2026-04-ib-01-what-are-table-formats-and-why-were-they-needed/) (April 29, 2026): <!-- Meta Description: Table formats like Apache Iceberg solved the ACID, schema, and performance problems that turned data lakes into data swamps. Here is...
- [The Metadata Structure of Modern Table Formats](https://tuts.alexmercedcoder.dev/2026/2026-04-ib-02-the-metadata-structure-of-modern-table-formats/) (April 29, 2026): <!-- Meta Description: Iceberg uses a metadata tree, Delta Lake uses a transaction log, Hudi uses a timeline. Here is exactly how each format organizes...
- [Performance and Apache Iceberg's Metadata](https://tuts.alexmercedcoder.dev/2026/2026-04-ib-03-performance-and-apache-icebergs-metadata/) (April 29, 2026): <!-- Meta Description: Iceberg's three-layer metadata tree eliminates directory listing and enables multi-level data skipping. Here is how scan planning...
- [Partition Evolution: Change Your Partitioning Without Rewriting Data](https://tuts.alexmercedcoder.dev/2026/2026-04-ib-04-partition-evolution-change-your-partitioning-without-rewriti/) (April 29, 2026): <!-- Meta Description: Iceberg lets you change partition schemes without rewriting data. Here is how partition evolution works internally and why Hive-style...
- [Hidden Partitioning: How Iceberg Eliminates Accidental Full Table Scans](https://tuts.alexmercedcoder.dev/2026/2026-04-ib-05-hidden-partitioning-how-iceberg-eliminates-accidental-full-t/) (April 29, 2026): <!-- Meta Description: Iceberg's hidden partitioning separates physical layout from user queries using transform functions. Here is how it works and why it...
- [Writing to an Apache Iceberg Table: How Commits and ACID Actually Work](https://tuts.alexmercedcoder.dev/2026/2026-04-ib-06-writing-to-an-apache-iceberg-table-how-commits-and-acid-actu/) (April 29, 2026): <!-- Meta Description: Here is exactly how an engine writes to an Iceberg table, step by step, from data files through the atomic commit that makes ACID...
- [What Are Lakehouse Catalogs? The Role of Catalogs in Apache Iceberg](https://tuts.alexmercedcoder.dev/2026/2026-04-ib-07-what-are-lakehouse-catalogs-the-role-of-catalogs-in-apache-i/) (April 29, 2026): <!-- Meta Description: Lakehouse catalogs store metadata pointers, manage namespaces, and enforce access control. Here is the complete catalog landscape...
- [When Catalogs Are Embedded in Storage](https://tuts.alexmercedcoder.dev/2026/2026-04-ib-08-when-catalogs-are-embedded-in-storage/) (April 29, 2026): <!-- Meta Description: S3 Tables and MinIO AI Stor embed the Iceberg catalog directly in the storage layer. Here is when embedded catalogs make sense and...
- [How Data Lake Table Storage Degrades Over Time](https://tuts.alexmercedcoder.dev/2026/2026-04-ib-09-how-data-lake-table-storage-degrades-over-time/) (April 29, 2026): <!-- Meta Description: Iceberg tables degrade through small files, orphan files, metadata bloat, sort order decay, and partition skew. Here is how to...
- [Maintaining Apache Iceberg Tables: Compaction, Expiry, and Cleanup](https://tuts.alexmercedcoder.dev/2026/2026-04-ib-10-maintaining-apache-iceberg-tables-compaction-expiry-and-clea/) (April 29, 2026): <!-- Meta Description: Keep Iceberg tables fast with compaction, snapshot expiry, orphan cleanup, and manifest rewriting. Here is when and how to run each...
- [Apache Iceberg Metadata Tables: Querying the Internals](https://tuts.alexmercedcoder.dev/2026/2026-04-ib-11-apache-iceberg-metadata-tables-querying-the-internals/) (April 29, 2026): <!-- Meta Description: Iceberg metadata tables let you query snapshots, files, manifests, and partitions using SQL. Here is every metadata table and how to...
- [Using Apache Iceberg with Python and MPP Query Engines](https://tuts.alexmercedcoder.dev/2026/2026-04-ib-12-using-apache-iceberg-with-python-and-mpp-query-engines/) (April 29, 2026): <!-- Meta Description: Access Iceberg tables from Python with PyIceberg, DuckDB, and Polars, or through MPP engines like Dremio, Spark, and Trino. Here is...
- [Approaches to Streaming Data into Apache Iceberg Tables](https://tuts.alexmercedcoder.dev/2026/2026-04-ib-13-approaches-to-streaming-data-into-apache-iceberg-tables/) (April 29, 2026): <!-- Meta Description: Stream data into Iceberg with Spark Structured Streaming, Flink, or Kafka Connect. Here is how each works and the trade-offs between...
- [Hands-On with Apache Iceberg Using Dremio Cloud](https://tuts.alexmercedcoder.dev/2026/2026-04-ib-14-hands-on-with-apache-iceberg-using-dremio-cloud/) (April 29, 2026): <!-- Meta Description: A practical walkthrough of creating, querying, and optimizing Iceberg tables on Dremio Cloud, from account setup to AI-powered...
- [Migrating to Apache Iceberg: Strategies for Every Source System](https://tuts.alexmercedcoder.dev/2026/2026-04-ib-15-migrating-to-apache-iceberg-strategies-for-every-source-syst/) (April 29, 2026): <!-- Meta Description: Migrate to Iceberg from Hive, data warehouses, or raw files using in-place migration, full rewrite, or the zero-downtime view swap...
- [How Query Engines Think: The Tradeoffs Behind Every Data System](https://tuts.alexmercedcoder.dev/2026/2026-04-qeo-01-how-query-engines-think-the-tradeoffs-behind-every-data-syst/) (April 29, 2026): <!-- Meta Description: Every database is a collection of engineering tradeoffs. Learn the 9 design decisions that shape how query engines store, index, and...
- [Row vs. Column: How Storage Layout Shapes Everything](https://tuts.alexmercedcoder.dev/2026/2026-04-qeo-02-row-vs-column-how-storage-layout-shapes-everything/) (April 29, 2026): <!-- Meta Description: Row stores keep records together for fast transactions. Column stores keep field values together for fast analytics. Here is how each...
- [How Databases Organize Data on Disk: Pages, Blocks, and File Formats](https://tuts.alexmercedcoder.dev/2026/2026-04-qeo-03-how-databases-organize-data-on-disk-pages-blocks-and-file-fo/) (April 29, 2026): <!-- Meta Description: Databases structure data on disk as heap files, sorted files, or LSM trees, then wrap it in formats like Parquet with metadata that...
- [B-Trees, LSM Trees, and the Indexing Tradeoff Spectrum](https://tuts.alexmercedcoder.dev/2026/2026-04-qeo-04-b-trees-lsm-trees-and-the-indexing-tradeoff-spectrum/) (April 29, 2026): <!-- Meta Description: B-trees balance reads and writes for OLTP. LSM trees maximize write throughput. Bitmap indexes accelerate OLAP filtering. Here is...
- [Inside the Query Optimizer: How Engines Pick a Plan](https://tuts.alexmercedcoder.dev/2026/2026-04-qeo-05-inside-the-query-optimizer-how-engines-pick-a-plan/) (April 29, 2026): <!-- Meta Description: Query optimizers transform SQL into execution plans using rule-based rewrites, cost-based search, and adaptive runtime adjustments....
- [Volcano, Vectorized, Compiled: How Engines Execute Your Query](https://tuts.alexmercedcoder.dev/2026/2026-04-qeo-06-volcano-vectorized-compiled-how-engines-execute-your-query/) (April 29, 2026): <!-- Meta Description: The Volcano model processes one row at a time. Vectorized execution processes batches with SIMD. Code generation fuses operators into...
- [Buffer Pools, Caches, and the Memory Hierarchy](https://tuts.alexmercedcoder.dev/2026/2026-04-qeo-07-buffer-pools-caches-and-the-memory-hierarchy/) (April 29, 2026): <!-- Meta Description: Databases use buffer pools, column caches, and result caches to keep hot data in RAM. Here is how each caching strategy works and...
- [Partitioning, Sharding, and Data Distribution Strategies](https://tuts.alexmercedcoder.dev/2026/2026-04-qeo-08-partitioning-sharding-and-data-distribution-strategies/) (April 29, 2026): <!-- Meta Description: Hash partitioning distributes data evenly. Range partitioning enables fast range scans. Both create tradeoffs. Here is how databases...
- [Concurrency, Isolation, and MVCC: How Engines Handle Contention](https://tuts.alexmercedcoder.dev/2026/2026-04-qeo-10-concurrency-isolation-and-mvcc-how-engines-handle-contention/) (April 29, 2026): <!-- Meta Description: Databases handle concurrent access using locks, MVCC, or optimistic concurrency control. Here is how each approach works and what...
- [Hash, Sort-Merge, Broadcast: How Distributed Joins Work](https://tuts.alexmercedcoder.dev/2026/2026-04-qeo-09-hash-sort-merge-broadcast-how-distributed-joins-work/) (April 29, 2026): <!-- Meta Description: Distributed joins move data across the network using shuffle, broadcast, or co-location strategies. Here is how each works and when...
- [Apache Software Foundation: History, Purpose, and Process](https://tuts.alexmercedcoder.dev/2026/2026-04-al-01-apache-software-foundation-history-purpose-and-process/) (April 13, 2026): Read the complete Open Source and the Lakehouse series:
- [What is Apache Parquet? Columns, Encoding, and Performance](https://tuts.alexmercedcoder.dev/2026/2026-04-al-02-what-is-apache-parquet-columns-encoding-and-performance/) (April 13, 2026): Read the complete Open Source and the Lakehouse series:
- [What is Apache Iceberg? The Table Format Revolution](https://tuts.alexmercedcoder.dev/2026/2026-04-al-03-what-is-apache-iceberg-the-table-format-revolution/) (April 13, 2026): Read the complete Open Source and the Lakehouse series:
- [What is Apache Polaris? Unifying the Iceberg Ecosystem](https://tuts.alexmercedcoder.dev/2026/2026-04-al-04-what-is-apache-polaris-unifying-the-iceberg-ecosystem/) (April 13, 2026): Read the complete Open Source and the Lakehouse series:
- [What is Apache Arrow? Erasing the Serialization Tax](https://tuts.alexmercedcoder.dev/2026/2026-04-al-05-what-is-apache-arrow-erasing-the-serialization-tax/) (April 13, 2026): Read the complete Open Source and the Lakehouse series: