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

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


Branch: CURRENT, Version: 2.8.6nb1, Package name: py39-psycopg2-2.8.6nb1, 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:

Filesize: 374.802 KB

Version history: (Expand)


CVS history: (Expand)


   2022-01-04 21:55:40 by Thomas Klausner | Files touched by this commit (1595)
Log message:
*: bump PKGREVISION for egg.mk users

They now have a tool dependency on py-setuptools instead of a DEPENDS
   2021-10-26 12:10:08 by Nia Alarie | Files touched by this commit (417)
Log message:
databases: Replace RMD160 checksums with BLAKE2s checksums

All checksums have been double-checked against existing RMD160 and
SHA512 hashes

The following distfiles could not be fetched (some may be only fetched
conditionally):

./databases/cstore/distinfo D6.data.ros.gz
./databases/cstore/distinfo cstore0.2.tar.gz
./databases/cstore/distinfo data4.tar.gz
   2021-10-07 15:35:53 by Nia Alarie | Files touched by this commit (417)
Log message:
databases: Remove SHA1 distfile hashes
   2020-10-30 10:54:06 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-psycopg2: updated to 2.8.6

What's new in psycopg 2.8.6
- Fixed memory leak changing connection encoding to the current one.
- Fixed search of mxDateTime headers in virtualenvs.
- Added missing values from errorcodes.
- `cursor.query` reports the query of the last :sql:`COPY` opearation too.
- `~psycopg2.errorcodes` map and `~psycopg2.errors` classes updated to
  PostgreSQL 13.
- Added wheel packages for ARM architecture.
- Wheel package compiled against OpenSSL 1.1.1g.

What's new in psycopg 2.8.5
- Fixed use of `!connection_factory` and `!cursor_factory` together.
- Added support for `~logging.LoggerAdapter` in
  `~psycopg2.extras.LoggingConnection`.
- `~psycopg2.extensions.Column` objects in `cursor.description` can be sliced.
- Added AIX support.
- Fixed `~copy.copy()` of `~psycopg2.extras.DictCursor` rows
   2019-10-21 13:31:22 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-psycopg2: updated to 2.8.4

Psycopg 2.8.4

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

A more detailed changes list is
* Fixed building with Python 3.8.
* Don't swallow keyboard interrupts on connect when a password is specified in \ 
the connection string.
* Don't advance replication cursor when the message wasn't confirmed.
* Fixed inclusion of time.h on linux.
* Fixed int overflow for large values in Column.table_oid and Column.type_code.
* errorcodes map and errors classes updated to PostgreSQL 12.
* Wheel package compiled against OpenSSL 1.1.1d and PostgreSQL at least 11.4.
   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