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

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


Branch: CURRENT, Version: 2.9.9, Package name: py311-psycopg2-2.9.9, Maintainer: pkgsrc-users

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:
[lang/python310] [databases/postgresql14-client]

Master sites:

Filesize: 375.904 KB

Version history: (Expand)


CVS history: (Expand)


   2023-10-04 10:19:57 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-psycopg2: updated to 2.9.9

What's new in psycopg 2.9.9
- Add support for Python 3.12.
- Drop support for Python 3.6.
   2023-09-28 17:48:37 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-psycopg2: updated to 2.9.8

What's new in psycopg 2.9.8

- Wheel package bundled with PostgreSQL 16 libpq in order to add support for
  recent features, such as ``sslcertmode``.
   2023-08-06 09:13:35 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-psycopg2: updated to 2.9.7

What's new in psycopg 2.9.7

- Fix propagation of exceptions raised during module initialization
- Fix building when pg_config returns an empty string
- Wheel package compiled against OpenSSL 1.1.1v
   2023-04-18 09:51:25 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-psycopg2: updated to 2.9.6

What's new in psycopg 2.9.6

- Package manylinux 2014 for aarch64 and ppc64le platforms, in order to
  include libpq 15 in the binary package.
- Wheel package compiled against OpenSSL 1.1.1t.
   2023-02-12 21:33:37 by Adam Ciarcinski | Files touched by this commit (1)
Log message:
py-psycopg2: not for Python 2.7
   2023-02-12 12:03:04 by Jonathan Schleifer | Files touched by this commit (3)
Log message:
Update databases/py-psycopg2 to 2.9.5

Updating to this version fixed an unknown exception being thrown with Python
3.11 on startup of matrix-synapse.
   2022-11-09 14:14:32 by Joerg Sonnenberger | Files touched by this commit (223)
Log message:
Reset MAINTAINER
   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