Status of binary transmission vs. plaintext (resultFormat)?
| От | Hajo Kirchhoff |
|---|---|
| Тема | Status of binary transmission vs. plaintext (resultFormat)? |
| Дата | |
| Msg-id | qac5a5$1e5g$1@blaine.gmane.org обсуждение исходный текст |
| Список | pgsql-odbc |
Hi there, using Wirekshark I noticed that UUIDs are transferred in plaintext between the ODBC driver and the postgreSQL database. For me this is a big deal since it uses twice as much data as the binary form (36 char vs. 16 bytes). I downloaded and analysed the ODBC sources and found that all calls to PQexecParams and PQexecPrepare use '0' for the 'resultFormat'. IOW, the ODBC driver explicitly requests all results in plaintext form as opposed to the binary form. This has been since it first used libpq as its interface to postgreSQL. Is my assumption correct that the ODBC driver really is not prepared to handle binary transfer? IOW that all data, be it float, int, timestamp, uuid, bool is really transmitted in full text form? What is the development status here? Are there or have there been any plans to support 'resultFormat == 1' (see https://www.postgresql.org/docs/11/libpq-exec.html)? What would be neccessary to support that? Best regards Hajo -- Hajo Kirchhoff Kirchhoff IT-Consulting http://www.litwindow.com
В списке pgsql-odbc по дате отправления: