Hacker News new | ask | show | jobs
by NateEag 35 days ago
How are you dealing with the problem of making sure the reporting queries are correct?

My experience so far is that it's harder and slower for me to understand the genAI code than to write it myself.

Skipping thorough comprehension seems to be the popular choice in my workplace, but it's not one I can justify.

1 comments

I make sure to understand the query to the fullest extent. I run explain plan to make sure no nasty things like full table scans are happening.

I guess just like any algorithm it’s easier to verify a solution than come up with one.