Articles tagged news

Psycopg 2.8.4 released

Posted by Daniele Varrazzo on 2019-10-20
Tagged as news, release

Psycopg 2.8.4 has been released.

The release brings a few assorted bugfixes and adds support for Python 3.8 and PostgreSQL 12.

Read more...

Psycopg 2.8.3 released

Posted by Daniele Varrazzo on 2019-06-14
Tagged as news, release

We have released Psycopg 2.8.3, which includes a slight change to the logical replication.

Choosing the right frequency to send replication feedback messages from the client to the server was previously the developer's responsibility, with too many feedback messages being a waste of bandwidth and server resources, too few slowing down WAL cleanup and possibly preventing a server graceful shutdown.

Read more...

Psycopg 2.8.1, 2.8.2 released

Posted by Daniele Varrazzo on 2019-04-14
Tagged as news, release

Hello,

We have just released Psycopg 2.8.2; a few days ago Psycopg 2.8.1 was released.

Some of the bugs addressed are ordinary teething problem with the 2.8 release, but an important change landed with 2.8.2: binary packages now ship with OpenSSL 1.1 instead of 1.0. This should fix concurrency problems on connection experienced both on Windows and Linux. Many thanks to Matthew Brett and Jason Erickson for this improvement!

Read more...

Psycopg 2.8 released

Posted by Daniele Varrazzo on 2019-04-04
Tagged as news, release

After about two years from the previous major release, psycopg 2.8 is finally here!

Among the highlights, PostgreSQL errors are now mapped to Python exceptions for a more idiomatic way to handle them. Several additions allow a better insight of the connection status and query results.

Behind the scene, asynchronous communication and concurrency received several improvements, and dropping support for older versions of Python gave the chance to refactor and modernise the codebase (with the especial help from Jon Dufresne who ruthlessly butchered our code into a streamlined pulp).

Thank you very much to everyone contributing so far. Happy hacking!

Read more...

Psycopg 2.7.5 released

Posted by Daniele Varrazzo on 2018-06-17
Tagged as news, release

psycopg2 version 2.7.5 has been released, fixing a few bugs found in the last months:

Read more...

Psycopg 2.7.4 released

Posted by Daniele Varrazzo on 2018-02-08
Tagged as news, release

We have released Psycopg version 2.7.4, bringing a few bug fixes... and working out the problem with Wheel packages.

Read more...

Psycopg 2.7.3.2 released

Posted by Daniele Varrazzo on 2017-10-24
Tagged as news, release

Following the release of PostgreSQL 10 we have released new binary packages as Psycopg 2.7.3.2. There are no code changes from Psycopg 2.7.3, but the new binary packages ship with the PostgreSQL 10 client library, enabling the use of new features such as multiple hosts in connection string, read-only mode, SCRAM-SHA-256 authentication.

Read more...

Psycopg 2.7.3 released

Posted by Daniele Varrazzo on 2017-07-24
Tagged as news, release

A quick release to fix a regression found in psycopg 2.7.2:

  • Restored default timestamptz[] typecasting to Python datetime. Regression introduced in Psycopg 2.7.2 (ticket #578).

Read more...

Psycopg 2.7.2 released

Posted by Daniele Varrazzo on 2017-07-22
Tagged as news, release

Releasing psycopg2 version 2.7.2: a release fixing a host of bugs found in the last 3-4 months.

Read more...

Psycopg 2.7.1 released

Posted by Daniele Varrazzo on 2017-03-13
Tagged as news, release

A quick bugfix release to solve some teething problems with some of the changes introduced in 2.7:

  • Ignore None arguments passed to connect() and make_dsn() (ticket #517).
  • OpenSSL upgraded from major version 0.9.8 to 1.0.2 in the Linux wheel packages (ticket #518).
  • Fixed build with libpq versions < 9.3 (ticket #520).

Read more...

Psycopg 2.7 released

Posted by Daniele Varrazzo on 2017-03-01
Tagged as news, release

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.

Read more...

Psycopg 2.7 beta 2 released

Posted by Daniele Varrazzo on 2017-02-17
Tagged as news, release

Hello,

we have released psycopg2 version 2.7 beta 2. This version comes two years after the previous major release so it is packed with new features and improvements; among the main points:

Read more...

Psycopg 2.6.2 released

Posted by Daniele Varrazzo on 2016-07-07
Tagged as news, release

Psycopg 2.6.2 has been released. You can get it from:

This is an interim release, packing together one year of bug fixes, before the release 2.7, intended to deliver several new features. Thank you very much to everybody contributing with reports, code, suggestions.

Read more...

Psycopg 2.6.1 released

Posted by Daniele Varrazzo on 2015-06-16
Tagged as news, release

Psycopg 2.6.1 has been released. You can get it from:

Read more...

Psycopg 2.5.4 released

Posted by Daniele Varrazzo on 2014-08-30
Tagged as news, release

Psycopg 2.5.4 has been released. You can get it from:

This version supports the new jsonb PostgreSQL type out-of-the-box. And of course there are a few bug fixed:

Read more...

Psycopg 2.5.3 Released

Posted by Daniele Varrazzo on 2014-05-13
Tagged as news, release

Psycopg 2.5.3 has been released. You can get it from:

This version contains several bug fixes over the previous release 2.5.2:

Read more...

Psycopg 2.5.2 released

Posted by Daniele Varrazzo on 2014-01-07
Tagged as news, release

Psycopg 2.5.2 has been released. You can get it from:

This version contains a few bug fixes over the previous release 2.5.1:

  • Fixed segfault pickling the exception raised on connection error (ticket #170).
  • Meaningful connection errors report a meaningful message, thanks to Alexey Borzenkov (ticket #173).
  • Manually creating lobject with the wrong parameter doesn't segfault (ticket #187).

Thank you very much to all the people who helped during the development!

Psycopg 2.5.1 released

Posted by Daniele Varrazzo on 2013-06-23
Tagged as news, release

Psycopg 2.5.1 has been released. You can get it from:

The version contains a few bug fixes over the previous 2.5:

  • Fixed build on Solaris 10 and 11 where the round() function is already declared (ticket #146).
  • Fixed comparison of Range with non-range objects (ticket #164). Thanks to Chris Withers for the patch.
  • Fixed double-free on connection dealloc (ticket #166). Thanks to Gangadharan S.A. for the report and fix suggestion.

Happy hacking!

Psycopg 2.5 released

Posted by Daniele Varrazzo on 2013-04-07
Tagged as news, release

We are happy to introduce the release 2.5 of Psycopg, packed with several juicy new features!

Here are a few highlights of the release:

Read more...

Psycopg 2.4.6 released

Posted by Daniele Varrazzo on 2012-12-12
Tagged as news, release

I'm happy to announce the release of Psycopg 2.4.6: a huge thank you to the many contributors.

This is a bugfix release, introducing no new feature. There are several small corrections in different areas (copy, adaptation, use of extra cursors, stability). The biggest improvements are with the Zope adapter: Zope users using previous 2.4.x versions are encouraged to update to version 2.4.6 soon.

Read more...

Psycopg 2.4.5 released

Posted by Daniele Varrazzo on 2012-03-29
Tagged as news, release

Many thanks to everybody that contributed with bug reports and comments to this release!

Read more...

Psycopg 2.4.4 released

Posted by Daniele Varrazzo on 2011-12-19
Tagged as news, release

After a short discussion on this list we decided to change the definitions of isolation levels to make sure old code using numeric constants (both psycopg1 and psycopg2) continue to works. Other small fixes are included in the release: see below for details.

Read more...

Psycopg 2.4.3 released

Posted by Daniele Varrazzo on 2011-12-12
Tagged as news, release

Mostly a bugfix release, with as usual a couple of small feature added:

Read more...

Psycopg 2.4.2 released

Posted by Daniele Varrazzo on 2011-06-12
Tagged as news, release

Psycopg 2.4.2 has been released: it brings a few small but interesting new features, and a lot of bug fixes.

Read more...

Psycopg 2.4.1 released

Posted by Federico Di Gregorio on 2011-05-11
Tagged as news, release

Hi *,

Daniele stacked another round of fixes on the devel branch, so it is time for another release. So, as always, kudos to Daniele and here are the direct download links:

Release notes attached, as always. And al always, have fun,

federico

Read more...

Psycopg 2.4 released

Posted by Federico Di Gregorio on 2011-02-27
Tagged as news, release

Hi *,

this is probably one of the best psycopg releases ever. Daniele, Jason and all the others that sent patches did an impressive work to have psycopg build and work flawlessy on all the supported platforms (well.. we can probably do a little bit better on MacOS but everything else is almost perfect). So here it is (followed by NEWS excerpt, as always):

Have fun,
federico

Read more...

Psycopg 2.4 beta1 released

Posted by Federico Di Gregorio on 2011-02-06
Tagged as news, release

Hi *,

me and Daniele, we just went through his series of patches (a loooot of patches) and we're ready to release a beta version of the new psycopg. Apart the usual changes and enhancements (detailed below) this is the first version that supports Python 3 (thanks to, guess who? :)

Read more...

New Psycopg Mailing List Online!

Posted by Daniele Varrazzo on 2011-01-08
Tagged as news, mailing, list

After a long while Psycopg has a Mailing List again!

You are welcome to subscribe, either if you are an user dealing with the first stumbling blocks (albeit a look at the documentation or the FAQ wouldn't hurt!) or if you want to contribute to the psycopg2 development, about which there are several upcoming news.

To post, send mail to <psycopg@postgresql.org>. Yes, we are proud to be hosted on the mighty shoulders of the PostgreSQL Infrastructure team. I want to thank them and the PostgreSQL Global Development Group wholeheartedly for making this happen.

See you there!

Psycopg 2.3.2 released

Posted by Daniele Varrazzo on 2010-12-20
Tagged as news, release

Hello,

just released Psycopg 2.3.2. The release fixes a bug reported in 2.3.0 and 2.3.1 preventing Psycopg to connect to pgBouncer. Thanks to Marti Raudsepp for the bug report and the patch.

Read more...

Psycopg 2.3.1 released

Posted by Daniele Varrazzo on 2010-12-04
Tagged as news, release

Hello,

just released Psycopg 2.3.1. No new feature since release 2.3.0: the only fix is for a build issue on CentOS 5.5 x86_64 (ticket #23).

Read more...

Psycopg 2.3.0 released

Posted by Federico Di Gregorio on 2010-12-01
Tagged as news, release

Hi *,

lately my involvment on psycopg has been quite small (work and other projects are taking their toll) but thanks to Daniele (with some help from Jan) here is a new psycopg2 release. The number of changes is big (an excerpt from the NEWS file is at the end, as always) so we decided to bump up the version to 2.3.0 and to test, and test... and test. We tested this new release on Linux and Windows, with Python 2.4, 2.5, 2.6, 2.7 and on PostgreSQL from 7.4 to 9.0.

Read more...

Psycopg at PGDay Italy 2010

Posted by Daniele Varrazzo on 2010-11-12
Tagged as news, pgday

PGDay Roma, 10 Dicembre 2010

Psycopg will be at PGDay Italy in Rome, on December 10th.

Read more...

Psycopg 2.3.0-beta1 released

Posted by Daniele Varrazzo on 2010-11-06
Tagged as news, release, beta

We have just released a new testing package: psycopg 2.3.0-beta1!

Read more...

New features in the upcoming Psycopg release

Posted by Daniele Varrazzo on 2010-11-02
Tagged as news, development

There are several new features being prepared in the upcoming Psycopg version. The documentation refers to it as release 2.2.3 but it may be ultimately released as 2.3. The main target of the release is to expose some of the new features introduced in PostgreSQL 9.0.

Read more...

Psycopg at PgDay Europe

Posted by Daniele Varrazzo on 2010-10-26
Tagged as pgday, news

Hello,

I will be at PgDay Europe 2010 in Stuttgart with a talk about Psycopg: Advanced PostgreSQL Access from Python with Psycopg.

The talk will be about some of the most advanced functionalities and new features available in the latest Psycopg releases: asynchronous communication, notifications, server-side cursors, advanced data mapping between Python and PostgreSQL, the upcoming support for two-phase commit and hstore objects.

If you have any suggestion about what you'd like to be shown in the talk, you may leave a feedback.

See you in Stuttgart!

Psycopg 2.2.2 released

Posted by Federico Di Gregorio on 2010-07-18
Tagged as news, release

Hi *,

summer release! Just bugfixes, this time. Get it from:

Read more...

Psycopg 2.2.1 released

Posted by Federico Di Gregorio on 2010-05-17
Tagged as news, release

Hi *,

repeat with me:

for x in xrange(1000):
    print "Always check it build on windows!"

but thank to Jason Erickson here is 2.2.1 that DO build on windows. :) No excerpt this time, it's a single liner, but here are the URLs:

Have fun,
federico

Psycopg 2.2.0 released

Posted by Federico Di Gregorio on 2010-05-16
Tagged as news, release

With many thanks to all the contributors here it is, psycopg 2.2.0:

As always, an excerpt from the NEWS file follows.

Have fun,
federico

Read more...