That might have been a day or two of research, instead it was 5 minutes to come up with a theory and an hour or so writing tests
reverendsteveii on Hacker News
5 minutes to come up with a theory and an hour or so writing tests
In the thread “"AI Will Replace All the Jobs " Is Just Tech Execs Doing Marketing”, replying to this comment
Helped: Solving a specific recursive database query optimization problem.
Got in the way: Could not determine the need for optimization or verify correctness.
… WITH RECURSIVE parent_chain AS (SELECT id, name, parent, 0 AS depth FROM table WHERE id = :id UNION ALL SELECT i.id, i.name, i.parent, pc.depth + 1 FROM fam.dx_concept i INNER JOIN parent_chain pc ON i.id = pc.parent) SELECT id, name, parent FROM parent_chain ORDER BY depth; That might have been a day or two of research, instead it was 5 minutes to come up with a theory and an hour or so writing tests. Gemini saved the day there. …