Support for testing on Windows

[amotl]

Problem

@mackerl submitted a patch (thanks!) to make this workable on Windows, but experienced some pains. This reminds me of similar pains I observed when trying similar things in Python lands the other day.

• Attempt to make crate-testing work under windows #92
• Run CI-testing on GHA/Windows mfussenegger/cr8#337

Thoughts

Would the Testcontainers for Java technologies for providing ephemeral CrateDB instances to software integration tests be helpful in any way? With those, needing to take care about the lifecycle of CrateDB instances becomes completely obsolete, based on container technologies (Docker).

Is that convincing in any way, or are there objections against or flaws with that approach? NB: I have to admit I also haven't tested the Testcontainers implementation on Windows, but it might be worth to explore?

Notes

We just recently improved the documentation page about "Software testing with Java and CrateDB", where you can find further references to all testing variants.

/cc @seut, @matriv

[amotl]

Ah, right. We can observe that using container technologies demonstrates obstacles when running on GHA/Windows, that's why using this also has problems for some.

Error: Container operations are only supported on Linux runners

• Testing on Windows: Let's try cratedb-examples#1265

[amotl]

^^ Because this is about other obstacles and a different topic, I guess it's not too applicable as an issue for this repository. Closing again, sorry for the noise.