./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)


   2025-02-02 11:38:04 by Havard Eidnes | Files touched by this commit (28) 
Log message:
lang/python and a number of python packages: re-do atomic64.mk issue.

Evidently, python 3.13 brought in the need to support 64-bit atomics.
This means that python extension packages built with C needs to
use mk/atomic64.mk to make -latomic available on the required 32-bit
ports.  Sadly, there is no reliable way to detect in the .mk files
whether the package is using C (or C++), so this change adds an
unconditional include of mk/atomic64.mk when the python version is
equal to or larger than 3.13 for packages using egg.mk or wheel.mk.

This undoes the individual package Makefile inclusions of mk/atomic64.mk
that I've added over the last few days.
   2025-01-18 20:40:04 by Havard Eidnes | Files touched by this commit (1) 
Log message:
databases/py-psycopg2: use atomic64 to fix build with python3.13 on macppc.
   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.