articles/2020/11/24/psycopg3-adaptation/

[utterances-bot]

The psycopg3 adaptation system — Psycopg

Python adapter for PostgreSQL

https://www.psycopg.org/articles/2020/11/24/psycopg3-adaptation/

[aklaver]

I'm liking it. The Dumper/Loader mechanism looks to be very useful. I'm especially interested in trying out the new binary adaptation. One edit comment, in the first sentence under 'Server-side binding' I believe it should be psycopg2 not psycopg3.

[dvarrazzo]

Thank you @aklaver - fixing it.

Binary adaptation works ok but many types still need a binary Dumper/Loader (numeric and date/time objects among the builtins). If you want to try it out, it's enough to use %b placeholders to send Python parameters in binary format. In order to receive binary results, at the moment the interface would be to create a binary cursor with conn.cursor(format=Format.BINARY) but I'm not sold on it just yet.

[soluwalana]

I am incredibly excited to get psycopg3 integrated in my new projects! Keep up the excellent work! Dynamic copy() is something that has been sorely missed for altogether too long.