./databases/py-psycopg2, PostgreSQL database adapter for Python

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]


Branch: CURRENT, Version: 2.8.2, Package name: py27-psycopg2-2.8.2, Maintainer: joerg

psycopg is a PostgreSQL database adapter for the Python programming language
(just like pygresql and popy.) It was written from scratch with the aim of
being very small and fast, and stable as a rock. The main advantages of
psycopg are that it supports (well... *will* support) the full Python
DBAPI-2.0 and being thread safe at level 2.

psycopg is different from the other database adapter because it was designed
for heavily multi-threaded applications that create and destroy lots of
cursors and make a conspicuous number of concurrent INSERTs or UPDATEs.
Every open Python connection keeps a pool of real (UNIX or TCP/IP) connections
to the database. Every time a new cursor is created, a new connection does not
need to be opened; instead one of the unused connections from the pool is
used. That makes psycopg very fast in typical client-server applications that
create a servicing thread every time a client request arrives.

This is version 2, a complete rewrite of the original code to provide
new-style classes for connection and cursor objects and other
sweet candies. Like the original, psycopg 2 was written with the aim of
being very small and fast, and stable as a rock.


Required to run:
[devel/py-setuptools] [lang/python27] [databases/postgresql95-client]

Required to build:
[pkgtools/cwrappers]

Master sites:

SHA1: b2eded9a78fa2aaa874b2cc3a28f1824a51c7d25
RMD160: dbf5aa8af1748908d2ad970c64a7059fd9439ade
Filesize: 359.594 KB

Version history: (Expand)


CVS history: (Expand)


   2019-04-15 09:01:23 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-psycopg2: updated to 2.8.2

2.8.2:
Fixed "there's no async cursor" error polling a connection with no cursor.
Fixed RealDictCursor when there are repeated columns.
Fixed RealDictRow modifiability.
Binary packages built with OpenSSL 1.1.1b. Should fix concurrency problems.
   2019-04-07 18:09:10 by Adam Ciarcinski | Files touched by this commit (3) | Package updated
Log message:
py-psycopg2: updated to 2.8.1

What's new in psycopg 2.8.1
- Fixed RealDictRow modifiability
- Fixed "there's no async cursor" error polling a connection with no cursor
   2019-04-05 11:14:41 by Adam Ciarcinski | Files touched by this commit (3) | Package updated
Log message:
py-psycopg2: updated to 2.8

Psycopg 2.8 released

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).
   2019-02-05 12:39:19 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-psycopg2: updated to 2.7.7

What's new in psycopg 2.7.7
- Cleanup of the cursor results assignment code, which might have solved
  double free and inconsistencies in concurrent usage.
- Wheel package compiled against OpenSSL 1.0.2q.
   2018-11-09 22:26:29 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-psycopg2: updated to 2.7.6

Psycopg 2.7.6:

Summary of changes:
- Close named cursors if exist, even if execute() wasn't called.
- Fixed building on modern FreeBSD versions with Python 3.7.
- Fixed hang trying to COPY via execute() in asynchronous connections.
- Fixed adaptation of arrays of empty arrays.
- Fixed segfault accessing the connection.readonly and connection.deferrable \ 
attributes repeatedly.
- execute_values() accepts sql.Composable objects.
- errorcodes map updated to PostgreSQL 11.
- Wheel package compiled against PostgreSQL 10.5 libpq and OpenSSL 1.0.2p.
   2018-07-03 05:57:16 by Adam Ciarcinski | Files touched by this commit (4)
Log message:
py-psycopg2: do not install tests (fix for Python 3.7)
   2018-06-18 09:46:16 by Adam Ciarcinski | Files touched by this commit (4) | Package updated
Log message:
py-psycopg2: updated to 2.7.5

What's new in psycopg 2.7.5:
- Allow non-ascii chars in namedtuple fields
- Fixed adaptation of arrays of arrays of nulls
- Fixed building on Solaris 11 and derivatives such as SmartOS and illumos
- Maybe fixed building on MSYS2
- Allow string subclasses in connection and other places
- Don't raise an exception closing an unused named cursor
- Wheel package compiled against PostgreSQL 10.4 libpq and OpenSSL 1.0.2o
   2018-04-05 11:45:13 by Jonathan Perkin | Files touched by this commit (3)
Log message:
py-psycopg2: Only supply timer funcs if they are missing.