In the petl API, there is no way to append to an existing file when exporting JSON. Unlike (CSV), the JSON doesn't support this mode of operation. Additionally, JSON doesn't stream the output, it is all read into memory.
For this reason, we should just limit the JSON result sets to 100k or 200k or whatever we decide the max single request should be. If petl ever changes this, we can change the JSON behavior.
In the petl API, there is no way to append to an existing file when exporting JSON. Unlike (CSV), the JSON doesn't support this mode of operation. Additionally, JSON doesn't stream the output, it is all read into memory.
For this reason, we should just limit the JSON result sets to 100k or 200k or whatever we decide the max single request should be. If petl ever changes this, we can change the JSON behavior.