Rendered on 2026-04-17 13:31:33 UTC

A space dedicated to random thoughts, experiments, and small projects around ETL, PostgreSQL, and anything in between. I aim to publish posts on a somewhat regular schedule, but please don’t hold me to it. Enjoy the read—and as always, take the code with a grain of salt. It may be buggy, outdated, or simply not the best solution. Stay skeptical, test things out, and feel free to reuse and adapt anything you find useful here.

---

Downloading Easter dates

This post walks through a simple ETL workflow for processing a dataset of Easter Sunday dates sourced from the US Census. Using standard Unix utilities and Bash, we download the raw ASCII file, transform the data into ISO 8601 format, filter and normalize the records, and finally load the results into a PostgreSQL database. The goal is to demonstrate how common command-line tools can be combined with SQL to build a lightweight and reproducible data pipeline.
Written on 2026-04-06 | bash OpenData PostgreSQL