3 ms·
I've found the trick for that kind of thing is to write automated tests for it - I sometimes write a set of pytest tests to exercise complex SQLite queries Giv
by simonw 3y ago
I've found the trick for that kind of thing is to write automated tests for it - I sometimes write a set of pytest tests to exercise complex SQLite queries
Gives me way more confidence in them, and means I can change them later and feel confident I haven't broken them.