Psycopg 2.7 released

From: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
To: pgsql-announce(at)postgresql(dot)org
Subject: Psycopg 2.7 released
Date: 2017-03-01 15:52:58
Message-ID: CA+mi_8bMyWzxRZkxsg0YwT3nA_HaT1xdEDxUiB=w1NaNdLwVJQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce

It's finally here! Thank you very much for waiting so long: we have
finally released Psycopg 2.7!

Buzzwords:

- Faster! Helps generating SQL for repeatedly executed statements and
faster Unicode decoding.
- Safer! Helps generating dynamic SQL statements with variable table and
field names.
- Easier! Use the binary package to avoid the need of C compiler, pg_config,
libpq required on the clients.
- Replication! Support for PostgreSQL physical and logical replication.
- Plays-better-with-pgbouncer-at-transaction-pooling-level! This.

You can download the source packages as usual from the canonical urls:

- http://initd.org/psycopg/tarballs/PSYCOPG-2-7/psycopg2-2.7.tar.gz
- http://initd.org/psycopg/tarballs/PSYCOPG-2-7/psycopg2-2.7.tar.gz.asc

Or just use pip:

pip install psycopg2

Before dumping the full set of changes I wish to thank again all the
people who have contributed to this psycopg version, especially
Oleksandr Shulgin and Craig Ringer for the replication protocol
support and Jason Erickson for the windows packaging.

New features:

- Added psycopg2.sql module to generate SQL dynamically (ticket #308).
- Added replication protocol support (ticket #322).
- Added parse_dsn() and make_dsn() functions (ticket #321, ticket #363).
connect() now can take both dsn and keyword arguments, merging them
together.
- Added __libpq_version__ and libpq_version() to inspect the version of
the libpq library the module was compiled/loaded with (ticket #35,
ticket #323).
- The attributes notices and notifies can be customized replacing them
with any object exposing an append() method (ticket #326).
- Adapt network types to ipaddress objects when available. When not
enabled, convert arrays of network types to lists by default. The old
Inet adapter is deprecated (ticket #317, ticket #343, ticket #387).
- Added quote_ident() function (ticket #359).
- Added get_dsn_parameters() connection method (ticket #364).
- callproc() now accepts a dictionary of parameters (ticket #381).
- Give precedence to __conform__() over superclasses to choose an object
adapter (ticket #456).
- Using Python C API decoding functions and codecs caching for faster
Unicode encoding/decoding (ticket #473).
- executemany() slowness addressed by execute_batch() and execute_values()
(ticket #491).
- Added async_ as an alias for async to support Python 3.7 where async
will become a keyword (ticket #495).
- Unless in autocommit, do not use default_transaction_* settings to
control the session characteristics as it may create problems with
external connection pools such as pgbouncer; use BEGIN options instead
(ticket #503).
- isolation_level is now writable and entirely separated from autocommit;
added readonly, deferrable writable attributes.

Bug fixes:

- Fixed error caused by missing decoding LoggingConnection (ticket #483).
- Fixed integer overflow in interval seconds (ticket #512).

Other changes:

- Dropped support for Python 2.5 and 3.1.
- Dropped support for client library older than PostgreSQL 9.1 (but older
server versions are still supported).
- isolation_level doesn't read from the database but will return
ISOLATION_LEVEL_DEFAULT if no value was set on the connection.
- Empty arrays no more converted into lists if they don't have a type
attached (ticket #506).

----

Psycopg is the most popular PostgreSQL adapter for the Python
programming language. At its core it fully implements the Python DB
API 2.0 specifications. Several extensions allow access to many of the
features offered by PostgreSQL.

Browse pgsql-announce by date

  From Date Subject
Next Message David Fetter 2017-03-06 02:53:46 == PostgreSQL Weekly News - March 05 2017 ==
Previous Message Bo Peng 2017-02-28 03:12:45 pgpoolAdmin 3.6.0 released