seafowl icon indicating copy to clipboard operation
seafowl copied to clipboard

Support for streaming (memory-limited) CSV downloads

Open mildbyte opened this issue 2 years ago • 0 comments

Currently we only support the JSON Lines output format and (IIRC) load the whole response into memory to serialize it before forwarding it to the client.

It would be nice to be able to:

  • return the response as CSV (e.g. selected with the Accept header, possibly using the GET API in order to cache the CSV file on the CDN)
    • probably setting the Content-Disposition header so that it's a standard download in the browser
  • support gzip compression?
  • stream the query result into the CSV writer instead of buffering it in memory

mildbyte avatar Oct 07 '22 12:10 mildbyte