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

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

Branch: CURRENT, Version: 2.9.10, Package name: py312-psycopg2-2.9.10, 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: 376.633 KB

Version history: (Expand)

CVS history: (Expand)


   2024-11-11 08:29:31 by Thomas Klausner | Files touched by this commit (862) 
Log message:
py-*: remove unused tool dependency

py-setuptools includes the py-wheel functionality nowadays
   2024-10-16 19:55:10 by Adam Ciarcinski | Files touched by this commit (3) | Package updated
Log message:
py-psycopg2: updated to 2.9.10

What's new in psycopg 2.9.10

- Add support for Python 3.13.
- Receive notifications on commit.
- `~psycopg2.errorcodes` map and `~psycopg2.errors` classes updated to
  PostgreSQL 17.
- Drop support for Python 3.7.
   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.