Latest articles
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.
Building Psycopg on Windows using MinGW
Posted by Daniele Varrazzo on 2011-06-05
Tagged as
windows,
build,
recipe
My goal was to install Psycopg on Windows using MinGW and the PostgreSQL binary package.
I have used the MinGW GCC binaries packaged by Giovanni Bajo. The package takes care of a lot of details, for instance registering MinGW as default compiler for Python, plus some magic I don't even want to know, and makes the entire process simple enough.
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
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 flawlessly 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):
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? :)
psycopg2 porting to Python 3: a report
Posted by Daniele Varrazzo on 2011-01-24
Tagged as
python3,
news
I've mostly finished the porting of psycopg2 to Python 3. Here is a report of what done and what can be improved.
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.
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).
PostgreSQL notifications with Psycopg2 and Eventlet
Posted by Daniele Varrazzo on 2010-12-01
Tagged as
recipe,
async,
eventlet,
notify
PostgreSQL supports asynchronous notifications, a simple messaging system allowing clients to be notified about events occurred in the database. Notifications can be sent by any session using a "NOTIFY channel" command and will be received by any session which has subscribed with a LISTEN channel to receive updates. The system has been greatly improved in PostgreSQL 9.0 with the addition of a message payload, making the feature even more useful. Previously a typical use case would have been to notify interested sessions that a certain table was updated: now it is possible to signal for instance which record was changed. You can put the NOTIFY command in a database trigger for automatic notifications on insert or update... the possibilities are actually quite interesting.