Comment by parhamn

I was wondering what the major changes between psycopg2 and psycopg3 were. Found a post from the maintainer here: https://www.varrazzo.com/blog/2020/03/06/thinking-psycopg3/

Main takeaways:

- Asyncio from the ground up

- Uses PQexecParams to do database-side escaping and interpolation

- ContextManager and transaction api improvements for

- Python only fallback if the C extension fails to build