Hacker News Reader

> make an ETL to clean up this dirty database

Can you provide concrete details?

When I do projects in this realm, it requires significant discussion with the business to understand how reality is modeled in the database and data, and that info is required before any notion of "clean up" can be defined.

View on HN

Yeah, you still do all of that domain research and requirements gathering and system design as your meatbag job. But now instead of writing the ETL code yourself by hand you can get 80-90% of the way there in a minute or two with AI assistance.

> you can get 80-90% of the way there in a minute or two with AI assistance.

That just leaves the other 80-90% to do manually ;)

If you do it in prod, you can save a lot of time by just borking the database and hoping they don't have backups.

Remember to run the commands outside of a transaction to optimize two statements!

Reply on news.ycombinator.com