Re:Life Altering PostgreSQL Patterns
by joewood1972 on Sunday March 16, 2025 @12:17PM
(#43380146)
Loving this list. One thing I would totally recommend though is to look at tools like DBT, as this supports a lot of these patterns out of the box (snapshots, materialized views, seeds for 'system tables' etc.). It also addresses the concerns with views and schema management.
[ Parent
| on HN ]
So I looked up DBT - it seems to be a company where the first thing I saw on their website was "Gen AI."
That doesn't inspire confidence in the longevity of their offering - but i'm also unclear exactly what it is they are offering. Can you give the audience the pitch?
Re:Life Altering PostgreSQL Patterns
by joewood1972 on Sunday March 16, 2025 @09:10PM
(#43384205)
Sure, DBT (Data Build Tool) has been around for a while. It's a way to manage SQL (and also Python) data pipelines - the "T" in ELT. Home page for DBT Core is here https://docs.getdbt.com/ (there is also a hosted DBT cloud premium offering). There are some good books on Data Engineering with DBT - I particularly liked "Data Engineering with dbt: A practical guide to building a cloud-based, pragmatic, and dependable data platform with SQL" by Roberto Zagni.