Soft deletion probably isn't worth it

Re:Soft deletion probably isn't worth it by enepture on Tuesday July 19, 2022 @04:17PM (#32157367)

As an FYI using a tool like DBT solves this problem. As someone who was not a data engineer I was not familiar, there were tools like this

[ Parent | on HN ]

Re:Soft deletion probably isn't worth it by teej on Tuesday July 19, 2022 @04:50PM (#32157784)

dbt is great, but I'm not sure it's appropriate to manage objects in a production transactional database. It's designed for analytical, columnar databases.

[ Parent | on HN ]

Re:Soft deletion probably isn't worth it by PaulMest on Tuesday July 19, 2022 @04:56PM (#32157859)

In case you're not familiar with DBT, it helps with the "transform" in ELT https://docs.getdbt.com/docs/introduction.

[ Parent | on HN ]

Re:Soft deletion probably isn't worth it by cpursley on Tuesday July 19, 2022 @04:34PM (#32157593)

I have this problem. What is DBT?

[ Parent | on HN ]

Re:Soft deletion probably isn't worth it by banashark on Tuesday July 19, 2022 @04:56PM (#32157857)

I believe this: https://docs.getdbt.com/docs/introduction

[ Parent | on HN ]

Re:Soft deletion probably isn't worth it by WesleyJohnson on Tuesday July 19, 2022 @09:32PM (#32160237)

Thank you for this. I had no idea this existed either and it may solve some points for us on MySQL where we've really been yearning for materialized views... which I'm now reading my be a foot gun.

[ Parent | on HN ]