[ANNOUNCE] Psycopg 2.7 released

Поиск
Список
Период
Сортировка
От Daniele Varrazzo
Тема [ANNOUNCE] Psycopg 2.7 released
Дата
Msg-id CA+mi_8bMyWzxRZkxsg0YwT3nA_HaT1xdEDxUiB=w1NaNdLwVJQ@mail.gmail.com
обсуждение исходный текст
Список 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.


В списке pgsql-announce по дате отправления:

Предыдущее
От: Bo Peng
Дата:
Сообщение: [ANNOUNCE] pgpoolAdmin 3.6.0 released
Следующее
От: David Fetter
Дата:
Сообщение: [ANNOUNCE] == PostgreSQL Weekly News - March 05 2017 ==