Ecto Sandbox and test parallelism

[dkarter]

Ecto does not support Sandbox for ClickHouse at the moment - this leads to having to truncate the table manually between tests and setting all tests as sync.

Are there any known workarounds? Will this ever be possible to add Sandbox support?

I'm concerned that the more we use ClickHouse the slower the test suite will get because we can't have asynchronous tests without sandbox.

[ruslandoga]

👋

Maybe MIX_TEST_PARTITION could be used as a workaround.

And just now I found out there are plans for adding transactions into ClickHouse so maybe Ecto-style sandboxing would be possible after that as well.