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

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


Branch: CURRENT, Version: 2.8.3, Package name: py37-psycopg2-2.8.3, 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] [databases/postgresql95-client] [lang/python37]

Required to build:
[pkgtools/cwrappers]

Master sites:

SHA1: 8747e8ac441f25d2014a26ab66664486a9e890ae
RMD160: f03a3ec9775d92d65b43c6a651570a4d38b45f0a
Filesize: 368.489 KB

Version history: (Expand)


CVS history: (Expand)


   2019-06-14 06:51:43 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-psycopg2: updated to 2.8.3

Psycopg 2.8.3 released

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.

Psycopg will now make sure that feedback is only sent after a certain period of \ 
time from the previous one, so that the client can simply call send_feedback() \ 
at each message without the fear of overwhelming the server.

For completeness, the changes included in the release are:
* Added interval_status parameter to start_replication() method and other \ 
facilities to send automatic replication keepalives at periodic intervals
* Fixed namedtuples caching introduced in 2.8
   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