News for hackers. Stuff that matters.
Re:Ask HN: How do you test SQL? by mritchie712 on Wednesday February 01, 2023 @05:50AM (#34608882)
Doesn't that mean you have to copy all your data into duckdb? I'd imagine with even a modest data warehouse, loading the entire thing to duckdb would be unfeasible.
Re:Ask HN: How do you test SQL? by RobinL on Wednesday February 01, 2023 @06:14AM (#34609045)
The tests are being run against small test datasets of 10s of rows rather than the real data that test whether the behaviour of transforms/joins etc. is as expected. You're right, this approach wouldn't be sensible if the tests have to use large production tables
Re:Ask HN: How do you test SQL? by mritchie712 on Wednesday February 01, 2023 @06:51AM (#34609293)
How do you get the small datasets? Selecting a random sample from the source?
Re:Ask HN: How do you test SQL? by wnolens on Wednesday February 01, 2023 @09:43AM (#34611108)
The test itself would provide a test dataset. That way you can cook up the interesting cases and ensure your queries work on them.