3 ms·
I'm only familiar with C++, Python, and SQL. Neither GDB nor PDB helps here, and I've never heard of a SQL debugger that will break apart expressions and let yo
by krapht 1y ago
I'm only familiar with C++, Python, and SQL. Neither GDB nor PDB helps here, and I've never heard of a SQL debugger that will break apart expressions and let you view intermediate query results.
- Mond_ 1y agoThat'd be problematic, but also sounds like a (solvable) tooling problem to me.
- jen20 1y agoIt’s been a while since I’ve used one, but I’m fairly sure the common debuggers for C#, F#, Rust and Java would all behave correctly when breakpointed like this.
- cess11 1y agoYou can use EXPLAIN and similar keywords to see the execution plans in common SQL database engines. In practice you don't really care about the actual intermediate data so it doesn't show it, usually it's enough to learn whether indices are used at every step. But you could in many cases easily infer from the execution plan what a query would look like and fetch an intermediate set separately.