etl Archives - ITFROMZERO - Share tobe shared!

Apache Iceberg + DuckDB: Build a Local Data Lakehouse with Time Travel Queries — No Cloud Required

By IT From Zero November 8, 2026

Apache Iceberg combined with DuckDB lets you build a complete data lakehouse right on your local machine — with ACID transactions, schema evolution, and time travel queries, all without cloud or Hive Metastore. This post walks through the setup step by step and shares best practices drawn from real-world experience.

Database

Migrating Data from MySQL to PostgreSQL: Comparing Methods and Practical Guide

By IT From Zero March 29, 2026

A guide comparing 3 methods for migrating data from MySQL to PostgreSQL: pgloader, manual mysqldump conversion, and Python ETL. Analyzes the pros and cons of each approach with practical command examples and a post-migration verification checklist.