• 0 Posts
  • 18 Comments
Joined 10 months ago
cake
Cake day: September 11th, 2023

help-circle



  • I disagree unless the tests are reasonably high level.

    Half the time the thing you’re testing is so poorly defined that the only way to tighten that definition is to iterate.

    In this sense, you’re wasting time writing tests until you’ve iterated enough to have something worth testing.

    At that point, a couple of regression tests offer the biggest bang for buck so you can sanity check things are still working when you move on to another function and forget all about this one













  • Err, no? At what point did I claim to be an expert?

    It doesn’t take a genius to realise that serving 100-record chunks of a billion record dataset using limit 100 offset 582760200 is never gonna perform well

    Or that converting indexed time columns to strings and doing string comparisons on them makes every query perform an entire table scan, which is obvious if you actually take the time to look at the query plan (spoiler: they don’t)

    “Why can’t the system handle more than 2 queries per second? This database sucks”