4 ms·

Neat. I'd rather have MIME type(s) for result sets. So we can tunnel over HTTPS. Postgres Wire Protocol https://crate.io/docs/crate/reference/en/4.3/interface

Neat. I'd rather have MIME type(s) for result sets. So we can tunnel over HTTPS. Postgres Wire Protocol https://crate.io/docs/crate/reference/en/4.3/interfaces/postgres.html https://crate.io/docs/crate/reference/en/4.3/interfaces/post... Tabular Data Stream https://en.wikipedia.org/wiki/Tabular_Data_Stream https://en.wikipedia.org/wiki/Tabular_Data_Stream

michelpp 6y ago
You can request different mime/types and postgrest will send you, for example CSV of the results instead of json.
- CameronNemo 6y ago
  Arrow would be a god send.
  - jpalomaki 6y ago
    Zedstore[1] is columnar storage layer for Postgres. It's not yet there, but I understood the goals is to get it in Postgres. Arrow as a format should make more sense with something like that in the background. I don't think you can efficiently pull the results in column oriented fashion right now. [1] https://www.postgresql.eu/events/pgconfeu2019/sessions/session/2738/slides/233/ZedStore-PGConfeu2019-Milan.pdf https://www.postgresql.eu/events/pgconfeu2019/sessions/sessi...