Tutorials on applying system design principles like modularity to SQL and data modeling, with hands-on refactoring examples using DuckDB and real dbt code. Readers get practical, step-by-step guidance on making SQL more readable, maintainable and reusable.
Website: https://www.ergestx.com/
An engineering blog from the Sequin team covering Postgres change data capture, pipeline architecture in Elixir, and product announcements. Readers get detailed explanations of design decisions such as back-pressure, delivery guarantees and duplicate handling.
This newsletter documents hands-on experiments with data platform technologies, such as agentic apps, small decision-focused LLMs and the evolution of dbt, and explains what the results mean for platform owners. Each issue pairs a first-person narrative with a built demo app, walkthrough video and comparison results.
AnomalyArmor's blog covers data engineering practice: alert storms in data monitoring, when data contracts are worth adopting, and where dbt tests stop and data observability begins. Readers get concrete, opinionated explanations with examples for data teams deciding how to catch pipeline failures.
Practical technical posts on why AI agents querying replicated enterprise data (Lightspeed, Square, PeopleSoft) return wrong totals when naive column names are trusted. Each issue walks through a concrete data-modelling trap and how to query around it.
One short email a week with hand-picked newsletters from the index. Free, no spam, unsubscribe anytime.
